Rahim Zulfiqar Ali LinkedIn Posts

TRAINING + MENTORSHIP (New) Online LIVE Classes | Become Data & Business Analyst in Microsoft #EXCEL 365 | ENROLL NOW 🟢

6 Weeks Program

TRAINING + MENTORSHIP (New) Online LIVE Classes | Become Data & Business Analyst in Microsoft #EXCEL 365 | ENROLL NOW 🟢

6 Weeks Program

Learn #Excel & #POWERBI | Upgrade your Skills | Online Course

For Beginners - Create Sales Analytical Dashboard in Microsoft POWER BI Desktop (Sep-2024) - Rahim Zulfiqar Ali | #PowerBI #DAX #dashboard

For Beginners - Create Sales Analytical Dashboard in Microsoft POWER BI Desktop (Sep-2024) - Rahim Zulfiqar Ali | #PowerBI #DAX #dashboard

Quick Preview: Exploratory Data Analysis (#EDA) via PYTHON in Microsoft #Excel 365 Anaconda, Inc.

1. Load The Data
2. Understand The Data
3. Handling Missing Data
4.

One Click Dashboards (Templates) Crypto Sheets ADD-IN in Microsoft Excel 365 | The easiest way to pull LIVE, REAL-TIME and HISTORICAL Crypto Currency

Custom Sorting via Formula in Excel 365 (Dynamic Array) #Excel

=SORTBY(Data,MATCH(Data[Medals],SortList,0),1)

Multiple Columns Criteria:
=SORTBY(Data,MATCH(Data[Medals],SortList,0),1,Data[Names],1)

GROUPBY Function with TOP 5 / BOTTOM 5 Results in #Excel 365 | Developer Tab, Option Button!

=IF(D6=1,TAKE(SORT(
GROUPBY(Data[Category],
HSTACK(Data[Quantity],Data[Revenue]),SUM,,0),
3,-1),5),
TAKE(SORT(
GROUPBY(Data[Category],
HSTACK(Data[Quantity],Data[Revenue]),SUM,,0),
3,1),5))

For Beginners - Create Sales Analytical Dashboard in Microsoft POWER BI Desktop (Sep-2024) - Rahim Zulfiqar Ali | #PowerBI #DAX #dashboard

GROUPBY Function with TOP N Results in #Excel 365
=TAKE(SORT(
GROUPBY(Data[Category],
HSTACK(Data[Quantity],Data[Revenue]),SUM,,0),
3,-1),C4)

GROUPBY Function with TOP N Results & Multiple Aggregations in #Excel 365

=TAKE(SORT(
GROUPBY(Data[Category],
Data[Revenue],
HSTACK(SUM,AVERAGE,COUNT),,0),
2,-1),C4+1)

List Slicer (New) in Microsoft POWER BI Oct-2024 #POWERBI

POWER BI - OCT2024 | New DAX Functions for Listing, Measures, Columns, Tables & Relationships. DAX QUERY VIEW #POWERBI

EVALUATE
  INFO.VIEW.COLUMNS()
  INFO.VIEW.MEASURES()
  INFO.VIEW.RELATIONSHIPS()
  INFO.VIEW.TABLES()

Tutorial Advanced! GROUPBY Function with TOP N Results with Multiple Aggregations (Multiple Columns with Different Calculations) in #Excel 365 | Example: Average is

𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐒𝐮𝐩𝐞𝐫𝐬𝐭𝐨𝐫𝐞 𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐚𝐥 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐏𝐎𝐖𝐄𝐑 𝐁𝐈

New Updates in this Template!
- Blinking Icons / Alerts
- TOP 5 Customers DAX
- Highlight TOP

FREE Template (DOWNLOAD) - Advanced Superstore #Sales Analytical Dashboard in Microsoft POWER BI | #POWERBI #DAX #PowerQuery #Analytics #Dashboard

Happy SpreadSheet Day! 17th OCT | The first spreadsheet program was VisiCalc, written for the Apple II computer in 1979.

Daniel Singer Bricklin (born

Get Unique & Sorted List from Multiple Lists Excluding Errors & Blank Cells - #Excel 365 | =SORT(UNIQUE(TOCOL(B5:D8,3)))

SMART SUM Techniques in MS #Excel

1. Multiple Ranges Totals - Filter (Select Total) - Go to Special (Home Tab) - Visible Cells Only