List.Generate(): Create Tables From Thin Air In Power BI With M!

List.Generate(): Create Tables from Thin Air in Power BI with M!

Announcement Update: For those who missed out on the webinar Watch the Session Recording for my (Avi Singh) webinar. Click here to watch the session recording of all PASS BA webinars. Download the PowerPoint Slide-Deck, Power BI Desktop (.pbix) file, Excel 2013 file Announcement: Friends, short notice, but in about 2 hours, I (Avi) will be presenting in the free SQLPASS Business Analytics Webinar Marathon, Thu Feb 25 9AM PST. Click to Register. Now back to the regularly scheduled programming…take it away Andrew.…

Read the Rest
Data Modeling For Power Pivot And Power BI

Data Modeling for Power Pivot and Power BI

What if I told you, there was one key skill, that has set me head and shoulders above the Excel crowd when working with Power Pivot and Power BI? Would you be interested in learning that skill? Great, because I was about to teach it to you anyway. Pay It Forward But first a story. I had discovered Power Pivot (code-named Gemini back then), while working in the Microsoft Commerce group. But really came in to my element at my…

Read the Rest
Sort Your Data On Load For Improved Compression

Sort Your Data on Load for Improved Compression

My last 2 blog posts have been about data compression – that theme continues today.  In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.  In January I went a bit deeper and talked about restructuring your data to get better compression.  In the comments section of this last post in January there was a seemingly innocuous comment from Mati Selg at the bottom of the…

Read the Rest
For Real This Time:  Show Barnes & Noble That Power Pivot And Power BI Are Important!

For Real This Time: Show Barnes & Noble that Power Pivot and Power BI are Important!

Sunday, Feb 7th in a Local B&N:  That Silver/Grey Spined Book is Ours! OK, for real, B&N has them now!  (I have seen them myself, as pictured above, and every B&N I’ve called has them). Remember, they accepted our challenge of an experiment:  they will stock our new book for a few weeks and see what kind of “action” it gets.  If it does decent sales, they will keep the book on the shelves (AND start stocking more such books,…

Read the Rest
Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?

Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?

I Bet You Think This is a Picture, Don’t You? Yeah, this is the place in most posts where you will find a picture…  but aha!  It is anything BUT! That’s not a picture, it’s a fully interactive Power BI dashboard embedded into this page! (Click, zoom/pan, hover – try it out) (And check Back EVERY HOUR for the latest stats – it updates automatically!) (If you're looking at this in email and can't see it, try this link instead.)…

Read the Rest
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
MS Roadmap: The Good, The Bad, And The Ugly

MS Roadmap: The Good, the Bad, and the Ugly

Yeah I’m a Bit Slow… Back in October, Microsoft released a roadmap blogpost detailing plans and direction for their BI platform.  I kinda pressed the Snooze bar on paying attention, because hey, I was super busy, plus…  I always tend to take my time with announcements like these.  I do my best “digestion” once the noise has died down, and my best thinking slowly, in quiet. Spoiler: Mostly Positive Words like “Bad” and “Ugly” are overkill, as my reactions are…

Read the Rest
Traditional BI Is (Unintentional) Corporate Sabotage

Traditional BI is (Unintentional) Corporate Sabotage

A CIA Manual for Inaction Perhaps you’ve seen this making the rounds on Facebook:  in the 1940’s, the CIA created a sabotage guide for citizens of France and other occupied countries.  You know, to screw with the Nazis, which is pretty much All Good.  This manual was declassified within the past ten years, and it provides an intriguing glimpse into human nature. The manual contains the sorts of things you’d expect to find:  how to wreck equipment, ruin fuel, disrupt…

Read the Rest