Data Loading and Visualization in Power BI E-Learning

Order this unique E-Learning course Data Loading and Visualization in Power BI online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.

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