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

Image by Unsplash

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.

What is DAX?

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.

Image from Unsplash

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.

Sankey Chart in Power BI
Sankey Chart in Power BI
Image by Unsplash

Introduction

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.

What is Sankey Chart

If you search in Google with “Sankey Chart”, you find the…


Step-by-step guidelines to implement advanced animated charts using US Super Store Sales data.

Image from Unsplash

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.

Table of Contents

1. Data Set

2. Abstraction

3. Learning Objective

4. Import Data

5. Transform Data (Calculated…


CODEX

A guided case study with OTT media data in Tableau

Image from Unsplash

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.

Table of Contents

1. Data Set

2. Abstraction

3. Learning Objective

4. Import Data

5. Create Calculated Field

6. Data Visualization

7. Conclusion

Data Set

I have taken the data from Kaggle. Please find the below link.

Abstraction

The dataset (amazon prime movies.csv) consists of 7 variables with 8127 records.


Step by step Python Code for data visualization (explore Matplotlib)

Image from https://unsplash.com/s/photos/data-visualization

Introduction

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.)

Image from https://unsplash.com/

Introduction

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

Image from Unsplash

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.

Table of Contents

1. Data Set

2…


Step by step Python Code for data cleaning ( missing values, outlier treatment, finding duplicates)

Image from Unsplash

Introduction

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…

Arpita Ghosh

Data science professional, Blogger,

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store