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.
- 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
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.
Note: Schedule is subject to change. All times listed below are in Pacific Time (please take daylight savings into effect until October 25, 2020).
|Monday, September 21, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Wednesday, September 23, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Friday, September 25, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Monday, September 28, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Wednesday, September 30, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Friday, October 2, 2020||9:00am – 1:00pm PDT||Video Training + Live Q&A|
|Wednesday, October 14, 2020||9:00am – 11:00am PDT||Follow-up “Ask Me Anything”|
|Wednesday, November 18, 2020||9:00am – 11:00am PST||Follow-up “Ask Me Anything”|
|Wednesday, December 9, 2020||9:00am – 11:00am PST||Follow-up “Ask Me Anything”|
What you’ll learn
What you get with the course
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.
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.
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.