Power BI for the Business Analyst Online (2 Modules)

Author: Matt Allington

You can become a Power BI ninja if you learn getting and transforming your data, reporting with Power BI and learn to write DAX! This online Power BI course is developed by Matt Allington. It will teach you how to use the existing capabilities in Power BI with hands-on experience, and includes bi-weekly (every 2 weeks) live online Q&A calls.

Duration:
8h 30m
Tools:
  • Power BI
Skills:
  • Data Visualization
  • Data Modeling
  • DAX Formulas
  • Data Transformation

What you'll learn?

  • Creating Interactive Power BI Reports: Bookmarks, Buttons, Tool Tips, Drill Through
  • Various Features in Power BI Desktop that facilitate your Report Generation: Cross Filter, Top N, Conditional Formatting, Hierarchies
  • Creating and Publishing to Workspaces in Power BI.com
  • Creating Dashboards in Power BI.com
  • Creating Power BI Workspace Apps to share Production Quality Reports with End Users
  • Introduction to Power Query to Cleanse and Consolidate Data
  • Introduction to DAX (Data Analysis eXpressions), the data modelling language of Power BI
  • Lookup Tables and Data Tables (Dim and Fact)
  • Measures vs Calculated Columns
  • Common DAX Functions: SUM(), DISTINCTCOUNT(), COUNTROWS(), DIVIDE(), IF(), IN { }
  • Filter Propagation
  • The CALCULATE() and ALL() Functions
  • Time Intelligence TOTALYTD(), DATEADD(), SAMEPERIODLASTYEAR()
  • The FILTER() Function
  • DAX Functions: SWITCH() and Field Parameters
  • Disconnected and Multiple Data Tables
  • Next Steps on Your DAX Journey
Course

Power BI for the Business Analyst Online (2 Modules)

$350Renews at $99 per year
(All prices in USD)
  • 8h 30m of training content
  • 18 modules
  • Downloadable files and Handouts
  • Support and Discussion
  • Certificate of Completion

Power BI for the Business Analyst Online (2 Modules)

$350

PLEASE NOTE:

This course has been superseded by an expanded version of Power BI for the Business Analyst Online.

The new version of the course includes all of the videos and materials from this original version of the course course, but also contains 3 additional hours of content on Power Query. In additional, any new or updated content will only be available in this new course.

We highly recommend enrolling in the new versions of Power BI for the Business Analyst Online instead of this course.

Course Description

Power BI for the Business Analyst Online is a structured, online training course that will help you learn reporting with Power BI, getting and transforming your data with Power Query, and writing DAX formulas (DAX is the data modeling language of Power BI).

It is created and delivered by Matt Allington, a world-renowned Power BI and DAX expert and trainer, Microsoft MVP (Power BI) for 6 consecutive years, and author of the best selling book Supercharge Power BI.

Power BI for the Business Analyst Online training comprises of:

  • Self-paced viewing of online videos, practicing following along with the demos and practice exercises.
  • Attending live online Q&A calls (1 hour each) held every 2 weeks at your convenience.
  • Downloading the video recordings of the Q&A calls for your later reference.
  • Extension reading and practicing with Matt’s books (included in this registration).

How it Works

This training a combination of self-paced learning and guided coaching. Upon registration, you will receive access to:

  • Online videos and downloadable course materials
    • The online videos are recorded by Matt Allington, who has the innate ability to make you learn the content with examples, demos, and practice exercises.
  • Bi-weekly (every 2 weeks) live online Q&A calls (1 hour each) with Matt Allington / Jason Cockington.
    • The Q&A calls are recorded, and the recordings are shared with you after each call. You can download these recordings and keep them for your later reference.

This access will be valid initially for one year that you can renew annually at your own discretion.

Who this course is for?

This is an introductory course for all people that want to learn Power BI from the beginning. It is perfect for:

  • Anyone who is new to Power BI and wants to learn it end-to-end.
  • Those who are self-taught and need to learn the important concepts they have missed.
  • Those who prefer guided learning.

Course Coverage

This online course consists of two Modules (Module 1 and Module 3). Expand the sections below for details.

Introduction to Power BI

Building Your First Report

Power BI Visuals

Power BI Formatting Features

Power BI Reporting Capabilities

Creating different types of Reports

Publishing reports to Powerbi.com.

Creating dashboards online.

Creating Group workspaces for collaboration.

Power BI.com Salient Features.

Creating and sharing apps with end users.

Intro to Power Query.

Introduction to data modelling.

Overview of the DAX language (Data Analysis Expressions).

Common functions in the DAX language.

How to write formulas that leverage multiple tables.

CALCULATE – the most important function in DAX.

Advanced concepts including table functions such as ALL, FILTER.

Time Intelligence.

What-if Analysis.

Field Parameters in Power BI

Live Online Q&A Calls

The live online Q&A calls will be held once every two weeks throughout the year (about 20 calls per year).

You can choose to complete the course material any time based on your availability and time preferences, and you can attend any of the scheduled Q&A calls.

You will receive a Zoom meeting invite for the Q&A calls in an upcoming month before the start of that month.

There are 2 Q&A calls that run concurrently (Group 1 and Group 2), designed to cater for most time zones around the world.

  • Group 1: 8:00 AM Australian Eastern Time (Sydney)
  • Group 2: 4:00 PM Australian Eastern Time (Sydney)

You can attend any group (Group 1/ Group 2) that you prefer.

The Q&A calls timings for February 2023 based on certain time zones are given below. If your time zone is not shown below, please convert to your time zone based on the time in Sydney, Australia (AEST).

Note: Please be aware of the multiple time differences due to the beginning and ending of Daylight Savings Time around the world.

Recommended Practice

It is recommended you view the videos, complete the practice exercises, and then prepare any questions you have prior to the Q&A call. You can email your questions along with any workbooks used and those questions will be taken up during the Q&A call.

One of the benefits of this style of learning is you can listen to and learn from all the discussion and questions from other participants.

DAX Books

SCPBI 3rd Edition
Cover of Supercharge Excel

Your registration includes digital copies of Matt Allington’s books, Supercharge Power BI and Supercharge Excel.

You can choose to use either book for your DAX learning. DAX skills are transferable between Power BI Desktop and Excel Power Pivot, with the difference being UI.

Power BI Desktop is more advanced than Excel in that it might include new DAX functions before Excel. But the DAX concepts remain the same.

The books will help you with more illustrations and practice exercises with DAX.

Note:

Power BI for the Business Analyst Online is built on an annual subscription formatRead more about this in the Frequently Asked Questions section below.

Bonus Gifts with this Course

Downloadable video recordings of the live online Q&A calls.

Access to all the scheduled Q&A calls as long as you are subscribed.

Course Update Log

First release of the course on Skillwave site. Registration opens for Semester 1, 2022 (commencing in the week of 31st January).

Release of Student Guide that can be used as a handy reference of the concepts/features covered in the course.

New lesson Field Parameters in Power BI is added to the topic Building DAX Language. Field Parameters is released as a preview feature in May 2022.

The Semester duration increased from 3 weeks to 5 weeks. The online live Q&A calls are scheduled once a week instead of twice a week based on the participants feedback.

This version of the course superseded by expanded version of Power BI for the Business Analyst Online, which contains 3 modules. We recommend enrolling in the new version of the course instead.

Course Formats

On-Demand
This is an online course developed and delivered by Matt Allington. You can view the pre-recorded videos at your own pace and practice the exercises following the demos. The course comes with all required sample files, practice workbooks, and digital copies of Matt Allington's books, 'Supercharge Power BI' and 'Supercharge Excel'.
Coached
The course includes live online Q&A calls with Matt Allington or Jason Cockington. The Q&A calls are held 2 different times to suit most of the time zones. During the Q&A calls, you can ask questions and ask for help for your business problems. You can attend the Q&A calls scheduled every 2 weeks as long as your subscription is active.

Course Content

Expand All
Module Content
0% Complete 0/1 Steps

How does the subscription work?

This course is built on an annual subscription format. Your registration comes with 12 months of access to the course materials, so you can refer back to the videos and example files whenever you like. Your subscription also gives you access to our private Discussion Forum, where you can ask questions related to the course materials, as well as how to apply those teachings to your own work. This forum is an invaluable resource that also allows students to practice their own learnings by helping others with those questions.

On your annual renewal date, your subscription will be automatically renewed with the credit card information on file, unless you cancel your subscription beforehand. You will be emailed a renewal reminder about one month before the renewal date. Please see the FAQs below for information about subscription renewals and cancellations.

About the author

Matt Allington

Matt Allington

Matt Allington is one of the founding partners of Skillwave.Training, and the founder of Excelerator BI in Australia. He is an expert in Power BI and DAX training, and has 30+ years of experience in using data to deliver business value. Matt is an author, blogger, and eight-time Microsoft MVP that specializes in Power BI, Power Pivot, and Power Query. He brings his business and IT experience to solve general business data problems quickly and efficiently.

FAQs

I’m a beginner, is this course suitable to me?

Yes, this is a beginner’s course and doesn’t require any reporting or programming knowledge. You will learn from scratch how to build reports, share them and model your data to extract business insights. In this course the concepts are explained and demonstrated with live examples that you can practice using the given training files and follow along.

Why is this course a subscription?

One of the key features of this course is that you get access to the online videos and live online Q&A calls with a Power BI expert. Subscribers of this course can attend any of the Q&A calls scheduled every 2 weeks during their subscription year. At the end of the first 12 months you can continue to subscribe and keep these benefits, or you can cancel your subscription and end your participation at that time. You will receive an email about 4 weeks before your subscription is renewed so that you can choose to opt out if you want to.

Will I get videos of the Q&A calls?

Yes, you will. Each Q&A call is recorded and the link to download the video will be sent to the registrants. You can download a copy of the video file and store it for your reference.

If I can’t attend a Q&A call, can I still ask questions?

Yes, you can. You can email your questions in advance. The trainer will answer the specific Q&A questions during the live online Q&A calls and you can watch the answers on the video recording that you recieve in your own time.

If I get distracted, can I come back and do it later?

Definitely. This is a subscription based course, and gives you access to the online videos and the live online Q&A calls that are scheduled during your subscription period. You can do self-paced learning and attend the Q&A calls as per your convenience. You can renew your subscription to continue to have these benefits.

Is there a specific time to join the course?

No. You can register to the course any time and you will get immediate access to the online videos and also meeting invite to attend the next scheduled Q&A calls. Your subscription validity is recorded from the time of your registration.

How do I access the course materials? Are they downloadable?

The pre-recorded videos are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and handouts for the course are downloadable.

Where are the pre-recorded course videos hosted?

All the videos for the course are hosted on Vimeo. Please note that some networks block access to Vimeo, in which case the videos will not be watchable. You may want to double-check that your network allows access to Vimeo before registering to the course, to ensure that you will be able to see the videos.

How do I receive my Certificate of Completion?

After all the modules and lessons have been completed, you will be able to download the Certificate of Completion from the My Courses area of your Account Dashboard.

Aside from the Q&A calls, what support is included with the course? How do I ask questions?

All users with a current course subscription receive access to our private Discussion Forum, where they can ask questions related to the course materials, as well as how to apply those teachings to their own work. This forum is also intended to act as a place for students to practice their own learnings by helping others with those questions. While the focus of this forum is primarily aimed at allowing students to learn by helping each other, they are monitored by our course authors as well. For technical issues related to the site, course access, or other questions regarding your account, please get in touch through our Contact Us page.

How do I renew my subscription?

If you subscription is set to auto-renew, our system will automatically renew your subscription for another year on your renewal date using the billing information on file. If you subscription is set to manual renewal, our system will generate a manual invoice and email it to you on the renewal date. About a month (4 weeks) before your next renewal date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details so your access is uninterrupted.

How do I cancel my subscription?

You may cancel your subscription at any time, and you will continue to have access to all of your course materials until your expiry date. To cancel your subscription, go to the Billing page from your Account Dashboard and select the subscription to cancel from the My Subscriptions area. Once in the Subscription Details page, you can then choose to cancel your subscription from the Actions field. After your subscription expires, you will not longer have access to the course materials, including the downloadable 'Supercharge Power BI' and 'Supercharge Excel' books.

What payment methods do you accept? What currency is used?

We accept credit card payments through our secure online payment portal, Stripe. If you would like to discuss other payment options, please get in touch through our Contact Us page. All transactions are charged in US Dollars. Please note that because Skillwave is registered in Canada, we are required by Canada Revenue Agency to collect the 5% Goods & Services Tax (GST) on registrations made by Canadians.

What is your refund policy for this course?

We think you will love our training. However, we recognize that sometimes a course is not right for where you are in your learning journey. Provided that you have completed less than 10% of the course and it is within 14 days of the purchase date, we will un-enroll you from the course and either issue a credit note equal to your original purchase value which you can use to register in a more suitable course in the Skillwave course catalogue, OR defer your course enrollment data until you’ve had time to upskill to an appropriate level. Please see our full refund policy at https://skillwave.training/terms/

Can an account be shared with or transferred to another user?

Login credentials, downloads, and other course materials are for the exclusive use of the registered user only. Sharing of credentials is in violation of our site policies and may result in termination of product and/or site access without notice.

Recommended Courses

Continue your learning journey with our other training offerings. We’ll help you take your skills to the next level.

  • Power BI
  • Power Query
  • PowerBI.com
10h 30m
6 Modules
  • Excel
  • Power BI
2h 30m
4 Modules
FREE