Microsoft Power BI - The Complete Masterclass [2023 EDITION] [Video]
Video
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$109.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterIntroduction
-
Preparing Our Project
-
Data Transformation - The Query Editor
- Exploring the Query Editor
- Connecting to Our Data Source
- Editing Rows
- Changing Data Types
- Replacing Values
- Close and Apply
- Connecting to a CSV File
- Connecting to a Webpage
- Extracting Characters
- Splitting and Merging Columns
- Creating Conditional Columns
- Creating Columns from Examples
- Merging Queries
- Pivoting and Unpivoting
- Appending Queries
- Practice and Solution: Population Table
- The Fact-Dimension-Model
- Practice: Load the Dimension Table
- Organizing Our Queries in Groups
- Entering Data Manually
- Creating an Index Column
- Workflow and More Transformations
- Module Summary
- Practice Assignment 1
- Practice Assignment 1 Solution
-
Data Transformation - Advanced
- Advanced Editor - Best Practices
- Performance: References Versus Duplicating
- Performance: Enable / Disable Load and Report Refresh
- Group By
- Mathematical Operations
- Run R Script
- Using Parameters to Dynamically Transform Data
- M Formula Language: Basics
- M Formula Language: Values, Lists, and Tables
- M Formula Language: Functions
- M Formula Language: More Functions and Steps
-
Creating a Data Model
-
Data Visualization
- Our First Visual
- The Format Tab
- Understanding Tables
- Conditional Formatting
- The Pie Chart
- All about the Filter Visual
- The Filter Pane for Developers
- Cross Filtering and Edit Interactions
- Practice Assignment 3
- Practice Assignment 3 Solution
- Syncing Slicers across Pages
- Creating Drilldowns
- Creating Drill-Throughs
- The Treemap Visual
- The Decomposition Tree
- Understanding the Matrix Visual
- Editing Pages
- Buttons and Actions
- Bookmarks to Customize Your Report
- Analytics and Forecasts with Line Charts
- Working with Custom Visuals
- Get Data Using R Script and R Script Visual
- Asking Questions - Q&A Visual
- Wrap Up - Data Visualization
-
Power BI and Python
-
DAX - The Essentials
-
DAX - The CALCULATE Function
-
Tell a Story with Your Data - Learn to Visualize Effectively
-
Power BI Service - Power BI Cloud
- How to Go On Now?
- Power BI Pro Versus Premium and Signing Up
- Exploring the Interface
- Discovering Your Workspace
- Connecting Power BI Desktop and Cloud
- Understanding Datasets and Reports
- Working on Reports
- Updating Reports from Power BI Desktop
- Creating and Working with Workspaces
- Installing and Using a Data Gateway
- Get Quick Insights
- Creating Dashboards
- Sharing Our Results Through Apps
- Power BI Mobile App
- Creating the Layout for the Mobile App
- Wrap Up - Power BI Cloud
-
Row-Level Security
-
More Data Sources
-
Next Steps to Improve and Stay Up-to-Date
About this
video
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that combine to turn unrelated data sources into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.
This course will give you a detailed introduction to Power BI Desktop, Power BI Cloud, and Power BI Mobile! You will then learn to design and implement professional reports and storytelling with data to visualize your data effectively. You will explore advanced features such as working with parameters, using R scripts, optimizing performance, and row-level security. You will focus on performance optimization, Python and R in Power BI, forecasting and advanced analytics, and time intelligence. The course also indulges in data transformation and visualization. You will explore DAX essentials and learn to create a data model.
Upon completing the course, you will gain comprehensive knowledge about Power BI features and reporting abilities. You will master data visualization techniques and acquire extensive knowledge about reporting using Power BI.
All resources are available at: https://github.com/PacktPublishing/Microsoft-Power-BI---The-Complete-Masterclass-2023-EDITION-
- Publication date:
- January 2023
- Publisher
- Packt
- Duration
- 14 hours 31 minutes
- ISBN
- 9781837634682