If you work with data, then you're probably familiar with Microsoft Power BI. It's a powerful...
Tutorials
Finding Discrepancies in Excel – 5 Easy Techniques Explained
When working with large datasets in Microsoft Excel, encountering discrepancies in the data is...
What Is SQL Used For? 7 Top Uses
SQL, or Structured Query Language, has been a fundamental tool in the realm of data management...
What is Self in Python: Real-World Examples
When writing classes in Python, you may often encounter the term 'self.' It is a crucial concept...
3 Easy Ways How to Subtract Dates in Excel
At some point, when working in Excel, you will need to find the number of days between two dates....
What Does a Data Analyst Do on a Daily Basis?
In the digital age, data plays a significant role in helping organizations make informed decisions...
Power BI Pro vs Premium – The Ultimate GuideÂ
Looking to maximize your data insights with Microsoft Power BI? Power BI is a valuable tool for...
Add, Remove, & Rename Columns In R Using dplyr
dplyr is a popular R package for data manipulation, making it easier for users to work with data...
How to Use KPI in Power BI – Let us Explain
Do you need to measure your business progress, your performance, or the distance to a target? In...
Power BI Solutions | The Quick Measures Pro
In today’s blog, we will continue our discussion on Quick Measures Pro. In Part 1, we talked about...
Format String Calculation Groups In Power BI P&L Statements
In this tutorial, you’ll learn how to create and format string calculation groups for Profit and...
How To Get Your Dataset’s Top N In Power BI
In today’s blog, we will walk you through the process of using Quick Measures Pro to create a...
Power BI Excel Integration For P&L Statements
Microsoft Excel is one of the most widely used tools for storing, organizing, and analyzing data....
Power BI Forecasting Model Using Python
Forecasting is an important aspect of data analysis, as it allows businesses to make informed...
Challenges (And Opportunities) In Power BI Deployment
Power BI is a powerful data visualization tool that allows businesses to easily create and share...
Power BI Statistical Analysis Using The “Magic” Dataset Call
This blog will show you how to do advanced inferential Power BI statistical analysis quickly and...
Power BI Planning Using The Priorities Matrix In Analyst Hub
This tutorial will discuss the Priorities Matrix, which is a Power BI planning tool found in the...
How To Create A Lollipop Plot In RStudio
A lollipop plot, also known as a dumbbell plot, is a data visualization technique that combines a...
Build Organizational Data Culture With Power BI
In Power BI, data culture refers to the values, beliefs, and practices that guide how data is...
Save Email Attachment To SharePoint With Power Automate
In today’s blog, you will learn how to automatically save email attachment to SharePoint using...
Power BI Business Applications: Analytics Flywheel For Building Momentum
In Power BI, a flywheel is a self-reinforcing loop made up of a few key initiatives. These...
Using Power Query Group By In A Data Challenge
In this Power Query tutorial, we'll examine a unique and intriguing Power Query Group By Alphabets...
RANKX DAX Function In Power BI: A Comprehensive Overview
RANKX is the most commonly used DAX function for ranking insights in Power BI. It is a simple...
How to Easily Decompose Power BI Time Series Data
This blog will teach you how to break down Power BI time series data into essential components....
Create A Matrix In Power BI Report Builder
In this tutorial, you will learn how to create and format a matrix in Power BI Report Builder. A...
How To Use ECDF Plots In Python And Power BI
This blog will demonstrate how to use a cumulative distribution plot, also known as Empirical...
Power BI Tools For Planning & Deployment
In this tutorial, we’ll go over two valuable resources available at Enterprise DNA. These Power BI...
Create A Gantt Chart In Power BI Report Builder: An Introduction
Gantt charts are a go-to tool for project managers and teams to track timelines and progress in an...
Best Power BI Dashboard Design Tips
Creating effective and visually appealing Power BI reports is essential for communicating data to...
Power Query Transform Column Challenge: Stacked Data to Ordered Table
This blog will examine the Stacked to Ordered Data Challenge from Excel BI, involving the Power...
How To Add A Power BI Emoji
If you want to add a Power BI emoji and make your reports livelier, there are several ways to go...
9 Tips To Improve Clarity In Power BI Reporting
Clarity is essential when communicating our story. This will not only enhance the experience of...
Introducing Power Query Extended Date Table V2
In today’s blog, I will briefly introduce the Extended Date Table 2.0. I first shared the code for...
Create A Gantt Chart In Power BI Report Builder
Power BI is a powerful data visualization tool that allows you to easily create and share...
The CALCULATE DAX Function: Issues & Solutions
In today’s blog, we will explore why you should not use the CALCULATE DAX function to obtain...
Power BI Tips And Tricks For Your Reports
To avoid falling into the trap of creating ineffective reports, I would like to share with you a...
Replace Value For Matching Text In Power Query
If you've ever had a requirement to perform multiple exact text match replacements, there's a good...
Paired Samples T-Test In Excel
In this tutorial, you'll learn how to execute and interpret the paired samples t-test using Excel....
Providing Context In Power BI Reports
Context in Power BI is a huge part of data storytelling because it involves thoughtful planning in...
Text Analysis Using Python: How To Identify Parts Of Speech
In this blog, we will show you how to do text analysis using Python to identify parts of speech in...
Paginated Reports: Sort & Filter A Bar Chart
In this tutorial, you’ll learn how to sort and filter a bar chart in your paginated reports. After...
UNION DAX Function Vs Power Query
In this tutorial, you’ll learn a DAX optimization technique using the UNION function. This...
Power BI Features In The eDNA Showcase
In today’s blog, we will go through the recent reports added to the Enterprise DNA Showcase. These...
How To Create Parameters In Power BI’s Report Builder
In this tutorial, you'll learn how to create parameters in Power BI Report Builder. You'll also...
Power BI Split Column By Delimiters In DAX
In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This...
Power BI Videos: How to Embed in Your Reports
At Enterprise DNA, we have posted a lot of tutorials to create reports using the latest features...
Power BI Paginated Reports: How To Format List
In this tutorial, you’ll learn how to format lists in Power BI Paginated Reports. Specifically,...
Dynamic Header & Footer In Power BI
In this tutorial, you’ll learn how to create a dynamic header and footer in your paginated...
Power BI Rank and Custom Grouping
As data analysts, we are often required to group and rank values from a data set in order to...
MS Flow: How To Upload In SharePoint Via Email
In this blog, we’ll create and analyze an MS Flow that doesn't originate from SharePoint. We'll...
Expression Report Builder: Examples and Guides
This tutorial will feature different examples of how to use the Expression Builder in Report...