Power BI Beyond the Basics: Power BI Intermediate Online Course

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. Learn the data files to be used and some Power BI settings to set you up for success in learning.

Your 100% online, self-paced Power BI Intermediate Course includes:

-7+ hours of Power BI Training Course designed by industry experts
–Learn at your own pace whenever and wherever you want, even if you work full-time
-In this course, we discuss the data files to be used and some Power BI settings to set you up for success in learning.
-Plus, 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.


"Master of Project Academy allows professionals to advance their training at a schedule that fits their busy life. No set dates, no set number of hours. No need to take time off to accommodate a course schedule in a physical classroom. And with 24 hour assistance, professionals have access to help whenever they need it."

Microsoft Excel Training

Power BI Intermediate Training Course is ideal for you if you’re looking to create beautiful looking charts and graphs that generate business insight and fuels decision making.

See Pricing


68+ Lectures


7+ Hours


Lifetime Access option


30 day money back guarantee!


100% Online & Self-Paced


Course Completion Certificate


  • Enroll in a Microsoft Appreciated Training
  • Learn about the data files to be used and some Power BI settings to set you up for success in learning
  • One big exercise, giving you plenty of practice building reports and dashboardss
  • Downloadable course files to follow along with the instructor and uses the Power BI Desktop version
  • Get prompt answers & support from the instructor within 24 hours!
  • Test yourself with quizzes at the end of the sections
  • Earn 10 PDUs if you are a PMP already

Microsoft Power BI is used by hundreds of millions of people around the world. Students, Accountants, Engineers, Managers, Architects, Doctors and many other professions are using Power BI as a self-service Business Intelligence (BI) solution from Microsoft. Power BI is user friendly and perfect for people with a limited technical or programming background.

This training is most suited for:

  • Data Analysts
  • Students
  • Engineers
  • Project Managers
  • Accountants
  • Anyone using Microsoft Power BI
  • Anyone who wants to learn how to use Power BI

What is Microsoft Power BI?

Power BI is an incredibly powerful, self-service 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.

What is in this Intermediate Microsoft Power BI Training Program?

Microsoft Power BI Intermediate course program includes 12 different sections.

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 uses the Power BI Desktop version. It also includes course files to follow along with the instructor.

In this Microsoft Power BI Intermediate Online Training Course course you will learn...

  • 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.
  • Do I need Microsoft Power BI Program?

    Our Microsoft Power BI Training is 100% online and self-paced. Lectures do not require you to have a MS Power BI on your PC. However, we recommend you to practice what you learned during the Microsoft Power BI Training course. Therefore, we advise you to obtain a MS Power BI license and try to apply what you learn throughout the Power BI course.

    Curriculum


      Section 1: Introduction
    Available in days
    days after you enroll
      Section 2: Importing and Transforming Data in Power Query
    Available in days
    days after you enroll
    • Start
      Combining Files and Removing Columns (4:33)
    • Start
      Importing Excel Data Files from a Folder (4:21)
    • Start
      Splitting and Merging Columns (4:55)
    • Start
      Applying Data Types (3:47)
    • Start
      Importing Text and CSV Files (7:11)
    • Start
      Relationships and Lookup Tables (6:41)
    • Start
      Duplicate vs Reference (7:07)
    • Start
      Creating a Lookup Table (3:28)
    • Start
      Creating Index Columns (3:43)
    • Start
      Merging Queries (5:19)
    • Start
      Enable/Disable Load and Report Refresh (3:22)
    • Start
      Advanced Editor (4:49)
    • Start
      Resolving Data Import Errors (5:07)
    • Start
      Organizing Queries into Groups (3:00)
    • Start
      Quiz
      Section 3: Data Modelling
    Available in days
    days after you enroll
    • Start
      Troubleshooting Relationship Issues (6:21)
    • Start
      Relationship Types (5:28)
    • Start
      Cross Filter Direction (4:36)
    • Start
      Quiz
      Section 4: DAX - Essential Skills
    Available in days
    days after you enroll
    • Start
      Measures vs Calculated Columns (10:56)
    • Start
      Creating a Date Table with DAX (6:45)
    • Start
      Creating Additional Columns (5:16)
    • Start
      Creating Conditional Columns (2:21)
    • Start
      Marking Table as a Date Table (2:48)
    • Start
      Using ROUNDUP to Extract Quarters (2:06)
    • Start
      Creating Quick Measures (5:41)
    • Start
      Creating a Key Measures Table (3:27)
    • Start
      Aggregation Methods (5:12)
    • Start
      Using SUMX (5:47)
    • Start
      Quiz
      Section 5: DAX - CALCULATE Function
    Available in days
    days after you enroll
    • Start
      Changing Context with FILTER (3:37)
    • Start
      The CALCULATE Function (4:33)
    • Start
      Using ALL with CALCULATE (5:26)
    • Start
      Quiz
      Section 6: Visualizations
    Available in days
    days after you enroll
    • Start
      Tables vs Matrix Tables (6:24)
    • Start
      Visualizations (8:37)
    • Start
      Formatting Visualizations - Part 1 (6:46)
    • Start
      Formatting Visualizations - Part 2 (3:07)
    • Start
      Conditional Formatting (12:42)
    • Start
      Column and Line Charts (13:55)
    • Start
      Card Visualizations (5:51)
    • Start
      Map Charts (9:41)
    • Start
      The Gauge Visualization (9:38)
    • Start
      Slicers and Filter (8:28)
    • Start
      Applying Design Elements (7:54)
    • Start
      Quiz
      Section 7: The Power BI Service
    Available in days
    days after you enroll
    • Start
      Inviting Others to a Shared Workspace (1:53)
    • Start
      Creating a Shared Workspace in Power BI Service (4:51)
    • Start
      Reports vs Dashboards (1:59)
    • Start
      Pinning Visualizations to the Dashboard (7:10)
    • Start
      Setting up Scheduled Refreshes (5:14)
    • Start
      Quiz
      Section 8: Orders Dashboard Example - Preparation
    Available in days
    days after you enroll
    • Start
      Report Requirements (3:59)
    • Start
      Orders Dashboard Example (3:30)
    • Start
      Importing Order Data (1:25)
    • Start
      Quiz
      Section 9: Orders Dashboard Example - Transformation
    Available in days
    days after you enroll
    • Start
      Creating Lookup Tables (5:38)
    • Start
      Transforming Order Data in Power Query (1:55)
    • Start
      Merging Queries (5:36)
    • Start
      Creating a Dates Table (11:10)
    • Start
      Creating DAX Measures (10:57)
    • Start
      Quiz
      Section 10: Orders Dashboard Example: Report
    Available in days
    days after you enroll
    • Start
      Adding a Report Title (9:50)
    • Start
      Report Navigation with Buttons and Bookmarks (10:23)
    • Start
      Card Visualizations and Filtering (12:39)
    • Start
      Line Chart: Count of Male vs Female Customers (7:13)
    • Start
      Stacked Column Chart: Total Revenue by Region (6:00)
    • Start
      Treemap Chart: Count of Orders by Year/Month (5:59)
    • Start
      Funnel Chart: Age Distribution (6:18)
    • Start
      Matrix Table: Count of Customers by Type and Status (4:32)
    • Start
      Adding Conditional Formatting (2:16)
    • Start
      Quiz
      Section 11: Orders Dashboard Example: Dashboard
    Available in days
    days after you enroll
    • Start
      Publishing the Report to the Power BI Service (3:15)
    • Start
      Pinning Media Tiles to Dashboard (6:32)
    • Start
      Quiz
      Section 12: Course Close
    Available in days
    days after you enroll
    • Start
      Course Close (1:50)
      Tip #1 - Join LinkedIn Community
    Available in days
    days after you enroll
    • Start
      Join LinkedIn Community & Follow Latest Updates
      How to Submit a PDU Claim (For Retaining PMP Certificate)
    Available in days
    days after you enroll
    • Start
      How to Submit PDUs
      Bonus Lecture - Discount for our paid courses
    Available in days
    days after you enroll
    • Start
      Bonus Lecture - Discount for our paid courses
      Important Notice About Certificate of Completion
    Available in days
    days after you enroll
    • Start
      Important Notice About Certificate of Completion

    Everything you need to train for Microsoft Power BI

    Ready to get serious about learning MS Power BI? Your new data analyst and BI professional career opportunities depend on it.
    Enroll today and give yourself the best chance to create the best in Power BI…
    100% online training, learn at your own pace from wherever you want


    In-person, virtual, and hybrid group training formats are available for this program.

    For group and corporate training solutions, please

    Request a Quote

    Monthly

    $47

    per month

    Benefits of a monthly subscription:

    The faster you complete the course, the less you pay

    Get continuous access to the course - auto-billing means no manual payment hassles.
    Cancel anytime

    Annual

    $97

    1-year duration

    Benefits of an annual subscription:

    Learn at your own pace - take your time to complete the training and fully prepare for the certification exam

    Revisit key lectures and highlights to give yourself the best chance of passing

    Lifetime

    $147

    lifetime access

    Benefits of lifetime course access:

    Pay once, get forever access to course materials and all future updates at no additional cost

    Revisit key lectures and highlights to give yourself the best chance of passing

    30 Day Money Back Guarantee - Our Overall Full Refund Rate is < 1%

    Frequently Asked Questions


    When does the course start and finish?
    Master of Project Academy courses are designed to be flexible and affordable, so you can learn how you choose.

    You can begin the course from the moment you enroll. Get instant access to all the lectures, videos and materials and train for certification at your own pace.

    There’s no deadline to complete the course – you can watch and re­‐watch as many times as you like, giving yourself the best chance at passing your certification exam at the first attempt.
    What if I am unhappy with the course?
    All our courses come with a full 30-­day guarantee for your protection. Our overall refund rate is less than 1% from 300,000+ students who have used our course to train for Microsoft Power BI.

    But if for any reason you decide to cancel, just email [email protected] within 30 days of enrollment, and we’ll refund your payment in full.
    Any further questions?
    We’re happy to answer them! Please visit our FAQ page for more details or email [email protected].
    How long can I access the course for?
    For however long you need it. You can choose from monthly access, one‐year access or lifetime access below. If you select monthly access you will be auto-­billed on the same day each month, and can access the full course at any time until you cancel.

    If you want to take longer to study the course, you can select annual or lifetime access to give yourself more time to watch and re-­‐ watch the lectures. Lifetime access is exactly that – you will never lose access and will receive free course content updates forever.
    Who teaches the course?
    Master of Project Academy instructors has several years of experience in their fields and each has major industry experience including but not limited to IT, banking, telecommunications, consultancy, non-profit organizations, military, energy, and more.

    Read more about Master of Project Academy Instructors.