Curriculum

12 Topics
Introduction to Business Intelligence
Self-Service Business Intelligence (SSBI)
Introduction to Power BI
Traditional BI vs. Power BI
Power BI vs. Tableau vs. QlikView
Uses of Power BI
The Flow of Work in Power BI
Working with Power BI
Basic Components of Power BI
Comparison of Power BI Version
Introduction to Building Blocks of Power BI
Data model and importance of Data Modeling

10 Topics
Data Sources in Power BI Desktop
Loading Data in Power BI Desktop
Views in Power BI Desktop
Query Editor In Power BI
Transform Clean Shape and Model Data
Manage Data Relationship
Editing a Relationship
Cross Filter Direction
Saving Workfile
Measures

10 Topics
Introduction to DAX
Importance of DAX
Data Types in DAX
DAX Calculation Types
Steps to Create Calculated Columns
Measures in DAX
DAX Syntax
DAX Functions
DAX Operators
DAX Tables and Filtering

13 Topics
Introduction to Visuals In Power BI
Visualization Charts in Power BI
Matrixes and Tables
Slicers and Map Visualizations
Gauges and Single Number Cards
Modifying Colors in Charts And Visuals
Shapes Text Boxes and Images
Custom Visuals
Page Layout and Formatting
Bookmarks and Selection Pane
KPI Visuals
Z-order
Grouping and Bining

8 Topics
Introduction to Power BI Service
Creating a Dashboard
Quick Insights in Power BI
Configuring a Dashboard
Power BI Q&A
Ask Questions about your Data
Power BI Embedded
Bookmarks and buttons

8 Topics
Data Sources Supported in Power BI
Exploring Live Connections to Data Sources
Connecting Directly to SQL Azure
Connecting Directly to SQL Server Analysis Services/My SQL
Import Power View and Power Pivot
Data Gateways
Direct Query vs. Import Connectivity Modes
Connecting Power BI in Excel

9 Topics
What is Power BI Report Server?
Key Features of Report Server
The architecture of the Report Server
Limitations of Report Server
Power BI Report Server vs. Power BI Service
Acquiring and Installing Power BI Report Server
What is a Web Portal?
Paginated Reports
Row Level Security

6 Topics
Brief concepts about R
R Programming Concepts
Create R Scripts for BI
Python Programming
Python Scripts in BI
Python integration with Power BI

6 Topics
Use Parameters
Create a data flow
Introduction to Anomaly Detection
Introduction to Smart Narrative
Introduction to Sensitivity labels in Power BI
Deployment Pipeline

5 Topics
Power BI Service
Row Level Security
Visuals and Charts
Power BI Desktop
Handling Workspaces

  Write a Review

Power BI Certification Training Course: PwC Academy

Go to Paid Course