Category: Self-Service Data Tools
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.
Written by Kristi Cantor on September 4, 2018
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.
Written by Kristi Cantor on August 21, 2018
Five years on from my life-changing encounter with PowerPivot, my pilgrimage to the Nirvana of Modern Excel continues with some occasional detours.
Written by Kristi Cantor on August 7, 2018
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell.
Written by Kristi Cantor on August 2, 2018
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).
Written by Kristi Cantor on July 24, 2018
Hello P3 Adaptive Nation! Today’s “post” is 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.
Written by Kristi Cantor on July 20, 2018
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.
Written by Kristi Cantor on June 26, 2018
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
Written by Kristi Cantor on June 21, 2018
Think back to the year 2012 when Microsoft introduced us to SQL Server Analysis Services Tabular models.
Written by Kristi Cantor on June 12, 2018
Let’s start off today’s post with a pop quiz. Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer
Written by Kristi Cantor on June 5, 2018
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.
Written by Kristi Cantor on May 29, 2018
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…
Written by Kristi Cantor on May 8, 2018