Decoding Pattern

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. 𝐀𝐧𝐝 𝐚 𝐨𝐧𝐞 𝐬𝐭𝐨𝐩 𝐬𝐨𝐥𝐮𝐭𝐢𝐨𝐧 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐭𝐡𝐢𝐬 𝐢𝐬𝐬𝐮𝐞 𝐟𝐨𝐫𝐞𝐯𝐞𝐫.

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.

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/

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!

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.

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

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 👇