Self Service BI Boot Camp

From: $895.00 for the first year

Prepare to change your company’s reporting game forever! In the Self Service BI Boot Camp, Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI solutions.

This course is a hybrid format of pre-recorded video training and live online Q&A with Ken Puls, for direct help with your questions. Please read the Course Description and Format sections below for more details.

As a special introductory offer, you save $100 off the first year’s price, valid until August 31, 2020. This discount is already reflected in the displayed price.

This is a subscription-based product, please see the SUBSCRIPTION & PRICING DETAILS section below more information.

Specs

SKU: Course_SSBI_BootCamp

Description

We know that data is not usually stored in nicely curated databases and often – even when it is – the data analyst doesn’t have access to it. Instead, we must piece together data provided in text files, Excel files, web pages, and even the body of emails to build the business intelligence solutions we need. Until now this has been a painful process with a great deal of cut and paste effort, and updates have been tedious and error prone. That stops with this workshop!

In the Self Service BI Boot Camp, we’ll dive into:

  • a deep exploration of Power Query for gathering and preparing your data
  • the benefits, concepts, and key terminology of Dimensional Modeling
  • how to create a variety of DAX measures, understand how DAX measures are calculated, and how to control their Filter Context
  • calendar intelligence, including building calendar tables, using the “Golden Date” pattern, and extending our model to report based on our own year-end
  • specific features of Excel and Power BI that every analyst should know, which tool is right for the job, and how they can be used together in one solution

Throughout this workshop, you’ll be working with both Excel and Power BI. Why? Because the tools and concepts you’ll be learning work in both places. So how do you know which one is right for the job? We’ll talk not only about that, but also how they can be used together in one solution. Come and join us to revolutionize your reporting process!

Read the full course description on the main course page.

Product Details

  • Format: On-demand streaming videos and live online Q&A and “Ask Me Anything” sessions with Ken Puls, plus downloadable example files and handouts.
  • Publisher: Skillwave Training (July 2020)
  • Language: English

Course Format

This course is a a hybrid format of pre-recorded video training interspersed with live online Q&A and coaching with Ken Puls, for direct help with your questions. It will run for 3 partial days/week for 2 weeks, plus 3 x 2-hour follow-up “Ask me Anything” sessions. Please see the Course Schedule below for more details.

Total hours: estimated 21 hours video training + 3 hours live Q&A and coaching + 6 hours live “Ask Me Anything” sessions = approximately 30 hours total

All of the live Q&A sessions will be recorded and shared with participants. Thus, you to still learn from the what is discussed, even if you are not able to join Ken live (due to time zone conflicts, other commitments, etc.) or get called away for part of it. This also allows you to watch the videos on your own schedule, and to pause, rewind, and practice more with example files.

The first of the 3 follow-up “Ask Me Anything” sessions will be held 2 weeks after the final training day. This gives you time to put into practice what you learned, applying it to your own data, and then bring your questions and challenges to the AMA’s. These sessions will also be recorded, in case you are not able to join them live or want to refer back to them later.

If you are not able to join us live for the Q&A or AMA’s, you can still email your questions to Ken beforehand and he will answer them in the session. You will then be able to watch the answer later on in the session recording.

SUBSCRIPTION & PRICING DETAILS

The course is on an annual subscription basis, with a list price of $995 USD for the first year and then $199 USD/year after that. You subscription gives you continued access all of the course materials and any future “Ask Me Anything” sessions and recordings that run during your enrollment year (in addition to the AMA’s for your initial course registration).

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 more information about subscription renewals and cancellations.

Course Schedule

Note: Schedule is subject to change. All times listed below are in Pacific Time (please take daylight savings into effect until October 25, 2020). 

DateTimeFormat
Monday, September 21, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Wednesday, September 23, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Friday, September 25, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Monday, September 28, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Wednesday, September 30, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Friday, October 2, 20209:00am – 1:00pm PDTVideo Training + Live Q&A
Wednesday, October 14, 20209:00am – 11:00am PDTFollow-up “Ask Me Anything”
Wednesday, November 18, 20209:00am – 11:00am PSTFollow-up “Ask Me Anything”
Wednesday, December 9, 20209:00am – 11:00am PSTFollow-up “Ask Me Anything”

What you’ll learn

  • A deep exploration of Power Query for gathering and preparing your data
  • Creating dynamic business intelligence models that are refreshable with a single click
  • The benefits, concepts, and key terminology of Dimensional Modeling
  • The difference between Facts, Dimensions, and Relationships
  • Designing and linking their parent tables correctly
  • Creating a variety of DAX measures
  • Controlling the Filter Context
  • Building calendar tables
  • Using the “Golden Date” pattern
  • Adjusting for non-standard year-ends
  • Specific features of Excel and Power BI that every analyst should know
  • Creating a Power BI report using a variety of different visuals for displaying data
  • Publishing a Power BI report and share it with other users
  • Managing Power BI report permissions

What you get with the course

An estimated 21 hours of Video Content (access for 12 months)

9 hours of Live Q&A and "Ask Me Anything" Sessions with Ken Puls

Video recordings of the Q&A and AMA sessions

Premium Content and Expert Instructor Guidance

Downloadable Files and Handouts

Course Certificate of Completion

Frequently Asked Questions

The course videos and Q&A / “Ask Me Anything” recording are streamed on-demand and may be watched as often as you like. However, they are not downloadable. The example files and any other handouts for each lesson are downloadable.

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 ensure that you will be able to see the videos.

You may ask your questions during any of the live online Q&A portions on the training days, or the follow-up “Ask Me Anything” sessions. All of these session will be recorded and shared with registrants.

If you are not able to join us live for the Q&A or AMA sessions, you can still email your questions to Ken beforehand and he will answer them in the session. You will then be able to watch the answer later on in the session recording.

Renewals:
Our system will automatically renew your subscription for another year on your expiry date using the billing information on file. About a month before your current expiry date, you will receive an email from us reminding you that the renewal is coming up and to confirm your billing details.

Cancellations:
You may cancel your subscription at any time, and you will continue to have access to all of the course materials until your expiry date. To cancel your subscription, go to the Subscriptions of the your Account Dashboard and select the subscription to cancel.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.