Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Power BI - A Complete Introduction [2023 EDITION]
  • Table Of Contents Toc
Microsoft Power BI - A Complete Introduction [2023 EDITION]

Microsoft Power BI - A Complete Introduction [2023 EDITION]

By : Academind by Maximilian Schwarzmüller GmbH, Manuel Lorenz
5 (1)
Buy this Video
close
close
Microsoft Power BI - A Complete Introduction [2023 EDITION]

Microsoft Power BI - A Complete Introduction [2023 EDITION]

5 (1)
By: Academind by Maximilian Schwarzmüller GmbH, Manuel Lorenz
Buy this Video

Overview of this book

Learn to achieve your business intelligence goals with Power BI’s comprehensive tools in this video course. Whether you need to analyze data from single or multiple sources, create captivating visualizations, or share results with colleagues, Power BI has you covered. Starting with the course objectives and an introduction to Power BI Desktop, you’ll explore connecting Power BI to various source types using the Query Editor. Understand the data model and establish relationships between tables. Develop visuals in the report view and efficiently share your work using Power BI Pro. Practical hands-on assignments will reinforce your learning and application of concepts. Advance your skills by mastering data import from JSON, REST APIs, and MySQL Server. Discover tips to excel in the Power BI world and create custom visuals using TypeScript and Power BI Developer tools. Engage in exciting projects and revise previous topics to solidify your knowledge. Even if you are a complete beginner, don’t worry! The course includes a brief crash course on Power BI Desktop, making it accessible to all levels of learners. By the end of this course, you’ll confidently analyze data from various sources, build your datasets, and adeptly navigate the Power BI universe, understanding how its tools synergize. Propel your business intelligence journey with Power BI expertise!
Table of Contents (12 chapters)
close
close
close
1
Getting Started
Icon
Welcome to This Course
Icon
Module Introduction
Icon
What Is Power BI?
Icon
Installing Power BI Desktop
Icon
Connecting Power BI Desktop to Source Files
Icon
Creating Our First Visuals
Icon
Comparing Excel and Power BI
Icon
Course Outline
Icon
The Two Ways (Paths) of Taking This Course
Icon
How to Get the Most Out of This Course
Icon
Important: How to Access Course Resources, Project Files, and Slides
2
Understanding the Power BI Desktop Basics and Preparing the Course Project
Icon
Module Introduction
Icon
The Power BI Desktop Workflow
Icon
Interface Tour
Icon
Important! Creating the Project Template and Recommended Settings
3
Data Preparation in the Power Query Editor
Icon
Module Introduction
Icon
Understanding Data Preparation / Cleaning / Cleansing
Icon
Connecting Power BI Desktop to Source Files
Icon
How Power BI Queries Data
Icon
Understanding Basic Row Operations
Icon
Filtering Data
Icon
Analyzing Columns and Removing Blank Fields
Icon
Understanding and Using the Append Feature
Icon
Choosing and Removing Columns
Icon
Append Behind the Scenes
Icon
Understanding the Transpose Feature
Icon
Replacing Values
Icon
Working with Dates - The Basics
Icon
Understanding Data Formats
Icon
Handling Data Format Errors
Icon
Understanding Pivoting and Unpivoting
Icon
Applying Pivoting and Unpivoting
Icon
Fixing a Sorting Problem
Icon
Extracting Data, Splitting Columns, and Sorting Multiple Columns
Icon
Introducing the "Group By" Feature
Icon
Improving the Project Structure
Icon
Wrap Up
4
Data Transformation in the Power Query Editor
chevron up
Icon
Module Introduction
Icon
Data Warehouse, Data Model, and Data Schema
Icon
The Star Schema - Theory
Icon
Applying the Star Schema to Our Project
Icon
Understanding References
Icon
Comparing References and Duplicates
Icon
Importing Country and Region Codes
Icon
Using "Enter Data" to Create a Table
Icon
Understanding the Merge Feature
Icon
How to Join Tables
Icon
Understanding Outer, Inner, and Anti Joins
Icon
Join Kind in Practice
Icon
Handling Merge Errors
Icon
Understanding the DIM-age Table
Icon
Bringing Back the "age-group" Column
Icon
Getting the Maximum Values from Each Age Group
Icon
Creating Conditional Columns
Icon
Creating an Index Column
Icon
Creating a DIM-gender Table
Icon
Understanding the FACT Table
Icon
Finishing the FACT Table
Icon
Applying Basic Mathematical Operations
Icon
Using the Enable Load Feature
Icon
Wrap Up
Icon
Query Editor – Assignment Problem
Icon
Query Editor – Assignment Solution
5
The Data Model - Working with Relationships and DAX (Data Analysis Expressions)
Icon
Module Introduction
Icon
Query Editor Versus Data Model
Icon
Understanding Relationships
Icon
Creating Our First Relationship
Icon
Understanding Cardinality and Difference Relationship Types
Icon
One to Many and Many to One
Icon
One to One
Icon
Many to Many
Icon
Fixing the Column Order Bug
Icon
Understanding the Cross-Filter Direction
Icon
Understanding Active Properties
Icon
Adding Relationships to the Project
Icon
M-Language Versus DAX (Data Analysis Expressions)
Icon
Creating a Custom Column with the M-Language
Icon
Creating a Calculated Column with DAX
Icon
M Versus DAX - What Should I Choose?
Icon
The DAX Basics
Icon
The Core DAX Syntax
Icon
DAX Data Types
Icon
DAX Operators
Icon
DAX Core Functions
Icon
Creating a Table with the CALENDAR Function
Icon
Extracting Data with the DOT Notation
Icon
Adding and Dividing Columns
Icon
Working with IF Functions
Icon
Understanding Relationship Functions
Icon
Calculated Column Versus Measure
Icon
Understanding and Creating Measures
Icon
Working with FILTER and CALCULATE Functions - Theory
Icon
Combining CALCULATED and FILTER Functions
Icon
Adding the Filter Condition to CALCULATE
Icon
Using Measures in Measures
Icon
Changing the Measure's Home Table
Icon
Understanding the Data Category
Icon
Wrap Up
Icon
Data Model and RelationshipView – Assignment Problem
Icon
Data Model and RelationshipView – Assignment Solution
6
Creating Visuals in the Report View
Icon
Module Introduction
Icon
The Power BI Workflow and Understanding Basic Visual Elements
Icon
Creating and Duplicating Pages
Icon
Organizing Visuals
Icon
Creating a New Visual
Icon
Creating Line and Column Charts
Icon
How FILTER Affects the Visual
Icon
Understanding Interactions
Icon
Hierarchies and Drill Down
Icon
Formatting Chart Colors
Icon
The Canvas
Icon
Formatting the Page Background / Wallpaper
Icon
Formatting the Filter Pane and Filter Cards
Icon
Formatting Visuals: General Settings
Icon
Diving Deeper into Formatting Visuals
Icon
Working with Report Themes
Icon
Finishing the Report Theme
Icon
Understanding the Slicer
Icon
Default Summarization and Sorting Order
Icon
Creating Treemaps and Working with Multiple Slicers
Icon
Creating Tables
Icon
Syncing Slicers
Icon
Filter on Visual, Page, and Report Level
Icon
Creating Single and Multi-Row Cards
Icon
Adding a Secondary Y-Axis
Icon
Combining Column and Line Charts
Icon
The Waterfall Chart
Icon
Importing Visuals
Icon
Finishing Touches
Icon
Wrap Up
Icon
Report Visualizations – Assignment Problem
Icon
Report Visualizations – Assignment Solution
7
Power BI Pro and Mobile - Sharing and Collaborating with Workspaces and Apps
Icon
Module Introduction
Icon
The Next Steps
Icon
Power BI Pro Pricing
Icon
Power BI Pro Interface Tour
Icon
Publishing and My Workspace - Theory
Icon
Publishing/Importing Power BI Desktop Projects to Pro
Icon
Datasets Walkthrough
Icon
List View Versus Lineage View
Icon
Exploring Reports in Pro
Icon
Understanding Dashboards
Icon
Creating Reports and Dashboards
Icon
Diving Deeper into "My Workspace", Understanding Refresh and a Refresh Error
Icon
Gateways - Theory
Icon
Gateways: Configuring Manual and Scheduled Refresh
Icon
Sharing Data from "My Workspace" Through Direct Access
Icon
Sharing Links
Icon
Understanding Collaboration Workspaces - Theory
Icon
Creating Collaboration Workspaces
Icon
Sharing Data Through Apps
Icon
Publishing and Unpublishing Apps
Icon
Deleting Collaboration Workspaces
Icon
Workspaces Versus Apps
Icon
Working with Power BI Mobile
Icon
Wrap Up
8
Other Data Sources
Icon
Module Introduction
Icon
Importing JSON Data
Icon
Importing Data from REST APIs
Icon
Preparation: Setting Up a MySQL Server
Icon
Importing Data from a MySQL Server (and Other SQL Servers)
Icon
Wrap Up
9
How to Stay Up-To-Date in the Power BI World
Icon
Module Introduction
Icon
Helpful Resources
Icon
Using Preview Features
10
Course Round-Up
Icon
Congratulations!
11
Optional - Power BI Desktop Crash Course (Introduction and Summary)
Icon
Module Introduction
Icon
Project Setup
Icon
Connecting Power BI Desktop to the Source Files
Icon
Query Editor Walkthrough
Icon
Removing Blank Rows and Fixing Format Errors
Icon
Saving the Project
Icon
Duplicates Versus References
Icon
Appending Queries
Icon
Splitting Columns and Extracting Data
Icon
Basic Column Interactions
Icon
Data Modelling Theory
Icon
Creating the "Orders" Table
Icon
Working with Indexes
Icon
The Formula Bar
Icon
Merging Queries
Icon
Loading Data Into the Data Model
Icon
Creating Line Charts
Icon
Understanding Relationships
Icon
Formatting Numbers in Charts
Icon
Understanding Interactions
Icon
Hierarchies and Drill-Down
Icon
Sorting Axis Values
Icon
Formatting Visuals and Applying Report Themes
Icon
Reports, Map Visuals, and Default Summarization
Icon
The Data Category
Icon
Applying Filters to Visuals
Icon
Understanding Slicers
Icon
Creating Tables
Icon
Working with DAX ("Data Analytics Expressions")
Icon
Sorting Weekdays with Calculated Columns
Icon
Fixing the Revenue Calculation
Icon
Introducing Measures
Icon
Working with Quick Measures
12
Bonus - Selected Features by Example and Refresher Project
Icon
Understanding Column from Examples
Icon
Group By, Big Data, and DAX Studio
Icon
Taxi Project - Query Editor
Icon
Taxi Project - Data Model and Visuals
Icon
Taxi Project - Power BI Service
You're currently viewing a free sample. Access the full title and Packt library for free now with a free trial.
Chapter: 4
Data Transformation in the Power Query Editor
Icon This video is locked
Icon
Icon
0:00
2.0x
1.5x
1.25x
1.0x
0.5x
caption settings
caption off
Icon Icon
ShowHide Transcripts Icon
Section: 26
Query Editor – Assignment Solution
In this video, we will solve the assignments outlined in the previous video. By comparing our solutions with the author's, we will gain valuable insights into refining our query editor skills and approaches.
CONTINUE WATCHING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Power BI - A Complete Introduction [2023 EDITION]
End of Chapter 4
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon