Given the nearly universal application of date and time dimension tables to business intelligence projects it’s generally understood that these tables should be maintained as
Tag: Power Query
Analyze SQL Agent Job History with Power BI
The purpose of this post is to share and describe a Power BI-based solution for analyzing SQL Server Agent job history data. SQL Server Agent
Ten Lessons in Finance (and BI)
Jim Grant, editor of Grant’s Interest Rate Observer and financial news contributor (you may have seen him on CNBC), recently shared 10 of the most
Data Profiling with Power Query
Did you know that you can use Power Query as a data profiling tool? While the great majority of Power Query (M) functions are centered
Boston Code Camp M Query Materials
Earlier today I presented M Query Fundamentals at Boston Code Camp 28. The following zip file contains the supporting PowerPoint slides from this session and
Integrated Product Dimension Query
Remaining Task: Revised Product Query In last week’s blog post, Brett’s top remaining work item for Sprint 12 was to revise the product dimension query.
Insight Quest 