Category Archives: Business Intelligence

It’s Just a Matter of Time: Power BI Date & Time Dimension Toolkit

Ever had report usage data and needed to figure out which day of the week is quietest so you can do maintenance? Want to visualize spikes in sales activity based on hour ranges within the day? Need a date or time dimension for a proof of concept in Power Pivot before you bother to spin up a real data warehouse? You’ve come to the right place!

Many excellent BI bloggers have covered creating a basic date dimension using Power Query. Indeed, I learned a great deal from Chris Webb and Matt Masson as I was creating my own date & time dimension toolkit. What I’d like to cover in this admittedly long post is how to create Power Query functions that you can spin up and configure quickly in Power Pivot. These functions build in the fields you need for both the attributes you display and the hidden fields you use to make those display nicely.

Continue reading

PASS Summit 2012: Encourage, Energize, Empower Part 1

Part 1: Encourage

I’ve stolen the title of this series of posts from the motto on the swag for the Women in Technology Luncheon from PASS Summit 2012, as I think it perfectly summarizes my experience at this conference. It was my second PASS Summit (first was in 2010), and I was thrilled to be able to attend again this year. Thanks to the PASS Chapter Leader scholarship and to Trek Bicycle Corporation for sponsoring my attendance!

Continue reading