Tag: Power BI

Replace Value For Matching Text In Power Query

Replace Value For Matching Text In Power Query - Enterprise DNA

If you’ve ever had a requirement to perform multiple exact text match replacements, there’s a good chance you’ve performed a series of replace value steps. But as always, there are multiple and easier ways to achieve the same result. You can watch the full video of this tutorial at the bottom of this blog. In

Continue reading

Paired Samples T-Test In Excel

Paired Samples T-Test In Excel - Enterprise DNA

In this tutorial, you’ll learn how to execute and interpret the paired samples t-test using Excel. You can watch the full video of this tutorial at the bottom of this blog. The paired sample t-test is going to check for a difference in the means of observations. So, we’re dealing with quantitative data between one

Continue reading

Providing Context In Power BI Reports

Providing Context In Power BI Reports - Enterprise DNA

Context in Power BI is a huge part of data storytelling because it involves thoughtful planning in order to present your story in a clearer manner. In one of my tutorials, we learned several tips and tricks that can be implemented easily inside your Power BI reports. Today, we will discuss the best practices around

Continue reading

Linear Regression In Python

Linear Regression In Python - Enterprise DNA

In data analysis, key influencers are variables that have a significant impact on a dependent variable. In other words, they are the factors that contribute the most to the outcome of interest. In Python, linear regression is used to identify key influencers in a dataset, and to measure the strength and direction of the relationship

Continue reading

Tabular Form In Power BI

Tabular Form In Power BI - Enterprise DNA

Today, you will learn how to calculate the ranking in a tabular form when fields from different dimension tables are brought together inside the table visual. You can watch the full video of this tutorial at the bottom of this blog. Let’s jump onto the Power BI to kick it off.  In this scenario, we

Continue reading