Tag: Power BI

How to Use KPI in Power BI – Let us Explain

guide to power bi kpi

Do you need to measure your business progress, your performance, or the distance to a target? In business, having a clear way to measure progress toward goals is vital. Power BI KPI functionality provides visual cues that can help companies hit their goals and stay on track with clarity! Power BI KPIs can give you

Continue reading

Clustering in Power BI and Python: How it Works

In this blog, you will learn how to do clustering in Power BI and Python and discover some of the advantages of using Python for clustering. You can watch the full video of this tutorial at the bottom of this blog. You can cluster data if it’s extensively unstructured and impossible to segregate manually into

Continue reading

Power BI Statistical Analysis Using The “Magic” Dataset Call

Power BI Statistical Analysis Using The Magic Dataset Call - Enterprise DNA

This blog will show you how to do advanced inferential Power BI statistical analysis quickly and easily using what I like to call “Magic” Data Set Call. You can watch the full video of this tutorial at the bottom of this blog. The Magic data set call lets you step out of Power Query into R or

Continue reading

Power Query Filter By a Specific First Letter or Character Tutorial

Power Query Filter By a Specific First Letter or Character Tutorial - Enterprise DNA

This Power Query filter tutorial will demonstrate a couple of approaches to solving Excel BI’s Table Filter Challenge. The goal of this challenge is to filter out names where the 2nd word starts with the letter “C.” This Excel BI challenge is a great opportunity to practice and hone your skills in Power BI. There are also

Continue reading

Adding a Conditional Index Column in Power BI

Adding a Conditional Index Column in Power BI - Enterprise DNA

This blog will demonstrate the best method of adding a conditional index column on Power BI. Using the Power Query, we’ll add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal to 90. You can watch

Continue reading