![Microsoft Power BI - A Complete Introduction [2023 EDITION] [Video]](https://static.packt-cdn.com/assets/images/Packt-iPad-Logos_250x308.png)
Microsoft Power BI - A Complete Introduction [2023 EDITION] [Video]
Subscription
FREE
Video
$173.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video
$173.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterGetting Started
- Welcome to This Course
- Module Introduction
- What Is Power BI?
- Installing Power BI Desktop
- Connecting Power BI Desktop to Source Files
- Creating Our First Visuals
- Comparing Excel and Power BI
- Course Outline
- The Two Ways (Paths) of Taking This Course
- How to Get the Most Out of This Course
- Important: How to Access Course Resources, Project Files, and Slides
-
Understanding the Power BI Desktop Basics and Preparing the Course Project
-
Data Preparation in the Power Query Editor
- Module Introduction
- Understanding Data Preparation / Cleaning / Cleansing
- Connecting Power BI Desktop to Source Files
- How Power BI Queries Data
- Understanding Basic Row Operations
- Filtering Data
- Analyzing Columns and Removing Blank Fields
- Understanding and Using the Append Feature
- Choosing and Removing Columns
- Append Behind the Scenes
- Understanding the Transpose Feature
- Replacing Values
- Working with Dates - The Basics
- Understanding Data Formats
- Handling Data Format Errors
- Understanding Pivoting and Unpivoting
- Applying Pivoting and Unpivoting
- Fixing a Sorting Problem
- Extracting Data, Splitting Columns, and Sorting Multiple Columns
- Introducing the "Group By" Feature
- Improving the Project Structure
- Wrap Up
-
Data Transformation in the Power Query Editor
- Module Introduction
- Data Warehouse, Data Model, and Data Schema
- The Star Schema - Theory
- Applying the Star Schema to Our Project
- Understanding References
- Comparing References and Duplicates
- Importing Country and Region Codes
- Using "Enter Data" to Create a Table
- Understanding the Merge Feature
- How to Join Tables
- Understanding Outer, Inner, and Anti Joins
- Join Kind in Practice
- Handling Merge Errors
- Understanding the DIM-age Table
- Bringing Back the "age-group" Column
- Getting the Maximum Values from Each Age Group
- Creating Conditional Columns
- Creating an Index Column
- Creating a DIM-gender Table
- Understanding the FACT Table
- Finishing the FACT Table
- Applying Basic Mathematical Operations
- Using the Enable Load Feature
- Wrap Up
- Query Editor – Assignment Problem
- Query Editor – Assignment Solution
-
The Data Model - Working with Relationships and DAX (Data Analysis Expressions)
- Module Introduction
- Query Editor Versus Data Model
- Understanding Relationships
- Creating Our First Relationship
- Understanding Cardinality and Difference Relationship Types
- One to Many and Many to One
- One to One
- Many to Many
- Fixing the Column Order Bug
- Understanding the Cross-Filter Direction
- Understanding Active Properties
- Adding Relationships to the Project
- M-Language Versus DAX (Data Analysis Expressions)
- Creating a Custom Column with the M-Language
- Creating a Calculated Column with DAX
- M Versus DAX - What Should I Choose?
- The DAX Basics
- The Core DAX Syntax
- DAX Data Types
- DAX Operators
- DAX Core Functions
- Creating a Table with the CALENDAR Function
- Extracting Data with the DOT Notation
- Adding and Dividing Columns
- Working with IF Functions
- Understanding Relationship Functions
- Calculated Column Versus Measure
- Understanding and Creating Measures
- Working with FILTER and CALCULATE Functions - Theory
- Combining CALCULATED and FILTER Functions
- Adding the Filter Condition to CALCULATE
- Using Measures in Measures
- Changing the Measure's Home Table
- Understanding the Data Category
- Wrap Up
- Data Model and RelationshipView – Assignment Problem
- Data Model and RelationshipView – Assignment Solution
-
Creating Visuals in the Report View
- Module Introduction
- The Power BI Workflow and Understanding Basic Visual Elements
- Creating and Duplicating Pages
- Organizing Visuals
- Creating a New Visual
- Creating Line and Column Charts
- How FILTER Affects the Visual
- Understanding Interactions
- Hierarchies and Drill Down
- Formatting Chart Colors
- The Canvas
- Formatting the Page Background / Wallpaper
- Formatting the Filter Pane and Filter Cards
- Formatting Visuals: General Settings
- Diving Deeper into Formatting Visuals
- Working with Report Themes
- Finishing the Report Theme
- Understanding the Slicer
- Default Summarization and Sorting Order
- Creating Treemaps and Working with Multiple Slicers
- Creating Tables
- Syncing Slicers
- Filter on Visual, Page, and Report Level
- Creating Single and Multi-Row Cards
- Adding a Secondary Y-Axis
- Combining Column and Line Charts
- The Waterfall Chart
- Importing Visuals
- Finishing Touches
- Wrap Up
- Report Visualizations – Assignment Problem
- Report Visualizations – Assignment Solution
-
Power BI Pro and Mobile - Sharing and Collaborating with Workspaces and Apps
- Module Introduction
- The Next Steps
- Power BI Pro Pricing
- Power BI Pro Interface Tour
- Publishing and My Workspace - Theory
- Publishing/Importing Power BI Desktop Projects to Pro
- Datasets Walkthrough
- List View Versus Lineage View
- Exploring Reports in Pro
- Understanding Dashboards
- Creating Reports and Dashboards
- Diving Deeper into "My Workspace", Understanding Refresh and a Refresh Error
- Gateways - Theory
- Gateways: Configuring Manual and Scheduled Refresh
- Sharing Data from "My Workspace" Through Direct Access
- Sharing Links
- Understanding Collaboration Workspaces - Theory
- Creating Collaboration Workspaces
- Sharing Data Through Apps
- Publishing and Unpublishing Apps
- Deleting Collaboration Workspaces
- Workspaces Versus Apps
- Working with Power BI Mobile
- Wrap Up
-
Other Data Sources
-
How to Stay Up-To-Date in the Power BI World
-
Course Round-Up
-
Optional - Power BI Desktop Crash Course (Introduction and Summary)
- Module Introduction
- Project Setup
- Connecting Power BI Desktop to the Source Files
- Query Editor Walkthrough
- Removing Blank Rows and Fixing Format Errors
- Saving the Project
- Duplicates Versus References
- Appending Queries
- Splitting Columns and Extracting Data
- Basic Column Interactions
- Data Modelling Theory
- Creating the "Orders" Table
- Working with Indexes
- The Formula Bar
- Merging Queries
- Loading Data Into the Data Model
- Creating Line Charts
- Understanding Relationships
- Formatting Numbers in Charts
- Understanding Interactions
- Hierarchies and Drill-Down
- Sorting Axis Values
- Formatting Visuals and Applying Report Themes
- Reports, Map Visuals, and Default Summarization
- The Data Category
- Applying Filters to Visuals
- Understanding Slicers
- Creating Tables
- Working with DAX ("Data Analytics Expressions")
- Sorting Weekdays with Calculated Columns
- Fixing the Revenue Calculation
- Introducing Measures
- Working with Quick Measures
-
Bonus - Selected Features by Example and Refresher Project
About this video
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!
- Publication date:
- October 2018
- Publisher
- Packt
- Duration
- 17 hours 14 minutes
- ISBN
- 9781789959031
Latest Reviews
(5 reviews total)