Enterprises rely on business intelligence (BI) to convert relevant information into knowledge that supports better strategic decisions. Many vendors provide business intelligence tools, capable of integrating multiple data sources, processing data analysis, and building interactive dashboards. Databases are often used with additional data management, reporting and analytics capabilities. This course takes a hands-on approach to the fundamentals of business intelligence with the Microsoft BI stack as an example platform.
The course reviews BI, data warehouse, and tools commonly used in industry. You will learn the basic data summary and visualization features of the tools, using Microsoft Excel, which includes PivotTables, Power Pivot and Power View. You will also learn intermediate features that are often used in BI solutions to customize PivotTable fields, formats and functions. You’ll learn to use slicers to filter data; use the internal Data Model; manage relationships in Power Pivot; create a Power Pivot-driven PivotTable; load data from SQL Server into Power Pivot; and create Power View dashboards, charts and maps.
The course uses Visual Studio to explore the BI development environment, where you will learn to build an Online Analytical Processing (OLAP) cube and dimensions. You will learn how to generate the data warehouse using SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS). The course also covers the presentation capabilities of the example tools, starting with browsing a cube in Visual Studio, building a report with SQL Server Reporting Services (SSRS), and connecting to an OLAP data source from Excel. The BI features of SharePoint Server and Performance Point Services will also be discussed.
The course is intended for BI developers and analysts. It will demonstrate how to build an enterprise level BI data flow, using Excel, SQL Server and Visual Studio as example tools. You will build a data warehouse and a multi-dimensional cube in class. By the end of the course, you will have experience building BI solutions with multiple data sources using common tools. SQL Server experience is not required, but the basic concepts of relational database design will not be covered in this course.
- Introduction to business intelligence concepts
- Survey of tools used in the industry
- Introduction to PivotTable and Power Pivot
- Creating dashboards with Power View
- Introduction to Power Map
- Introduction to SQL Server and using Visual Studio
- Introduction to Integration Services
- Introduction to Reporting Services
- Browsing Analysis Services cubes in Visual Studio and Excel
- Course review