Ehsan Adl
Ehsan holds a master’s degree in business management with a specialization in Marketing and has over four years of experience in data analysis. He is always looking for ways to help businesses grow and gain a better understanding of their situations to make timely, well-informed decisions.
Ehsan has a keen eye for identifying areas of improvement within organizations and continually thinks about how processes can be made more efficient. He thrives on tackling challenges and solving problems, believing that data can be leveraged to provide organisations with a transparent source of the truth, and that businesses should aim to make data-driven decisions to produce the best outcomes.
Measures Vs. Calculated Columns In Power BI
In Power BI, understanding when to use a measure and when to create a new column can impact performance, flexibility, and how data is displayed. Here’s a detail of the differences, with their advantages, disadvantages, and guidance on usage. Definition and...
How to Publish Your Power BI Dashboard into Novypro
If you want to know how to publish your Power BI dashboard into Novypro.com follow me:) 1. First, you need to Publish your report (dashboard) in the Power BI service. So, click on the Publish logo and then Publish it into your workspace. 2. Then, you can see the...
How to Create Dynamic Titles In Power BI
Hello everyone, If you want to create a dynamic title Power BI, follow these steps: Using Sample Superstore dataset, 1. Create a measure and give it a name for example "Dynamic Title": Dynamic Title = SELECTEDVALUE(Orders[Sub-Category],"All Sub-Categories") This is a...
How To Create a Combined Set In Tableau
Hello everyone, For example, In Sample Superstore, If you want to show both Top and Bottom 10 Customers, you should create a combined set: 1. Create Top 10 Customers set (by Sales): Right click on the Customer Name, Hover on the Create and then select "Set...". 2.In...
Add Dynamic Reference Lines Into Your Charts (Example: Pareto Chart)
Hello everyone, in this post I want to explain how to add dynamic reference lines into our Pareto Chart. If you want to see how to create a Pareto Chart use the following link:...
Visualizing the Pareto Principle in Tableau
In Sample Superstore: Put Sum of Sales in the Rows and Count Distinct of Product Name in the Columns. Put Product Name to Detail (in Mark section). Right click on SUM(Sales), Quick Table Calculation, choosing Running Total. Right click on CNTD(Product Name), select...
Pareto Principle (80/20 Rule) in Data Analysis
In the world of data analysis, efficiency and impact are crucial. One of the most powerful tools to achieve this is the Pareto Principle, often referred to as the 80/20 Rule. This principle suggests that in many situations, 80% of the effects come from 20% of the...
Socioeconomic Trends and Child Care Affordability
Hello everyone, The last project of Dashboard Week focused on child care in the United States from 2008 to 2018. The dataset contained over 200 columns, with all column names in abbreviation. I began by reviewing the documentation to understand the abbreviations, and...
Day 4 of Dashboard Week : Dengue
Hello everyone, the 4th project for the Dashboard Week was about Dengue : Do you know what Dengue is?! Dengue is a mosquito-borne viral infection that causes flu-like symptoms and can lead to severe complications, particularly in tropical and subtropical regions. The...
National Park Services Api
Hello everyone! Today, I want to share insights from the third day of Dashboard Week, where we focused on working with APIs. Our project centered around the National Park Service API, which provides a wealth of information across several endpoints covering parks,...