P3 Adaptive
Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper.
For me, whenever I am new to a concept, and I read a statement like the one above, I often say “Well that’s great, but just what does that mean?” I am a big believer in mental models or ways of visualizing the flow of execution.
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).
Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle.
Think back to the year 2012 when Microsoft introduced us to SQL Server Analysis Services Tabular models.
Early in my BI career, I learned that telling friends and family I worked in “Business Intelligence” wasn’t very helpful.
I worked most of my career as an actuary at various insurance companies. Most of the time they had systems that were built before I was born, so I spent a good portion of time getting and transforming (see what I just did?) data into a format ready for analysis.
Hello P3 Adaptive Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots.
What an amazing year 2018 has started out to be! Joining the P3 Adaptive team was an aspiration of mine that started in the Fall of 2013…
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project.
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.