Mastering Power BI E-Learning

Embark on a transformative journey through the world of Power BI with our comprehensive training program. Over four tracks, participants will master the essentials of data loading, visualization, and report creation in Power BI Desktop, before delving into the collaborative Power BI Service and the robust capabilities of Power Query. The exploration extends into advanced topics, covering administration, security, real-time data, and performance optimization. Finally, participants will immerse themselves in the cutting-edge realm of Power BI Artificial Intelligence, gaining expertise in generating data insights, building machine learning models, and utilizing specialized AI charts. This learning ensures a well-rounded proficiency in harnessing Power BI's capabilities for insightful data representation, collaborative workspaces, advanced administration, and the integration of artificial intelligence for data-driven decision-making.

This Learning Kit with more than 24:53 hours of learning is divided into three tracks:

Track 1: From Data Loading to Stunning Visualizations

Embark on a comprehensive journey through the core fundamentals of Power BI with the "Data Loading and Visualization" track. This track begins with an exploration of the Power BI Desktop, covering installation procedures and providing an overview of its functionalities. Participants will delve into creating impactful reports within Power BI Desktop, mastering basic visualizations such as tables, charts, and maps. As the learning progresses, the focus shifts to advanced aspects of data modeling, introducing calculated columns, measures, relationships, and hierarchies for a nuanced understanding of data manipulation. The track navigates through diverse data sources, including Excel, SQL Server, and web-based and cloud-based data, equipping participants with versatile skills. Elevating the visualization game, participants will explore advanced techniques such as Sankey diagrams, Gantt charts, custom visualizations, and the incorporation of images and shapes, ensuring a well-rounded expertise in leveraging Power BI for insightful data representation.

E-learning courses (7 hours +):

Data Loading & Visualization in Power BI: Getting Started

Course: 1 Hour, 4 Minutes

• Course Overview
• Introduction to Power BI
• Installing and Exploring Power BI Desktop
• Loading Data from a CSV File
• Renaming Columns and Removing Duplicates
• Merging and Splitting Columns
• Column Profile, Quality, and Distribution
• Visualizing Data Using a Bar Chart
• Course Summary

Data Loading & Visualization in Power BI: Loading Data from Databases

Course: 1 Hour, 13 Minutes

• Course Overview
• Loading Data from SharePoint
• Visualizing Data Using Pie and Donut Charts
• Loading Data from SQL Server
• Visualizing Hierarchy and Proportions Using a Treemap
• Using the Import Mode for Data Storage
• Using the DirectQuery Mode for Data Storage
• Connecting to a MySQL Server
• Clearing Cached Credentials and Reconnecting with New Credentials
• Visualizing Data Using Area Charts
• Course Summary

Data Loading & Visualization in Power BI: Loading Data from Cloud Storage

Course: 1 Hour, 29 Minutes

• Course Overview
• Uploading Data Into Google BigQuery
• Loading Data from Google BigQuery
• Visualizing Data Using a Matrix
• Uploading Data to S3 and Creating a User with the Right Permissions
• Loading Data from S3 Using a Python Script
• Visualizing and Customizing a Line Chart
• Loading Data from Azure Blob Storage
• Visualizing Data and Using Drillthrough Filters on Scatter Plots
• Loading Data from an Application Programming Interface (API) Response
• Loading Data from a Website
• Course Summary

Data Loading & Visualization in Power BI: Data Modeling

Course: 2 Hours, 2 Minutes

• Course Overview
• Loading Data for Calculated Tables
• Creating Calculated Tables Using INTERSECT
• Creating Calculated Tables Using NATURALINNERJOIN
• Creating Calculated Tables Using UNION
• Creating Calculated Columns
• Creating Multiple Calculated Columns in a Table
• Loading Data for Data Modeling Using Relationships
• Setting Up One-to-One Relationships between Tables
• Setting Up One-to-Many Relationships and the Cross-filter Direction
• Configuring Many-to-Many Relationships
• Setting Up Many-to-Many Relationships and Cross-filter Direction
• Displaying Star Ratings Using Calculated Measures
• Creating Calculated Measures Using DAX Formulas
• Understanding the Default Date Hierarchy
• Using Time Intelligence and Date Hierarchy Drill Down
• Creating Custom Hierarchies and Using Map Visualizations
• Course Summary

Data Loading & Visualization in Power BI: Advanced Visualizations

Course: 1 Hour, 31 Minutes

• Course Overview
• Visualizing Data Using a Gauge Chart
• Visualizing a Recruitment Pipeline Using a Funnel Chart
• Analyzing Flows Using Sankey Diagrams
• Displaying Flows through Multiple Sets of Nodes
• Viewing Project Schedules Using Gantt Charts
• Customizing Gantt Charts
• Comparing Multiple Variables across Categories with Radar Charts
• Analyzing Profits Using a Heatmap
• Using Calendar Layouts with Time Series Data
• Course Summary

Track 2: Mastering Power BI Service and Power Query

Delve into the collaborative and transformative capabilities of Power BI with the "Power BI Service and Power Query" track. This learning begins with a comprehensive overview of the Power BI service, emphasizing sharing, collaboration, and the deployment of reports to the cloud. Participants will explore the intricacies of creating dynamic dashboards within the Power BI service, mastering the art of building dashboards, adding tiles, and incorporating drill-throughs and drill-downs. The track then shifts focus to Power Query, empowering participants with the skills to transform and clean data efficiently, merge and combine datasets seamlessly, and pivot and unpivot data for enhanced analytics. As the learning unfolds, participants will gain insights into creating dashboards and reports tailored for mobile devices, optimizing the Power BI experience on the go. Throughout the track, an emphasis on sharing workspaces, monitoring usage metrics, and managing mobile content ensures a comprehensive understanding of the collaborative and mobile facets of Power BI.

E-learning courses (8 hours +):

Getting Started with Power Query in Power BI

Course: 1 Hour, 57 Minutes

• Course Overview
• Power Query
• Getting Started with Power Query
• Performing Column Deletion and Renaming Operations
• Cleaning Data and Performing Basic Transformations
• Splitting Columns and Removing Duplicate Rows
• Duplicating and Referencing Queries
• Creating Basic and Advanced Filters
• Adding Custom and Conditional Columns
• Creating Columns Using Merge Queries
• Grouping and Summarizing Operations
• Using Parameterized Queries
• Combining Queries Using Append
• Course Summary

Performing Joins Using Merge Queries in Power BI

Course: 1 Hour, 25 Minutes

• Course Overview
• Loading Data and Setting Up Relationships
• Performing Inner Joins Using Merge Queries
• Performing Left Outer Joins Using Merge Queries
• Performing Right Outer Joins Using Merge Queries
• Performing Full Outer Joins Using Merge Queries
• Performing Left Anti and Right Anti Joins
• Using Anti Joins to Filter Errors
• Pivoting and Unpivoting Columns
• Performing Fuzzy Merging
• Ignoring Case and Combining Text Parts
• Configuring the Similarity Threshold
• Performing Fuzzy Merging Using a Transformation Table
• Course Summary

Getting Started with the Power BI Service

Course: 2 Hours

• Course Overview
• Power BI Service
• Creating an Account with the Power BI Service
• Creating Datasets
• Getting Started with Dataflows
• Refreshing Dataflow
• Autogenerating Reports in the Power BI Service
• Creating Reports Using the Power BI Service
• Creating a Report and a Dashboard
• Using Natural Language Q&A with the Dashboard
• Sharing Reports and Dashboards
• Connecting to a Dataflow from Power BI Desktop
• Publishing a Report from Power BI Desktop to the Power BI Service
• Creating Dashboards from Multiple Reports
• Creating and Publishing a Report with a Slicer
• Applying Row-level Security to Datasets and Reports
• Exporting and Embedding Reports
• Course Summary

Working with Scorecards, Dashboards, & Paginated Reports in Power BI

Course: 2 Hours

• Course Overview
• Creating Scorecards to Track Metrics
• Creating Connected Metrics and Submetrics
• Filtering Metrics
• Connecting to a Dataflow and Creating Multiple Reports
• Working with Live Tiles in Dashboards
• Updating Dashboards and Reports with Data Refresh
• Pinning Visuals from Excel
• Using Slicers in Dashboards
• Creating a Simple Paginated Report
• Linking Paginated Reports
• Building and Sharing Power BI Apps
• Creating and Using Deployment Pipelines
• Updating Content and Redeploying Pipeline
• Course Summary

Using the Power BI Mobile App

Course: 53 Minutes

• Course Overview
• Installing and Using the Power BI Mobile App
• Configuring the Mobile Layout of a Report
• Using Visual Filters and Report Filters in Mobile View
• Adding and Hiding Shortcuts and Favorites
• Sharing, Commenting, and Using Annotations
• Course Summary

Track 3: Advanced Strategies for Administration, Security, and Performance

Embark on an intensive exploration of advanced Power BI functionalities with the "Advanced Topics in Power BI" track. This track begins by unraveling the intricacies of administration and security, covering roles, access management, data gateways, data protection, and data loss prevention. Participants will gain mastery over implementing row-level and object-level security, ensuring a robust and controlled data environment. The learning then shifts gears into the realm of real-time data and performance optimization, guiding participants on connecting to streaming data sources and leveraging automatic refresh and alerting mechanisms. The track delves deep into the art of optimizing report and dashboard performance through techniques such as caching and minimizing data transfers, equipping participants with the skills to ensure a seamless and responsive Power BI experience. Throughout this advanced track, a focus on cutting-edge topics elevates participants' proficiency, making them adept in handling the complexities of Power BI administration, security, and performance optimization.

E-learning courses (2 hours +):

Advanced Topics in Power BI: Getting Started with Power BI Administration

Course: 44 Minutes

• Course Overview
• Introducing Power BI Administration
• Exploring the Admin Portal as a Fabric Administrator
• Enabling Settings for the Organization
• Configuring Settings Using Security Groups
• Blocking Uncertified Visuals and Adding Organizational Visuals
• Course Summary

Advanced Topics in Power BI: Working with Real-time Streaming in Power BI

Course: 1 Hour, 55 Minutes

• Course Overview
• Introduction to Real-time Streaming in Power B
• Publishing a Report Using On-premises Data
• Refreshing Data via a Data Gateway
• Connecting to a PubNub Streaming Dataset
• Adding Streaming Tiles to Dashboards
• Customizing Streaming Visuals Using Market Order Data
• Configuring a Streaming API Source
• Using cURL to Post Streaming Records to the API Stream
• Using Python to Post Streaming Records to the API Stream
• Creating a Report From a Streaming Plus Push Dataset
• Configuring Dashboard Alerts
• Configuring Scheduled Refresh
• Performing Query Caching in Power BI
• Course Summary

Track 4: Empowering Your Data Insights: Unleashing AI in Power BI

Embark on an immersive journey into the realm of artificial intelligence within Power BI with the "Power BI Artificial Intelligence" track. This exploration encompasses various facets of AI, starting with the ability to automatically generate data insights on datasets and visualize them on dashboards. Participants will learn to interpret fluctuations in visuals and discover distribution variations using AI insights. The track then transitions into the realm of machine learning, guiding participants through the process of creating and training machine learning models, assessing model performance, and integrating Azure Machine Learning models seamlessly into Power BI. Specialized charts designed for AI tasks, including anomaly detection, sentiment analysis, decomposition tree visuals, key influencers visualizations, and smart narrative summaries, offer participants a comprehensive toolkit. The learning concludes with a focus on natural language interaction, empowering participants to explore data seamlessly using Power BI Q&A and creating Q&A visuals within reports. This track ensures participants are well-versed in leveraging artificial intelligence to extract meaningful insights and drive informed decision-making within Power BI.

E-learning courses (6 hours +):

Leveraging AI Insights & Text Analytics in Power BI

Course: 2 Hours, 14 Minutes

• Course Overview
• Leveraging Artificial Intelligence (AI) in Power BI
• Generating AI Insights on Datasets
• Importance of Data in Generating Insights
• Optimizing Data for Better Insights
• Extracting Insights from Reports
• Analyzing Insights from Reports
• Viewing Insights from Dashboard Tiles
• Explaining Fluctuations in Visuals
• Discovering Where Distributions Vary
• Performing Language Detection Using Text Analytics
• Performing Key Phrase Extraction Using Text Analytics
• Performing Sentiment Scoring with Text Analytics
• Executing Image Tagging Using Vision Analytics
• Course Summary

Training Machine Learning Models in Power BI

Course: 1 Hour, 43 Minutes

• Course Overview
• Creating a Dataflow and Exploring Data for Binary Classification
• Training a Binary Classification Model
• Analyzing the Training Report, Top Influencers, and Probability Thresholds
• Performing Cost Benefit Analysis and Assessing Model Performance
• Exploring Data Loading and Exploratory Data Analysis for Regression
• Configuring and Training a Regression Model
• Evaluating and Interpreting the Training Report
• Loading Data and Exploring Multi-class Classification
• Viewing Training Metrics for Multi-class Classification
• Retraining the Model with New Data
• Course Summary

AI-powered Visuals in Power BI

Course: 1 Hour, 25 Minutes

• Course Overview
• Performing Anomaly Detection with Insights and Forecasting
• Detecting and Explaining Anomalies
• Drilling Down into Measures Using the Decomposition Tree
• Using AI Splits to Build the Decomposition Tree
• Locking and Unlocking Levels
• Interpreting Key Influencer Visuals
• Viewing Multiple Key Influencers and Top Segments
• Configuring Key Influencer Visuals
• Creating Key Influencers for Continuous Numeric Metrics
• Course Summary

Smart Narratives, Q&A Visuals, & Copilot in Power BI

Course: 1 Hour, 18 Minutes

• Course Overview
• Generating Smart Narratives for Visuals
• Creating and Configuring Dynamic Values in Smart Narratives
• Generating Smart Narratives with Filters, Clusters, and for Reports
• Asking Natural Language Questions Using Q&A Visuals
• Teaching Q&A New Terms Used in Queries
• Configuring Synonyms and Suggested Questions for Q&A
• Using Copilot to Write DAX Formulas for Quick Measures
• Generating More Complex DAX Formulas with Copilot
• Course Summary