The Ultimate Drawing Course Beginner to Advanced...
$179
$79
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659
Business
Business Analytics & Intelligence
Microsoft Power BI
15 days of Power BI - Complete Microsoft Power BI Bootcamp
Just 15 days to master Power BI Desktop + Power BI Service (Cloud) + Power BI Mobile in a project-based, practical way.
4.6
(20080)
105151 enrolled on this course
Last updated 11/2021
Nikolai Schuler
Description
Learn data visualization through Microsoft Power BI and create opportunities for you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.
You'll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.
Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond Accordingly
Connect Power BI to a Variety of Datasets
Drill Down and Up in Your Visualization and Calculate Data
Visualize Data in the Form of Various Charts, Plots, and Maps
Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI
Each section provides exercises that will challenge you so you can learn by immediately applying what you're learning.
Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.
Contents and Overview
This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.
To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and time series.
Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.
In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.
You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.
Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brick charts, and more.
By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.
You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.
Who this course is for:
Anyone that has never used Power BI before and is looking for a hands-on approach to learn it
Anyone working with data and get professional working with Power BI
Anyone that wants to pursue a career as a data analyst, data scientist or BI consultant
What you'll learn
Learn Power BI from scratch
Build Reports
Use DAX
Create Visualizations
Clean Data with PowerQuery
Connect to data sources
Requirements
- You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
- No previous design experience is needed.
- No previous Adobe XD skills are needed.
Course Content
27 sections • 95 lectures
Expand All Sections
1.1-Welcome!
1.2-What is Power BI?
1.3-All Files for Download
1.4-How to Install Power BI Desktop: Step-by-Step Guide for Beginners
1.5-Power BI Interface Tutorial: Loading Data and Creating Your First Visualization
1.6-The Interface
1.7-How to Navigate Power BI Panes: Tips for Efficient Workspace Management
1.8-Important: Configuring Initial Project Settings
1.9-How to Connect and Load CSV Data in Power BI
1.10-Our Project: How to Create a Comprehensive Sales Report in Power BI
1.11-How to Use Power Query Editor for Data Transformation in Power BI
1.12-The Query Editor
1.13-How to Fix Data Source Errors in Power BI: Troubleshooting Missing File Paths
1.14-Power BI Data Transformation: Using Remove Rows and Choose Columns Features
1.15-Power BI Query Editor: Changing Column Data Types for Accurate Analysis
1.16-How to Change Data Types in Power BI Using Locales
1.17-Data Types, Replace & Edit rows
1.18-Power BI Data Cleaning: Replace Text and Change Column Data Types Step-by-Step
1.19-Summary: Query Editor and Transform Data in Power BI
1.20-Welcome challenge!
1.21-Final project for today
2.1-Goals Day 2: Effective Visualizations and Data Transformations
2.2-How to Extract Values in Power BI: Data Transformation Techniques for Analysis
2.3-Optimizing Data Preparation: Using Split Column Tools in Power BI Query Editor
2.4-How to Clean and Transform Text Data in Power BI Query Editor
2.5-Power Query Data Cleaning: Numerical Transformations in Power BI
2.6-Power BI Data Model Essentials: Building Efficient Relationships for Dashboards
2.7-Practice: Data Cleaning & Relationship
2.8-Solution: Data Cleaning & Relationship
2.9-Solution: How to Create and Fix Relationships in Power BI Data Models
2.10-Power BI Visualization Techniques: Mastering Stacked Column Charts and Legends
2.11-Power BI Formatting: Mastering the Format Pane for Enhanced Visualizations
2.12-How to Use Data Labels in Power BI Charts: Stacked Column and Pie Visualizations
2.13-How to Use Pie Charts Effectively in Power BI: Best Practices and Alternatives
2.14-How to Create and Format a Pie Chart in Power BI: Step-by-Step Tutorial
2.15-Final Project: Day 2
3.1-Goals Day 3: Combining Data and Data Modeling in Power BI
3.2-How to Append Queries in Power BI: Combining Data from Multiple Tables
3.3-Append Queries
3.4-How to Group and Manage Queries in Power BI: Organizing Your Data Sources
3.5-How to Hide Tables in Power BI: Improving User Experience in Report View
3.6-How to Use Date Hierarchy in Power BI Line Charts for Time-Based Visualizations
3.7-How to Use Drill Down Mode in Power BI: Beyond Date Hierarchies
3.8-How to Create and Customize Line Charts in Power BI: A Step-by-Step Guide
3.9-Project: Day 3
3.10-How to Combine Multiple Files from a Folder in Power BI: Step-by-Step Tutorial
3.11-How to Create a Fact-Dimension Model in Power BI: Star Schema Explained
3.12-Fact-Dimension model
3.13-Understanding Cardinality in Power BI: Mastering Many-to-One Relationships
3.14-How to Manage Active and Inactive Relationships in Power BI Data Models
3.15-How to Manage Relationships in Power BI: Autodetect & Data Model Best Practices
3.16-Final quiz for today
4.1-Power BI Table Visualization: Tips for Effective Data Presentation
4.2-How to Format Tables in Power BI: Customizing Styles & Colors for Visualizations
4.3-How to Use Conditional Formatting Rules in Power BI for Data Visualization
4.4-Practice Project
4.5-Mastering Data Integration: Merge Queries for Comprehensive Dashboards
4.6-Power BI Data Transformation: Mastering Pivot & Unpivot Techniques for Analytics
4.7-Mastering Power BI Relationships: From One-to-Many to Many-to-Many Connections
5.1-How to Use Power BI Slicers: A Comprehensive Guide to Filtering Data Effectively
5.2-How to Design Professional Power BI Reports: Formatting Canvas and Wallpaper
5.3-Practice Project
5.4-Mastering Power BI Filters: Basic and Advanced Filtering Options Explained
5.5-Advanced Power BI Filtering Techniques: Top N, Visual-Level, and Date Filters
5.6-Mastering Power BI Slicer Sync: Advanced Techniques for Data Filtering
5.7-Mastering Treemap Visuals in Power BI: Alternatives to Bar and Pie Charts
5.8-Power BI Edit Interactions: Mastering Cross-Filtering Between Visuals
5.9-Power BI Drill Through Tutorial: Enhancing Dashboard Interactivity and Analysis
5.10-Mastering Power BI Tooltips: Enhance Your Data Visualization with Custom Info
5.11-Practice Project
6.1-Using M Language: Creating Custom Columns for Advanced Data Manipulation
6.2-How to Enable and Disable Load in Power BI Data Models for Better Performance
6.3-Power BI Query Management: Differences Between Duplicates and References
6.4-How to Use Power BI Columns from Examples for Efficient Data Transformation
6.5-Project
6.6-Optimizing Power BI Charts: Sorting Weekdays for Effective Data Visualization
6.7-How to Create a Conditional Column in Power BI for Weekday Sorting
6.8-How to Create Interactive Map Visualizations in Power BI for Data Analysis
6.9-How to Use Power BI Filled Maps for Effective Data Filtering and Visualization
6.10-Power BI Line Charts: Adding Forecasts and Trend Lines for Advanced Analytics
6.11-How to Use Power BI Anomaly Detection: Find Outliers in Time Series Data
7.1-How to Create Interactive Drillthrough Buttons in Power BI for Better Navigation
7.2-How to Use Clear and Apply Slicer Buttons in Power BI for Efficient Filtering
7.3-Creating User-Friendly Buttons in Power BI: Tooltips, Transparency, and Actions
7.4-How to Create and Use Bookmarks in Power BI: A Step-by-Step Guide
7.5-Challenge: Building Interactive Top N Filters with Buttons and Booksmarks
7.6-Solution: Building Interactive Top N Filters with Buttons and Booksmarks
7.7-Mastering Power BI Card Visual: Customize and Format for Impactful Dashboards
7.8-How to Use Multi-Row Cards in Power BI: A Step-by-Step Tutorial
7.9-Final project for today!
7.10-How to Create Custom Tooltips in Power BI: Displaying Report Pages as Visuals
7.11-Power BI Theme Gallery: Finding and Importing Custom Themes for Better Reports
8.1-How to Create Calculated Columns in DAX: Power BI Data Model Enhancement
8.2-Power BI Measures vs Calculated Columns: Key Differences in DAX Calculations
8.3-How to Use DAX Average Function in Power BI: Mastering Calculated Measures
8.4-Create a Measure Table in Power BI: Organizing DAX Calculations Efficiently
8.5-DAX Basics: Understanding COUNT, COUNTROWS, and DISTINCTCOUNT in DAX
8.6-Mastering SUMX and AVERAGEX: Iterative Functions in DAX for Power BI
8.7-Mastering Row-Based Functions in DAX: SUMX & AVERAGEX for Power BI Calculations
8.8-Power BI DAX Essentials: Rounding Numbers with Precision in Calculated Columns
8.9-DAX Essentials: Understanding Row Context and RELATED Function in Power BI
9.1-DAX Filter Context Explained: Mastering CALCULATE Function
9.2-How to Use the FILTER Function in DAX: Advanced Power BI Calculations Explained
9.3-Master DAX Logical Operators: Advanced Filtering Techniques in Power BI
9.4-DAX Challenges
9.5-Solutions
9.6-Advanced DAX Techniques: Overcoming Filter Context with ALL Function in Power BI
9.7-Advanced DAX Techniques: Optimizing Percentage Calculations with ALL Function
9.8-How to Use ALLEXCEPT Function in DAX: Advanced Power BI Filtering Techniques
9.9-How to Use ALLSELECTED Function in DAX: Advanced Power BI Filtering Techniques
10.1-How to Use DATEADD Function in DAX for Time Intelligence in Power BI
10.2-Mastering Running Totals with DAX: Year-to-Date and Quarter-to-Date in Power BI
10.3-How to Use DAX FORMAT Function in Power BI for Custom Date Formatting
10.4-Power BI Time Intelligence: Building a Date Table with DAX and ADDCOLUMNS
10.5-Complete Date Table with features
10.6-Mastering DAX in Power BI: Using ChatGPT for Measures and Calculated Columns
10.7-Optimizing Power BI Reports with ChatGPT: Advanced DAX Measure Techniques
10.8-DAX Challenges
10.9-DAX Solutions
11.1-Goals Day 11: Publish Power BI Reports to the Cloud
11.2-Power BI Service: Accessing and Consuming Reports Anywhere in the World
11.3-Understanding Power BI Subscriptions: Choosing the Right License for Your Needs
11.4-How to Sign Up for Power BI Service: Step-by-Step Guide for Free & Pro Versions
11.5-Power BI Service Setup: Using Office 365 Enterprise Trial for Free Access
11.6-How to Navigate Power BI Service: A Quick Guide for Beginners
11.7-Understanding Power BI Workspaces: Dashboards, Reports, and Datasets Explained
11.8-Power BI Service: Publishing Reports and Datasets to Your Workspace
11.9-How to Create and Edit Reports in Power BI Service: Step-by-Step Guide
11.10-Power BI Workspace Management: Updating Reports and Datasets in the Cloud
11.11-Mastering Power BI Workspace Access: Admin, Member, and Contributor Roles
11.12-Final project for today
12.1-Goals Day 12: Creating Apps, Schedule Refresh and Dashboards
12.2-How to Set Up Power BI Gateway for Automatic Data Refresh in Power BI Service
12.3-How to Set Up Scheduled Refresh in Power BI
12.4-How to Create and Distribute Power BI Apps for Effective Report Sharing
12.5-Optimizing Power BI Report: Creating Overview Dashboards for High-Level Insights
12.6-How to Get AI-Powered Insights from Your Power BI Data: A Step-by-Step Guide
12.7-How to Set Up and Use Power BI Mobile App: A Step-by-Step Guide for Beginners
12.8-How to Create Mobile-Friendly Power BI Reports: Step-by-Step Guide
12.9-Project for today
13.1-Goals for Day 13: How to Set Up Row-Level Security (RLS) in Power BI
13.2-Basic RLS: Creating Custom Roles for Data Access Control in Power BI
13.3-Power BI RLS: Publishing and Testing Security Measures in the Cloud Workspace
13.4-Understanding Data Model Relationships for Effective RLS in Power BI
13.5-Power BI Security: Setting Up Dynamic RLS with External Tables and DAX
13.6-How to Fix Many-to-Many Relationships in Power BI Row-Level Security (RLS)
13.7-How to Implement Page-Level Security in Power BI: Custom Navigation Workaround
14.1-Goals for Day 14: Building a Machine Learning Model in Power BI
14.2-Overview: How to Integrate Python with Power BI for Advanced Data Analysis
14.3-How to Install Python and Connect It with Power BI for Data Analysis
14.4-How to Use Python in Power BI: Transform Data with Pandas and Matplotlib
14.5-Python script I used in the next lecture
14.6-How to Use Python Visuals in Power BI: Step-by-Step Guide for Data Analysis
14.7-Python script II used in the next lecture
14.8-How to Create Violin Plots in Power BI Using Python & Seaborn for Data Analysis
14.9-Python script III used in the next lecture
14.10-Power BI and Python Integration: Sentiment Scoring for Business Analytics
14.11-Troubleshooting Python Integration in Power BI: Solutions for Common Issues
14.12-How to Connect Power BI to REST API: Step-by-Step Guide for JSON Data Import
14.13-Setting Up MySQL Workbench for Power BI Integration Guide
14.14-Power BI and SQL Server Integration: Setting Up Your First Database Connection
15.1-Goals for Day 15: Power Query M Language: Advanced Data Transformation
15.2-Master Power BI M Language: Advanced Data Transformation Techniques for Analysts
15.3-Understanding the Basics of Power Query M Language
15.4-Power Query M Language: Understanding Values, Lists, and Tables
15.5-Mastering Table Functions in Power Query M Language
15.6-Quick Challenge 1
15.7-Mastering Power Query M Language: Each & Table.AddColumns
15.8-Quick Challenge 2
15.9-Power Query M Formula Language: Advanced Functions and Documentation Guide
15.10-Final Capstone Project
16.1-You made it!
16.2-Bonus
You May Like
10,000+ unique online course list designs
