ShahAlam: Data Training & Analytics

🤔 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/

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/

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.

📊 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/

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/

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/