This is a step by step tutorial starting with an introduction to DAX operators, DAX function categories, DAX data model components and first hands-on experience with DAX
For any POWER BI job description, you will find one competency is mandatory. Any idea what is that? Yes, you are right. It is DAX.
DAX is playing an important key role in any Power BI project. In this blog series, I will capture my understanding of DAX with some practical code.
DAX (Data Analysis Expressions) is known as a functional language. It means, calculations mostly use functions to generate the results.
DAX…
A complete guided case study in Power BI based on the Kaggle data set.
Today I was trying to prepare some tasty salad and going to some food blogs. I found a good recipe with avocado. As we know avocado is a very good source of vitamins and helps to protect from heart disease. After having a good salad, I couldn’t come out from avocado and found a popular data set in the Kaggle. I started to plan to do some data analysis.
In this blog, I am going to explain to you how I have completed one case study…
Implementation guide to creating Sankey chart in Power BI using Hollywood Most Profitable stories data.
For every data analysis project, data visualization plays an important role. When we think about data visualization, plenty of charts/graphs are coming to our minds. Earlier, we used bar, line, pie, etc, some common format charts.
The visualization world is changing, many chart formats are joining. Out of them, Sankey Chart is very popular.
In this blog, you will learn how to build a Sankey Chart in Power BI using one Kaggle data set.
If you search in Google with “Sankey Chart”, you find the…
Nowadays, in each and every place, animation is playing a key role. For example, whether it is in Facebook, Instagram, Twitter or any other social media platform, as a user we are always attracted to any type of animated pictures.
A customer will be more engaged in a storytelling session if we promote the animated chart features of any business intelligence or data visualization tool.
To follow this trend, in this blog, we are going to explore the advanced animated chart features of Power BI.
1. Data Set
2. Abstraction
3. Learning Objective
4. Import Data
5. Transform Data (Calculated…
Nowadays OTT Platform is very famous. Due to COVID, all theatres and cinema halls are closed and OTT is one of the key platforms to entertain the audience.
In this blog, we will do data analysis step by step with Amazon Prime’s data using Tableau.
1. Data Set
2. Abstraction
3. Learning Objective
4. Import Data
5. Create Calculated Field
6. Data Visualization
7. Conclusion
I have taken the data from Kaggle. Please find the below link.
The dataset (amazon prime movies.csv) consists of 7 variables with 8127 records.
Step by step Python Code for data visualization (explore Matplotlib)
If we want to apply for any data analyst or data scientist role, it is necessary to know one of the programming languages used for such roles. It could be R or Python or Scala etc. To fulfill this, I have selected Python for data analysis.
If you want to check the practical code data loading, data cleaning, data interpretation, then please check the below links.
Now we are in the most interesting phase of data analysis. I would say the Data Visualization step is the visual representation of the…
Step by step Python Code for data understanding (statistical analysis, use of pivot table, data sorting, etc.)
If we want to apply for any data analyst or data scientist role, it is necessary to know one of the programming languages used for such roles. It could be R or Python or Scala etc. To fulfill this, I have selected Python for data analysis.
If you want to check the practical code data loading step from different sources and data cleaning steps. Please check the below links.
After data cleaning, we are now in the actual data analysis stage. In this…
Guided project on OLTP to OLAP data transformation and Decomposition Tree using US Super Store Sales data
Earlier, for any data transformation or data conversion project, we used different ETL tools. Yes, for large-scale enterprise projects, definitely we need ETL or data warehouse tools. But, using Power BI we can very well transform any transactional data to analytical data that means OLTP data model to OLAP data model.
In this blog, we are going to learn how we can create a Star-Schema data model from a transactional data file. We will explore Decomposition Tree AI visual.
1. Data Set
2…
Step by step Python Code for data cleaning ( missing values, outlier treatment, finding duplicates)
If we want to apply for any data analyst or data scientist role, it is necessary to know one of the programming languages used for such roles. It could be R or Python or Scala etc. To fulfill this, I have selected Python for data analysis.
If you want to check the practical code data loading step from different sources. Please check the below link.
The data preparation step is the most important part to win the battle of a data analysis project. This document…
Data science professional, Blogger,