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
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
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
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
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
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.