Power BI Fundamentals

The creation of data-backed visualization is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

AcademyX's Power BI Fundamentals course is designed to train professionals on the powerful features of Microsoft's powerful cloud-based business intelligence platform to analyze and visualize data. Topics covered:

Analyzing Data with Self-Service BI

Data Analysis and Visualization for Business Intelligence
Self-Service BI with Microsoft Power BI

Connecting to Data

Create Data Connections
Model Data with Relationships
Save Power BI Files

Performing Advanced Data Modeling and Shaping

Clean and Transform Data with Query Editor
Shape Data with the Query Editor
Combine and Manage Data Rows

Visualizing Data with Power BI

Create Visualizations in Power BI
Chart Data in Power BI

Enhancing Data Analysis

Enhance Analysis with Customized Visuals and Pages
Enhance Analysis with Tooltips

Modeling Data with Calculations

Create Calculations with Data Analysis Expressions (DAX)
Create Calculated Measures and Conditional Columns

Creating Interactive Visualizations

Create and Manage Data Hierarchies
Filter and Slice Reports
Create Dashboards in Power BI

Prerequisites:

Experience managing data with a spreadsheet program such as Excel or Google Sheets. *Please Note: A Mac environment will not work for this class