Microsoft

Power BI for Excel Users PBI-1

  • 3 upcoming dates 2 open for booking
  • $1,195 per seat

Upcoming dates

Dates Where Status Seat Book
Sep 24–25 2026 Live Online 9:00 AM to 4:00 PM PT Confirmed to run $1,195
Nov 2–3 2026 Live Online 9:00 AM to 4:00 PM PT Scheduled $1,195
Dec 7–8 2026 Live Online 9:00 AM to 4:00 PM PT Confirmed to run $1,195

See every class on the schedule

About this class

As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" is a direct result of the popularity and growth of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages.

Creating data-backed visualizations is key for data scientists, or any professional, to explore, analyze, and report insights and trends from data. Microsoft Power BI software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and it enables users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, enabling users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.

What you'll be able to do

  • Analyzing Data and Reporting with Power BI
  • Connecting to Data
  • Cleaning, Transforming, and Loading Data
  • Visualizing Data with Power BI
  • Enhancing Visuals for Data Analysis
  • Customizing and Filtering Reports
  • Sharing Reports and Creating Dashboards in the

Course outline

  1. 01 Module 1Analyzing Data and Reporting with Power BIData Analysis and Visualization for Business IntelligenceInteract with Reports in Power BIModule 2Connecting to DataCreate Data Source ConnectionsConfigure and Manage RelationshipsSave Files in Power BIModule 3Cleaning, Transforming, and Loading DataLoad, Clean, and Shape Data with the Query EditorProfile Data with the Query EditorShape Data with the Query EditorTransform Data with the Query EditorModule 4Visualizing Data with Power BICreate Visualizations with Power BISelect Visualization Types with Power BIModule 5Enhancing Visuals for Data AnalysisCustomize Visuals and PagesIncorporate Tooltips in VisualizationsModule 6Customizing and Filtering ReportsCreate Data HierarchiesFilter ReportsConfigure Slicers for Interactive FilteringModule 7Sharing Reports and Creating Dashboards in thePower BI ServicePublish and Explore Reports in the Power BI ServiceCreate DashboardsAdd Q&A to Dashboards

Download the full outline (PDF)

Before you attend

  • To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel. To meet this prerequisite, you can take any one or more of the following courses: Microsoft Excel Level 1 Microsoft Exce l Power Pivot Data Analysis and Visualization with Microsoft Excel

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More microsoft technical classes

See all