Decoding Pattern

02/05/2026

Everyone who works with Excel has faced this problem frequently.
And the problem is 𝐃𝐀𝐓𝐄 related issue.

Let's say you have a date (06/03/2025) in Excel.

In your computer the date is 𝟔ᵗʰ 𝐨𝐟 𝐌𝐚𝐫𝐜𝐡, 𝟐𝟎𝟐𝟓

But sometimes when you send that Excel file to someone this date turns out to be 𝟑ʳᵈ 𝐨𝐟 𝐉𝐮𝐧𝐞, 𝟐𝟎𝟐𝟓

In that video, I have described --

1. Why that issue happens?
2. How you can address that issue?
3. 𝐀𝐧𝐝 𝐚 𝐨𝐧𝐞 𝐬𝐭𝐨𝐩 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐭𝐡𝐢𝐬 𝐢𝐬𝐬𝐮𝐞 𝐟𝐨𝐫𝐞𝐯𝐞𝐫.

01/04/2026

A common issue happens every time when someone opens an excel file in UK but the file is coming from the USA.

Use local option in Power Query to solve this issue.
Now it doesn't matter from where you are opening that power bi report or excel file.

It will work just fine even if you open it from the MOON..

In this short video, I have shown how you can solve this problem.

15/03/2026

Everyone who works with Excel has faced this problem frequently.
And the problem is 𝐃𝐀𝐓𝐄 related issue.

Let's say you have a date (06/03/2025) in Excel.

In your computer the date is 𝟔ᵗʰ 𝐨𝐟 𝐌𝐚𝐫𝐜𝐡, 𝟐𝟎𝟐𝟓

But sometimes when you send that Excel file to someone this date turns out to be 𝟑ʳᵈ 𝐨𝐟 𝐉𝐮𝐧𝐞, 𝟐𝟎𝟐𝟓

I have created a video on this issue.

In that video, I have described --

1. Why that issue happens?
2. How you can address that issue?
3. 𝐀𝐧𝐝 𝐚 𝐨𝐧𝐞 𝐬𝐭𝐨𝐩 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐭𝐡𝐢𝐬 𝐢𝐬𝐬𝐮𝐞 𝐟𝐨𝐫𝐞𝐯𝐞𝐫.

This is just the Intro part of that video.

Video will come out tomorrow InsaAllah.

Subscribe and press the bell icon to get the notification when I will be uploading the video.

YT Channel Link: https://www.youtube.com/

04/03/2026

This is the intro footage from my recent video on YT.

Recently I closed a project with one of my clients. He is an ecommerce business owner. He asked me to predict the future sales so that he can compare the actual sales with the predicted year.

In this video, I am going to show how I have solved this problem using statistics and data visualization!

02/03/2026

Color coding and icons are great way if you want to communicate your data properly.

But using a lot of color and icons increase clatter into the visualization.

If you look at the image attached you can immediately identify --

• Blue line is representing actual sales whereas orange line is representing forecasted sales

• The orange line is not a solid line as of the blue line, it is a dashed line

• And if you see the label at the top you can see whenever there is an increase in the actual sales compared to the forecasted sales, it is representing as ⬆ arrow and with green color.

• And if there ia a drop in the actual sales, it is representing as ⬇ arrow with red color.

• And a toggle button to select the year.

This image is taken from my recent YouTube video.
If you haven't watch that video,
Here's the link of that video: https://youtu.be/WcTiWndXyno

28/02/2026

There is a new quote everywhere that
-- DATA is the new OIL

If you can analyze the data you have properly, you can unlock a lot of new insights for your business.

Recently I closed a project with one of my clients. He is an ecommerce business owner. He asked me to predict the future sales so that he can compare the actual sales with the predicted year.

In this video, I am going to show how I have solved this problem using statistics and data visualization!

Video link in the first comment.

23/02/2026

This is the 3rd video of the Customer Churn Analysis Playlist. In this video, I have discussed why senior citizens are more likely to churn the telco customer service.

And what we can do to retain our existing senior citizens.

I have used Excel's pivot table and conditional formatting to answer all of the questions.

27/01/2026

In order to sort in Excel, you have to just follow the steps shown in the video.

You don't need to add an index column neither you need to sort by index column.

This feature is exculsively available in Microsoft Excel.

This is short clip from my full video on "What Really Causes Customer Churn? Value-Level Analysis".

24/01/2026

Customer churn doesn’t usually happen for random reasons.
In most cases, a few specific customer choices are responsible for most of the problem.
In this short clip, I’m breaking down real customer data to show which behaviors are linked to higher churn and why that matters for businesses.
This is part of a larger case study where I’m slowly moving from raw data to clear, decision-focused insights—before building dashboards.
If you work with customer data or run a business and want to understand why customers leave, this kind of analysis can be really eye-opening.
Full analysis is on my YouTube channel 👇

14/01/2026

Watch my Latest Video on Telco Customer Churn : https://youtu.be/edD3yeeIYaw

Link to the dataset : https://www.kaggle.com/datasets/blastchar/telco-customer-churn

This is first video of the Telco Chustomer Churn Playlist. There will be multiple videos in this playlist. 2-3 videos on the Exploratory Data Analysis, an explanatory dashboard to tell a clear story and a exploratory dashboard using Power BI totrack the key performance indicators (KPIs).

In this video, I have done Exploratory Data Analysis on Telco Customer churn from kaggle. I have given introduction of the dataset. I have load this data into Power Query for basic cleaning. I then load this data into Power Pivot to write down DAX function to perform the analysis. I have taken into account the Gender, Senior Citizen, Partner and Decendent column for churn rate analysis. In the next video I will perform data analysis on other columns.

Follow ans subscribe to my youtube channel to learn awesome data analytics techniques.

Facebook
📘 https://www.facebook.com/rayaaal/

Instagram
📸 https://www.instagram.com/zakirreyal/

LinkedIn
💼 www.linkedin.com/in/md-zakir-hussain-khan-smb-insights

Email
📧 [email protected]

Link to the dataset : https://www.kaggle.com/datasets/blastchar/telco-customer-churnThis is first video of the Telco Chustomer Churn Playlist. There will be ...