Microsoft Power Bi - The Complete Masterclass [2022 Edition]
Last updated 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.51 GB | Duration: 15h 45m
Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!
What you'll learn
Learn the complete workflow in Power BI from A to Z
Advanced analytics with DAX - calculated columns & measures
All-in-One: Power BI Desktop, Power BI Cloud & Power BI Mobile!
Learn how to design and implement professional reports
Learn storytelling with data to visualize your data effectively
Advanced features such as working with parameters, using R scripts, optimizing performance and
Row-Level Security
Performance optimizing
Storytelling with data
Python & R in Power BI
Forecasting & advanced analytics
Time intelligence
Requirements
A computer with Windows operating system
Power BI Desktop (free download)
For some modules with Power BI Service (Cloud) account a school or work email adress is required to sign up (free 60 day trial)
Description
Do you want to learn the skills to professionally analyze data?Do you want to learn all the steps to create impressive reports?Then Microsoft Power BI is the right tool for you!In this course you will learn - step by step - everything that is important in Power BI to become an advanced Power BI report creator.That's what you'll learn
ower BI Desktop, Power BI Cloud & Power BI Mobile!✓ Understand everything from scratch - step by step, very structured and practice-oriented✓ Learn all the important tools - know when and how to use them properly✓ Connect different data sources - from basics to advanced✓ Create your data model - and understand it✓ Master DAX - to do more advanced analysis on your data✓ Get to know all the different visualizations - and how to use them✓ Storytelling with data - learn how to visualize your data effectively✓ Create interactive visualizations - with drill throughs and drill downs✓ Advanced analysis - learn how to use R Script in Power BI (Data Science)✓ Forecasting - Advanced analytics which can be helpful in Data Science✓ Row-Level Security - Implement the security concept to control access to the dataThis course is right for you if.. you have never worked with Power BI and want to learn everything hands-on in one course.. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.This is the course that covers everything in Power BI to become an advanced report devolopper! Enroll now to get life long access!
Overview
Section 1: Introduction
Lecture 1 Welcome!
Lecture 2 What is Power BI?
Lecture 3 Download & Installing Power BI Desktop
Lecture 4 Quick Interface Tour
Lecture 5 Mini Project: Transform Data
Lecture 6 Mini Project: Visualize Data
Lecture 7 Mini Project: Creating a Data Model
Lecture 8 Course Outline: What will you learn in this course?
Lecture 9 How to lean best with this course?
Lecture 10 All source files & course slides
Section 2: Preparing our Project
Lecture 11 Creating our initial project file
Lecture 12 Working with the attached project files
Section 3: Data Transformation - The Query Editor
Lecture 13 Exploring the Query Editor
Lecture 14 Connecting to our data source
Lecture 15 Editing rows
Lecture 16 Changing data types
Lecture 17 Replacing values
Lecture 18 Close & Apply
Lecture 19 Connecting to a csv file
Lecture 20 Connecting to a web page
Lecture 21 Extracing characters
Lecture 22 Splitting & merging columns
Lecture 23 Creating conditional columns
Lecture 24 A little note regarding the next lecture
Lecture 25 Creating columns from examples
Lecture 26 Merging Queries
Lecture 27 Pivoting & Unpivoting
Lecture 28 Appending Queries
Lecture 29 Practise & Solution: Population table
Lecture 30 The Fact-Dimension-Model
Lecture 31 Practise: Load the dimension table
Lecture 32 Organizing our queries in groups
Lecture 33 Text to be used in the next lecture
Lecture 34 Entering data manually
Lecture 35 Creating an index column
Lecture 36 Workflow & more transformations
Lecture 37 Module summary
Section 4: Data Transformation - Advanced
Lecture 38 Advanced Editor - Best practises
Lecture 39 Performance: References vs. Duplicating
Lecture 40 Performance: Enable / Disable Load & Report Refresh
Lecture 41 Group by
Lecture 42 Mathematical Operations
Lecture 43 Run R Script
Lecture 44 Using Parameters to dynamically transform data
Lecture 45 M formula language: Basics
Lecture 46 M formula language: Values, Lists & Tables
Lecture 47 M formula language: Functions
Lecture 48 M formula language: More functions & steps
Section 5: Creating a Data Model
Lecture 49 Why a data model?
Lecture 50 Create & edit relationships
Lecture 51 One-to-many & one-to-one relationship
Lecture 52 Many-to-many (m:n) relationship
Lecture 53 Cross filter direction
Lecture 54 Activate & deactivate relationships
Lecture 55 Module summary
Section 6: Data Visualization
Lecture 56 Our first visual
Lecture 57 The format tab
Lecture 58 Understanding tables
Lecture 59 Conditional formatting
Lecture 60 The Pie Chart
Lecture 61 All about the filter visual
Lecture 62 The filter pane for developers
Lecture 63 Cross filtering & edit interactions
Lecture 64 Syncing slicers across pages
Lecture 65 Creating drill downs
Lecture 66 Creating drill throughs
Lecture 67 The tree map visual
Lecture 68 The decomposition tree
Lecture 69 Understanding the matrix visual
Lecture 70 Editing pages
Lecture 71 Buttons & Actions
Lecture 72 Bookmarks to customize your report
Lecture 73 Analytics and Forecasts with line charts
Lecture 74 Working with custom visuals
Lecture 75 R Script to use
Lecture 76 Get data using R Script & R Script visual
Lecture 77 Asking questions - Q&A visual
Lecture 78 Wrap up - data visualization
Section 7: Power BI & Python
Lecture 79 Python in Power BI - Plan of attack
Lecture 80 Setting up Python for Power BI
Lecture 81 Transforming data using Python
Lecture 82 Python script I used in the next lecture
Lecture 83 Creating visualizations using Python
Lecture 84 Python script II used in the next lecture
Lecture 85 Violin plots, pair plots & ridge plots using Python
Lecture 86 Python script III used in the next lecture
Lecture 87 Machine learning (BayesTextAnalyzer) using Python
Lecture 88 Performance & Troubleshooting
Section 8: DAX - The Essentials
Lecture 89 Intro
Lecture 90 The project data
Lecture 91 DAX cheat sheet
Lecture 92 All files for the DAX part
Lecture 93 Measures vs. Calculated Columns
Lecture 94 Automatically creating a date table in DAX
Lecture 95 CALENDAR
Lecture 96 Creating a complete date table with features
Lecture 97 Script to be used in your future projects
Lecture 98 Creating key measure table
Lecture 99 Aggregation functions
Lecture 100 The different versions of COUNT
Lecture 101 SUMX - Row based calculations
Lecture 102 DAX Exercise 1
Lecture 103 DAX Solution 1
Section 9: DAX - The CALCULATE function
Lecture 104 CALCULATE - The basics
Lecture 105 Changing the context with FILTER
Lecture 106 ALL
Lecture 107 ALLSELECTED
Lecture 108 ALLEXCEPT
Lecture 109 DAX Exercise 2
Lecture 110 DAX Solution 2
Section 10: DAX - Time Intelligence
Lecture 111 Time Intelligence intro & DATEADD
Lecture 112 Year-to-Date & Month-to-Date
Lecture 113 TOTALYTD vs. DATESYTD
Lecture 114 DATESBETWEEN
Section 11: DAX - Advanced topics
Lecture 115 Logical operators
Lecture 116 Formatting & Commenting
Lecture 117 Using Variables
Lecture 118 Using quick measures in a smart way
Section 12: Tell a story with your data - learn to visualize effectively
Lecture 119 Intro - Best practises
Lecture 120 Show empathy & indentify the requirements
Lecture 121 Find the most suitable KPIs
Lecture 122 Choose an effective visual
Lecture 123 Make use of natural reading pattern
Lecture 124 Tell a story using visual cues
Lecture 125 Avoid chaos & group information
Lecture 126 Wrap up - storytelling with data
Section 13: Power BI Service - Power BI Cloud
Lecture 127 How to go on now?
Lecture 128 Power BI Pro vs Premium & Signing up
Lecture 129 An alternative if you don't have a business email
Lecture 130 Exploring the interface
Lecture 131 Discovering your workspace
Lecture 132 Little note on the next lecture - Uploading your report
Lecture 133 Connecting Power BI Desktop & Cloud
Lecture 134 Understanding datasets & reports
Lecture 135 Working on reports
Lecture 136 Updating reports from Power BI Desktop
Lecture 137 Creating and working with workspaces
Lecture 138 Installing & using a data gateway
Lecture 139 Get Quick Insights
Lecture 140 Creating dashboards
Lecture 141 Sharing our results through Apps
Lecture 142 Power BI Mobile App
Lecture 143 Creating the layout for the Mobile App
Lecture 144 Wrap up - Power BI Cloud
Section 14: Row-Level Security
Lecture 145 Intro
Lecture 146 Creating a Row-Level Security
Lecture 147 Row-Level Security in the Cloud
Lecture 148 Row-Level Security & Data Model
Lecture 149 Dynamic Row-Level Security
Lecture 150 Dynamic Many-to-Many RLS
Lecture 151 Hierarchical Row-Level Security
Section 15: More data sources
Lecture 152 JSON & REST API
Lecture 153 Setting up a local MySQL database
Lecture 154 Connecting to a MySQL database in Power BI
Lecture 155 Connecting to a SQL database (PostgreSQL)
Section 16: Next steps to improve & stay up to date
Lecture 156 Congratulations & next steps
Lecture 157 More data to practise
Section 17: Bonus
Lecture 158 Bonus lecture
Anyone that is looking for a complete and comprehensive intro to Power BI,Everyone that wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures,Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant,Anyone that has never used Power BI before and is looking for a hands-on approach to learn it
What you'll learn
Learn the complete workflow in Power BI from A to Z
Advanced analytics with DAX - calculated columns & measures
All-in-One: Power BI Desktop, Power BI Cloud & Power BI Mobile!
Learn how to design and implement professional reports
Learn storytelling with data to visualize your data effectively
Advanced features such as working with parameters, using R scripts, optimizing performance and
Row-Level Security
Performance optimizing
Storytelling with data
Python & R in Power BI
Forecasting & advanced analytics
Time intelligence
Requirements
A computer with Windows operating system
Power BI Desktop (free download)
For some modules with Power BI Service (Cloud) account a school or work email adress is required to sign up (free 60 day trial)
Description
Do you want to learn the skills to professionally analyze data?Do you want to learn all the steps to create impressive reports?Then Microsoft Power BI is the right tool for you!In this course you will learn - step by step - everything that is important in Power BI to become an advanced Power BI report creator.That's what you'll learn
ower BI Desktop, Power BI Cloud & Power BI Mobile!✓ Understand everything from scratch - step by step, very structured and practice-oriented✓ Learn all the important tools - know when and how to use them properly✓ Connect different data sources - from basics to advanced✓ Create your data model - and understand it✓ Master DAX - to do more advanced analysis on your data✓ Get to know all the different visualizations - and how to use them✓ Storytelling with data - learn how to visualize your data effectively✓ Create interactive visualizations - with drill throughs and drill downs✓ Advanced analysis - learn how to use R Script in Power BI (Data Science)✓ Forecasting - Advanced analytics which can be helpful in Data Science✓ Row-Level Security - Implement the security concept to control access to the dataThis course is right for you if.. you have never worked with Power BI and want to learn everything hands-on in one course.. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.This is the course that covers everything in Power BI to become an advanced report devolopper! Enroll now to get life long access! Overview
Section 1: Introduction
Lecture 1 Welcome!
Lecture 2 What is Power BI?
Lecture 3 Download & Installing Power BI Desktop
Lecture 4 Quick Interface Tour
Lecture 5 Mini Project: Transform Data
Lecture 6 Mini Project: Visualize Data
Lecture 7 Mini Project: Creating a Data Model
Lecture 8 Course Outline: What will you learn in this course?
Lecture 9 How to lean best with this course?
Lecture 10 All source files & course slides
Section 2: Preparing our Project
Lecture 11 Creating our initial project file
Lecture 12 Working with the attached project files
Section 3: Data Transformation - The Query Editor
Lecture 13 Exploring the Query Editor
Lecture 14 Connecting to our data source
Lecture 15 Editing rows
Lecture 16 Changing data types
Lecture 17 Replacing values
Lecture 18 Close & Apply
Lecture 19 Connecting to a csv file
Lecture 20 Connecting to a web page
Lecture 21 Extracing characters
Lecture 22 Splitting & merging columns
Lecture 23 Creating conditional columns
Lecture 24 A little note regarding the next lecture
Lecture 25 Creating columns from examples
Lecture 26 Merging Queries
Lecture 27 Pivoting & Unpivoting
Lecture 28 Appending Queries
Lecture 29 Practise & Solution: Population table
Lecture 30 The Fact-Dimension-Model
Lecture 31 Practise: Load the dimension table
Lecture 32 Organizing our queries in groups
Lecture 33 Text to be used in the next lecture
Lecture 34 Entering data manually
Lecture 35 Creating an index column
Lecture 36 Workflow & more transformations
Lecture 37 Module summary
Section 4: Data Transformation - Advanced
Lecture 38 Advanced Editor - Best practises
Lecture 39 Performance: References vs. Duplicating
Lecture 40 Performance: Enable / Disable Load & Report Refresh
Lecture 41 Group by
Lecture 42 Mathematical Operations
Lecture 43 Run R Script
Lecture 44 Using Parameters to dynamically transform data
Lecture 45 M formula language: Basics
Lecture 46 M formula language: Values, Lists & Tables
Lecture 47 M formula language: Functions
Lecture 48 M formula language: More functions & steps
Section 5: Creating a Data Model
Lecture 49 Why a data model?
Lecture 50 Create & edit relationships
Lecture 51 One-to-many & one-to-one relationship
Lecture 52 Many-to-many (m:n) relationship
Lecture 53 Cross filter direction
Lecture 54 Activate & deactivate relationships
Lecture 55 Module summary
Section 6: Data Visualization
Lecture 56 Our first visual
Lecture 57 The format tab
Lecture 58 Understanding tables
Lecture 59 Conditional formatting
Lecture 60 The Pie Chart
Lecture 61 All about the filter visual
Lecture 62 The filter pane for developers
Lecture 63 Cross filtering & edit interactions
Lecture 64 Syncing slicers across pages
Lecture 65 Creating drill downs
Lecture 66 Creating drill throughs
Lecture 67 The tree map visual
Lecture 68 The decomposition tree
Lecture 69 Understanding the matrix visual
Lecture 70 Editing pages
Lecture 71 Buttons & Actions
Lecture 72 Bookmarks to customize your report
Lecture 73 Analytics and Forecasts with line charts
Lecture 74 Working with custom visuals
Lecture 75 R Script to use
Lecture 76 Get data using R Script & R Script visual
Lecture 77 Asking questions - Q&A visual
Lecture 78 Wrap up - data visualization
Section 7: Power BI & Python
Lecture 79 Python in Power BI - Plan of attack
Lecture 80 Setting up Python for Power BI
Lecture 81 Transforming data using Python
Lecture 82 Python script I used in the next lecture
Lecture 83 Creating visualizations using Python
Lecture 84 Python script II used in the next lecture
Lecture 85 Violin plots, pair plots & ridge plots using Python
Lecture 86 Python script III used in the next lecture
Lecture 87 Machine learning (BayesTextAnalyzer) using Python
Lecture 88 Performance & Troubleshooting
Section 8: DAX - The Essentials
Lecture 89 Intro
Lecture 90 The project data
Lecture 91 DAX cheat sheet
Lecture 92 All files for the DAX part
Lecture 93 Measures vs. Calculated Columns
Lecture 94 Automatically creating a date table in DAX
Lecture 95 CALENDAR
Lecture 96 Creating a complete date table with features
Lecture 97 Script to be used in your future projects
Lecture 98 Creating key measure table
Lecture 99 Aggregation functions
Lecture 100 The different versions of COUNT
Lecture 101 SUMX - Row based calculations
Lecture 102 DAX Exercise 1
Lecture 103 DAX Solution 1
Section 9: DAX - The CALCULATE function
Lecture 104 CALCULATE - The basics
Lecture 105 Changing the context with FILTER
Lecture 106 ALL
Lecture 107 ALLSELECTED
Lecture 108 ALLEXCEPT
Lecture 109 DAX Exercise 2
Lecture 110 DAX Solution 2
Section 10: DAX - Time Intelligence
Lecture 111 Time Intelligence intro & DATEADD
Lecture 112 Year-to-Date & Month-to-Date
Lecture 113 TOTALYTD vs. DATESYTD
Lecture 114 DATESBETWEEN
Section 11: DAX - Advanced topics
Lecture 115 Logical operators
Lecture 116 Formatting & Commenting
Lecture 117 Using Variables
Lecture 118 Using quick measures in a smart way
Section 12: Tell a story with your data - learn to visualize effectively
Lecture 119 Intro - Best practises
Lecture 120 Show empathy & indentify the requirements
Lecture 121 Find the most suitable KPIs
Lecture 122 Choose an effective visual
Lecture 123 Make use of natural reading pattern
Lecture 124 Tell a story using visual cues
Lecture 125 Avoid chaos & group information
Lecture 126 Wrap up - storytelling with data
Section 13: Power BI Service - Power BI Cloud
Lecture 127 How to go on now?
Lecture 128 Power BI Pro vs Premium & Signing up
Lecture 129 An alternative if you don't have a business email
Lecture 130 Exploring the interface
Lecture 131 Discovering your workspace
Lecture 132 Little note on the next lecture - Uploading your report
Lecture 133 Connecting Power BI Desktop & Cloud
Lecture 134 Understanding datasets & reports
Lecture 135 Working on reports
Lecture 136 Updating reports from Power BI Desktop
Lecture 137 Creating and working with workspaces
Lecture 138 Installing & using a data gateway
Lecture 139 Get Quick Insights
Lecture 140 Creating dashboards
Lecture 141 Sharing our results through Apps
Lecture 142 Power BI Mobile App
Lecture 143 Creating the layout for the Mobile App
Lecture 144 Wrap up - Power BI Cloud
Section 14: Row-Level Security
Lecture 145 Intro
Lecture 146 Creating a Row-Level Security
Lecture 147 Row-Level Security in the Cloud
Lecture 148 Row-Level Security & Data Model
Lecture 149 Dynamic Row-Level Security
Lecture 150 Dynamic Many-to-Many RLS
Lecture 151 Hierarchical Row-Level Security
Section 15: More data sources
Lecture 152 JSON & REST API
Lecture 153 Setting up a local MySQL database
Lecture 154 Connecting to a MySQL database in Power BI
Lecture 155 Connecting to a SQL database (PostgreSQL)
Section 16: Next steps to improve & stay up to date
Lecture 156 Congratulations & next steps
Lecture 157 More data to practise
Section 17: Bonus
Lecture 158 Bonus lecture
Anyone that is looking for a complete and comprehensive intro to Power BI,Everyone that wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures,Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant,Anyone that has never used Power BI before and is looking for a hands-on approach to learn it
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
