Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Power BI Intermediate: Beyond the Basics

Share

Summary

If you’ve mastered the basics of Power BI but want to take your skills to the next level, join us for a 90-minute workshop. We’ll provide step by step guidance for using the Power BI Query Editor to clean and transform your raw data, so that it can be used to quickly generate reports. This program will also cover how to use the Power BI formula language (DAX) to create calculations that can be used in your reports, and MUCH more.

Gain must-have skills and join us for this hands-on training to discover:

  • Techniques for transforming raw data to make it “report ready”
  • How to create calculations using the Power BI formula language
  • Expert methods for generating an array of more advanced visuals
  • & MUCH more

Program Highlights

Advanced Techniques for Cleaning & Transforming Your Data

  • Simple solutions for quickly cleaning up and restructuring less-than ideal data
  • Best practices for creating executive level dashboards suitable for publication
  • Expert methods for merging and appending data from multiple datasets

Power BI Formula Language

  • Understand the difference between M and DAX
  • Ways to use DAX functions such as LOOKUPVALUE and IF
  • Create additional columns in your datasets using M and DAX

Summarize Data & Display the Right Level of Granularity

  • Learn when to use Calculated Column vs. when to use Measures
  • Techniques for implementing functions such as SUMX and AVERAGEX
  • Why learning how to use the CALCULATE function is a must!

About The Speaker

Mike Thomas is a Fellow of The Learning and Performance Institute and has worked with plus for a large number of global organizations.

  • Mike also designs and develops Microsoft Office-based solutions that automate key business processes.
  • Mike will show you how to let Excel and other Microsoft programs solve your problems for you!

Program Benefits

Join us for a 90-minute workshop and take your Power BI skills to the next level, in order to extract business intelligence for enhanced decision making. You’ll learn how to clean up your raw data to make it “report ready”, create calculations using the Power BI formula language, and much more!

Purchase this On-Demand Workshop

Power BI Intermediate: Beyond the Basics

On-Demand $199 + applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 + applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 + applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.

Purchase This On-Demand Webinar

Power BI Intermediate: Beyond the Basics

On-Demand $199 + applicable taxes
3 Workshop Bundle $300 + applicable taxes
One-year subscription (All Access Membership) $699 + applicable taxes
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

Full-Team Pass

Simply share the invite link with your team so you can learn and grow together!

Yours Forever

The event recording and materials are yours to rewatch and share as you choose.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.