This is a short article but it is useful to refer.
Here are the steps the author has outlined:
- Master T-SQL query and normalization, then de-normalization to create data warehouse (star/snow/flake schema)
- How to create multi-dimensional model
- Using ETL, it is Microsoft SQL Server Integration Services
- How to create cube using Microsoft SQL Server Analysis Services
- Using report building and dashboard tools such as Microsoft SQL Server Reporting Services, PowerView...to deliver the reports to end users
Source: http://bloggerzspot.com/how-to-start-microsoft-bi-2/
0 comments:
Post a Comment