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.
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.
Sometimes I forget that it has only been a year at P3 Adaptive . Every new client that I have seems like I‘ve spent months getting to know a business, their projects, and the incredible people that move the needle at an organization.
Hello P3 Adaptive Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe.
As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting, I could not stop using external workbook links
Eight years ago, I lucked into an epiphany: IT-driven BI was going to give way to biz-driven BI (aka “self-service” or “Agile” BI). The new wave of BI tools – led by Power Pivot at the time, which ultimately grew into Power BI – gave business subject matter experts something they’d previously lacked: the ability to execute directly.
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection.
It’s time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI.
P3 Adaptive has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success.
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.
A long time ago a peer in Financial Planning and Analysis said “Financial Planning starts in the home.” I modified the statement to “Data analytics starts in the home.”
As a ‘water cooler’ of sorts for this community, we meet some amazing people. Doug Burke shares with us how easy Power Query makes it to do powerful cleaning with a click of the mouse.
Hello P3 Adaptive Nation, I’m excited to be back and writing a technical post again…it’s been too LONG!