Decoding Pattern

Decoding Pattern In this page we are going to learn everything about Microsoft Excel and Power BI for Business Intelligence. Stay tuned for the latest updates.

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!

Color coding and icons are great way if you want to communicate your data properly.But using a lot of color and icons in...
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

There is a new quote everywhere that -- DATA is the new OILIf you can analyze the data you have properly, you can unlock...
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 ๐Ÿ‘‡




Watch my Latest Video on Telco Customer Churn : https://youtu.be/edD3yeeIYawLink to the dataset : https://www.kaggle.com...
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 ...

Address

House #133, Road #03, Alamnagar Rangpur
Rangpur
5402

Alerts

Be the first to know and let us send you an email when Decoding Pattern posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share