fbpx

Comprehensive Power BI

About the Course – With no prior experience in the field of Data Visualization to being a successful Power BI professional. This Course has been designed specifically for those who has no prior experience in Data Visualization but wants to become a successful Data Visualization Professional.

This course covers everything from Scratch to get you comprehensive understanding and hands on experience on Power BI and other topics which are needed to be a successful Data Visualization professional. A true hands on experience along with real life case studies and problem statement are included to give you actual project experience.

Please check the Course Curriculum for details of the Topics which will be covered during the course.

Join the Next Batch to learn Online in Live Interactive Class format.

Power BI Introduction

1
Power BI Introduction
2
Data Visualization, Reporting, Datasets
3
Business Intelligence(BI), Traditional BI, Self-Serviced BI
4
Cloud Based BI, On Premise BI
5
Power BI Products
6
Power BI Desktop
7
Flow of Work in Power BI Desktop
8
Power BI Report Server, Power BI Service, Power BI Mobile
9
Flow of Work in Power BI / Power BI Architecture
10
A Brief History of Power BI

PBI Desktop Installation

PBI Desktop & Service Overview

1
Power BI Desktop Installation
2
Building Blocks of Power BI
3
Datasets, Visualizations, Reports, Dashboards, Tiles
4
Power BI Desktop User Interface
5
Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
6
Overview of Power Query / Query Editor – Extract, Transform
7
Connecting to Data Sources, Establish connection to the Excel source
8
Importing Data into Power BI or Query Editor
9
Transforming the Data using Power Query
10
Model the Data using Power Pivot – Relationship View
11
Creating New Measures and New Columns using DAX – Data View
12
Visualizing the Data using Power View and Power Maps – Report View
13
Saving and Publishing the Visuals or Reports
14
Logon to Power BI Service
15
View the Reports in PBI Service and Share the reports

Introduction to Power Query – Extract

Transform & Load

1
Data Transformation, Benefits of Data Transformation
2
Data cleansing or Transform Data using Power Query
3
Overview of Power Query / Query Editor, Query Editor User Interface
4
The Ribbon (Home, Transform, Add Column, View Tabs)
5
The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar
6
Advanced Editor – Complete ETL Code
7
Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
8
Power Query Conceptually
9
Quizes and Assignments

Datatypes and Filters in Power Query

1
Datatypes, Changing the Datatype of a Column
2
Filters in Power Query
3
Auto Filter / Basic Filtering
4
Filter a Column using Text Filters
5
Filter a Column using Number Filters
6
Filter a Column using Date Filters
7
Filter Multiple Columns
8
Quizes and Assignments

Inbuilt Column Transformations

1
Remove Columns / Remove Other Columns
2
Name / Rename a Column
3
Reorder Columns or Sort Columns
4
Add Column / Custom Column
5
Split Columns
6
Merge Columns
7
PIVOT, UNPIVOT Columns
8
Transpose Columns
9
Quizes and Assignments

In built Row Transformations

1
Header Row or Use First Row as Headers
2
Keep Top Rows, Keep Bottom Rows
3
Keep Range of Rows
4
Keep Duplicates, Keep Errors
5
Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
6
Remove Duplicates, Remove Blank Rows, Remove Errors
7
Group Rows / Group By
8
Quizes and Assignments

Combine Queries (Append Queries & Merge Queries)

Append Queries / Union Queries

1
Append Queries
2
Append 2 or more files individually with different queries
3
Appending multiple files of same type from a folder using single query
4
Query Options
5
Copy Query, Paste Query
6
Enable Load, Include in report Refresh
7
Duplicate Query, Reference Query
8
Move to Group, Move Up, Move Down
9
Quizes and Assignments

Merge Queries / Join Queries

1
Merge Queries, Merge Queries as New
2
Default Types of Joins / Join Kinds / Merge Type
3
Cartesian Join or Cross Join
4
Quizes and Assignments

Power Pivot

Power BI Data Modeling – Relationship View

1
Data Modeling Introduction
2
Relationship, Need of Relationship
3
Relationship Types / Cardinality in General
4
AutoDetect the relationship, Create a new relationship, Edit existing relationships
5
Make Relationship Active or Inactive
6
Cross filter direction (Single, Both), Assume Referential Integrity
7
Quizes and Assignments

Enhancing the Data Model - DAX

1
What is DAX, Calculated Column, Measures
2
DAX Table and Column Name Syntax
3
Creating Calculated Columns, Creating Measures
4
Implicit Vs Explicit Measures
5
DAX Syntax
6
DAX Operators
7
Quizes and Assignments

DAX Functions Categories

1
Date and Time Functions
2
Logical Functions
3
Text Functions
4
Math
5
Filter Functions
6
Time Intelligence Functions
7
Quizes and Assignments

Power View

1
Report View / Power View
2
Filters in Power View
3
Grouping, Binning
4
Hierarchies and Drill-Down Reports
5
Quizes and Assignments

Power BI Visualizations

1
Visualizing Data, Why Visualizations
2
Visualization types, Field Wells
3
Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data
4
Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data
5
Leveraging Power BI Custom Visuals
6
Quizes and Assignments

Power BI Service

1
Power BI Service Introduction
2
Creating Power BI Service Account, SIGN IN to Power BI Service Account
3
Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service
4
DATASETS, WORKBOOKS, REPORTS, DASHBOARDS
5
Working with Datasets, Creating Reports in Cloud using Published Datasets
6
Power BI Datasets Live Connection using Desktop
7
Working with Workbooks, working with Reports, Sharing Reports
8
Quizes and Assignments

Data Gateways

1
Introduction to Data Gateways
2
How Data Gateways work
3
Connect to an on premise Data Source by using a Data Gateway
4
Download Data Gateway
5
Installing a Data Gateway
6
Types of Gateways
7
On-premises Data Gateway, On-premises Data Gateway (personal mode)
8
Manage Data Gateway
9
Add and Remove Administrators
10
Refresh On Premise Data
11
Configuring Automatic Refresh using Schedules
12
Quizes and Assignments

Collaboration in Power BI using App Workspace

1
Introduction to App Workspaces
2
Create an App Workspace
3
Add Members to App Workspace to Collaborate
4
App Workspace Access
5
Admin, Member, Contributor

Sharing Power BI Content using Apps and Content Packs

1
Introduction to App
2
Publish an App
3
Update a Published App
4
Manage Content in App
5
Sharing App
6
Content Pack Introduction
7
Create Content Pack
8
Sharing Content Packs
9
Selecting the Content / Items to Publish or Share
10
Quizes and Assignments

Row Level Security in Power BI

1
Introduction to Row Level Security
2
Row Level Security (RLS) with DAX
3
Manage Roles, Creating Roles, Testing Roles
4
Dynamic Row Level Security
5
Creating Users Table and Adding to the Model
6
Quizes and Assignments

ADD ON

1
Real-time Project Explanation
2
Resume Preparation
3
Interview Questions Discussions
4
Mock Interviews
Yes, all sessions will be live sessions !!

Bringing in one of the most comprehensive course for Power BI!!


The amount of information and knowledge I will bring in with course is unparalleled!!


If you are able to complete this course with proper commitment and dedication, able to complete our assignment and able to clear our mock interview after the course, you can clear any interview!!


That's the power of my courses..


I am going to make it in such a way that 2021 starting bring a job offer for you..


Your wait is over..


And for the fist batch I will give huge discounts to make sure everyone can buy it and get over their struggle as early as possible after attending this 2 month of Comprehensive Power BI course..


Course will be added to my website Datacurators. tech by today..


Keep learning

Add to Wishlist
Duration: 2 months
Lectures: 134
Level: Advanced

Working hours

Monday 10:00 am - 11.30 pm
Tuesday 10:00 am - 11.30 pm
Wednesday 10:00 am - 11.30 pm
Thursday 10:00 am - 11.30 pm
Friday 10:00 am - 11.30 pm
Saturday 9:00 am - 9.00 pm
Sunday 9:00 am - 9.00 pm