Microsoft Power BI: The Complete Guide

سرفصل های دوره

A comprehensive guide on how to master Power BI Desktop and Power BI Online. Featuring a Formula One course project.

01 - Introduction and Set Up

001 Course Introduction

002 Power BI Ecosystem

003 Power BI Desktop Installation

004 Power BI Desktop Interface Overview

005 Course Project and Dataset Download (IMPORTANT)

external-links.txt

02 - Part 1 Loading and Transforming Data

001 Part 1 Section Overview

002 Entering Data Manually

003 Saving Your Work

004 Loading the Races CSV Data

005 Removing Rows and Columns

006 Data Types

007 Working with Columns

008 Splitting Extracting Information from Columns

009 Simple Mathematical Operations

010 Duplicate, Index and Conditional Columns

011 Refreshing the Source Data

012 Sorting your Data

013 Filtering Values

014 Logically Ordering your Applied Steps

015 Replacing Values

016 Duplicate vs Reference

017 Appending Queries

018 Removing Duplicates

019 Transpose, Reverse Rows and Count Rows

020 Loading the Circuits JSON File & Assignment

021 Loading the Drivers Text File & Assignment

022 Loading the Constructors CSV File & Assignment

023 Loading the Results CSV File & Assignments

024 Group By

025 Pivoting and Unpivoting

026 Download the Part 1 Power BI Report

external-links.txt

03 - Part 2 Data Modelling

001 Part 2 Section Overview

002 Linking Tables via Relationships

003 One to Many Cardinality and Cross Filter Direction

004 Many to Many Cardinality

005 One to One Cardinality

006 Creating the Relationships for our Data Model (Assignment)

007 Autodetect and Active Relationships

008 Data Modelling Approaches - STAR and SNOWFLAKE

009 Merging Tables - Join Types

010 Merging Tables Demonstration

011 Download the Part 2 Power BI Report

04 - Part 3 Visualizations in Power BI

001 Part 3 Section Overview

002 Visualization and Report Basics

003 Table and Matrix Visuals

004 Bar and Column Charts

005 Quick Note on Legends

006 Interactions

007 Drilldowns and Hierarchies

008 The Filter Pane

009 Small Multiples

010 Line and Area Charts

011 Combo Charts and Cross Filter Direction Revisited

012 Scatter Charts

013 Treemaps

014 Cards

015 Data Categories and Maps

016 Tooltips

017 Visual Elements

018 Additional Visualizations

019 Best Practice Tips and Formula One Report Requirements

020 Creating the Formula One Report Part 1

021 Creating the Formula One Report Part 2

022 Download the Part 3 Power BI Report

05 - Part 4 Power BI Online

001 Part 4 Section Overview

002 Power BI Online Overview

003 Power BI Pro Interface Tour

004 Publishing Reports to Power BI Pro

005 Dashboards

006 Refreshing Data

007 Collaboration Workspaces

06 - Part 5 Introduction to DAX (Data Analysis Expressions)

001 Part 5 Section Overview - Languages in Power BI

002 DAX Overview

003 Aggregation Functions

004 Filter Functions

005 Other Functions

006 Assignment Questions

007 Download the Part 5 Power BI Report

07 - Congratulations

001 Congratulations.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy