Business Data Analysis Using Microsoft Power Bi

Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI

Last updated 2022-01-10 | 4.4

- 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....

What you'll 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 how to create advanced DAX measures and calculated columns for complex calculations.

Learn Dataflows (new CDM base

Azure Lake gen2)

what it is and how to use and configure databases in it.

Learn how to use charts using visuals like column

line

pie

combo

Scatter

Treemap

Funnel

Gauges and KPIs to name a few.

Easily clean the messy data

model your data as per your requirement and format your report to make it look beautiful and professional.

Learn to create powerful tables and matrix 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 to use Custom Visualizations and Themes in Power BI.

Learn and develop data modeling skills.

Learn how to automate the cleansing of data.

Learn how to collaboration and sharing of content on Microsoft's Powerful platform.

This hands on course will prepare you to start your data analytics career.

Learn Dashboard-in-a-day at your own pace at home or at your office.

Learn Power BI Best Practices

Tip and Tricks.

* Requirements

* Absolutely no experience is required. We will start from the basics and gradually build up your knowledge with clear and concise step by step instructions
* No prior knowledge needed
* covers Power BI end to end
* while providing a wealth of practical tips for those that already know Power BI.
* Power BI requires that you use a work or school email address to sign up. You can't sign up using email addresses provided by consumer email services or telecommunication providers. This includes outlook
* hotmail
* gmail
* yahoo and others.

Description

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 how to create advanced DAX measures and calculated columns for complex calculations.
Learn Dataflows (new CDM base, Azure Lake gen2), what it is and how to use and configure databases in it.
Learn how to use charts using visuals like column, line, pie, combo, Scatter, Treemap, Funnel, Gauges and KPIs to name a few.
Easily clean the messy data, model your data as per your requirement and format your report to make it look beautiful and professional.
Learn to create powerful tables and matrix 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 to use Custom Visualizations and Themes in Power BI.
Learn and develop data modeling skills.
Learn how to automate the cleansing of data.
Learn how to collaboration and sharing of content on Microsoft's Powerful platform.
This hands on course will prepare you to start your data analytics career.
Learn Dashboard-in-a-day at your own pace at home or at your office.
Learn Power BI Best Practices, Tip and Tricks.

Course content

15 sections • 252 lectures

Business intelligence - Course Introduction 2 lectures

Business Analysis - Course Introduction Preview 11:31

Thank you for enrolling & How to get support Preview 03:10

What is Business Intelligence and why companies use it 6 lectures

What is Business Intelligence Preview 03:43

Why use Business Intelligence Preview 08:09

What answers Business Intelligence gives a business Preview 10:45

Characteristics of Modern BI Tools Preview 10:28

Factors to consider while buying business intelligence solution Preview 07:25

Descriptive-Predictive-Prescriptive Analytics Preview 03:46

Introduction to Power BI 10 lectures

Power Bi Introduction - 0 Preview 02:11

Power Bi Introduction - 1 Preview 08:24

Power Bi Introduction - 2 Preview 07:05

Why Microsoft Power BI Preview 04:17

Power BI Family Preview 08:16

Power BI Desktop Preview 08:35

Power BI Service 1 Preview 11:21

Power BI Service 2 Preview 04:11

IT Challenges 0 Preview 04:59

IT Challenges 1 Preview 04:57

Data Analysis and Business Intelligence - Collect , Injest and Import Data 15 lectures

Download Data files first Preview 00:05

Import data from CSV files Preview 04:30

Import data from Excel files Preview 04:15

Import data from Web 1 Preview 12:02

Import data from Web 2 Preview 06:18

Import Real-time Streaming Data Preview 09:35

Download and Install SQL Server Express Preview 07:56

Download and Install Sample Databases Preview 08:22

Import data from SQL Server Preview 07:38

Import data from OData feed REST-API Preview 02:29

Import Data from Folder Preview 06:12

Dataflows - Introduction Preview 05:31

Dataflows - Create Gateway from Scratch Preview 08:14

Dataflows - Create Entities from CSV file Preview 13:17

Dataflows - Create Entities Using SQL Server Preview 10:54

Power Query : Prep, Clean and Shape Data 10 lectures

Download resources for this section. Preview 00:05

Remove Rows Preview 02:47

Remove Columns Preview 02:10

Make first row as headers Preview 01:36

How to create calculate columns Preview 05:52

How to remove duplicates Preview 03:06

Unpivot columns and split columns Preview 05:41

Change Data type, Replace Values and Rearrange the columns Preview 03:27

Append Queries Preview 10:02

Merge Queries Preview 08:09

Power BI Visuals 23 lectures

Download resources for this section. Preview 00:03

Visuals Intro Preview 06:54

Visuals-Bar Charts Preview 12:27

Visuals-Line Charts Preview 06:43

Visuals-Pie Chart Preview 07:45

Stacked bar Chart Preview 05:31

Clustered Column Chart Preview 04:46

Visuals-Area Chart and Analytics Tab Explained-0 Preview 12:49

Visuals-Area Chart and Analytics Tab Explained-1 Preview 11:01

Visuals-Combo Chart Preview 06:42

Visuals-Scatter Chart Preview 09:36

Visuals-Treemap Chart Preview 05:51

Visuals-funnel Chart Preview 06:11

Visuals-Card and Multi-Row Card Preview 13:48

Visuals-Gauge Card Preview 07:12

Visuals-KPIs Preview 05:52

Visuals-Matrix Preview 09:43

Visuals-Table Preview 04:39

Visuals-Text boxes - Shapes - Images Preview 18:26

Visuals-Slicers Preview 10:08

Visuals-Maps Preview 07:45

Custom Visuals - Word Cloud Preview 12:22

Visualization interactions Preview 06:24

Data Modeling in Power BI 17 lectures

Our First Report-0 Preview 10:41

Our First Report-1 Preview 09:45

Our First Report-2 Preview 10:07

Our First Report-3 Preview 09:46

Publishing and Sharing your first report Preview 10:13

Theme Download file Preview 00:02

Modeling Basics-0 Preview 10:21

Modeling Basics-1 Preview 06:24

Modeling Basics-2 Preview 04:51

Modeling and Relationships-0 Preview 08:53

Modeling and Relationships-1 Preview 07:27

Other ways to create Relationship Preview 04:34

Normalization - Denormalization-0 Preview 09:44

Normalization - Denormalization-1 Preview 06:41

OLTP vs OLAP Preview 08:02

Star Schema vs Snowflake Schema-0 Preview 08:36

Star Schema vs Snowflake Schema-1 Preview 08:30

Introduction to DAX using Power BI 28 lectures

DAX101 - Importing Data for Dax Learning Preview 06:31

DAX101 - Resources for Dax Learning Preview 06:00

DAX101 - What is Dax Preview 05:09

DAX101 - Dax Data Types Preview 04:07

DAX101 - Dax Operators and Syntax Preview 08:20

DAX101 - M vs Dax Preview 08:32

DAX101 - Create a Column Preview 05:39

DAX101 - Rules to Create Measures Preview 06:37

DAX101 - Calculated Columns vs Calculated Measures-0 Preview 08:48

DAX101 - Calculated Columns vs Calculated Measures-1 Preview 06:19

DAX101 - Sum() Preview 06:06

DAX101 - AVERAGE()-MIN()-MAX() Preview 04:22

DAX101 - SUMX() Preview 06:27

DAX101 - DIVIDE() Preview 06:48

DAX101 - COUNT()-COUNTROWS() Preview 09:42

DAX101 - CALCULATE()-0 Preview 08:42

DAX101 - CALCULATE()-1 Preview 05:51

DAX101 - FILTER() Preview 10:51

DAX101 - ALL() Preview 08:47

DAX101 - Time Intelligence - Create Date Table in M (important) Preview 10:47

DAX101 - Time Intelligence - Create Date Table in DAX-0 Preview 07:36

DAX101 - Time Intelligence - Create Date Table in DAX-1 Preview 07:59

DAX101 - Time Intelligence - SAMEPERIODLASTYEAR() Preview 06:27

DAX101 - Time Intelligence - TOTALYTD() Preview 06:34

DAX101 - Display Last Refresh Date Preview 04:28

DAX101 - Time Intelligence - PREVIOUSMONTH() Preview 05:58

DAX101 - Time Intelligence - DATEADD() Preview 10:32

DAX101 - Quick Measures Preview 06:07

Hands-on Real-world Projects 71 lectures

Delicious Pizza Report-0 Preview 07:05

Delicious Pizza Report-1 Preview 10:10

Delicious Pizza Report-2 Preview 08:53

Abank Bank Report-0 Preview 09:48

Abank Bank Report-1 Preview 10:26

Abank Bank Report-2 Preview 09:10

Abank - Create phone layout Preview 04:15

Financial Report-0 Preview 09:04

Financial Report-1 Preview 08:13

Financial Report-2 Preview 05:34

Financial Report-3 Preview 06:28

Financial Report-4 Preview 04:25

Financial Report-5 & Analytics tab explained Preview 10:30

Personality and looks-0 Preview 07:58

Personality and looks-1 Preview 09:10

Personality and looks-2 Preview 11:27

Productivity Survey by Microsoft Office Team-0 Preview 09:44

Productivity Survey by Microsoft Office Team-1 Preview 09:55

Productivity Survey by Microsoft Office Team-2 Preview 10:48

Productivity Survey by Microsoft Office Team-3 Preview 09:49

Productivity Survey by Microsoft Office Team-4 Preview 11:03

Toughest Sport by Skills-0 Preview 09:22

Toughest Sport by Skills-1 Preview 10:34

Toughest Sport by Skills-2 Preview 12:03

Natural Disasters-0 Preview 08:43

Natural Disasters-1 Preview 10:10

Natural Disasters-2 Preview 09:57

Natural Disasters-3 Preview 07:10

Please watch this first Preview 00:30

Adv - Procurement-Spend Analysis-0 Preview 08:00

Adv - Procurement-Spend Analysis-1 Preview 08:01

Adv - Procurement-Spend Analysis-2 Preview 08:27

Adv - Procurement-Spend Analysis-3 Preview 07:31

Adv - Procurement-Spend Analysis-4 Preview 09:13

Adv - Product Analysis-0 Preview 09:17

Adv - Product Analysis-1 Preview 08:45

Adv - Product Analysis-2 Preview 11:52

Adv - Product Analysis-3 Preview 05:51

Adv - Regional Analysis-0 Preview 09:16

Adv - Regional Analysis-1 Preview 11:21

Adv - Regional Analysis-2 Preview 09:44

Adv - Regional Analysis-3 Preview 09:54

Adv - Regional Analysis-4 Preview 06:35

Adv - IT-Tickets Analysis-0 Preview 09:15

Adv - IT-Tickets Analysis-1 Preview 10:06

Adv - IT-Tickets Analysis-2 Preview 11:23

Adv - IT-Tickets Analysis-3 Preview 09:52

Adv - IT-Tickets Analysis-4 Preview 14:10

Adv - Human Resources 1-0 Preview 09:22

Adv - Human Resources 1-1 Preview 11:20

Adv - Human Resources 1-2 Preview 08:15

Adv - Human Resources 1-3 Preview 13:41

Adv - Human Resources 2-0 Preview 06:33

Adv - Human Resources 2-1 Preview 10:37

Adv - Human Resources 2-2 Preview 09:30

Adv - Human Resources 3-0 Preview 07:45

Adv - Human Resources 3-1 Preview 09:29

Adv - Human Resources 3-2 Preview 08:53

Adv - Financial Report-0 Preview 09:16

Adv - Financial Report-1 Preview 08:52

Adv - Financial Report-2 Preview 09:31

Adv - Financial Report-3 Preview 09:25

Adv - Financial Report-4 Preview 05:49

Adv - Sales Report-0 Preview 10:33

Adv - Sales Report-1 Preview 09:00

Adv - Sales Report-2 Preview 04:42

Adv - Bank Report-0 Preview 05:18

Adv - Bank Report-1 Preview 07:36

Adv - Bank Report-2 Preview 08:05

Adv - Bank Report-3 Preview 05:35

Adv - Bank Report-4 Preview 05:32

Personal - Enterprise Gateway 5 lectures

On-Premises Gateway Preview 07:41

Personal vs Enterprise Gateway Preview 03:23

Install and Configure Personal Gateway Preview 09:45

Install and Configure Enterprise Gateway Preview 06:00

Manage SQL Server Data Source thru Enterprise Gateway Preview 11:05

Power BI Service and Dashboards 25 lectures

PowerBI Reports Preview 00:50

PowerBI Workspaces Preview 02:13

PowerBI Datasets Preview 02:37

What are Dashboards Preview 02:03

How to create Workspace and Publish Report Preview 03:28

Create dashboards 6 different ways-0 Preview 08:05

Create dashboards 6 different ways-1 Preview 11:13

Favorite dashboards, reports, and apps in Power BI Preview 02:15

Subscribe to a Report or Dashboard Preview 02:34

Rename Workspace or Report or Dashboard Preview 04:35

Display Reports or Dashboards in Full screen mode Preview 02:37

Delete Reports or Dashboards Preview 04:04

Dashboard Menus Preview 12:11

Quick Insights Preview 11:19

Setting up Alerts on Cards Preview 05:56

Q-A in Power BI Preview 04:48

Analyze in Excel Preview 04:17

File and View Options Preview 04:59

Printing Dashboard and Reports Preview 03:37

Row level security Preview 09:06

Access Reports Dashboards using Mobile Devices Preview 09:46

Report page tooltip-0 Preview 08:50

Report page tooltip-1 Preview 05:02

Filter- Page-Report-Visualization level-0 Preview 08:01

Filter- Page-Report-Visualization level-1 Preview 08:57

Row Level Security in Power BI 10 lectures

PATH Function Preview 09:34

PATHCONTAINS Function Preview 04:12

PATHITEM Function Preview 03:36

PATHITEMREVERSE Function Preview 03:47

PATHLENGTH Function Preview 02:45

RLS - Static Row Level Security Preview 11:06

RLS - Dynamic Row Level Security Preview 11:20

RLS - Organizational Hierarchy 1 Preview 11:40

RLS - Organizational Hierarchy 2 Preview 11:14

RLS - Organizational Hierarchy 3 Preview 04:04

Sharing and Collaboration in Power BI 5 lectures

Sharing and Collaboration Preview 03:37

Sharing Dashboard Preview 05:16

Sharing Workspaces Preview 09:31

Sharing App Preview 08:02

Publish To Web Preview 05:05

Bonus Lectures 24 lectures

Download Materials Preview 00:05

Power BI : Best Practices, Tips and Tricks 0 Preview 10:03

Power BI : Best Practices, Tips and Tricks 1 Preview 10:00

Power BI : Best Practices, Tips and Tricks 2 Preview 09:57

Power BI : Best Practices, Tips and Tricks 3 Preview 09:59

Power BI : Best Practices, Tips and Tricks 4 Preview 10:00

Power BI : Best Practices, Tips and Tricks 5 Preview 14:09

Dashboard-in-a-day : Download Material link Preview 00:05

Dashboard-in-a-day : Introduction Preview 08:18

Dashboard-in-a-day : Accessing Data Preview 12:55

Dashboard-in-a-day : Data Preparation 0 Preview 10:31

Dashboard-in-a-day : Data Preparation 1 Preview 09:10

Dashboard-in-a-day : Data modeling and Exploration 0 Preview 09:39

Dashboard-in-a-day : Data modeling and Exploration 1 Preview 11:40

Dashboard-in-a-day : Data modeling and Exploration 2 Preview 09:26

Dashboard-in-a-day : Data modeling and Exploration 3 Preview 10:18

Dashboard-in-a-day : Data modeling and Exploration 4 Preview 09:39

Dashboard-in-a-day : Data Visualizations 0 Preview 15:39

Dashboard-in-a-day : Data Visualizations 1 Preview 12:12

Dashboard-in-a-day : Publishing Report Preview 09:41

Dashboard-in-a-day : Creating Dashboards 0 Preview 08:53

Dashboard-in-a-day : Creating Dashboards 1 Preview 06:30

Dashboard-in-a-day : 6 ways to create Dashboards 0 Preview 08:05

Dashboard-in-a-day : 6 ways to create Dashboards 1 Preview 11:13

Final Words 1 lectures