Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started

Power BI Intermediate

HomeHome > CoursesCourses> Microsoft > Power BI Intermediate
Share
Share this course
Facebook Linkedin Twitter

Power BI Intermediate

Chapter name: Lesson name

Power BI Intermediate

Ready to watch the complete course?

Become a member and get unlimited access to the entire software training library of over 8,000 video tutorials

Start Your Membership
Loading the player ...

Contents

  • 1. Introduction
    • Free Course Introduction
      02m 20s
    • Free Setting Up for Success
      08m 18s
  • 2. Importing and Transforming Data in Power Query
    • Free Importing Excel Data Files from a Folder
      04m 21s
    • Free Combining Files and Removing Columns
      04m 33s
    • Free Splitting and Merging Columns
      04m 55s
    • Applying Data Types
      03m 47s
    • Importing Text and CSV Files
      07m 11s
    • Relationships and Lookup Tables
      06m 41s
    • Duplicate vs Reference
      07m 07s
    • Creating a Lookup Table
      03m 28s
    • Creating Index Columns
      03m 43s
    • Merging Queries
      05m 19s
    • Enable/Disable Load and Report Refresh
      03m 22s
    • Advanced Editor
      04m 49s
    • Resolving Data Import Errors
      05m 07s
    • Organizing Queries into Groups
      03m 00s
  • 3. Data Modelling
    • Troubleshooting Relationship Issues
      06m 21s
    • Relationship Types
      05m 28s
    • Cross Filter Direction
      04m 36s
  • 4. DAX - Essential Skills
    • Measures vs Calculated Columns
      10m 56s
    • Creating a Date Table with DAX
      06m 45s
    • Creating Additional Columns
      05m 16s
    • Creating Conditional Columns
      02m 21s
    • Marking Table as a Date Table
      02m 48s
    • Using ROUNDUP to Extract Quarters
      02m 06s
    • Creating Quick Measures
      05m 41s
    • Creating a Key Measures Table
      03m 27s
    • Aggregation Methods
      05m 12s
    • Using SUMX
      05m 47s
  • 5. DAX - CALCULATE Function
    • The CALCULATE Function
      04m 33s
    • Changing Context with FILTER
      03m 37s
    • Using ALL with CALCULATE
      05m 26s
  • 6. Visualizations
    • Visualizations
      08m 37s
    • Tables vs Matrix Tables
      06m 24s
    • Formatting Visualizations - Part 1
      06m 46s
    • Formatting Visualizations - Part 2
      03m 07s
    • Conditional Formatting
      12m 41s
    • Column and Line Charts
      13m 55s
    • Card Visualizations
      05m 51s
    • Map Charts
      09m 41s
    • The Gauge Visualization
      09m 38s
    • Slicers and Filter
      08m 28s
    • Applying Design Elements
      07m 54s
  • 7. The Power BI Service
    • Creating a Shared Workspace in Power BI Service
      04m 51s
    • Inviting Others to a Shared Workspace
      01m 53s
    • Reports vs Dashboards
      01m 58s
    • Pinning Visualizations to the Dashboard
      07m 09s
    • Setting up Scheduled Refreshes
      05m 14s
  • 8. Orders Dashboard Example - Preparation
    • Orders Dashboard Example
      03m 30s
    • Report Requirements
      03m 59s
    • Importing Order Data
      01m 25s
  • 9. Orders Dashboard Example - Transformation
    • Transforming Order Data in Power Query
      01m 55s
    • Creating Lookup Tables
      05m 38s
    • Merging Queries
      05m 36s
    • Creating a Dates Table
      11m 10s
    • Creating DAX Measures
      10m 57s
  • 10. Orders Dashboard Example: Report
    • Adding a Report Title
      09m 50s
    • Report Navigation with Buttons and Bookmarks
      10m 23s
    • Card Visualizations and Filtering
      12m 39s
    • Line Chart: Count of Male vs Female Customers
      07m 13s
    • Stacked Column Chart: Total Revenue by Region
      06m 00s
    • Treemap Chart: Count of Orders by Year/Month
      05m 59s
    • Funnel Chart: Age Distribution
      06m 17s
    • Matrix Table: Count of Customers by Type and Status
      04m 31s
    • Adding Conditional Formatting
      02m 16s
  • 11. Orders Dashboard Example: Dashboard
    • Publishing the Report to the Power BI Service
      03m 15s
    • Pinning Media Tiles to Dashboard
      06m 32s
  • 12. Course Close
    • Course Close
      01m 50s
  • Description
  • Course Resources
  • Shortcode Not working

Power BI Intermediate

  • DURATION: 6.33 hours
  • VIDEOS: 68
  • LEVEL: Intermediate

Power BI is a powerful, interactive business intelligence (BI) solution from Microsoft. It imports data from multiple sources, which you can then transform and analyze with a range of visual tools. Power BI has a user-friendly interface ideal for people with a limited technical background, allowing them to create their own reports and dashboards.

This intermediate Power BI course is designed to build on the material covered in our Power BI beginner-level course, so it is ideally recommended to go through that course first, which will give you a good handle on the basics and familiarity with the interface. If you already have a preliminary understanding of Power BI’s functionality, this intermediate course is right for you.

In this course, we discuss the data files to be used and some Power BI settings to set you up for success in learning. The last part of the course is one big exercise, giving you plenty of practice building reports and dashboards.

This course also includes course files to follow along with the instructor and uses the Power BI Desktop version.

This course uses the Power BI Desktop version. It also includes course files to follow along with the instructor.

The course covers:

  • Importing and transforming data in Power Query
  • Importing Excel, text, and CSV files and combining files
  • Enabling/disabling load and report refresh
  • Resolving data import errors
  • Getting started with data modeling and relationship types
  • Learning measures vs. calculated columns
  • Creating a date table with DAX
  • Creating additional and conditional columns
  • Using the ROUNDUP and SUMX functions
  • Creating quick measures and key measures tables
  • Using the DAX – CALCULATE function
  • Using tables vs. matrix tables
  • Formatting visualizations and applying conditional formatting
  • Building column, line, and map charts
  • Adding gauge and card visualizations
  • Using slicers and filters and apply design elements
  • Creating a shared workspace in the Power BI service
  • Building reports and dashboards
  • Pinning visualizations to the dashboard
  • Setting up scheduled refreshes

Power BI Intermediate

The course comes with course instructor files compressed into .zip format. You will need to download the .zip file to your PC or Mac (the files are not compatible with a mobile device) and unzip it. Once unzipped, all of the course files will reside in one folder.

Click on the below to open Dropbox in a new browser tab, then click on “Download” in the top right-hand corner.

  • Power BI – Beyond the Basics Course Instructor Files

Get immediate access to the entire library!

Annual Membership

$ 197 /per year

This is an annual membership to SimonSezIT.com with access to all online training courses.  You will be charged again when your membership expires. You can cancel at any time.

Sign Up

Monthly Membership

$ 25 /per month

This is a monthly membership to SimonSezIT.com with access to all online training courses. You will be charged each month. You can cancel at any time.

Sign Up

Related courses

Microsoft Access 2021 - Simon Sez IT

Access 2021 Beginners

Data Analytics in Excel - Simon Sez IT

Data Analytics in Excel

Microsoft Project 2021 - Simon Sez IT

Project 2021 Beginners

Project for the Web - Simon Sez IT

Project for the Web

Outlook 2021/365 - Simon Sez IT

Outlook 2021

Microsoft Word 2021 - Simon Sez IT

Word 2021

PowerPoint 2021 Simon Sez IT

PowerPoint 2021

Excel 2021 Advanced - Simon Sez IT

Excel 2021 Advanced

Excel 2021 Intermediate Simon Sez IT

Excel 2021 Intermediate

Excel 2021 Beginners Simon Sez IT

Excel 2021 Beginners

Microsoft Windows 11 Simon Sez IT

Windows 11 (2023 Update)

Pivot Tables for Beginners SSIT

PivotTables for Beginners

What people are saying

"So far all good. Offers clear explanations & demonstrations to help understand which program to purchase along with the initial setup."

PATRICIA JUSTICE

"Clear presentation, easy to follow. I consider accounting a chore, but this course lessens the burden."

MARY MADDOX

"This is terrific...!! I love her pace and clear explanations."

JON CHRISTOPHERSEN

Trusted by

  • Guitar Center
  • Honeywell
  • Charter
  • SIU carbondale
  • College of
  • Clean Harbors
  • Wyle
  • fareva

Start Your Membership

Simon Sez: “Let’s make you a software superstar!”

From Excel to photo editing, experience quality courses that ensure easy learning.

START YOUR MEMBERSHIP
Learn More

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)