Watch Microsoft Power BI: The Complete Guide Free Online - Full Video Classroom | MJ Accedemy

Udemy – Microsoft Power BI: The Complete Guide 2024-11

Download Course (Free)

Lecture 17/78

00:00/00:00

Lecture 17 of 78

Data Types

Download Course (Free)

Course Content

0 / 78 completed

Section 1: Part 1 Loading and Transforming Data26 videos

Part 1 Section Overview

Saving Your Work

Entering Data Manually

Loading the Races CSV Data

Removing Rows and Columns

Simple Mathematical Operations

Duplicate, Index and Conditional Columns

12m

Filtering Values

Sorting your Data

Working with Columns

Splitting Extracting Information from Columns

11m

Data Types

25mNow Playing

Logically Ordering your Applied Steps

14m

Refreshing the Source Data

Duplicate vs Reference

Transpose, Reverse Rows and Count Rows

Replacing Values

Appending Queries

Removing Duplicates

Loading the Circuits JSON File & Assignment

Loading the Constructors CSV File & Assignment

Pivoting and Unpivoting

Group By

Loading the Drivers Text File & Assignment

11m

Download the Part 1 Power BI Report

Loading the Results CSV File & Assignments

18m

Section 2: Introduction and Set Up5 videos

Power BI Desktop Installation

Power BI Ecosystem

Course Introduction

13m

Power BI Desktop Interface Overview

12m

Course Project and Dataset Download (IMPORTANT)

17m

Section 3: Part 2 Data Modelling11 videos

Part 2 Section Overview

Many to Many Cardinality

One to One Cardinality

One to Many Cardinality and Cross Filter Direction

Autodetect and Active Relationships

Creating the Relationships for our Data Model (Assignment)

Merging Tables - Join Types

Data Modelling Approaches - STAR and SNOWFLAKE

Linking Tables via Relationships

18m

Download the Part 2 Power BI Report

Merging Tables Demonstration

11m

Section 4: Part 3 Visualizations in Power BI22 videos

Part 3 Section Overview

Visualization and Report Basics

12m

Bar and Column Charts

10m

Interactions

11m

Quick Note on Legends

Small Multiples

Drilldowns and Hierarchies

Table and Matrix Visuals

17m

The Filter Pane

Combo Charts and Cross Filter Direction Revisited

Treemaps

Scatter Charts

Cards

Line and Area Charts

16m

Visual Elements

Tooltips

Additional Visualizations

12m

Download the Part 3 Power BI Report

Best Practice Tips and Formula One Report Requirements

Data Categories and Maps

18m

Creating the Formula One Report Part 2

34m

Creating the Formula One Report Part 1

43m

Section 5: Part 4 Power BI Online7 videos

Part 4 Section Overview

Power BI Online Overview

Dashboards

Power BI Pro Interface Tour

Refreshing Data

Collaboration Workspaces

Publishing Reports to Power BI Pro

22m

Section 6: Part 5 Introduction to DAX (Data Analysis Expressions)7 videos

Part 5 Section Overview - Languages in Power BI

11m

DAX Overview

Filter Functions

Download the Part 5 Power BI Report

Other Functions

Aggregation Functions

12m

Assignment Questions

20m

About this Lecture

Section: Part 1 Loading and Transforming Data • Size: 54.17 MB • Duration: 25m

Course Summary

Microsoft Power BI: The Complete Guide, Learn one of the most in demand business intelligence tools around and master the most important concepts in the Power BI Ecosystem. Connect to various data sources including csv, excel, JSON and more. Perform extensive data transformations to make our data ready for reporting. Use relationships and data modelling methodologies to create an effective data model. Explore all kinds of visualisations from Column Charts, Scatter Charts, Maps, Tooltips and more. Use visual elements like action icons and buttons to navigate between pages in your report. Explore the capabilities of Power BI Pro and how it can enable you to collaborate within your Organization. Leverage Data Analysis Expressions to add insight and analysis to our Power BI Report. By the end of the Formula One Analysis Project you will gain extensive skills and have experience of developing a business intelligence solution end to end. You should gain more than enough experience to add value to your real world projects!The course is packed with lectures, code-along videos, assignment questions and detailed walkthroughs. There should be more than enough to keep you engaged and learning! As an added plus you will also have lifetime access to all the lectures.

Course Content

0 / 78 completed

Section 1: Part 1 Loading and Transforming Data26 videos

Part 1 Section Overview

Saving Your Work

Entering Data Manually

Loading the Races CSV Data

Removing Rows and Columns

Simple Mathematical Operations

Duplicate, Index and Conditional Columns

12m

Filtering Values

Sorting your Data

Working with Columns

Splitting Extracting Information from Columns

11m

Data Types

25mNow Playing

Logically Ordering your Applied Steps

14m

Refreshing the Source Data

Duplicate vs Reference

Transpose, Reverse Rows and Count Rows

Replacing Values

Appending Queries

Removing Duplicates

Loading the Circuits JSON File & Assignment

Loading the Constructors CSV File & Assignment

Pivoting and Unpivoting

Group By

Loading the Drivers Text File & Assignment

11m

Download the Part 1 Power BI Report

Loading the Results CSV File & Assignments

18m

Section 2: Introduction and Set Up5 videos

Power BI Desktop Installation

Power BI Ecosystem

Course Introduction

13m

Power BI Desktop Interface Overview

12m

Course Project and Dataset Download (IMPORTANT)

17m

Section 3: Part 2 Data Modelling11 videos

Part 2 Section Overview

Many to Many Cardinality

One to One Cardinality

One to Many Cardinality and Cross Filter Direction

Autodetect and Active Relationships

Creating the Relationships for our Data Model (Assignment)

Merging Tables - Join Types

Data Modelling Approaches - STAR and SNOWFLAKE

Linking Tables via Relationships

18m

Download the Part 2 Power BI Report

Merging Tables Demonstration

11m

Section 4: Part 3 Visualizations in Power BI22 videos

Part 3 Section Overview

Visualization and Report Basics

12m

Bar and Column Charts

10m

Interactions

11m

Quick Note on Legends

Small Multiples

Drilldowns and Hierarchies

Table and Matrix Visuals

17m

The Filter Pane

Combo Charts and Cross Filter Direction Revisited

Treemaps

Scatter Charts

Cards

Line and Area Charts

16m

Visual Elements

Tooltips

Additional Visualizations

12m

Download the Part 3 Power BI Report

Best Practice Tips and Formula One Report Requirements

Data Categories and Maps

18m

Creating the Formula One Report Part 2

34m

Creating the Formula One Report Part 1

43m

Section 5: Part 4 Power BI Online7 videos

Part 4 Section Overview

Power BI Online Overview

Dashboards

Power BI Pro Interface Tour

Refreshing Data

Collaboration Workspaces

Publishing Reports to Power BI Pro

22m

Section 6: Part 5 Introduction to DAX (Data Analysis Expressions)7 videos

Part 5 Section Overview - Languages in Power BI

11m

DAX Overview

Filter Functions

Download the Part 5 Power BI Report

Other Functions

Aggregation Functions

12m

Assignment Questions

20m