Enrolment options
![Microsoft Power BI - The Practical Guide [2022 EDITION]](https://online.linkvn.vn/pluginfile.php/49222/course/overviewfiles/download.png)
- Enrolled students: 1
Guests cannot access this course. Please log in.
Course content
Sections:
20
•
Activities:
0
•
Resources:
286
- Welcome to This Course
- 002 What is Power BI
- 003 Installing Power BI Desktop
- 004 Connecting Power BI Desktop to Source Files
- 005 Creating our First Visuals
- 007 Comparing Excel & Power BI
- 008 Course Outline
- 009 How to Get the Most Out of This Course
- 010 Important_ How to Access Course Resources, Project Files & Slides
- 001 Module Introduction
- 002 The Power BI Desktop Workflow
- 003 Interface Tour
- 004 Important! Creating the Project Template & Recommended Settings
- 001 Module Introduction
- 002 Understanding Data Preparation _ Cleaning _ Cleansing
- 003 Connecting Power BI Desktop to Source Files
- 004 How Power BI Queries Data
- 005 Understanding Basic Row Operations
- 006 Filtering Data
- 007 Analyzing Columns & Removing Blank Fields
- 008 Understanding & Using the Append Feature
- 009 Choosing & Removing Columns
- 010 Append Behind the Scenes
- 011 Understanding the Transpose Feature
- 012 Replacing Values
- 013 Working with Dates - The Basics
- 014 Understanding Data Formats
- 015 Handling Data Format Errors
- 016 Understanding Pivoting & Unpivoting
- 017 Applying Pivoting & Unpivoting
- 018 Fixing a Sorting Problem
- 019 Extracting Data, Splitting Columns & Sorting Multiple Columns
- 020 Introducing the _Group By_ Feature
- 021 Improving the Project Structure
- 022 Wrap Up
- 001 Module Introduction
- 002 Data Warehouse, Data Model & Data Schema
- 003 The Star Schema - Theory
- 004 Applying the Star Schema to our Project
- 005 Understanding References
- 006 Comparing References & Duplicates
- 007 Importing Country & Region Codes
- 008 Using _Enter Data_ to Create a Table
- 009 Understanding the Merge Feature
- 010 How to Join Tables
- 011 Understanding Outer, Inner & Anti Joins
- 012 Join Kind in Practice
- 013 Handling Merge Errors
- 014 Understanding the DIM-age Table
- 015 Bringing Back the _age-group_ Column
- 016 Getting the Maximum Values From Each Age Group
- 017 Creating Conditional Columns
- 018 Creating an Index Column
- 019 Creating a DIM-gender Table
- 020 Understanding the FACT Table
- 021 Finishing the FACT Table
- 022 Applying Basic Mathematical Operations
- 023 Using the Enable Load Feature
- 024 Wrap Up
- 001 Module Introduction
- 002 Query Editor vs Data Model
- 003 Understanding Relationships
- 004 Creating our First Relationship
- 005 Understanding Cardinality & Difference Relationship Types
- 006 One to Many & Many to One
- 007 One to One
- 008 Many to Many
- 009 Fixing the Column Order Bug
- 010 Understanding the Cross Filter Direction
- 011 Understanding Active Properties
- 012 Adding Relationships to the Project
- 013 M-Language vs DAX (Data Analysis Expressions)
- 014 Creating a Custom Column with the M-Language
- 015 Creating a Calculated Column with DAX
- 016 M vs DAX - What Should I Choose
- 017 The DAX Basics
- 018 The Core DAX Syntax
- 019 DAX Data Types
- 020 DAX Operators
- 021 DAX Core Functions
- 022 Creating a Table with the CALENDAR Function
- 023 Extracting Data with the DOT Notation
- 024 Adding & Dividing Columns
- 025 Working with IF Functions
- 026 Understanding Relationship Functions
- 027 Calculated Column vs Measure
- 028 Understanding & Creating Measures
- 029 Working with FILTER & CALCULATE Functions - Theory
- 030 Combining CALCULATED & FILTER Functions
- 031 Adding the Filter Condition to CALCULATE
- 032 Using Measures in Measures
- 033 Changing the Measure's Home Table
- 034 Understanding the Data Category
- 035 Wrap Up
- 001 Module Introduction
- 002 The Power BI Workflow & Understanding Basics Visual Elements
- 003 Creating & Duplicating Pages
- 004 Organizing Visuals
- 005 Creating a New Visual
- 006 Creating Line & Column Charts
- 007 How FILTER Affects the Visual
- 008 Understanding Interactions
- 009 Hierarchies & Drill Down
- 010 Formatting Chart Colors
- 011 The Canvas
- 012 Formatting the Page Background _ Wallpaper
- 013 Formatting the Filter Pane & Filter Cards
- 014 Formatting Visuals_ General Settings
- 015 Diving Deeper Into Formatting Visuals
- 016 Working with Report Themes
- 017 Finishing the Report Theme
- 018 Understanding the Slicer
- 019 Default Summarization & Sorting Order
- 020 Creating Treemaps & Working with Multiple Slicers
- 021 Creating Tables
- 022 Syncing Slicers
- 023 Filter on Visual, Page & Report Level
- 024 Creating Single & Multi Row Cards
- 025 Adding a Secondary Y-Axis
- 026 Combining Column & Line Charts
- 027 The Waterfall Chart
- 028 Importing Visuals
- 029 Finishing Touches
- 030 Wrap Up
- 001 Module Introduction
- 002 The Next Steps
- 003 Power BI Pro Pricing
- 004 Power BI Pro Interface Tour
- 005 Publishing & My Workspace - Theory
- 006 Publishing _ Importing Power BI Desktop Projects to Pro
- 007 Datesets Walkthrough
- 008 List View vs Lineage View
- 009 Exploring Reports In Pro
- 010 Understanding Dashboards
- 011 Creating Reports & Dashboards
- 012 Diving Deeper Into _My Workspace_, Understanding Refresh and a Refresh Error
- 013 Gateways - Theory
- 014 Gateways_ Configuring Manual & Scheduled Refreshs
- 015 Sharing Data From _My Workspace_ via Direct Access
- 016 Sharing Links
- 017 Understanding Collaboration Workspaces - Theory
- 018 Creating Colaboration Workspaces
- 019 Sharing Data via Apps
- 020 Publishing & Unpublishing Apps
- 021 Deleting Collaboration Workspaces
- 022 Workspaces vs Apps
- 023 Working with Power BI Mobile
- 024 Wrap Up
- 001 Module Introduction
- 002 Importing JSON Data
- 004 Importing Data from REST APIs
- 005 Preparation_ Setting up a MySQL Server
- 006 Importing Data from a MySQL Server (and other SQL Servers)
- 007 Wrap Up
- 001 Module Introduction
- 002 Helpful Resources
- 003 Using Preview Features
- 001 Congratulations! What you Learned & How to Continue
- 001 About this Module
- 002 Understanding Column from Examples
- 003 Group By, Big Data & DAX Studio
- 004 Please Read_ Bonus Project Introduction
- 005 Taxi Project - Query Editor
- 006 Taxi Project - Data Model & Visuals
- 007 Taxi Project - Power BI Service
- 001 How to Continue After the Latest Course Update
- 001 Welcome to the Course!
- 002 What is Power BI
- 003 Installing Power BI Desktop & Project Setup
- 004 Connecting Power BI Desktop to Source Files
- 005 Working in the Query Editor
- 006 Understanding the Data Model & Creating Visuals
- 007 Course Outline - What's Inside the Course
- 008 How To Get The Most Out Of This Course
- 001 Module Introduction
- 002 Using the Attached Project Files
- 003 Understanding the Power BI Desktop Workflow
- 004 Exploring the Interface of the Data Model
- 005 Understanding the Query Editor Interface
- 006 Important! Creating the Project File & Recommended Settings
- 001 Module Introduction
- 002 Connecting Power BI Desktop to Source Files
- 003 Keeping & Removing Rows
- 004 Working with Filters
- 005 Removing Empty Rows
- 006 Saving the Project Draft
- 007 Appending Queries
- 008 Working with Columns
- 009 Replacing Values
- 011 Formatting Data & Handling Formatting Errors
- 012 Pivoting & Unpivoting Data
- 013 Splitting Columns
- 014 Creating Groups & Cleaning Up our Project
- 015 What we Achieved & How to Continue
- 016 Theory Time_ The Star Schema
- 017 How we Use the Star Schema in our Project
- 018 Query Duplicates vs References
- 019 Creating the DIM-Region Table & Removing Duplicates
- 020 Creating Tables Manually
- 021 Theory Time_ Merging Queries
- 022 Understanding _Join Kind
- 023 Merging Queries Applied
- 024 Finishing the DIM-Region Table
- 025 The Next Steps
- 026 Creating the DIM-Age Table
- 027 Understanding _Extract
- 028 Working with Conditional Columns
- 029 Creating the FACT-Table
- 030 Understanding Basic Mathematical Operations
- 031 Performance Optimization
- 032 Wrap Up
- 001 Module Introduction
- 002 Understanding Relationships
- 003 Cardinality_ Many-to-One & One-to-One
- 004 Cross Filter Direction & Many-to-Many
- 005 Understanding Active Properties
- 006 M-Language vs DAX (Data Analysis Expressions)
- 007 M vs DAX - A Practical Example
- 008 Understanding the DAX Basics
- 009 The DAX Syntax
- 010 Supported DAX Data Types
- 011 Diving Into Operators
- 012 DAX Functions - An Overview
- 013 Understanding the CALENDAR Function
- 014 Applying the DAX Basics
- 015 Understanding IF & RELATED
- 016 Calculated Columns vs Measures
- 017 Creating our First Measures
- 018 Understanding CALCULATE & FILTER
- 019 Applying CALCULATE & FILTER in Measures
- 020 Creating Measures with Measures
- 021 Understanding _Data Category
- 022 Wrap Up
- 001 Module Introduction
- 002 Understanding Basic Visual Concepts
- 003 Getting Started with Visuals & Reports
- 004 Creating our First Visuals
- 005 Understanding Tooltips & Interactions
- 006 Diving Intro Hierarchies & Drill Mode
- 007 Data Colors & Conditional Formatting
- 008 Formatting Report Pages
- 009 Formatting Visuals
- 010 Working with Report Themes
- 011 Using the Slicer
- 012 Understanding Default Summarization & Sorting
- 013 Working with Treemaps & Tables
- 014 Syncing Slicers
- 015 Understanding Filter Types (Visual, Page & Report)
- 016 Working with (Multi) Row Cards
- 017 Creating Combined Visuals & Waterfalls
- 018 Using Custom Visuals
- 019 Wrap Up
- 001 Module Introduction
- 002 Why we Need Power BI Pro (Service)
- 003 Power BI_ Service vs Pro vs Premium
- 005 Exploring the Power BI Pro Interface
- 006 Understanding Workspaces
- 007 Connecting Power BI Pro & Power BI Desktop
- 008 Understanding Datasets in Power BI Pro
- 009 Working with Reports
- 010 Creating Dashboards
- 011 Exploring _My Workspace
- 012 Refreshing Data with Gateways
- 013 Sharing Data From _My Workspace
- 014 Understanding Collaboration Workspaces
- 015 Workspaces vs Apps vs Content Packs
- 016 Publishing an App
- 017 Workspace or App - Which one Should I Choose
- 018 Working with Power BI Mobile
- 019 Wrap Up
- 001 Module Introduction
- 002 Why Custom Visuals
- 003 The Required Tools
- 004 Setting Up & Installing the Required Tools
- 005 Creating a New Visual
- 006 Analyzing the Project & the Code
- 007 Rendering Content to the Screen
- 008 Using d3.js & a First Shape
- 009 Getting Started with the Bars
- 010 Rendering a Chart for Dummy Data
- 011 Binding Real Data
- 012 Coloring the Bars
- 013 Adding an Axis
- 014 Package & Wrap Up
- 015 Useful Resources & Links
- 001 Bonus_ More Content!