Consolidated Worksheets with Power Query
The more I use Power Query, the more I want to use Power Query – and of course the more I learn.
Category: Power BI
Power BI Designer vs. Excel: What’s Microsoft Up To?
This is Power BI Designer, a New Product from Microsoft, and It’s Relevant to ALL of Us.
Cycle Plots Show You Data Insights using Power Pivot and Power BI
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.
RANKX-apalooza: Within and Across Groups, With Filters, Etc.
One from the Reference Stacks I sometimes find RANKX() a bit perplexing. So awhile back I made myself a workbook of
Power BI Jun 2nd Webinar Recording Available
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.
A New Take on “Data Quality?”
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.
Some Good Power Pivot / Power BI Computers
Last month I posted a survey of computer performance for Power Pivot and Power BI usage.
Power Query Super Charges the Internet
I spent time recently thinking about how Power Query has really opened up the data on the Internet and made it more accessible to us all.
Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine
Intro from Rob: Today I’m interviewing Chris Finlan of Microsoft about MS’s recent acquisition of Datazen, and what this means to us in the Power Pivot and Power BI community.
Free Webinar: How to Build BI Solution Using Power BI
Rob made a joke in one of his classes, that “Microsoft gives you the parts to the Porsche”.
Harness Power Query to Gain Competitive Analysis Insights from LinkedIn
Guest Post by Gil Raviv Intro: Many experts had proclaimed LongForm Journalism was headed towards extinction in the digital age. In fact it has found a new resurgence and a […]
DAX – The Diabolical Genius of “SWITCH TRUE”
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().