Learn Business Intelligence…

Business Data Analysis using Microsoft Power BI: A to Z

Absolutely no Power BI experience is required. 

The complete and comprehensive course on Power BI

Taught by HIGHLY EXPERIENCED INSTRUCTORS

& loved by students ALL OVER THE WORLD.

Why you should take this course!

  • Lifetime Access to All Future Updates.
  • 25+ hours of HD quality contents.
  • Fast & Friendly Support in the Q&A section.
  • Custom Notes, homework exercises, Checklists, Templates, course quizzes to Help Get Results Faster.
  • Udemy Certificate of Completion Ready for Download and A 30 Day “No Questions Asked” Money Back Guarantee!

Course Key Features

This course covers all the aspect of this subject. From basic fundamental training to expert level tutorials!
The curriculum has been designed by experienced faculty and feedback from students.

  • Strong Fundamentals  Focussed on fundamentals to set a strong foundation of the course.
  • Video Training  Course is taught via videos and screencasts
  • Planned Curriculum Built by experienced faculty, it is a time bound course
  • Task Oriented Focus on overall learning experience, this course is task based.
  • Event based Various events are organised in the course for an overall learning experience.
  • Learning  Exposure This is not just a course but an overall learning experience.
  • Test Exercises  Advanced level exercises are built in the course.

  • Overall Learning  This is not just a course but an overall learning experience.
  •  Advanced Exercises  Advanced level exercises are built in the course.
  • One to One interaction Student Instructor one to one interaction in the course.
  • Live Experiments Students are exposed to live experimentation and learning from practicals.
  • Focus on Details Course specialises in focussing on minute details in the subject.
  • Experiential Learning Focus on overall learning experience, this course is task based.
  • Student Focussed Built by experienced faculty, it is a time bound course

What you will Learn

  • Learn to use the easiest Business Intelligence tool to create stunning reports and dashboards
  • Learn how you can visualize that data in a meaningful way to revile insights into your business like never before
  • Learn how, with Power BI, to connect to multiple sources of data like SQL Server, Excel, CSV, JSON, XML, Web and SQL Analysis Services etc....
  • Learn how to, with the power of basic DAX, create powerful calculations and comparisons across multiples tables of data
  • Learn what is Predictive, Descriptive and Prescriptive analytics and how to do it in Power BI
  • Learn how to use charts using visuals like column, line, pie, combo, Scatter, Treemap, Funnel, Gauges and KPIs to name a few
  • Learn how to create advanced DAX measures and calculated columns for complex calculations
  • Learn to create powerful tables and matrixes of reporting data.
  • Learn how to use Text Boxes, Shapes, Images, maps, and other visuals.
  • Learn how to turn data into insight and data into interactive visualizations to tell a story.
  • Learn how to use advanced features like Report page tooltips and Bookmarks.
  • Learn and develop data modeling skills.
  • Easily clean the messy data, model your data as per your requirement and format your report to make it look beautiful and professional.
  • Learn how to automate the cleansing of data.
  • Learn how to collaboration and sharing of content on Microsoft's Powerful platform
  • Learn Dataflows (new CDM base, Azure Lake gen2), what it is and how to use and configure databases in it.
  • Learn how to save screen real state using Dynamic Dimensions and Dynamic Meassures.
  • Learn to use Custom Visualizations and Themes in Power BI

Start Learning now ...

This hands-on course will prepare you to start your data analytics career. Absolutely no Power BI or Database experience is required. We will start from the basics and gradually build up your knowledge with clear and concise step by step instructions.

Course Curriculum

  • Introduction to Power BI
  • Collect, Injest and Import Data
  • Prep, Clean and Shape Data
  • Power BI Visuals
  • Data Modeling
  • Introduction to DAX
  • Hands-on Real-word Projects
  • Personal - Enterprise Gateway
  • Power BI Service and Dashboards
  • Sharing and Collaboration

Section 1. Introduction to Power BI
Course Introduction
Thank you for enrolling – Must watch
Power Bi Introduction – 0
Power Bi Introduction – 1
Power Bi Introduction – 2
Why Microsoft Power BI
Power BI Family
Power BI Desktop
Power BI Service 1
Power BI Service 2
Descriptive-Predictive-Prescriptive Analytics
IT Challenges 0
IT Challenges 1

01:18:33

06:12
01:26
02:16
09:34
07:05
04:17
08:39
08:35
11:34
04:27
03:46
04:59
04:57

Collect , Injest and Import Data

Import data from CSV files
Import data from Excel files
Import data from Web 1
Import data from Web 2
Import Real-time Streaming Data
Import data from SQL Server
Import data from OData feed REST-API
Import Data from Folder
Dataflows – Introduction
Dataflows – Create Gateway from Scratch
Dataflows – Create Entities from CSV file
Dataflows – Create Entities Using SQL Server

01:31:00

04:30
04:15
12:02
06:18
09:35
07:38
02:29
06:12
05:31
08:14
13:17
10:54

Prep, Clean and Shape Data

Remove Rows
Remove Columns
Make first row as headers
How to create calculate columns
How to remove duplicates
Unpivot columns and split columns
Change Data type, Replace Values and Rearrange the columns
Append Queries
Merge Queries

42:55

02:47
02:10
01:36
05:52
03:06
05:41
03:27
10:02
08:09

Power BI Visuals

Visuals Intro
Visuals-Bar Charts
Visuals-Line Charts
Visuals-Pie Chart
Stacked bar Chart
Clustered Column Chart
Visuals-Area Chart and Analytics Tab Explained-0
Visuals-Area Chart and Analytics Tab Explained-1
Visuals-Combo Chart
Visuals-Scatter Chart
Visuals-Treemap Chart
Visuals-funnel Chart
Visuals-Card and Multi-Row Card
Visuals-Gauge Card
Visuals-KPIs
Visuals-Matrix
Visuals-Table
Visuals-Text boxes – Shapes – Images
Visuals-Maps
Custom Visuals – Word Cloud
Visualization interactions

003:02:30

06:54
12:27
06:43
07:45
05:31
04:46
12:49
11:01
06:42
09:36
05:51
06:11
13:48
07:12
05:52
09:43
04:39
18:26
07:45
12:22
06:24

Data Modeling

Our First Report-0
Our First Report-1
Our First Report-2
Our First Report-3
Publishing and Sharing report
Modeling Basics-0
Modeling Basics-1
Modeling Basics-2
Modeling and Relationships-0
Modeling and Relationships-1
Other ways to create Relationship
Normalization – Denormalization-0
Normalization – Denormalization-1
OLTP vs OLAP
Star Schema vs Snowflake Schema-0
Star Schema vs Snowflake Schema-1

02:14:35

10:41
09:45
10:07
09:46
10:13
10:21
06:24
04:51
08:53
07:27
04:34
09:44
06:41
08:02
08:36
08:30

Introduction to DAX

DAX101 – Importing Data for Dax Learning
DAX101 – Resources for Dax Learning
DAX101 – What is Dax
DAX101 – Dax Data Types
DAX101 – Dax Operators and Syntax
DAX101 – M vs Dax
DAX101 – Create a Column
DAX101 – Rules to Create Measures
DAX101 – Calculated Columns vs Measures-0
DAX101 – Calculated Columns vs Measures-1
DAX101 – Sum()
DAX101 – AVERAGE()-MIN()-MAX()
DAX101 – SUMX()
DAX101 – DIVIDE()
DAX101 – COUNT()-COUNTROWS()
DAX101 – CALCULATE()-0
DAX101 – CALCULATE()-1
DAX101 – FILTER()
DAX101 – ALL()
DAX101 – Time Intelligence-Create Date Table 0
DAX101 – Time Intelligence-Create Date Table 1
DAX101 – Time Intelligence-PREVIOUSMONTH()
DAX101 – Time Intelligence-SAMEPERIODLASTYEAR()
DAX101 – Time Intelligence – TOTALYTD()
DAX101 – Display Last Refresh Date
DAX101 – Time Intelligence – DATEADD()
DAX101 – Quick Measures

03:09:19

06:31
06:00
05:09
04:07
08:20
08:32
05:39
06:37
08:48
06:19
06:06
04:22
06:27
06:48
09:42
08:42
05:51
10:51
08:47
07:36
07:59
05:58
06:27
06:34
04:28
10:32
06:07

Hands-on Real-word Projects

Delicious Pizza Report-0
Delicious Pizza Report-1
Delicious Pizza Report-2
Abank Bank Report-0
Abank Bank Report-1
Abank Bank Report-2
Abank – Create phone layout
Financial Report-0
Financial Report-1
Financial Report-2
Financial Report-3
Financial Report-4
Financial Report-5
Personality and looks-0
Personality and looks-1
Personality and looks-2
Productivity Survey by-0
Productivity Survey by-1
Productivity Survey by-2
Productivity Survey by-3
Productivity Survey-4
Toughest Sport by Skills-0
Toughest Sport by Skills-1
Toughest Sport by Skills-2
Natural Disasters-0
Natural Disasters-1
Natural Disasters-2
Natural Disasters-3
Please watch this first
Adv – Procurement Analysis-0
Adv – Procurement Analysis-1
Adv – Procurement Analysis-2
Adv – Procurement Analysis-3
Adv – Procurement Analysis-4
Adv – Product Analysis-0
Adv – Product Analysis-1
Adv – Product Analysis-2
Adv – Product Analysis-3
Adv – Regional Analysis-0
Adv – Regional Analysis-1
Adv – Regional Analysis-2
Adv – Regional Analysis-3
Adv – Regional Analysis-4
Adv – IT-Tickets Analysis-0
Adv – IT-Tickets Analysis-1
Adv – IT-Tickets Analysis-2
Adv – IT-Tickets Analysis-3
Adv – IT-Tickets Analysis-4
Adv – Human Resources 1-0
Adv – Human Resources 1-1
Adv – Human Resources 1-2
Adv – Human Resources 1-3
Adv – Human Resources 2-0
Adv – Human Resources 2-1
Adv – Human Resources 2-2
Adv – Human Resources 3-0
Adv – Human Resources 3-1
Adv – Human Resources 3-2
Adv – Financial Report-0
Adv – Financial Report-1
Adv – Financial Report-2
Adv – Financial Report-3
Adv – Financial Report-4
Adv – Sales Report-0
Adv – Sales Report-1
Adv – Sales Report-2
Adv – Bank Report-0
Adv – Bank Report-1
Adv – Bank Report-2
Adv – Bank Report-3
Adv – Bank Report-4

10:25:36

07:05
10:10
08:53
09:48
10:26
09:10
04:15
09:04
08:13
05:34
06:28
04:25
10:30
07:58
09:10
11:27
09:44
09:55
10:48
09:49
11:03
09:22
10:34
12:03
08:43
10:10
09:57
07:10
00:30
08:00
08:01
08:27
07:31
09:13
09:17
08:45
11:52
05:51
09:16
11:21
09:44
09:54
06:35
09:15
10:06
11:23
09:52
14:10
09:22
11:20
08:15
13:41
06:33
10:37
09:30
07:45
09:29
08:53
09:16
08:52
09:31
09:25
05:49
10:33
09:00
04:42
05:18
07:36
08:05
05:35
05:32

Personal – Enterprise Gateway

On-Premises Gateway
Personal vs Enterprise Gateway
Install and Configure Personal Gateway
Install and Configure Enterprise Gateway
Manage SQL Server Data Source thru Enterprise Gateway

37:54

07:41
03:23
09:45
06:00
11:05

Power BI Service and Dashboards

PowerBI Reports
PowerBI Workspaces
PowerBI Datasets
What are Dashboards
Create Workspace and Publish Report
Create dashboards 6 different ways-0
Create dashboards 6 different ways-1
Favorite dashboards/reports/apps
Subscribe to a Report or Dashboard
Rename Workspace/Report/Dashboard
Full screen mode
Delete Reports or Dashboards
Dashboard Menus
Quick Insights
Setting up Alerts on Cards
Q-A in Power BI
Analyze in Excel
File and View Options
Printing Dashboard and Reports
Row level security
Reports using Mobile Devices
Report page tooltip-0
Report page tooltip-1
Filter- Page-Report-0
Filter- Page-Report-1

02:23:23

00:50
02:13
02:37
02:03
03:28
08:05
11:13
02:15
02:34
04:35
02:37
04:04
12:11
11:19
05:56
04:48
04:17
04:59
03:37
09:06
09:46
08:50
05:02
08:01
08:57

Sharing and Collaboration

Sharing and Collaboration
Sharing Dashboard
Sharing Workspaces
Sharing App
Publish To Web

31:31

03:37
05:16
09:31
08:02
05:05

Comments are closed.