Contents
Power BI Training
Introduction of Power BI
Learning Objective: This module will introduce you to Power BI, its building blocks and the various fundamental concepts of Power BI.
- Business Intelligence
- SSBI (Self Service Business Intelligence tools)
- Power BI
- Architecture of Power BI
- Components of Power BI
Power BI Desktop
Learning Objective: This module will introduce you to Power BI Desktop. You will know how to extract data from various sources and establish connections with Power BI Desktop, perform transformation operations on data and the Role of Query Editor in Power BI.
- Overview of Power BI Desktop
- Data sources and connections in Power BI ( Various different DS connections)
- Query editor in Power BI
- Transform data in Query editor
- Joining data
- Data interpretations
- Manage data relationship
- Change data source connectivity
- Create calculated measures and filter at data level
- Modeling data
Data Analysis Expressions (DAX)
Learning Objective: This module will help you learn the basics of DAX in Power BI Desktop.
- Why DAX
- DAX Syntax
- Data types in DAX
- Types of calculations
- DAX tables and Filtering
- DAX queries
- DAX Parameters
- Analytics calculations
Data Visualizations
Learning Objective: This module will help you understand the benefits and best practices of Data Visualization. It will also help you in creating charts using Custom Visuals.
- Supported Chart types in Power BI
- Map Visualizations
- Color palettes in Charts
- Loading Shapes, text boxes, and images
- Custom visuals
- Z-Order
Power BI Q&A and Data Insights
Learning Objective: This module will help you in creating Dashboards and publishing it on Power BI services.
- Introduction to Power BI Services
- Dashboard vs. Reports
- Quick Insights
- Creating Dashboards
- Power BI Q&A
- Ask Questions of your Data
- Power BI Embedded
Power BI Report Server
Learning Objective: This module will help you understand about Power BI Report Servers and data gateways. Also, you will learn about the web portal in which you display and manage reports and KPI’s.
- Report server Basics
- Web Portal
- Row level security
- Data Gateways
- Scheduled data refresh
