Final Sprint 12 Tasks With a few days left for Sprint 12 of the Power BI project, two lower priority items have been added from
Category: M
Trailing Period M Queries
Trailing History Requirements A common requirement for fact tables and BI queries generally is to retrieve a specific date interval relative to the current date.
Dynamic Customer History Segmentation
The Situation: First Purchase Date Your customer dimension table has a column (attribute if you prefer) for the date of the first purchase for the
Data Source Staging Queries
Parameterized Data Source Queries For Power BI datasets, a recommended data access method is to define parameters specific to the data sources and then develop
Mastering Power BI
Mastering Microsoft Power BI I’ve agreed with Packt Publishing to author a new Power BI book – Mastering Microsoft Power BI. This project will begin
Data Insights Summit
I just registered for the Microsoft Data Insights Summit in June. I’m most interested in the following five topics: Azure Analysis Services Migration of PBIX
Insight Quest 