Course Details
Course Description:
The Excel BI Tools: Power BI for Excel Users course is a 2-day course that is designed to teach students how to take Excel data and create and publish visualizations using Power BI.
Topics covered in the course include:
- Power BI Introduction
- Using Excel data in Power B
- Power BI Desktop
- Using the Query Editor
- Modeling your data
- Creating Visualizations in Power BI
- Publishing and Sharing Visualizations
Target Student: This course is designed for students who are not IT professionals but want to learn how to create and publish reports with Power BI. Students should have experience creating worksheets in Excel. Experience with Pivot Tables is also ideal, but is not required.
IT professional may want to consider the more in-depth course 20778: Analyzing Data with Power BI
Getting started with Power BI
Introducing Power BI
Using Power BI
A brief look at Power BI Desktop
A brief look at the Power BI service
Power BI and Excel
Using Excel data in Power BI
Uploading Excel data to Power BI
Importing Power View and Power Pivot to Power BI
Getting Data
Overview of Power BI Desktop
Working with Power BI Desktop
Connect to data sources in Power BI Desktop
Additional advanced data sources and transformation
Shaping and Transforming Data
Working with the Query Editor
Cleaning and transforming your data with the Query Editor
Cleaning irregularly formatted data
Modeling
Introduction to data modeling
Managing data relationships
Creating calculated columns
Optimizing data models
Creating calculated measures
Creating calculated tables
Explore your time-based data
Introduction to DAX
DAX calculation types
DAX functions
Visualizations
Using visuals in Power BI
Creating and customizing simple visualizations
Modify colors in charts and visuals
Shapes, text boxes, and images
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
Working with the Power BI service
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Install and configure a personal gateway
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export dashboards and reports
Manually republish and refresh your data
Create groups in Power BI
Use content packs
Update content packs
Publishing to the web
Please check the course description to find prerequisite information.
We offer live-instructor group training classes for your team.
Upskill your team from the comfort of your office or online.
Benefits of Group Training Include:
- Experienced Professional Instructor Trains Your Team
- Content Focused On Your Team's Needs
- Convenient Scheduling and Class Setup
- Significant Per/Student Cost Savings
- Online, On-Site and Blended Options Available
Virtual Live Instructor
Financing Available
Free Repeat
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
We offer private Power BI group training services for organizations looking to upskill their team members with a live-instructor.
Training options include:
Learn more about how Power BI Private Group Training from Business Computer Skills can help your team.
