Microsoft BI Tools: Power BI for Excel Users Course Outline

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

SPECIAL AFTER-HOURS CLASS
This class is part of our special after-hours series of events that meet after the regular workday, typically on Monday through Thursday evenings. Below is some additional background information on our after-hours classes.

When does the class meet?
To see the class meeting times for your time zone, hover the mouse over the date listed on this outline page and the class times will pop up. Classes typically start at 8 pm Eastern, 7 pm Central, 6 pm Mountain, and 5 pm Pacific. Classes meet from 2 to 3 hours each night, depending on the particular class.

Where does the class meet?
All After-Hours classes must be taken from your home or office. If you want to attend a class from one of our physical training locations, you will need to take the version of this class that meets during the regular weekday. Follow this link to see our weekday class schedule and review the list of over 300 locations available when you enroll.
Microsoft BI Tools: Power BI for Excel Users Weekday Class

Is this the same content as the daytime class?
The instructor will review the most important topics during the live instructor-led session. However, the duration of the evening class is slightly less than the daytime class. To compensate for the reduced hours, we include our ONLC On-Demand content. These are self-study materials that will not only fill in the gaps in your learning, but you will also give you the opportunity to review concepts for 6 months after the class. In addition, should you not be able to attend one of the evening sessions, you will have the On-Demand content to bring you back up to speed. We've got you covered!

What software and hardware is needed?
- You need just a basic computer with an internet connection. The software will be loaded on our servers and you will connect to that computer. (So no software is needed on your computer). Here's a more detailed list:
- At least 1 monitor (Dual monitors or 2 devices would be helpful, but not required.)
- Audio Connection. You can use audio from your computer with a microphone (a standalone microphone, headset, or even a camera that has a microphone.) Most laptops will have a built-in microphone and speaker.Or use your cell phone.

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.

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 Power BI
OneDrive for Business with Excel
Import Power View and Power Pivot to Power BI

Getting Data
Available data sources in Power BI Desktop
Connecting to data sources
Connecting to a database
Connecting to a CSV file

Shaping and Transforming Data
Introduction to the Query Editor
Clean and transform your data with the Query Editor
Cleaning irregularly formatted data

Modeling
Introduction to modeling your data
How to manage your data relationships
Optimizing data models
Introduction to DAX
DAX calculation types
DAX functions
Create calculated columns
Create calculated measures
Create calculated tables
Explore your time-based data

Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
Page layout and formatting
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
Introduction to security, and workspaces
Create workspaces in Power BI
Manually republish and refresh your data
Install and configure a personal gateway
Print and export dashboards and reports
Publish to web
View outline in Word

EPBEX1

Attend hands-on, instructor-led Microsoft BI Tools: Power BI for Excel Users training classes at ONLC's more than 300 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 Courses and select the one that's right for you.