A better way to get results without data
Imagine having a data set and wanting to see zeroes instead of empty cells. Sounds easy? Well, this case has some caveats.- 28164Murphy ≡ DeepGuide
The One Page Data and Analytics Templates
Master Data and Analytics reports and processes with five templates- 25130Murphy ≡ DeepGuide
On using intermediary results in DAX Measures
We use table variables in DAX all the time. What if we must calculate intermediary results and reuse them in a DAX Measure? Let's solve...- 28281Murphy ≡ DeepGuide
Streamlit Tutorial: Creating Word Reports for Data Science Projects
Combining python-docx and Streamlit for Data Science Report Automation- 28132Murphy ≡ DeepGuide
Analyze performance when aggregating data in Power BI and DAX Queries
We aggregate data in Power BI all the time. Here I show you how to write queries in DAX to summarize columns to aggregate data- 26665Murphy ≡ DeepGuide
Uncovering the secrets of KEEPFILTERS in DAX
The KEEPFILTERS() function in DAX is an underestimated function. Let's go into the rabbit hole of this function and discover some secrets- 22747Murphy ≡ DeepGuide
Changing perspective on your data in Power BI
Introduction Imagine a Report page with some Cards, columns, and line charts. On top of the page, you will see four buttons: Actuals YTD (Year-To-Date) YE (Year-End) Last three months Something like this: When you click on the Button YTD, your numbers wil- 29897Murphy ≡ DeepGuide
Combining Actuals and Forecasts in one continuous Line in Power BI
In several businesses, we have the Actual Sales and Forecasts. How can we show both datasets on one line?- 22230Murphy ≡ DeepGuide
Balancing Urgency vs. Sustainability as an Analytics Team
A guide on how to navigate immediate reporting requests to future proof your work most effectively- 24603Murphy ≡ DeepGuide
How to Dynamically Restrict Data Import in Power Query
When we have a large amount of data, we might ask: Do I really need all this data in my reporting? If no, read this piece to learn more.- 29256Murphy ≡ DeepGuide
Going the Next Step with Stock Measures in DAX
Introduction Stock calculations are commonly used when data cannot be aggregated over time. For example, summing up my bank account balance over time would be a bad idea. It would be a good idea for me, but not my bank. Currently, I am working on a client- 27530Murphy ≡ DeepGuide
Converting a Flat Table to a Good Data Model in Power Query
When loading a wide Excel table into Power BI, we end up with a suboptimal Data model. What can we do to create a good Data model?- 22500Murphy ≡ DeepGuide
The Marketing Reporting Gap
Why do marketers turn to spreadsheets and how to close this gap- 24564Murphy ≡ DeepGuide
About Calculating Sales depending on another Value in DAX
Measures aggregate the Values from columns in one Fact table. But what if we need a dependency to another table?- 28748Murphy ≡ DeepGuide
Calculate the percentage of the total with RLS in place in Power BI
With RLS in place, some users can see only some aspects of the data set. But what happens when they must compare the result to the total?- 27855Murphy ≡ DeepGuide
Visualize a business process through data serialization
Sometimes, we want to visualize a business process in Power BI. This is not easy, depending on the visualization needed.- 26560Murphy ≡ DeepGuide
Calculating the previous value in Power BI
Calculating the consumption based on meter data looks easy. However, complex situations can be challenging. Let's see how we can solve...- 22374Murphy ≡ DeepGuide
On Handling Precalculated Hierarchical Data in Power BI
While hierarchies are a familiar concept with data, some sources deliver their data in an unusual format. Let's see a not-so-unusual case.- 29614Murphy ≡ DeepGuide
Using Power BI for Planning (Warehouse) with Stock Values
How can we use Power BI to plan for the future using Stock-Measures? Here, I show you a possible approach.- 27887Murphy ≡ DeepGuide
How to Manipulate the Total in Power BI
In most cases, the total aggregates the detail rows in a visual. But what if the Total should show something different?- 24004Murphy ≡ DeepGuide
1 2
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag