Welcome to ONLC Training Centers

Microsoft On-Demand: Power BI for Excel Users Course

Price:$495

Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.


Microsoft On-Demand: Power BI for Excel Users Course

 

*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***

(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.

Overview

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.

Audience profile

The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI**

Prerequisites

Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required.

What You Need to Take this Training

A Windows machine with Excel installed and a high-speed internet connection.

Looking for a Live, Instructor-led Class Instead?

If self-study training is not right for you, we have this same course in a live, instructor-led format. For instructor-led training click the below link:
Power BI Introduction for Excel Users

**Note**

While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 3-day course titled PL-300: Power BI Data Analyst. It is for IT professionals and power users who want a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. For details, visit:
Instructor-led: PL-300: Power BI Data Analyst

Duration

You have 24/7 access for 180-days to this digital course that includes 5h 16m of video presentation. As a traditional course it would be a 2-day class.

Course Outline

Getting started

  • Introducing Power BI
  • A quick look at Power BI Desktop
  • A quick look at the Power BI service

Power BI and Excel

  • Introduction to using Excel data in Power BI
  • Upload Excel data to the Power BI service
  • Using Excel as a Data Source
  • Import Power View and Power Pivot to Power BI

Getting Data

  • Data Sources in Power BI Desktop
  • Connect to data sources in Power BI Desktop
  • More advanced data sources and transformation
  • Connect to SQL Server in Power BI Desktop
  • Connect to CSV files in Power BI Desktop

Shaping and Transforming Data

  • Introduction to the Query Editor
  • Clean and transform your data with the Query Editor
  • Cleaning irregularly formatted data

Modeling Data

  • Introduction to modeling your data
  • How to manage your data relationships
  • Optimizing data models
  • Introduction to DAX
  • DAX functions
  • Calculated columns in DAX
  • Calculated measures in DAX
  • Create calculated tables

Visualizations

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Combination Charts
  • Modify colors in charts and visuals
  • Text boxes, shapes, and smart narratives
  • Page layout and formatting
  • Group interactions among visualizations
  • Visual hierarchies and drill-down
  • Using custom visualizations
  • R integration in Power BI Desktop

Publishing and Sharing

  • Introduction to the Power BI service
  • Publish Power BI Desktop Reports
  • Create and configure a dashboard
  • Share dashboards with your organization
  • Quick insights in Power BI
  • Ask questions of your data with natural language
  • Create custom Q&A suggestions
  • Create workspaces in Power BI
  • Manually republish and refresh your data
  • Install and configure a personal gateway
  • Export dashboards and reports to PDF
  • Printing from the Power BI Service
  • Publish to web from Power BI

 

View outline in Word

GPBEX1

Attend hands-on, instructor-led Microsoft On-Demand: Power BI for Excel Users training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Power BI Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com