What Is The Main Purpose Of Business Intelligence?
Business intelligence (BI) aims to transform data into actionable insights that facilitate strategic business decisions.
Category: Power Query
What Is An Example Of A Company That Uses Business Intelligence?
Coca-Cola is a prime example of how a global conglomerate leverages business intelligence to streamline its operations and gain a competitive edge
What Does A Business Intelligence Role Do?
A Business Intelligence Analyst plays a pivotal role in transforming data into actionable insights that drive strategic business decisions
What Is A Business Intelligence Consultant?
A business intelligence consultant has a unique blend of analytical and technological expertise combined with an in-depth understanding of business operations.
Business Intelligence Consulting Services
Business intelligence consulting encompasses a range of services designed to help businesses develop, implement, and optimize their data strategies
Now You Can Save Time by Automating Repetitive Tasks
Now You Can Save Time by Automating Repetitive Tasks Manual, repetitive tasks are more than just a necessary evil; they’re a roadblock standing in the way of growth and strategic […]
Solving the Query – Pivot Edition
Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation
Working with Lists in Power Query – Let’s Count Words
Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may not realize it, so if you add some List knowledge to your quiver, you’ll be able to kick your Power Query skills up a notch.
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
Power Query (M)agic: Parameters for Dataflows!
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page.
Automated Testing With Power Query
I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality.