Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pros and cons of choosing MS OLAP Services
jnicho02, This is a common question that I have been asked on many client sites (I'm a consultant), and not just for OLAP. The same is also asked of ETL tools when MS SQL Server comes with Data Transformation Services (DTS) built in. Well, to keep it simple, the Microsoft OLAP offering has... -
star schema v. snowflake schema
A snowflake, to put it in simple terms, is an extension of a star schema. Where in a star schema each dimension is typically stored in one table (which could therefore contain hundreds of attributes), the snowflake principle extrapolates this dimension and creates tables for each level of that...- keefy
- Post #4
- Forum: Data Warehousing/Big Data
-
Choosing a business intelligence software
When selecting a BI tool for an enterprise wide solution, there is typically no particular product suited to any particulr industry (except perhaps Essbase's financial calculation capabilities). I have developed BI applications for a number of years, and every time it comes to product selection...- keefy
- Post #6
- Forum: Data Warehousing/Big Data
