Data Loading and Visualization in Power BI E-Learning

Learn all about data management and powerful data visualisation with our Data Loading and Visualisation in Power BI Training! This course is designed to help you load, transform and visualise data effectively in Power BI so you can discover and present valuable insights. Ideal for both beginners and advanced users who want to strengthen their skills in Power BI.

You will learn how to import, cleanse and structure data from different sources, and how to create interactive reports and dashboards. With hands-on exercises, you will work with advanced visualisation options to present your data in a clear and engaging way. By the end of the course, you will be able to support business decisions with compelling data analysis.

Benefits of this training:

• Step-by-step guidance in loading and transforming data in Power BI
• Hands-on experience in designing interactive dashboards and reports
• In-depth knowledge of advanced visualisation techniques
• Access to practice exams and support from an online mentor

Course content

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