2014
lynda.com
Ron Davis
00:43:39
English

What is Microsoft business intelligence (BI), and how can you use it to benefit your organization? Learn in this quick tour of the stack with BI pro Ron Davis, who explains the three main components of a business intelligence solution (SQL Server, Excel, and SharePoint) and how companies typically use them together. Learn about the visualization, forecasting, and data-mining possibilities available within Microsoft BI. Then investigate SQL Server Integration Services, which allows you to extract, transform, and load data from a data warehouse or data mart. Start watching now to learn how Microsoft business intelligence can put your data to work for you.

Introduction
Welcome
What you should know before watching this course
1. What Is Business Intelligence (BI)?
What is the BI stack?
Why do companies put so much into BI?
What visualizations are available?
Understanding forecasting and data mining
2. SQL Server Integration Services
Understanding extract, transform, and load (ETL)
ETL in an Integration Services package
3. Data Warehouses and Data Marts
Facts or measures
Dimensions
Creating hierarchies for reporting and drill-down
Conclusion
Next steps

http://o53xo.nr4w4zdbfzrw63i.cmle.ru/Excel-tutorials/Microsoft-Business-Intelligence-Stack-Fundamentals/169623-2.html?srchtrk=index%3a1%0alinktypeid%3a2%0aq%3aMicrosoft+Business+Intelligence+Stack+Fundamentals%0apage%3a1%0as%3arelevance%0asa%3atrue%0aproducttypeid%3a2

Download File Size:75.47 MB

---