Basic to Advance Microsoft Power BI- Part 1/2 (2022 updates)
Complete tutorial on Power BI Desktop - Data Analytics
Course Description
A very detailed discussion on Power BI introduction. A Free Microsoft tool works in real world to produce amazing , powerful and dynamic ,interactive dashboards/Reports.
Also, covered basic level information on PowerQuery for your better grip on fundamental.
Installation on Power BI - Real live example shown. No fast forward. Helpful for new students who never seen BI before.
Clustered Column and Stacked Column Chart visualizations covered . When and why they should be used and difference between them discussed too.
how to import data and things to be taken care of from different sources.
Drill down feature for deep analysis.
Stylish Drill-Through feature.
Line & Pie Visualizations.
Tool-tip and Tool Tips features - Why you need them and what is the difference.
How to make Tables and Matrix. Their role in reports .Difference between them. Advantages and disadvantages.
Learn how to create Slicers and rules to be followed.
What are Cards and Themes in BI - Simple awesome.
Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this.
Cross Filtering feature - No VBA , no complex formulas- Inbuilt feature which adds so much value to your reports and dashboards.
Area Chart Visualization -from scratch. with practical scenarios telling the difference between it and others .
Line and Column visualization - including stacked.
How to use custom visuals if you not happy with in-built ones though they are always extra-ordinary
Show amazing up and down falls in business using Waterfall visualization
Complete discussion on KPI ,Map , Tree Map , QnA feature, Decomposition tree visualization, Ribbon Chart.
How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level.
Use of Slicers in navigating pages.
How to Create a Dashboard in Powerbi Using above points.
You can ask for support any day , any time.
Who this course is for:
- Students who want to make career in Analytics .
- Students who are keen to make powerful and impactful visualizations in few minutes and with very very less efforts.
- Professionals who have been working on Excel a lot like MIS Analysts ,Business Analysts or someone who wants to produce data reports in an exclusive manner.
Goals
What will you learn in this course:
- Students who want to learn one of the best Data Visualization Tool in the industry are welcome to kick start their learning in this Part1
- This is a first part of Power BI in which BI Destkop is covered. Basic to Advance. After finishing this, Join me in Part2 which talks about BI Service in detail
- Introduction to PowerBI desktop, a quick walk through over other tools like PowerBI services , DAX language, M code language , PowerQuery
- How to install PowerBI Desktop. System requirements and why BI?
- How to import data from different sources in BI like Excel, csv files , txt files , databases like ms access, sql server
- Doubts like what is M code, DAX , where they are used and differences between these two languages.
- Do you need to know PowerQuery before BI or not? What is PQ or m Code role in BI Tool. All such types of doubts are discussed in detail in this part 1.
- We are covering PowerBI Desktop all features with practical examples and Dashboards too in this Part2
- Every Visual with Quizzes and Dashboards plus beautiful Navigation panes.
Prerequisites
What are the prerequisites for this course?
You should not know basic excel. Nothing else is required.
No VBA or macro knowledge is required.

Curriculum
Check out the detailed breakdown of what’s inside the course
Basic to Advance Microsoft Power BI- (2022 updates)
37 Lectures
-
Introduction to PowerBI - Understand in-depth its Components 52:10 52:10
-
How to Import Excel Data in BI and fundamentals 41:23 41:23
-
Clustered Column Visual - Let us finally begin the show 57:00 57:00
-
Stacked Column Visuals 17:11 17:11
-
Clustered Bar and Stacked Bar Visuals - Horizontal data view 19:16 19:16
-
SLICERS Visual - Life changing experience 24:54 24:54
-
Line Visual - How to see TRENDS 18:05 18:05
-
Area Chart Visual - Magnitude is the key 03:57 03:57
-
Column Line and Ribbon Visuals - Do the Deep analysis 23:25 23:25
-
Introduction PowerQuery for you - Overview 23:25 23:25
-
PowerQuery Continues - Take More idea 01:34:20 01:34:20
-
Small multiples Feature in BI 08:51 08:51
-
My favorite Tables - Most used Visual 21:45 21:45
-
Multi Card Visual - Useful in displaying overall numbers 12:35 12:35
-
Gauge Visual - Track how far are we from Targets 28:53 28:53
-
MATRIX Visual - Its awesome - Everything you need to know 25:59 25:59
-
Matrix - More features 10:22 10:22
-
How to use Drill on feature in Matrix - game changing 13:41 13:41
-
SubTotals in Matrix 13:30 13:30
-
Map Visual 1 17:25 17:25
-
Map Visual Continues 22:59 22:59
-
Map Visual - More knowledge 07:56 07:56
-
Maps Visual 12:41 12:41
-
Maps for reports 13:18 13:18
-
Decomposition Visual 38:53 38:53
-
Decomposition Tree - more Insight 08:47 08:47
-
Decomposition Tree - Covering every point 11:16 11:16
-
How to use Drill on feature - Deep dive 14:59 14:59
-
CrossFiltering feature - A unique way of doing the automations 09:30 09:30
-
Filter pane in BI 14:21 14:21
-
BI Services-Part-1 26:12 26:12
-
BI Services-Part-2 16:25 16:25
-
BI Services-Part-3 08:00 08:00
-
BI Services-Part-4 33:15 33:15
-
BI Services-Part-5 17:08 17:08
-
BI Services-Part-6 30:03 30:03
-
BI Services-Part-7 24:22 24:22
Instructor Details

ajay parmar
Data Analytics TrainerI have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Course Certificate
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now