🔥$100K Hit! Where Will Bitcoin Go Next? Find Out Live!
watching now
5 Students

Description

What Will You Learn?

  • How to visualize business data in Power BI
  • How to use Power BI to create reports and dashboards
  • How to edit data in both Power BI and Power Query Editor
  • How to filter and analyze data in Power BI

Requirements

  • Power BI
  • Interest in business analytics
  • NFT Certificate
  • 158 Lessons
  • Beginner
  • English
  • 4.1 Rating
  • +100 XP

Share Course on Social media

Curriculum

Course consist of total 11h 58min of content, in total.

Section 1: Introduction
01:43
Section 2: Microsoft Power BI:Create Global Store Sales Dashboard
1:03:44
Adding Background Image in the Page and Access Database File
03:56
Adding Image,Text Box and Card Part 1
05:35
Adding Image,Text Box and Card Part 2
07:20
Adding Buttons and Map
03:49
Adding Slicers
05:17
Adding Table and Selecting Top 5 Countries by Sales in Funnel Chart
06:51
Locking Visual for Filtering Data
04:25
Adding Table and Conditionally Formatting Table Values
06:43
Adding Column Chart and Customer Slicer
04:28
Adding Line Chart
02:50
Bookmarks the Pages
06:01
Use Buttons to Navigate Pages and Slicer for to Get Specific Data
05:51
Section 3: Microsoft Power BI:Create Malaria Analytics Dashboard
1:46:05
Adding Horizontal Bar,Image and Text Box
04:10
Adding Slicers and Clear Filters Button
06:18
Adding Data Set,Text Box,Button,Horizontal Line and Map Chart
06:16
Adding Stacked Bar Chart and Table
07:25
Adding Card and Text Box
05:21
Copy and Paste Slicers and Clear Filters Button
05:23
Adding Card and Text Box Part 1
07:59
Adding Card,Text Box and Stacked Area Chart Part 2
07:07
Adding Data Tables
05:23
Use Copy and Paste Technique
07:49
Adding Line Chart and Table
05:30
Filter Specific Data by Using Filter Pane
03:57
Copy and Paste Layers of Previous Page Part 1
07:08
Copy and Paste Layers of Previous Page Part 2
08:17
Adding Previous Buttons and Creating Bookmarks Part 1
05:46
Adding Previous Buttons and Creating Bookmarks Part 2
04:22
Inserting Bookmarks Links in the Buttons
05:42
Clear All Filters
00:56
Section 4: Microsoft Power BI:Create Climate Change Report
2:57:26
Introduction
02:22
Creating Page 1 (Home Page)
06:39
Creating Page 2 (Carbon Dioxide) Part 1
05:28
Creating Page 2 (Carbon Dioxide) Part 2
02:15
Creating Page 2 (Carbon Dioxide) Part 3
05:12
Creating Page 2 (Carbon Dioxide) Part 4
03:48
Creating Page 2 (Carbon Dioxide) Part 5
03:30
Creating Page 2 (Carbon Dioxide) Part 6
05:18
Creating Page 2 (Carbon Dioxide) Part 7
02:43
Creating Page 3 (Global Temperature) Part 1
03:17
Creating Page 3 (Global Temperature) Part 2
06:47
Creating Page 3 (Global Temperature) Part 3
04:46
Creating Page 3 (Global Temperature) Part 4
06:15
Creating Page 3 (Global Temperature) Part 5
05:30
Creating Page 3 (Global Temperature) Part 6
04:21
Creating Page 4 (Ice Area) Part 1
06:04
Creating Page 4 (Ice Area) Part 2
05:36
Creating Page 4 (Ice Area) Part 3
02:06
Creating Page 4 (Ice Area) Part 4
07:03
Creating Page 4 (Ice Area) Part 5
06:16
Creating Page 4 (Ice Area) Part 6
01:22
Creating Page 5 (Disasters) Part 1
05:18
Creating Page 5 (Disasters) Part 2
03:13
Creating Page 5 (Disasters) Part 3
05:59
Creating Page 5 (Disasters) Part 4
02:41
Creating Page 5 (Disasters) Part 5
04:15
Creating Page 6 (Plastic Pollution) Part 1
02:34
Creating Page 6 (Plastic Pollution) Part 2
07:26
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 1
05:03
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 2
05:21
Creating Page 7 (Ozone Hole Area and Air Pollution) Part 3
03:16
Creating Page 8 (Causes , Effects and Prevention) Part 1
05:12
Creating Page 8 (Causes , Effects and Prevention) Part 2
04:08
Creating Page 8 (Causes , Effects and Prevention) Part 3
04:27
Creating Page 8 (Causes , Effects and Prevention) Part 4
05:42
Creating Page 8 (Causes , Effects and Prevention) Part 5
05:06
Creating Page 8 (Causes , Effects and Prevention) Part 6
02:42
Bookmarks Report Pages
06:03
Insert Bookmarks Links in the Buttons
02:22
Section 5: Bookmarks Pane and Selection Pane
1:21:59
Analyzing Data by Creating Column,Bar and line Charts Buttons
07:25
Analyzing Data by Creating Pie,Donut and Map Charts Buttons
07:51
Analyzing Data by Creating Sales Report and Units Sold Report Buttons
07:27
Creating Color Buttons for Chart
07:00
Creating Font Sizes Buttons for Chart
06:46
Creating Axis Buttons for Chart
09:04
Creating Clear All Slicers Button
03:46
Creating Another Slicers Panel with Two Buttons
06:31
Creating Toggles Button
07:00
Creating Another Toggles Button
09:07
Section 6: Editing and Visualizing Data
2:10:58
Download Course Files
Introduction to Power BI and Loading Data in Power BI Part 1
04:31
Introduction to Power BI and Loading Data in Power BI Part 2
04:10
Manage Relationships Between Data Tables in the Power BI
04:24
Creating First Sales Report in the Report Tab
06:16
Visualizing First Sales Report Data
07:25
Filtering Data by Selecting Top and Bottom options
02:07
Creating and Visualizing Second Sales Report in the Report Tab
08:41
Fltering Data by Using Treemap Chart
03:01
Creating and Visualizing Third Sales Report in the Report Tab
14:34
Formating Column Chart
02:38
Analyzing Data by Using Pie Chart
03:28
Analyzing Data by Using Scatter Chart
02:39
Analyzing Data by Using Waterfall Chart
02:55
Analyzing Data by Using Guage Card
02:01
Adding Text Box,Image and Shapes
03:44
Locate Places with Latitudes and Longitudes
03:44
Globe Map
02:55
Creating and Visualizing Fourth Sales Report in the Report Tab
09:40
Analyzing Data in the Combination Charts
03:37
Formatting Slicers
04:43
Formatting and Changing Layout of Page
04:24
Creating a Duplicate Report Page
03:57
Summarizing Sales Data
03:50
Create Hierarchies and Drill Down Data
09:51
Selecting Filter Options
01:45
Changing the Background Color of Page
03:52
Adding Background Image in the Report Page
01:10
Analyzing Data by Using Analytics
04:45
Section 7: Extracting Data from the Website
15:47
Extracting Sales Data from the Website
06:41
Creating Report
03:16
Visualizing Report
05:50
Section 8: Extracting Sales Data from the Website
17:47
Extracting Sales Data from the Website
03:25
Combining all Queries into one Query
02:13
Extracting User Data from the Website and Merging Two Queries Data in One Query
07:45
Analyzing Top Sold Movies Data in Power BI
04:24
Section 9: Publish and Create Dashboard
45:13
Upload Report into Power BI Web
01:30
Create Dashboard
04:35
Quick Insights in Data
04:15
Open in Focus Mode and Edit Details
02:27
Adding Textbox in the Dashboard
04:28
View Dashboard in Full Screen Mode
01:43
Adding Image in the Dashboard
03:11
Asking Questions to Data
04:04
Manage Data Gateway(Automatically Refresh Dashboard Data)
04:12
Printing Dashboard
01:54
Republish Power BI Desktop Report
01:38
Create Workspace to Share Data into Organization
01:56
Creating Apps
02:58
Editing Apps
01:39
Installing Third Parties Apps
02:40
Publishing Power BI Report to Web
02:03
Section 10: New Quick Measure(Calculations Without Dax Code)
04:51
Calculating Sales Year to Date
03:18
Calculating Running Total
01:33
Section 11: Custom Visuals
1:08:19
Synoptic Panel Part 1
03:35
Synoptic Panel Part 2
03:06
Chiclet Slicer
05:11
KPI(Key Performance Indicator) Part 1
04:10
KPI(Key Performance Indicator) Part 2
02:04
Bullet Chart
03:20
Dial Gauge
03:35
Linear Gauge
02:29
Infographic Designer
04:43
Infographic Designer(Show Motorcycles Shapes in Bar Chart)
04:31
Infographic Designer(Show Apartment Shapes in Column Chart)
03:22
Infographic Designer(Adding Images in Column Chart)
03:43
Infographic Designer(Changing Multiple Layout Part 1)
02:57
Infographic Designer(Changing Multiple Layout Part 2)
03:59
Infographic Designer(Show Sales in Shapes)
03:31
Infographic Designer(Show Sales in Multiple Shapes)
03:01
TreeViz and Funnel Visuals
03:26
Agility Planning Matrix
02:45
Sunburst and KPI Card Visuals
02:49
Network Visuals
02:02
Section 12: Global
04:28
Adding Column Chart and Customer Slicer
04:28

About the Instructor

I have completed master degree in science (applied physics) but now I am teaching Microsoft Excel and Microsoft Power BI online and hundreds of students have enrolled in my courses. I love teaching online as well as I am teaching data analysis and data visualization.

See All Instructor Courses

BitDegree platform reviews