Free Workshop From Microsoft and P3: Modern Excel Analyst In A Day
Do you have Excel Analysts spending hours wrangling data week after week to provide updated reporting and analytics?
Do you have Excel Analysts spending hours wrangling data week after week to provide updated reporting and analytics?
Hello fellow Americans! It’s the day after the election, and who better to have on than sports and analytics journalist Michael Salfino from FiveThirtyEight, The Athletic, and The Independent. Data and politics and a little sports mixed in for good measure!
Ep 2- Journalist Michael Salfino and the Raw Data crew discuss using data in sports and politics, and the parallels in business.
There are few stories as tortured and twisted as my relationship with Analysis and Reporting. In 2002, as part of the Excel team at Microsoft, I was introduced to the concept of Business Intelligence
Over the years, I’ve written multiple times about how BI spending increases during hard times
This is an April Fools’ joke. OPTIMIZEDAX() doesn’t exist, but we hope the post gives you a laugh nonetheless.
This is one of those things where I spent a lot of time figuring out how to do something non-obvious. And hey, that’s usually a good thing to share! Keeps others from burning needless time, pushes the envelope a bit, inspires “riffs” and improvements on the core idea, etc.
In today’s article, I’m aiming to achieve three overlapping goals:
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
In Power BI, every visual needs a title. Titles not only makes it easier to manage items in the selection pane, but also provide context when exporting data. Without a […]
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
Quick tip for DST Refresh Date function Power BI Service. I’ll put the code up front, and explain it below.