LIVE Self Service BI and Data Visualization Bundle (Boston)

Author: Ken Puls

This bundle includes registration for the LIVE, in person, 3-Day Self Service BI Boot Camp with Ken Puls + the LIVE, in person, 1-day Data Visualization in Excel Boot Camp with Jon Peltier in Boston, MA.

Duration:
28h
Tools:
  • Excel
  • Power BI
Skills:
  • Data Preparation
  • Data Modeling
  • DAX Formulas
  • Data Analysis
  • Data Visualization

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, and adjusting for non-standard year-ends
  • Publishing a Power BI report, sharing it with others, and managing permissions
  • 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
  • Understanding chart data and different chart types available in Excel
  • Creating and formatting various types of Excel charts
  • Building dynamic and interactive charts in Excel
  • Using non-chart visualizations such as heat maps, sparklines, and icons
  • Working with small multiples, Pivot Charts, and other data visualization techniques
Course

LIVE Self Service BI and Data Visualization Bundle (Boston)

$2,195(All prices in USD)
  • 28h of training content
  • Support and Discussion
  • Certificate of Completion

Out of stock

LIVE Self Service BI and Data Visualization Bundle (Boston)

$2,195

Out of stock

This is a LIVE, in person training package, delivered in a small group format (20 people maximum) over 4 consecutive days.

Options are available to attend:

  • 3-day Self Service BI Boot Camp with Ken Puls
  • 1-day Data Visualization in Excel Boot Camp with Jon Peltier
  • 4-day bundle that includes registration in BOTH Boot Camps

Self Service BI Boot Camp Description

In the Self Service BI Boot Camp, Microsoft MVP and business intelligence expert Ken Puls will teach you how to use Excel, Power Query, and Power BI together to build robust Self Service BI solutions. 

It begins with a deep exploration of Power Query. Built-in to both Excel and Power BI, Power Query can clean, reshape, and combine your data with ease – no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot, and even un-pivoting data is not only simple, but an investment in the future. With Power Query’s robust feature set at our fingertips, and our data clean and ready to be used, we’re now ready to explore creating dynamic business intelligence models that are refreshable with a single click.

Next, we introduce the benefits, concepts and key terminology of Dimensional Modeling. Based on the Power Pivot Data model, it’s this portion that lays the cornerstone of your reporting solution. You’ll learn the difference between Facts, Dimensions and Relationships, where they live, and how to design and link their parent tables correctly. You’ll also learn some key Power Query recipe patterns for solving two of the most frequent challenges when trying to relate tables together.

While learning to create the proper dimensional model is critical to every solution, the visible magic happens when we talk about DAX in the next section of the workshop. This powerful formula language allows us to report on much more than just the ‘Sum of Sales’. In this workshop, you’ll learn how to create a variety of DAX measures, understand how DAX measures are calculated, and how to control their Filter Context. These are all critical skills for building your own advanced measures for your work.

No course on self-service BI would be complete without discussing calendar intelligence, which is exactly why we cover it. From building calendar tables on the fly to exploring the “Golden Date” pattern, we’ll work through the steps required for extending our model to report based on our own year-end.

Finally, we’ll dive into specific features of Excel and Power BI that every analyst should know. How easy is it to create a Power BI report and use a variety of different visuals for displaying data? How can you publish a Power BI report and share it with other users? How do you manage those permissions? All these questions will be answered!

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!

You can view a full listing  of the topics covered in this course by downloading the Course at a Glance document (PDF download).

Who this course is for?

  • Anyone who needs to build reports based on data.
  • Attendees who are looking for guided hands-on training in a small group setting as they learn a new topic.
  • Experience working with Excel PivotTables is highly encouraged. Experience with Power BI is optional.

Data Visualization in Excel Boot Camp Description

In the Data Visualization in Excel Boot Camp, Microsoft MP and charting expert Jon Peltier will cover both the theory and practice of charting in Microsoft Excel through hands-on learning. It will

start off by diving into charting theory, including such topics as data, chart types, and formatting. The practice portion of the course will cover combination charts, conditional formatting of charts, custom chart types, dynamic charts, and interactive charts, with numerous tricks sprinkled in.

This is an intermediate level course with topics ranging from basic to advanced. Attendees should have good Excel skills including formulas and data management techniques, and at least a passing familiarity with creating charts in Excel and general formatting in Office programs.

Attendees will learn to craft effective charts. They will gain an understanding of what makes efficient chart data, and how to manipulate data and formatting to achieve desired chart styles. Chart types and formatting will be covered – not only the how, but the what and why.

Participants will also learn how to work with the different elements of charts. They’ll be able to leverage worksheet formulas and controls to make dynamic charts that reflect changing data and interactive charts that reflect user selections.

While not focused on dashboard reports, the course will include dashboard-related topics such as small multiples and non-chart visuals.

You can view a full listing  of the topics covered in this course by downloading the Course at a Glance document (PDF download).

Who this course is for?

  • Anyone who needs to create charts and other data visualizations in Excel.
  • Attendees who are looking for guided, hands-on training in a small group setting as they learn a new topic.
  • Attendees should be experienced working in Excel, including formulas and data management techniques. Familiarity with charting an asset but not required. 

Course Schedule

This course is 4 consecutive days of in person, hands-on training with Ken Puls and Jon Peltier in a small group setting (20 people maximum*). There will be time set aside each day for refreshment and lunch breaks. Location: Boston, MA
Dates Time
No future dates scheduled 9:00AM – 4:30pm
*If you are registering for more than 1 person, please see the information on group registrations in the FAQ section at the bottom of this page.

Included with Registration

  • Exclusive access to practical hands-on training in a small group setting (20 people maximum) from Microsoft MVPs Ken Puls and Jon Pelteir
  • A USB with all files for use during the course
  • Catered lunch and 2 refreshment breaks each day
  • Additional learning resources and tools, as noted below

Bonus Gifts

1 year of access to the online version of this course, including access to the Q&A and AMA sessions and our exclusive Discussions Forum.

Both print and digital edition of Ken Puls' book, 'Master Your Data'

1 year subscription to the Power Query Recipes

1 year subscription to the Monkey Tools Excel add-in

Recording of the live Data Visualization in Excel event

1 license to Peltier Tech Charts for Excel 4.0

Software Requirements

You must bring a laptop with both of the following installed:

  • Excel 2016 or higher (Office 365 recommended)
  • Power BI Desktop version 2.119.x (July 2023) or higher

Notes on Software Requirements

  1. Don’t have Excel 2016 or higher? You can sign up for a free one-month trial of Office 365 Business Premium. (Click here to learn more.)
  2. If you are running Excel 2016, please go to Windows Update -> Advanced and make sure you’ve checked the box to receive updates for other products when you update Windows!
  3. If you do not yet have Power BI Desktop installed, we recommend installing it from the Microsoft Store, as it stays up to date. To do this, press your Windows key, type “Store” and open the Microsoft Store App. Search for “Power BI Desktop” and choose to install it.
  4. If you do have Power BI Desktop installed, but you are not automatically receiving updates, you can get the most recent version of Power BI Desktop here.
  5. This course is taught on the Windows platform. Mac versions of Excel are not supported, and Power BI Desktop does not have a Mac version. (Running a Windows instance in a Fusion or Parallels is fine, but we cannot provide support to set this up, as we are not Mac users.)

Refund & Transfer Policy

Please note that if you must cancel your registration, it is refundable for online credit only; no cash refunds are available on this course.

If you cancel your registration on or before [date] you will receive a credit of the original purchase value that may used towards any of the courses or other digital products offered on the Skillwave Training site. Because of the site rental and catering arrangements, no refunds (credit or otherwise) are available for cancellations on or after [date].

If you are not able to attend, you may transfer your registration to another individual. Please contact us through our online contact form for more information if you need to transfer your registration.

Please note that Skillwave is not responsible for any travel or accommodation costs that registrants may incur, including any that may be due to changes or cancellations.

Course Formats

Coached
This LIVE, on-site, in person training is conducted over 4 consecutive days. You will receive hands-on training directly with Ken Puls and Jon Peltier in a small group setting (20 people maximum).

About the author

Ken Puls

Ken Puls

Microsoft MVP, FCPA, FCMA
Ken Puls is one of the founding partners of Skillwave.Training, and the President and Chief Training Officer of Excelguru Consulting Inc. in Canada. He is a Chartered Professional Accountant, blogger, author, and trainer with over 20 years of business and IT experience. His passion lies in exploring tools to turn data into information, and teaching others how to use them. Ken is a Microsoft MVP and a leading expert in Excel, Power Query, and Power BI.

FAQs

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
30h
13 Modules
$350