Power BI Introduction for Excel Users

Power BI is one of our most popular class series and these classes can fill weeks ahead.

2 DaysLive Online & In-CenterInstructor-led since 1983Course Code: BPBEX1

Course overview

Power BI is one of our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible. View More Dates

Power BI is one of our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible. Class Format Fully interactive live, hands-on training presented and supported by a professional online instructor. Attend from ` your own location

or any ONLC center

. Class Times Based on local time zone... 10:00a - 4:45p (ET) | 9:00a - 3:45p (CT) | 8:00a - 2:45p (MT) | 7:00a - 1:45p (PT) Power BI for Excel Users Course 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.

Who this is for

The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI. Power BI for Excel Users Course Prerequisites Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but it is not required. Can't Get Time Off to Attend Live Training? Check out our self-study, self-paced course ` Microsoft On-Demand: Power BI for Excel Users

. This format lets you learn at your own pace and on your own schedule. ** NOTE: More In-Depth Microsoft Official IT Course Available ** While Power BI Introduction for Excel Users is designed for average end users needing to learn essential Power BI skills, we have a more in-depth course, ` PL-300: Power BI Data Analyst

. Course PL-300 is for IT professionals and power users who want a deeper dive into the material and/or who are preparing for Exam PL-300 to earn Microsoft Certification: Power BI Data Analyst Associate. .overview-items { margin: 20px 0; padding: 20px; background: #ededed; border-radius: 12px; display: grid; grid-template-columns: 1fr 1px 1fr 1px 1fr; align-items: center; width: max-content; gap: 16px; @media (max-width: 767px) { grid-template-columns: 1fr; } .overview-item-separator { height: 100%; background: #616161; @media (max-width: 767px) { width: 100%; height: 1px; } } .overview-item { display: flex; flex-direction: column; gap: 6px; span{ color: #254972; font-size: 13px; line-height: 13px; font-weight: 700; } strong{ color: #254972; font-size: 24px; line-height: 24px; font-weight: 700; display: flex; align-items: center; gap: 4px; svg{ width: 24px; height: 24px; } } } } Number of learners451,019 Courses Taken62,523 Average course rating4.25

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

Download outline as PDF →

$795

Live Online & In-Center