Data Analytics Essentials With Power Bi

  1. Home
  2. Microsoft-power-bi
  3. Data Analytics Essentials With Power Bi

Tags: Microsoft Power BI

Get Started Quickly with Visualization, Data Prep and DAX on Power BI

Last updated 2022-01-10 | 4.6

- Simple methods to Analyze data with Power BI and gain Insights
- Automate manual reporting processes with Power BI
- Make reports available to stakeholders 24/7 on all devices

What you'll learn

Simple methods to Analyze data with Power BI and gain Insights
Automate manual reporting processes with Power BI
Make reports available to stakeholders 24/7 on all devices
Select the appropriate charts for visualization (Data Visualization)
Create links in reports with Book Marks (Data Visualization)
Design Interactive Reports and Dashboards (Data Visualization)
Logical steps to build Data Models from (Data Modeling & DAX)
Understand concept of Fact and Dimension Tables (Data Modeling & DAX)
Simplified methods to write your own DAX Measures (Data Modeling & DAX)
Build your Calendar/Date Table from Scratch with DAX (Data Modeling & DAX)
Combine multiple Excel Workbooks (Data Preparation)
Combine Multiple Excel Worksheets (Data Preparation)
Master the rules for Data Preparation (Data Preparation)

* Requirements

* Basic Reporting
* Fundamental Excel Knowledge is an added advantage
* Knowledge of Excel Pivot Tables is an added advantage

Description

  • Simple methods to Analyze data with Power BI and gain Insights
  • Automate manual reporting processes with Power BI
  • Make reports available to stakeholders 24/7 on all devices
  • Select the appropriate charts for visualization (Data Visualization)
  • Create links in reports with Book Marks (Data Visualization)
  • Design Interactive Reports and Dashboards (Data Visualization)
  • Logical steps to build Data Models from (Data Modeling & DAX)
  • Understand concept of Fact and Dimension Tables (Data Modeling & DAX)
  • Simplified methods to write your own DAX Measures (Data Modeling & DAX)
  • Build your Calendar/Date Table from Scratch with DAX (Data Modeling & DAX)
  • Combine multiple Excel Workbooks (Data Preparation)
  • Combine Multiple Excel Worksheets (Data Preparation)
  • Master the rules for Data Preparation (Data Preparation)

Course content

6 sections • 81 lectures

Intro & Overview 15 lectures

Welcome! Preview 00:33

Introductions Preview 04:07

About the Course Preview 06:07

Downloading Power BI Desktop Preview 02:38

Understanding the Power BI User Interface Preview 08:03

Power BI Interface

Check your knowledge

Understanding the Case Study Data Preview 04:24

Importing Data to Power BI Preview 03:53

Understanding the Power Query User Interface Preview 05:26

Intro to Transforming Data with Power Query Preview 03:29

Intro to Transforming Data with Power Query Continued Preview 05:05

Re-Using M Scripts in Microsoft Excel and Loading Data to Power BI Preview 03:46

More Information on using copied M Scripts to Excel Preview 00:30

Editing Queries and Refreshing Data Preview 00:00

Power Query Transformation

Check your knowledge

Visualizing Reports in Power BI 21 lectures

Introduction to Power BI Reporting Preview 03:36

Visualizing a timeline report with Line Chart Preview 03:33

Formatting Power BI Charts Preview 05:54

Adding a new chart to the canvass Preview 03:23

Creating a Top N Report with a Bar Chart Preview 03:34

Sorting a Visual Preview 03:20

Filtering a page with Filters Pane and Using Slicers Preview 05:44

Controlling Visual Interactions on the Canvass Preview 03:07

Using Visuals Background to enhance Report Page Preview 01:56

Using Shadows to enhance Reports Preview 00:16

Chart Elements

Check your knowledge

Working with Shapes and Text Box Preview 03:03

Working with Report Themes Preview 03:45

Re-Using a Report Page as Template Preview 04:40

Adding a back button to return to a previous page Preview 01:48

Designing a Report optimized for Mobile View Preview 03:21

Publishing Reports to the Power BI Service Preview 05:25

Introduction to Q & A Preview 03:18

Selecting the right Visuals Preview 03:12

Module Outro Preview 00:46

Assignment

In this assignment, you will use the Super Store excel data to build a Power BI Report

Understanding Data Modeling in Power BI 10 lectures

Introduction to Data Modeling Preview 03:12

Why build a Data Model? Preview 04:36

Step 1 - 4 of Building a Data Model Preview 11:27

Step 5 of Building a Data Model Preview 06:34

Preparing Data Model Files in Power Query Preview 03:25

Extracting the Fact and Dimension Tables Preview 04:44

Investigating & Resolving issues with Relationships 1 Preview 04:49

Investigating & Resolving issues with Relationships 2 Preview 07:46

Testing the Relationships in Report View Preview 02:13

Data Modeling Quiz

Test your knowledge on Data Models

Introduction to DAX 19 lectures

Data Analysis Expressions (DAX) Preview 00:33

Introduction to DAX Preview 02:21

Using CALENDARAUTO() to generate a Calendar Table Preview 05:02

Using FORMAT() Function to add Month, Year and Quarter Columns to Calendar Preview 06:45

Connecting the Calendar Table to the Fact Table Preview 03:26

Using the MONTH() Function to Create a Custom Sort Column for the Month Column Preview 02:39

Writing simple Aggregation Measure Preview 04:09

Aggregation Measures Preview 00:19

Understanding Filter Context 1 Preview 03:57

Understanding Filter Context 2 Preview 02:31

Introduction to CALCULATE() function Preview 05:31

Creating a shell table to keep Measures Preview 02:35

Writing Time Intelligence Formulas - the PREVIOUSMONTH() Function Preview 06:41

Calculating Month on Month Variance Preview 03:42

Using the REMOVEFILTERS() function and Calculating Percentage share Preview 04:50

During the March 2020 update, the REMOVEFILTERS() function used in this lesson has stopped showing up in the Power BI Intellisense. So you will have to type out the full name of the function, open parenthesis and enter the arguments as shown in the video, then close the parenthesis as usual. It still works very fine.

Using SAMEPERIODLASTYEAR() to calculate SPLY Values Preview 02:28

Calculating Year to Date Values Preview 05:02

Automatic Measures with Quick Measures Preview 03:06

Time intelligence Formulas Preview 00:17

Visualizing the Measures 9 lectures

Customizing the Report Theme Preview 01:51

Creating a Report Page Template Preview 04:32

Visualizing Monthly Revenue vs SPLY on a Line Chart Preview 02:53

Creating a Forecast from a Line Chart Preview 04:31

Visualizing Monthly Variance with a Waterfall Chart Preview 02:44

Creating a Matrix Table report with Data Bars Preview 02:24

Creating a simple Donut Chart Preview 01:46

Visualizing Current & Previous Period with Clustered Bar Chart Preview 01:58

Visualizing Changes in ranking over time with Ribbon Chart Preview 05:00

Data Preparation Techniques 7 lectures

Introduction to Data Preparation Preview 01:10

Using Append method to combine Excel Worksheets Preview 05:11

Using Workbook Property Method to combine Excel Worksheets Preview 07:02

Comparing Append & Workbook Property Consolidation Methods Preview 04:00

Consolidating Clean Excel Workbooks from a Folder Preview 05:42

Consolidating un-clean Excel Workbooks from a Folder Preview 09:45

What next? Preview 00:40