Tag: Data Analysis

Anomaly Detection In Power BI: Options And Limitations

Power BI introduced another feature called Anomaly Detection in its November 2020 update. This feature is only available in line charts for now. Anomaly detection in Power BI enables report creators to enhance line charts by automatically detecting anomalies in a time series data. This feature allows us to easily find insights without slicing and

Continue reading

8th Power BI Challenge Now Wrapped Up – Jira IT Service Desk Analysis

Time flies when you’re having fun, especially if the fun comes from solving a Power BI Challenge! Just like that, we’re done with yet another round, and the submissions were insightful and creative, as always. The 7th round was about purchases, inventory and sales. This time, we challenged our participants to work on a problem

Continue reading

Simple Power BI Transformations For More Optimized Data

I’m going to talk about simple Power BI transformations you can do around the query editor. You may watch the full video of this tutorial at the bottom of this blog. The query editor allows you to clean up your data and transform it from its rawest form. Although it allows you to do some

Continue reading

Converting A YYWWD Code Into A Date Value In Power BI

How To Convert YYWWD Code Into Date Value In Power BI Query Editor Tutorial

In this blog, we will be discussing how to convert a YYWWD code into a Date Value. This tutorial was based on a response to a query of an Enterprise DNA Support Forum member. You may watch the full video of this tutorial at the bottom of this blog. The member asked for a way to

Continue reading

Custom Dynamic Segmentation Using DAX In Power BI

In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. You may watch the full video of this tutorial at the bottom of this blog. Dynamic groups are created

Continue reading