Home > Ask the Data management / BI Experts > Business intelligence and analytics Questions & Answers > Star schema design for BI
Ask The Data Management Expert: Questions & Answers
EMAIL THIS

Star schema design for BI

William McKnight EXPERT RESPONSE FROM: William McKnight

Pose a Question
Other Data Management Categories
Meet all Data Management Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 29 July 2003
My company wants to acquire a new tool (probably Microstrategy) for business intelligence (BI) purposes. My role is to design/customize the star schema for the tool for our pharmaceutical manufacturing company. What are the basic things that I need to know about a star schema design? Should I explore the requirements (with regards to sales) before designing the star schema?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Business intelligence and analytics
Do we need business intelligence (BI) tools to be successful?
How to explain and define business intelligence to mid-management
Examining different data access methods: OLAP and data mining
What are the best analytical tools for business intelligence for finance?
Fastest way to learn business intelligence (BI)
Should a data steward have direct SQL access for reporting purposes?
Business intelligence market growth for 2009 and beyond
Comparing Cognos vs. Business Objects for BI reporting
Business intelligence in management careers
Data warehouse and business intelligence team reporting structure

Data modeling tools and techniques
Understanding five major enterprise information management benefits
Data modeling concepts: How settings can increase application success
Advantages and disadvantages of XML shredding
How to shred XML with the DB2 XMLTABLE function
Shredding XML docs into relational tables with annotated XML schemas
Examples of single and bulk XML shredding of XML documents
Improving ODBC application performance and coding
How to capture metadata information, ETL rules with CA Erwin Data Modeler
Data Warehouse Platforms Product Directory
Data models serve as blueprint for business intelligence, master data management projects

Data warehouse software
Microsoft details self-service business intelligence, data warehouse releases
Why pay for a data warehouse appliance when you can get one free?
In-database analytics pulls together SAS, data warehouse vendors
Teradata takes a logical approach to data warehousing appliances
BT taps open source BI software, homegrown DW to unlock customer data
Bill pushes for data warehouse, XBRL to track TARP funds
Teradata VP talks data warehouse appliances, reveals cloud and SSD plans
Data Warehouse Platforms Product Directory
Commodity hardware aiding data warehouse appliance performance, costs
What does MapReduce and in-database technology mean for data warehouses?

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data modeling  (SearchDataManagement.com)
predictive modeling  (SearchDataManagement.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


You shouldn't jump right into designing a star shema. You should always explore business requirements before modeling structure, whether that's a star schema, a normalized model or a flat structure. You can find an article that may help on BI Requirements Gathering in our latest BI Best Practices Newsletter .

You really have 3 masters to serve - one is the business, one is Microstrategy and one is sound dimensional modeling practice. Ralph Kimball's books are the best for the latter and I would work with the Microstrategy team to understand what it needs. Since most of us don't code perfect dimensional models due to various reasons, the tools have become a lot more adept at working with various modeling styles -- including a star schema -- in the past several years. Don't let this lull you into poor modeling techniques however. It will be much more difficult to develop the end user layer the more you stray from sound dimensional modeling practice.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice

About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts