Description
Prérewuis
contenu
Module 1 – Introduction to Business Intelligence
- Introduction to Business Intelligence
- Business Intelligence scenarios
- Business Intelligence teams
- Self-Service BI
Module 2 – Introduction to the Microsoft Power BI suite of tools
- Business Intelligence Tools
- What is Power BI?
- What is the Power BI Portal?
- What is Power BI Mobile?
- What is the Power BI Report Server?
- Installing Power BI
- Understanding the Power BI environment
- Understanding Power BI Terminology
- Lab – Installing Power BI Desktop
- Lab – Creating your first report
Module 3 – Connecting to Data Sources
- Choosing the right connector for your source
- Connecting to an SQL Server
- Connecting to an Excel File
- Connecting to a CSV File
- Data Connectivity Mode
- Advanced Options
- What is a Dataset?
- Best Practices
- Lab – Connecting to an Excel file
- Lab – Connecting to an SQL Server in Azure
Module 4 – Modeling Data
- Data Warehouses
- Data Warehouse Examples
- Relationships
- How Relationships are used in Reports
- Lab – Creating Relationships
Module 5 – Power BI Visuals
- Reports
- Power BI Visual Types
- Charts
- Maps
- Tables/Matrix
- Custom Visuals
- Interactive Data Visualizations
- Lab – Creating Charts and Maps
- Lab – Importing and using Custom Visuals
Module 6 – Power BI Transformations
- What are transformations?
- Shaping Data
- Combining Data
- Calculated Columns
- Measures
- Transformation Best Practices
- Lab – Shaping and Combining Data
- Lab – Creating Calculated columns
- Lab – Creating Measures
Module 7 – Power BI Languages
- Data Analysis Expressions (DAX)
- Transact-SQL
- Multidimensional Expressions (MDX)
- The R Programming Language
- Python
- Power Query Formula “M” Language
- Lab – Using DAX
- Lab – Using T-SQL
Module 8 – Power BI Portal and Collaboration
- The Power BI Environment and Menus
- Why Workspaces?
- What Are Dashboards?
- What Are Apps?
- Lab – Sharing Your Reports