UNF Professional and Lifelong Learning
UNF Professional and Lifelong Learning · Microsoft

Introduction to Power BI Training

LevelBeginner
Duration3 Days
ExperienceNone
Average Salary$109,029
LabsYes

Offered to the Jacksonville and Northeast Florida community through UNF Professional and Lifelong Learning in partnership with Applied Technology Academy — live online or in person, taught by ATA's practitioner instructors.

Course Overview

It discusses in depth the industry- recognized steps from raw data to detailed analysis via five main stages:

  • Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
  • Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
  • Creating and extending a comprehensive data model with DAX
  • Visualizing data in Power BI desktop using built-in tools
  • Sharing and collaborating with the Power BI service or Power BI server
Course Outline
  • Chapter 1: Power BI Overview
    • Visual analysis and visual analytics
    • Power BI Infrastructure
    • Loading Data
    • Introduction to Power BI Desktop
    • Hands-On Exercise 1.1 Loading and Visualizing data
  • Chapter 2: Transforming Data
    • Using Power Query to clean, transform and load data
    • Profiling your data
    • Resolve data quality issues
    • Apply user-friendly names to Queries, tables, and columns
    • Import data from an Excel formatted report
    • Hands-On Exercise 2.1 Transforming Data with Power Query
    • Hands-On Exercise 2.2 Appending, Merging, and Combining Queries
  • Chapter 3: Creating a Data Model
    • Understand the role of the Data Model in Power BI
    • Create table relationships
    • Understand Cardinality and Cross Filtering
    • Discuss Star and Snowflake schema
    • Create a Date Dimension
    • Build a Data Model from multiple Data sources
    • Hands-On Exercise 3.1 Creating a Data Model
  • Chapter 4: Visualizing your Data
    • Discuss Report settings
    • Choosing the right visualizations
    • Creating, formatting, and styling your reports
    • Using Hierarchies and Drilldown
    • Utilizing Slicers and Filters
    • Adding Custom Visualizations
    • Hands-On Exercise 4.1 Creating Reports Part 1
    • Hands-On Exercise 4.2 Creating Reports Part 2
    • Hands-On Exercise 4.3 Creating Reports Part 3
  • Chapter 5: Introduction to DAX, Calculated Columns and Measures
    • Gain an Introduction to DAX
    • Differentiate between Calculated Columns and Measures
    • Create Calculated Columns
    • Create Measures
    • Understand Filter and Row context
    • Understand the power of the Calculate function
    • Hands-on Exercise 5.1 Introduction to DAX
    • Optional Hands-on Exercise 5.2 Intermediate Level DAX
  • Chapter 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)
    • Discuss the Power BI Service and Power BI Server
    • Understand the main components of the Power BI Service
    • Publish a Power BI Project to the Power BI Service
    • Share Reports
    • Build and Share Dashboards
    • Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service
Intended Audience
  • BI and reporting professionals
  • Data analysts
  • Data professionals
Prerequisites

There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.