Office 365
Training
Welcome!    Login | Checkout 0 Items | Checkout
ETI Performance Improvement

Software Training

Showing that application who's boss since 1984


MicroSoft Power BI

Welcome to Introduction to Microsoft Power BI! This powerful collection of software, apps, and services will help you analyze your organization’s data and uncover insights and trends. This course will show you how to link and model data in Power BI and create visual reports that reveal data insights. Although the Power BI desktop client will be the primary focus, an introduction to the Power BI web app will also be provided.

Prerequisites

This manual assumes the user has an intermediate knowledge of Microsoft Excel and Microsoft Access, as well as a basic knowledge of Windows and web browsers.



More About This Session


Topics
Dates & Registration

MicroSoft Power BI

1 Day

List Price: $265


Register!

Lesson 1: Getting Started

TOPIC A: An Introduction to Power BI

  • What is Power BI?
  • The Building Blocks of Power BI
  • The Power BI Desktop Interface
  • Important Information About Power BI Updates

TOPIC B: Working with Power BI Desktop Files

  • Opening Files
  • Saving Files
  • Creating a New File
  • Publishing to the Power BI Web App

TOPIC C: Connecting to Data Sources with Power BI Desktop

  • Connecting to an Excel Workbook
  • Connecting to an Access Database
  • Viewing All Connection Options
  • Creating a Manual Dataset
  • Managing Data Sources

TOPIC D: Creating a Report with Visualizations

  • Using the Visualizations Pane
  • Using the Fields Pane
  • Creating a Visualization
  • Interacting with Visualizations
  • Changing the Visualization Type
  • Moving and Resizing Visualizations

TOPIC E: Doing More with Visualizations

  • Formatting Visualizations
  • Viewing Visualization Data
  • Using Focus Mode and Spotlight
  • Removing a Visualization

Lesson 2: Working with Data

TOPIC A: Transforming and Sanitizing Data

  • Using Data View
  • Cleaning Irregularly Formatted Data
  • Managing Columns
  • Sorting Table Data

TOPIC B: Using the Query Editor

  • Opening the Query Editor
  • The Query Editor Interface
  • Using the Query Settings Pane
  • Using Merge Queries
  • Using Append Queries

TOPIC C: Data Modeling

  • What is DAX?
  • Creating a New Table
  • Creating a New Calculated Column
  • Creating a New Measure

TOPIC D: Managing Relationships

  • Using the Relationships View
  • Creating Relationships
  • Editing Relationships
  • Deleting Relationships
  • Using the Manage Relationships Dialog

Lesson 3: Working with Reports and Visualizations

TOPIC A: Managing Report Pages

  • Navigating Through Pages
  • Showing and Hiding Pages
  • Adding Pages
  • Deleting Pages
  • Renaming Pages
  • Changing Page Order

TOPIC B: Changing Report View Options

  • Setting Page View Options
  • Customizing Your View
  • Using Phone vs. Desktop Layout

TOPIC C: Working with Visualizations

  • Understanding Drill through Options
  • Changing Category and Summarization Options
  • Arranging Visualizations
  • Editing Interactions
  • About Custom Visualizations

TOPIC D: Adding Static Objects to a Report

  • Inserting Pictures
  • Inserting Text Boxes
  • Inserting Shapes
  • Working with Static Objects

Lesson 4: A Closer Look at Visualizations

TOPIC A: Matrixes, Tables, and Charts

  • Creating a Table
  • Creating a Matrix
  • Overview of Chart Types
  • Creating Charts

TOPIC B: Maps

  • Creating a Treemap
  • Creating a Bubble Map
  • Creating a Filled Map

TOPIC C: Cards, Gauges, and KPIs

  • Creating a Card
  • Creating a Gauge
  • Creating a KPI

TOPIC D: Slicers

  • Creating a Slicer
  • Using Slicers
  • Customizing Slicer Display
  • Changing Slicer Mode
  • Changing Slicer Orientation

Lesson 5: Introduction to the Power BI Web App

TOPIC A: Getting Started

  • Opening the Power BI Web App
  • The Web App Interface
  • Web App Building Blocks
  • Key Differences

TOPIC B: Connecting to Data Sources with the Power BI Web App

  • Connecting to Local Data
  • Connecting to Live Data
  • Connecting to Content Packs
  • Connecting to Samples

TOPIC C: Using Workspaces, Dashboards, and Reports

  • Viewing and Managing Power BI Content
  • Viewing a Workspace
  • Viewing Dashboards and Reports
  • Managing Reports

TOPIC D: Creating Custom Dashboards

  • Creating a Dashboard
  • Pinning Visualizations to a Dashboard
  • Adding Custom Tiles
  • Managing Dashboards

TOPIC E: Power BI Web App Features

  • Using Insights
  • Using Q & A
  • Customizing Q & A Suggestions


MicroSoft Power BI

1 Day

List Price: $265

Date Time Classroom or Online Select Session
01/15/2019 8:30 AM Classroom Add To Cart Add To Cart
01/15/2019 8:30 AM Online Add To Cart Add To Cart
02/08/2019 8:30 AM Classroom Add To Cart Add To Cart
02/08/2019 8:30 AM Online Add To Cart Add To Cart

back to top

Customize Sessions

Need a customized session?


Did you know that all of our sessions can be customized?
Let us help create a private session your team will love!

Selected Sessions

No Sessions Selected

Add a session to begin registration.
  • Personalize This Session

    All of our sessions can be customized to meet your team's specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team's valuable time!

    Let us help customize your next:

    Lunch-n-Learn

    30-90 Minute Webinar

    Half or Full Day Training

    On-Demand Learning

    Team Learning Paths



    Contact us today!



Contact

ETI Performance Improvement
8500 Keystone Crossing Suite 550
Indianapolis, Indiana 46240

p. 317.475.6555
e. [email protected]

Hours:
8:00 am - 5:00 pm M-F EST

Educate. Equip. Empower.
ETI Performance Improvement

© 2018 ETI Performance Improvement        Illustrations ©2012 Nathaniel Charles