651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

QuickStart to Power BI for Analysts & Users - Introduction to Power BI

2 Days

Description

QuickStart to Power BI for Analysts and Users is a two-day introductory-level course  that provides attendees with a hands-on exploration of the essential features and benefits of Power BI, as well as a targeted hands-on jump start to performing data analysis with Power BI.  This course will provide you with the job-ready skills required to make you productive in your role with basic Power BI features and functionality, right after the training ends.

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, students will learn how to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Shape and Combine Data
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Time Permitting: Explore the Power BI developer API.
  • Time Permitting: Describe the Power BI mobile app

Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, students will learn how to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Shape and Combine Data
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Time Permitting: Explore the Power BI developer API.
  • Time Permitting: Describe the Power BI mobile app

Upcoming Classes

Virtual Classroom Live
August 12, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
October 28, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Topics

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI
  • Hands-on: Exploring an Enterprise BI solution
  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

Module 2: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Topics

  • Power BI
  • The Power BI service
  • Hands-on: Creating a Power BI dashboard
  • Connecting to Power BI data
  • Create a Power BI dashboard

Module 3: Power BI Essentials

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Topics

  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service
  • Hands-on: Importing data into Power BI
  • Importing Excel files into Power BI
  • Viewing reports from Excel files

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data and transforming it into a form ready for reporting.

Topics

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Hands-on: Shaping and combining data
  • Shape power BI data
  • Combine Power BI data

Module 5: Modelling data

 

This module describes how to shape and enhance data.

Topics

  • Relationships
  • DAX queries
  • Calculations and measures
  • What is DAX (Overview)
  • What is DAX (Tabular)
  • Creating Calculated Columns (Basics)
  • Conditional and Logical Functions
  • Creating Calculated Measures
  • Time Intelligence (Overview)
  • Time Intelligence (Time Intelligence Functions)
  • Using X-Functions and A-Functions
  • DAX as a Query Language
  • Hands-on: Let’s Model Data

Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Topics

  • Creating Power BI Reports
  • Page Layout and Formatting
  • Working with Multiple Visualizations
  • Creating Charts
  • Histograms
  • Managing a Power BI Solution
  • Power BI Service Settings
  • Power BI Desktop Settings

Module 7:  Direct Connectivity

  • Cloud Data
  • Connecting to Big Data
  • Connecting to Analysis Services
  • Direct Connectivity to Analysis Services
  • Using the On-Premises Gateway
  • SSAS Multidimensional Models

Bonus Topics / Time Permitting

This content will be included with your course materials, and will be addressed in class if time permits.

Module 8: The Developer API

  • The Developer API
  • The Interactive API Console
  • Custom Visuals
  • Using Custom Visuals
  • Using the Developer API

Module 9: PowerBI Mobile

  • Power BI Mobile Apps
  • Creating Dashboards for Mobile Devices
  • Power BI for iOS and Android
  • Power BI for Windows 10
  • Using the Power BI Mobile App
  • Annotating Dashboards
  • Power BI Embedded
  • Adding Visualizations to an App
  • Power BI Community

Upcoming Classes

Virtual Classroom Live
August 12, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
October 28, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Before attending this course, students should have:

  • A general knowledge of database concepts (fields, records, relationships).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting 
  • Familiarity with Excel.

Upcoming Classes

Virtual Classroom Live
August 12, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
September 23, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Virtual Classroom Live
October 28, 2024

$1,500.00
2 Days    10 AM ET - 6 PM ET
view class details and enroll
Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date