Category: Excel

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

Power BI Performance Analyzer Queries: An Overview

Power BI Performance Analyzer Queries An Overview - Enterprise DNA

In this tutorial, you’ll learn how the Performance Analyzer works in Power BI. Specifically, this blog will discuss the query generated by the Performance Analyzer tool and how it changes depending on the visuals in your report. Performance Analyzer is a Power BI tool that measures and displays the duration required for loading or refreshing

Continue reading

Power BI Port Number: Connecting Power BI To SSAS, Excel, And C#

Power BI Port Number Connecting Power BI To SSAS, Excel, And C# - Enterprise DNA

In this tutorial, you’ll learn how to use a Power BI port number to connect a data model to SSAS, Excel, or C#. The Power BI desktop runs a local instance of SSAS and then assigns it a random port number. This port number changes every time you close and open a Power BI file.

Continue reading

Chi-Square Test In Excel: Comparing Variables

Chi-Square Test In Excel Comparing Variables - Enterprise DNA

In this post, we’re going to show you how to use the Chi-square test in Excel to compare variables. You can watch the full video of this tutorial at the bottom of this blog. The Chi-square test of independence has two categorical variables. We will find out if there’s any relationship between those variables. We

Continue reading