Excel BI Tools: Power BI for Excel Users is unfortunately unavailable

Thankfully we have 22 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel BI Tools: Power BI for Excel Users

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$795
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

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 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.

*** NOTE: This class also available in as a Microsoft Official Course ***

While this course is designed for average end users needing to learn essential Power BI skills, there is also a more in-depth version of this class. The 3-day Analyzing Data with Power BI (20778) course is for IT professionals and power users wanting a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. Microsoft Software Assurance Vouchers can also be accepted as payment for the official course. For more details on the course, go to
20778: Analyzing Data with Power BI

Course Outline:

Getting started
  • Introducing Power BI
  • Using 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
  • Import Power View and Power Pivot to Power BI
Getting Data
  • Overview of Power BI Desktop
  • Getting started with Power BI Desktop
  • Connect to data sources in Power BI Desktop
  • More advanced data sources and transformation
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
  • Create calculated columns
  • Optimizing data models
  • Create calculated measures
  • Create calculated tables
  • Explore your time-based data
  • Introduction to DAX
  • DAX calculation types
  • DAX functions
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
  • 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
  • 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
  • Publish to web

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 7950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

22 Top Choices

Introduction to Excel - Learn Basics

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Monday Oct 21st, 9:15am - 1pm

$184.98

Mastering Excel - Intermediate

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Monday Oct 21st, 1:30pm - 4:30pm

$184.99

Excel Introduction

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Wednesday Oct 23rd, 9am - 4pm

Excel 2007/2010/2013 Advanced

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Friday Oct 25th, 9am - 4pm

Mastering Excel – Advanced

at Chicago Computer Classes - The Loop 200 W Madison St Ste 2100, Chicago, Illinois 60606

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Monday Oct 28th, 9am - 12:30pm

$299.99

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors....

Thursday Nov 14th, 9am - 4:30pm

Excel 2007/2010/2013 Intermediate

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...

Thursday Oct 24th, 9am - 4pm

Microsoft Excel

at Discovery Center - Irving Park 4318 N Elston Ave 2nd Fl, Chicago, Illinois 60641

You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...

Saturday Nov 2nd, 10am - 5pm

Excel Data Analysis with PivotTables

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to: Prepare data for PivotTable reporting and create PivotTables from various data sources; Analyze Data Using PivotTables; Work with PivotCharts. This course is taught with the Office 2013 version software....

Monday Nov 4th, 9am - 1pm

Excel Level 2

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Friday Nov 8th, 9am - 4pm

Excel Level 1

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

Thursday Nov 7th, 9am - 4pm

Microsoft Excel Level 1

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course is ideal for people new to Excel who need to produce reports, budgets, lists...

Monday Nov 11th, 9am - 4:30pm

Microsoft Excel Level 2

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite:  You should have completed...

Tuesday Nov 12th, 9am - 4:30pm

Excel at Excel: Getting Down to the Basics

at General Assembly - Near North Side 444 N Wabash Ave 5th Fl, Illinois City, Illinois 60611

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a “power” user. We’ll start with the absolute...

Tuesday Nov 12th, 6pm - 8pm

Microsoft Excel Level 3

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Wednesday Nov 13th, 9am - 4:30pm

Excel Level 3

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about:  Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...

Wednesday Nov 13th, 9am - 4pm

Excel Dashboards

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course builds upon the foundational knowledge presented in the Excel Basic/Level 1 courses and will help start you down the road to creating advanced workbooks and worksheets that you can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...

Thursday Nov 14th, 9am - 4pm

VBA Excel - Introduction to Macros & VBA

at Chicago Computer Classes - River North 190 S La Salle St, Chicago, Illinois 60603

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

Monday Oct 21st, 1pm - 4pm

$299.99

Excel VBA (Visual Basic for Applications)

at Computer Training Source, Inc. - Schaumburg 1821 Walden Office Sq Ste 400, Schaumburg, Illinois 60173

Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Friday Nov 22nd, 9am - 4pm

Excel VBA Programming

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This 3-day Excel VBA Programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more! Excel...

Monday Nov 25th, 9am - 4pm

  (3 sessions)
$995

3 sessions