Fred Kaffenberger

A teacher at heart, Fred loves that moment when someone struggling to solve a problem makes a breakthrough. Fred spent six years in client services and sales for an online work order system. After this, he used Excel to help streamline commercial real estate operations for a major telecommunications carrier, where he discovered Power Pivot and Power BI. He was thrilled at how these tools helped him work smarter and more systematically. As an English major, Fred knows that a knack for working with data can surface in surprising places.

This is a quick tip on automated testing with Power Query. I loved Nar's post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For…

Data Warehouses: What Do I Know? Well, I'm no expert. I learned Power Pivot and Power BI through Excel. What I know is from helping to build a SQL data warehouse. That is, I've worked with a data warehouse pro.…

Today, we'll look at Power BI workspaces, apps, and how to keep changes from mucking up reports. In the software development lifecycle, a distinct space to test new reports ensures consistent results. Moreover, it's part of good governance. This post builds…

What I didn't know about the Power BI Service (PBIS): I've been using the Power BI Service (PBIS) daily for five months, and before that, I consulted on challenging DAX problems for over a year. So, when I attended a…

Use a disconnected table in Power BI to show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance between the two in one matrix table. And conditional formatting!

Today, I'll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles... and yes, I'll throw in a Greatest Formula In the World (GFITW) version, too. In Part One, I used What-if-parameters…

In 2013, Rob showed how to use a disconnected table and slicer to show moving averages with a variable time period. That post built on an earlier post, which steps through the process of creating moving averages. What-If-Parameters, teased at…