Power BI

Who should attend

This class is for data analysts and managers who want to find business insights by creating impactful and elegant data visualizations.
Team Pass by Learnit

Power BI

From $0
Two, 2-hour Modules (9am - 11:30am PT)

Are your usual pie charts getting yawns in meetings? Learn Power BI to create elegant and impactful data visualizations, from bubble graphs to heat maps.

Course ID
L0049
Upcoming LIVE ONLINE public classes
No Upcoming public classes
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Interested in a private
workshop for your company?

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Course Outline

Day 1: Prepping Data and Creating Visualizations

Lesson 1: Introducing Power BI 

  • Navigating the Interface
  • Power BI Web Services
  • Building a Report Using Excel Data
  • Publishing and Sharing Power BI Reports

Lesson 2: Shaping and Combining Data

  • Importing from Multiple Data Sources
  • Using Power Query
  • Shaping, Transforming and Combining Data
  • Producing Reports Using your Data Transformations

Day 2: Modeling Data and Publishing Options


Lesson 3: Modeling Data 

  • Establishing Table Relationships
  • Writing DAX (Data Analysis Expressions)
  • Building Custom Calculated Columns
  • Building Custom Data Measures
  • Incorporating your Custom Columns and Measures in Reports 

Lesson 4: Publishing Options

  • Overview of Power BI Web Service Capabilities
  • Building a Web Service Dashboard
  • Sharing your Dashboards
  • Installing and Using the Power BI Mobile App
  • Embedding Reports in Web Pages
  • Publishing Reports to MS SharePoint and MS Teams 

What We'll Explore:

  1. Import well-formed data into Power BI Desktop
  2. Build reports with stunning visuals
  3. Publish a report to the Power BI service on Office 365
  4. Create and edit query steps in Power Query
  5. Learn basic data transformation tools
  6. Combine data from different data sources and tables
  7. Understand the need for table relationships
  8. Discover and build DAX functions that enhance your dataset
  9. Learn to build calculated columns, tables and measures
  10. Create Interactive Power BI Dashboards
  11. Discover the Power BI mobile app
  12. Understand how to embed Power BI reports into other media

Skills covered

No items found.

Power BI

Reviews

Thank you so much for this training. Joe was a great instructor - very knowledgeable and very easy to follow along with. I specifically appreciated how much he related the application of various tools to real world scenarios when we posed questions to him.

Roy P.
Roy P.

Mo was a great instructor! He really listened to the needs of the class and worked hard to answer all questions fully and with great examples.

David W.
David W.

Good foundation for all the main/basic functions. Power BI is less daunting. Better understanding of what it can do and what it's compatible with. Mo did a great job with the pacing and explanation of the course material. He was very helpful in answering specific questions that catered to each of our current professional positions.

Cheryl C.
Cheryl C.