Power Bi Training Course Content
Introduction
- Installation
- Interface of Power BI
- Introduction to our Source Data
Introduction to SQL
- Data Definition Language
- Data Manipulation Language
- String Functions
- Numeric Functions
- Date Functions
- Conversion Functions
- Joins
- ER Modeling
- Normalization
- SQL Select Variants
- Sorting
- Conditional Functions
- Sub Queries
- Set Operators
- Manipulating large Data Sets
Different Data Sources in Power BI
- Type of Connectors
- Loading Data in Power BI
- Ways to Create Visual
- Understanding Fields Box
- Understanding Aggregation
- Power BI Architecture
Drilling into your data
- Drill up and Down your data
- Advanced drill down option
Formatting visual
Structuring your data
- Wide Table Vs Tall Table
- Transforming your Data Structure (Unpivot Data)
- Fill & Replace Data
- Splitting and formatting your data
- Date & Time Transformations
Power BI Dashboard
- Introduction to Dashboard Data
- Loading Data & Knowing about Relationships
- Ways to combine your data
- Cardinality
- Absence of Common Columns
- Adding Tables & Matrix
- Adding Bar & Column Charts
- Adding Pie & Donut Charts
- Adding Tree maps
- Adding Line Charts
- Adding Combo Charts
- Adding Bubble Maps
- Adding Filled maps
- Adding Cards and Multi Row Cards
- Inserting Elements
Filters
- Adding Slicers
- Understanding the Filters Pane
- Drill through Filters
- Month’s vs Calendar Months
Making your visuals Interactive
- Using Bookmarks and Buttons to present insights
- Refresh data and data source settings
- Assignment instructions and introduction to dataset
- Building Dashboard
Parameters and Functions
Data Analysis Expressions (DAX)
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
Case Studies