Rahim Zulfiqar Ali LinkedIn Posts

Hello #DataFam

Statement of Comprehensive Income - with Big Data in Microsoft POWER BI Desktop | Data Storytelling Dashboard | International Business Communication

Traditional Excel Approach vs. Modern Excel Approach (Dynamic Array Formula) | Dynamic Spill Ranges in Excel 365 | Financial Modeling Example! #Excel

Thanks

There is an understandable desire to share all the data you analyzed and every #dataviz you built when communicating to your audience. While

Become Business Intelligence Analyst in POWER BI (Desktop + Service) | LIVE Online Classes (May & Jun 2024) Enroll Now | #POWERBI #DAX

Build Sankey diagrams in Tableau with Viz Extensions.

Tableau Product Manager Wilson Po and Engineering Manager Jacquelyn Cheng share how you can add more

Implementing this methodology made me a better dashboard designer.



First presented in 1996, Ben Shneiderman's Visual Information Seeking Mantra is still influential today.


These three

Storytelling in PowerPoint – Power BI add-in for PowerPoint - April 2024 Updates

Public snapshot: Anyone who can view the presentation can view the

Highlight MAX & MIN Data Points in POWER BI Desktop Visuals | NO Complex DAX | Conditional Formatting Solution | #POWERBI

✨ Introducing Copilot Pane in Power BI Desktop (Preview) April 2024

Copilot experience for report creation is now available for preview in the April

Learn Modern Excel & POWER BI Together - Exclusive Recorded Course with Discount! (20+ Templates Included) #Excel #POWERBI #DAX #PowerQuery #Analytics

How to Generate Random Teams from a List of Names without Repetition in #Excel 365

=WRAPROWS(SORTBY(Data,RANDARRAY(COUNTA(Data))),3)

Combine Multiple Tables and Perform Aggregation Sum | POWER QUERY Solution | Data Transformation #POWERQUERY #EXCEL #Data

Extract the Numbers & SUM from Non Adjacent Range in Google Sheets | #GoogleSheets

=ARRAYFORMULA(SUM(IF(ISNUMBER(SPLIT(CONCATENATE(A3:G12),{"(,)"})),SPLIT(CONCATENATE(A3:G12),{"(,)"}),0)))

Extract the Numbers & SUM from Non Adjacent Range in #Excel 365

=SUM(IFERROR(0+TEXTSPLIT(CONCAT(A3:G12),{"(",")"}),0))

=SUM(--DROP(TEXTSPLIT(CONCAT(A3:G12),"(",")",,,0),,1))

=SUM(0+TAKE(TEXTSPLIT(CONCAT(A3:G12),"(",")",,,),,-1))

Thanks to Rick Rothstein & Bo Rydobon 🇹🇭

CHALLENGE! Extract the Numbers & SUM from Non Adjacent Range in #Excel 365 | Share your Solution in Comment Below!

Download File: https://lnkd.in/dTnQN6WJ

Extract Numbers from Cell within Round Brackets #Excel 365
=IFERROR(--TEXTSPLIT(TEXTAFTER(B3:B12,"(",SEQUENCE(,3)),")"),"")

Thanks to Bo Rydobon 🇹🇭

Hello #DataFam,
HBL Credit Cards Example | New Button Slicer & Card in Microsoft POWER BI Desktop | #POWERBI #Dashboard #Visuals HBL

Hello #DataFam | New Button Slicer & Card in Microsoft POWER BI Desktop | #POWERBI | Nov-23 Update | Example of NIKE Shoes

Resume Vs. Reality
#Excel #PowerBI

Dynamic Aggregation using LET Function - Dynamic Array Formula #Excel 365

=LET(range,D11:D17,select,F7,calc,CHOOSE(select,109,104,105,101),SUBTOTAL(calc,range))

Useful in Dashboard Reporting | (MIS Reports / Sales)