- View Offline
- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process
Skill Level Intermediate
Hi! I'm Ron Davis. And welcome to Microsoft Business Intelligence Stack in Depth. In this course, we're going to look at almost all of the aspects of the Microsoft BI stack. We're going to look at SQL, Sharepoint, and Excel. Within SQL, we're going to start with the traditional multidimensional mode. Then we're going to move over to the SQL tabular mode. We'll move over into Excel Power Pivot and look at using it in Business Intelligence.
Then we move over into its Sharepoint, and use all of its BI features, mainly Excel to share those workbooks that you've created. Performance point services to create dashboards off of your data warehouse or other sources. Visio services and then we'll finally wrap up with data mining and predictive analytics. Now let's get started with Microsoft Business Intelligence Stack in Depth.