DAX – What is Driving my Sales $ Increase?
I LOVE Pivot Tables – they are (in my view) the best aggregation tool available to the data analyst today
Roundtable: Better IT/Biz Relations in the Power BI Era
New Feature: Roundtable. Welcome to an experimental new feature here at P3 Adaptive , where members of the team discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on our Slack channel, and are then lightly edited for publishing on Friday.
Nerds-Turned-Bullies, the Rise of the Brogrammer, and Are Analytics Good for SQL People?
Today I want to go off-topic just a little bit, but in a way that I think is relevant to many of us as professionals. And then bring it home, so to speak, specifically at the intersection of Analytics and Databases.
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.
Two Hours to Change Your Business (Or Job. Or Life.)
Folks, today I want to share a source of personal pride – literally share it, and make sure YOU experience it
Power Query as a File Audit Tool
Today I am sharing how I use Power Query as a file audit tool to support a regular task I complete every week. The objective of this post is to create broader awareness of how great Power Query is to solve different types of problems, and to possibly get you thinking about other problems you have that could be solved with this tool.
Victory at MS Data Summit! Analyze in Excel for Power BI
Recorded a brief demo video of this feature, embedded below. Analyze in Excel is reported to be working for some free accounts but not all (does not work for me). Does work for Paid/Pro accounts. If you use multiple accounts you may need this workaround.
List.Generate(): Create Tables from Thin Air in Power BI with M!
An article that includes a simple tutorial on how to create tables in Power BI with M written by the experts at P3 Adaptive.
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 .
Sort Your Data on Load for Improved Compression
My last 2 blog posts have been about data compression – that theme continues today. In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.
Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?
An article on what is possible with an embedded Power BI dashboard and Google Analytics from the experts at P3 Adaptive .
Restructure Your Data Table for Improved Compression
I was relaxing during my vacation thinking some more about column compression in Power Pivot.
