Upcoming In-Person Class Schedule, March-May

Upcoming In-Person Class Schedule, March-May

Upcoming Two-Day Classes in DC, Seattle (Consecutive with MDIS), Philly, and Indy – Plus a 1-Day Precon at PASS BA in San Jose A bit more organized this year… (Today’s post is short and direct, with another “real” post coming on Thursday about Power BI.) We’re going to be announcing our class schedule a bit further in advance this year, and today we’re excited to share that we have dates scheduled through May Washington DC, March 8-9 The full two-day…

Read the Rest
Thanksgiving Sale For Online Course Ends Today (Monday 11/30)

Thanksgiving Sale for Online Course Ends Today (Monday 11/30)

There are two kinds of people in this world (okay, the two that we’re rooting for ) Those who have bought our new “Power Pivot and Power BI” book Those who are about to buy our new book I have good news for both groups. You can buy our Online Video Course during our Thanksgiving Sale. Here’s why it’s a great option for both groups: 1. You have bought our new book The Video Course is a great accompaniment to…

Read the Rest
Gear Up For Black Friday Sale At PowerPivotPro

Gear Up for Black Friday Sale at PowerPivotPro

This Thanksgiving there are many things we are thankful for. This has been our busiest year ever. But we are thankful that we didn't have to work a single day the whole year. If you love your work…it isn't really work, is it? Here is a quote from Rob’s Foreword in the new book, sharing the same sentiment: We live charmed lives – working in data and solving valuable problems is the sort of thing that we “expect” to be…

Read the Rest
GFITW Strikes Again! Another Power Pivot Training Exercise

GFITW Strikes Again! Another Power Pivot Training Exercise

Me and Rob were discussing a chapter from our new book: Chapter 25 - Time Intelligence with Custom Calendars: Greatest Formula in the World (GFITW). (This chapter received a complete overhaul by the way. There are many new/updated chapters in the 2nd Ed book). Chapter 25: Time Intelligence and the Greatest Formula in the World! I was saying that the GFITW pattern had wide applicability, even outside custom calendars, and was arguing that we should encourage our readers to read…

Read the Rest
Free Power BI Webinar On Tue Nov 17

Free Power BI Webinar on Tue Nov 17

Our monthly Power BI webinar is on Tue Nov 17. Go ahead and register now. We’ve been cranking on our PowerPivot book double-time, but I’m glad I’m still able to squeeze in our regular webinar. There is so much I want to share in updates, but I’m afraid that’d have to wait. Here’s what you’d get from the webinar… Newcomers: Should get a good dose of Introduction to Power BI (focused towards the Excel user) Repeat Attendees: We would try…

Read the Rest
(SOLUTION) Real World Exercise Using Power Pivot, Power Query

(SOLUTION) Real World Exercise using Power Pivot, Power Query

The Problem We had presented you with the real world exercise, which you could solve using Power Pivot and Power Query. Click to read that blog post or watch the video below introducing the exercise. We highly recommend, you take a crack at solving this yourself before going on to review our solution.Click to Download Exercise File The Solution Click to Download Solution FileYou can watch the video below which explains the solution or read on… Step 1A: Get Your…

Read the Rest
Power BI Sep 22 Webinar Recording And Signups

Power BI Sep 22 Webinar Recording and Signups

Our next Excel to Power BI free webinar would be on Oct 20th. Click to register. Along with Power BI basics, we’ll cover the relevant Power BI updates and as always there would be ample opportunity for Q&A. Free Webinar Oct 20th Click to watch our Sep 22 webinar or use the links below to jump to a specific topic:- 00:29 Start of Webinar04:32 Demo PowerBI.com - Start04:51 Demo - Get Data07:53 Demo - Create Reports09:11 Demo - Create Dashboards13:49…

Read the Rest