Power BI used for Surfing FUN!
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.”
Search Results for: best pract
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Power Query (M)agic: Consecutive Days (Part 2)
Two weeks ago I wrote a blog post about how to create a set of data with Consecutive Days using SQL or Power Query.
Data-Driven Success: Recipes for Business Leaders
My new seminar’s mission is to provide business leaders with easy-to-follow recipes for data-driven success
Power Query (M)agic Part 3: Divide & Conquer
Welcome back P3 Adaptive Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting!
Power BI Feature Spotlight: Report Drill Through
Every month Power BI gets an update that adds a nice handful of new features. Here at P3 Adaptive we ALL get excited for new Power BI features!
Why Excel’s Power Query Refresh Speeds Suck
Ever noticed that Power Query refresh is slower in Excel than Power BI? Ken Puls, PQ Expert, explains the problem and what you can do to fix it!
Power BI Q&A: Four Tips to Get All Your Questions Answered!
In today’s fast-paced digital world, information is power, especially when it comes to mastering the intricacies of software development and deployment
Designing for Usability in Power Pivot and Power BI
An article on improving the usability in Power Pivot and Power BI as well as where the current program is at now and how to improve key flaws.
Data Modeling for Power Pivot and Power BI
An article on Data Modeling for Power Pivot and Power BI as well as a brief explanation about what we do written by the experts at P3 Adaptive .
Two Tricks to Make Your Cube Formula Scorecards Drama-Free!
Guest Post by Andrew Todd Cube Formulas: Ultimate flexibility for your reports but lots of drama to update… A while back, I was tasked with finding a way to automate […]
DAX – Trended Moving Averages
I’ve always been a firm believer that moving averages probably give a better insight into trends within a business than a simple trend line associated to a set of values such as monthly sales