ShahAlam: Data Training & Analytics

27/05/2026

26/05/2026

🤔 Still confused about Excel’s (+) sign and (@) sign in formulas?

😃 In this quick Excel tutorial, learn how to find the week number of a month using the WEEKNUM function along with Plus Sign (+) At Sign (@) like a pro!

=WEEKNUM(+B3:B27,1)-(+B3:B27,1)+1

A small trick that can make a BIG difference in your Excel skills. Don’t miss it! 🔥

Practice File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQAXKBcaZiM2RZl4R4jF4r4dAc_6hzsS0uPJUW7mx_S4nkg?e=TL4OyP

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

YouTube Channel:
https://www.youtube.com/

25/05/2026

My new book is coming soon. Stay tuned for updates!

24/05/2026

One Problem – Three Solutions: Excel Dynamic Array, Power Query M & PostgreSQL

📊 Month-over-Month (MoM) Sales Analysis

In this video, you will learn how to calculate:

✅ Total Monthly Sales

✅ Month-over-Month (MoM) Sales Difference

✅ Month-over-Month Sales Growth %

using three powerful tools:

🔹 Excel 365 Dynamic Array Formulas

🔹 Power Query

🔹 PostgreSQL

Topics covered in this tutorial:

✔ GROUPBY Function in Excel

✔ LET Function Optimization

✔ Dynamic Arrays with HSTACK & VSTACK

✔ DROP & TAKE Functions

✔ Power Query Group By Transformation

✔ Index-Based Previous Row Calculation

✔ try...otherwise Error Handling

✔ PostgreSQL Window Functions

✔ LAG Function for Previous Month Analysis

✔ MoM Growth Percentage Calculation

This tutorial is perfect for:

📌 Data Analysts

📌 Excel Users

📌 Power BI Learners

📌 SQL Beginners

📌 Financial Reporting Professionals

💡 Learn how the same analytical problem can be solved using:

Spreadsheet formulas

ETL transformation logic

Database window functions

Excel Formula | Power Query M Code | PostgreSQL Query are fully explained step-by-step.

Download Practice File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQDZN26he1GwRZVAo4VjhAd1Ae4poDRB5Y08KMKg5HzsuJc?e=sMVEgb

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

YouTube Channel:
https://www.youtube.com/

23/05/2026

📊 Case Title:
Month over Month (MoM) Sales Performance Analysis
________________________________________
🧩 Context:
A sales dataset contains transaction-level records with:
• sales_date
• dept_name
• sales_amount
The business wants to understand monthly sales performance and track how sales change from one month to the next.
________________________________________
🎯 Business Requirement:
To calculate and analyze:
• Total monthly sales
• Previous month sales
• Month-over-month (MoM) sales difference
• Month-over-month sales growth percentage
________________________________________
❗ Additional Requirement:
• If there is no previous month data, the result should return 0 instead of blank
• Growth calculation must safely handle division by zero
________________________________________
🔥 Question Form:
How can we calculate monthly total sales and compare each month with its previous month using DAX measures?
________________________________________
🛠 Function Used:
• SUM
• CALCULATE
• DATEADD
• IF
• DIVIDE

21/05/2026

Solution to Twenty Second (22nd ) Challenge with Excel 365 Dynamic Array Formulas

Learn how to calculate the Maximum and Minimum Loan Amount based on Loan Type using Excel 365 Dynamic Array formulas.

In this video, I have solved Challenge 22 using the powerful GROUPBY function along with VSTACK, DROP, HSTACK, MAX, and MIN functions in Excel 365.

Topics Covered:
✔ GROUPBY Function in Excel 365
✔ Dynamic Array Formulas
✔ MAX and MIN Calculation by Group
✔ VSTACK and DROP Functions
✔ Advanced Excel Formula Techniques
✔ Excel Data Analysis

This solution is simple, dynamic, and efficient for modern Excel users.

Download Excel File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQCwDwv_O_grR5q4rcxd6FDNAdn-iEwI4xtEXRx5sHgBylg?e=TY0cOb

LinkedIn Post:
https://www.linkedin.com/posts/excelmdshahalam_excel-challenge-22-department-wise-max-activity-7280550741411315713-4oyv?utm_source=share&utm_medium=member_desktop

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

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

The next will be Solution to Twenty Second (22nd) Challenge with Excel Power Query M Code

I appreciate your understanding of any mistakes I made—please focus on learning and enjoy the video.

20/05/2026

📊 Combining Multiple

Tables in PostgreSQL Made Simple
In this short demo, I show how to create a unified table by appending multiple monthly tables using CREATE TABLE AS with UNION ALL.

We build a single dataset (tbl_all) from:
• tbl_jan
• tbl_feb
• tbl_mar

Then validate the result using a simple SELECT query.

This approach is highly useful for:
✔ Monthly reporting
✔ Data consolidation
✔ MIS and analytics workflows

Efficient, clean, and widely used in real-world database projects.

Download Practice File:
https://1drv.ms/f/c/F66A2644F1B4537C/IgDvB2fh5cgRRJKD-ehxSs9cAdNkv_yKG1Lz099H8zlEn1A?e=ILJ9Ky

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

Visit Website:
https://www.shahalamanalytics.com/

YouTube Channel:
https://www.youtube.com/

19/05/2026

Just shared a short video on how to work with Lists, Records, and Tables in Power Query.

In this video, I demonstrated:
• Combining tables dynamically
• Extracting columns as lists
• Converting records into tables
• Understanding {}, [], &, and indexing concepts in Power Query

These small concepts are extremely powerful for data transformation and automation.

Download Practice File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQDxmiH-eJREQI65ABgc7pZ7AaZLPwSt-GM2PISoxgSu8ME?e=CHwqRB

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

Visit Website:
https://www.shahalamanalytics.com/

YouTube Channel:
https://www.youtube.com/

17/05/2026

One Problem – Three Solutions: Excel Dynamic Array, Power Query M & PostgreSQL

Learn how to transform every 3 rows into separate records using three powerful tools:
✅ Excel 365 Dynamic Array Formula
✅ Power Query
✅ PostgreSQL

In this tutorial, you will learn how to convert a single-column dataset into structured columns like Name, Month, and Sales.

📌 Topics Covered:
🔹 Excel 365 Dynamic Array Solution
Using WRAPROWS and VSTACK functions
🔹 Power Query Solution
Using List.Split, List.Zip, and Table.FromColumns
🔹 PostgreSQL Solution
Using CTE, ROW_NUMBER(), CEIL(), CASE WHEN, and GROUP BY

🎯 In this video, you will understand:

✔ How WRAPROWS works in Excel 365
✔ How List.Split and List.Zip work in Power Query
✔ How CEIL(rn/3.0) creates group numbers in PostgreSQL
✔ How CASE WHEN converts rows into columns
✔ Practical data transformation techniques for Data Analysis

🔥 Perfect for:
• Excel Users
• Data Analysts
• Power Query Learners
• SQL Beginners
• PostgreSQL Developers
• BI Professionals

Download Practice File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQAKhnwOWA7vTKFgCYjYgJo_AcXEmCTsvXnYO-6b0f4Va70?e=6lj2hU

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

YouTube Channel:
https://www.youtube.com/

16/05/2026

Admission Going on for New Batch

Live Online Course | Data Analytics with Microsoft Excel & AI | Business Cases & Projects-Based Learning

Enroll Now:
https://www.dikkhabd.com/course/mastering-ms-excel/excel/

Course Outline:
https://www.shahalamanalytics.com/media/Excel_Course_Outline.pdf

Let Your Data Speak with the world’s most powerful spreadsheet tool!

This course isn’t just about formulas — it’s about using MS Excel to solve real business problems. Learn hands-on with practical projects designed to boost your workplace efficiency and confidence in data analysis.

What You’ll Learn:
Text Functions for Dynamic Data Manipulation
Conditional Analysis Functions
Match & Lookup Functions
Date & Time Functions
Conditional & Custom Formatting
Pivot Table Mastery for Smart Summaries
Charts and Graphs for Data Visualization
Use AI to Solve the Problem

Project-Based Practice to apply every skill

Starts: 01 June 2026
Days: Saturday and Tuesday
Time: 9:00 PM – 10:30 PM
Total Duration: 15 Classes (20 Hours)
Course Fee: BDT 3,000/-

Class Recording Will be provided. You will get certificate after participating in a post training test

Trainer: Md. Shah Alam
Microsoft Certified Trainer
10.5+ Years Industry Experience
5.5+ Years Training Experience
Trained over 6,000 professionals & students
Perfect for job holders, fresh graduates & freelancers!
Live & Interactive | Certificate Included |

16/05/2026

📊 Case Title:
Count the Number of Branches Achieving Sales Target Using a Single DAX Measure

🧩 Context:
A sales model contains three related tables: Sales Data, Sales Target, and Division. Each branch has sales and target information stored across different tables.

🎯 Business Requirement:
Calculate how many unique branches achieved or exceeded their assigned sales targets.

❗ Additional Requirement:
The solution must be written using a single professional DAX measure with VAR for better readability, maintainability, and performance optimization.

🔥 Question Form:
How can we count the number of branches where Sales ≥ Target using one optimized DAX measure?

🛠 Function Used:
VAR, ADDCOLUMNS, VALUES, CALCULATE, FILTER, DIVIDE, COUNTROWS