P3 Adaptive: Actively Removing Bias in Hiring
Women in business and STEM fields often have a shadow hanging over them when applying for a job. Will they only be judged by their gender or will skills matter?
Category: Data Strategy
Can Microsoft escape gravity and beat Moore’s Law?
Have you ever heard of Moore’s Law? Often declared dead, yet refusing to die, Moore’s Law has been predicting the explosive growth of computing power for 70+ years.
Completing the Set Up: Field Parameters Using Tabular Editor
May 2022’s release of Power BI Desktop is the best releases we’ve seen in several years. They released a new gem of a featured called FIELD PARAMETERS and this blog is going to go over the benefits to you as a developer
2022 The Year of the Remote Migration
Recent data from Zip Recruiter suggests that 2022 will be the year for changing jobs. The ongoing, global Covid challenge has shifted much of the workforce from an “in-the-office” mentality to more of a remote “the office is anywhere you are” mindset.
We’re Changing Our Name (and Nothing Else!)
In the Fall of 2009, I created PowerPivotPro.com in order to begin blogging about this new technology called Power Pivot. I’d seen what it could do, and knew it was going to change the world. People needed to know about it! So, the blog was born.
Planning at the speed of COVID: P3 Adaptive and Power On
During “normal” times, you can often get away with guessing that tomorrow will resemble yesterday, and simply following your well-worn business map.
A Brief Treatment of DIVIDE(), RANKX(), and “N/A”
Ya know, we could probably write articles about RANKX for an entire year. There are just SO many subtleties to it, and SO many different ways you might want to rank things. Endless source of blog fodder.
Power BI Brain Candy: Value Above Replacement
In today’s article, I’m aiming to achieve three overlapping goals:
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page.
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
Power Query (aka “Get and Transform” in Excel, aka the “Query Editor” in Power BI Desktop) is a powerful ETL tool, more powerful than you might expect from something native to Excel (also a native part of the free software Power BI Desktop).
Making BI Count
Early in my BI career, I learned that telling friends and family I worked in “Business Intelligence” wasn’t very helpful.
Power Query (M)agic: Super SubVars
The Challenge. I love the idea behind Power Query (M)agic. These posts let Power Query users learn and share best practices (tips & tricks) that solve real problems. Query management comes up a lot.