Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 20 hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

6 Topics
What Is Power BI?
Download and Install Power BI Desktop
Quick Interface Tour
Mini Project: Transform Data
Mini Project: Visualize Data
Mini Project: Creating a Data Model

2 Topics
Creating Our Initial Project File
Working with the Attached Project Files

24 Topics
Exploring the Query Editor
Connecting to Our Data Source
Editing Rows
Changing Data Types
Replacing Values
Close and Apply
Connecting to a CSV File
Connecting to a Webpage
Extracting Characters
Splitting and Merging Columns
Creating Conditional Columns
Creating Columns from Examples
Merging Queries
Pivoting and Unpivoting
Appending Queries
Practice and Solution: Population Table
The Fact-Dimension-Model
Practice: Load the Dimension Table
Organizing Our Queries in Groups
Entering Data Manually
Creating an Index Column
Workflow and More Transformations
Practice Assignment 1
Practice Assignment 1 Solution

11 Topics
Advanced Editor - Best Practices
Performance: References Versus Duplicating
Performance: Enable / Disable Load and Report Refresh
Group By
Mathematical Operations
Run R Script
Using Parameters to Dynamically Transform Data
M Formula Language: Basics
M Formula Language: Values Lists and Tables
M Formula Language: Functions
M Formula Language: More Functions and Steps

9 Topics
Why a Data Model?
Create and Edit Relationships
One-to-Many and one-to-One Relationship
Many-to-Many (m:n) Relationship
Cross-Filter Direction
Activate and Deactivate Relationships
Module Summary
Practice Assignment 2
Practice Assignment 2 Solution

24 Topics
Our First Visual
The Format Tab
Understanding Tables
Conditional Formatting
The Pie Chart
All about the Filter Visual
The Filter Pane for Developers
Cross Filtering and Edit Interactions
Practice Assignment 3
Practice Assignment 3 Solution
Syncing Slicers across Pages
Creating Drilldowns
Creating Drill-Throughs
The Treemap Visual
The Decomposition Tree
Understanding the Matrix Visual
Editing Pages
Buttons and Actions
Bookmarks to Customize Your Report
Analytics and Forecasts with Line Charts
Working with Custom Visuals
Get Data Using R Script and R Script Visual
Asking Questions - Q&A Visual
Wrap Up - Data Visualization

7 Topics
Python in Power BI - Plan of Attack
Setting Up Python for Power BI
Transforming Data Using Python
Creating Visualizations Using Python
Violin Plots Pair Plots and Ridge Plots Using Python
Machine Learning (BayesTextAnalyzer) Using Python
Performance and Troubleshooting

10 Topics
Introduction
The Project Data
Measures Versus Calculated Columns
Automatically Creating a Date Table in DAX
Calendar
Creating a Complete Date Table with Features
Creating a Key Measure Table
Aggregation Functions
The Different Versions of COUNT
SUMX - Row-Based Calculations

5 Topics
CALCULATE - The Basics
Changing the Context with FILTER
ALL
ALLSELECT
ALLEXCEPT

6 Topics
Show Empathy and Identify the Requirements
Find the Most Suitable KPIs
Choose an Effective Visual
Make Use of Natural Reading Pattern
Tell a Story Using Visual Cues
Avoid Chaos and Group Information

14 Topics
Power BI Pro Versus Premium and Signing Up
Exploring the Interface
Discovering Your Workspace
Connecting Power BI Desktop and Cloud
Understanding Datasets and Reports
Working on Reports
Updating Reports from Power BI Desktop
Creating and Working with Workspaces
Installing and Using a Data Gateway
Get Quick Insights
Creating Dashboards
Sharing Our Results Through Apps
Power BI Mobile App
Creating the Layout for the Mobile App

7 Topics
Introduction
Creating a Row-Level Security
Row-Level Security in the Cloud
Row-Level Security and Data Model
Dynamic Row-Level Security
Dynamic Many-to-Many RLS
Hierarchical Row-Level Security

4 Topics
JSON and REST API
Setting Up a Local MySQL Database
Connecting to a MySQL Database in Power BI
Connecting to a SQL Database (PostgreSQL)

  Write a Review

Certificate in Power BI

Go to Paid Course