We’ll be hosting our monthly “Excel to Power BI” Webinar on Aug 18. Short notice, I know. But that means you have no excuse to dally, register today! Invite your colleagues, friends, even your mum.

An article on how to transition from Excel Power Pivot or Power Query to Power BI Desktop from the experts at P3 Adaptive .

In our last webinar the #1 question and confusion seemed to be around Excel versus Power BI Desktop (formerly called Power BI Designer). The thing is, both tools are really part of an ecosystem. And the biggest confusion was around understanding how these tools fit into the overall landscape.

This is Power BI Designer, a New Product from Microsoft, and It’s Relevant to ALL of Us.

By Avi Singh [Twitter] If you want to look for trends based on weekday (Sunday…Saturday) or month-of-the-year seasonality (January…December), Cycle Plots can be a potent visualization tool.

One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So awhile back I made myself a workbook of

Thanks to all, who attended our Power BI Webinar on Jun 2nd. We had 400+ (well, 438 to be precise) attend, what ended up being a 2 hour webinar with all the questions being asked.

Bad Data DOES Lead to Bad Results.  But Good Data Can STILL Lead to Bad Results. Garbage in, Garbage out.  We’re all familiar with this.  If you’re being given junky source data, it’s going to be hard to perform ANY meaningful analysis or reporting on said data until the quality of the inputs is addressed.

Last month I posted a survey of computer performance for Power Pivot and Power BI usage.

Rob made a joke in one of his classes, that “Microsoft gives you the parts to the Porsche”.