45018 lines of code woow! 😅

Does it work on Mac ?

what are the different charts do you suggest for doing benchmarking

Very useful 👌

Nice sir

Hello #DataFam 𝐂𝐚𝐥𝐥 𝐂𝐞𝐧𝐭𝐞𝐫 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐚𝐥 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐏𝐎𝐖𝐄𝐑 𝐁𝐈 𝐃𝐞𝐬𝐤𝐭𝐨𝐩 (𝐃𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐯𝐞 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬) Top Features: - Light / Dark Mode - KPI - Color Scheme - Descriptive Analytics - Right Chart Selection Concepts Dataset from Data.World Website by Mark Bradbourne (Call Center) #POWERBI #Dashboard #Analytics #CallCenter #RWFD #Lightmode #Darkmode #UIDesign #UXDesign #Data #DataVisualization #BusinessDashboard #VizOfTheDay

Sir, when I use a x lookup same invoice number but different amounts however look up picking first invoice amount for second one too .. kaise resolve karee iss issue ko. Ex. regular hours and OT Hours have the same invoice number but look up value picking same regular hours for OT too

We are looking for more GUI visualizations and Deneb is taking us back to command prompt 😊. Cool stuff, I like the ability to customize to taste.

Deneb is a custom visual for Microsoft #PowerBI which allows creators to use the declarative JSON syntax of the Vega or Vega-Lite languages to build their own bespoke data visualizations, without having to learn web development.

well done

Thank you so much, this is work

Q1. Filter all Employees who are Reporting to Manager Rahim? =VSTACK(HR_Data[#Headers],FILTER(HR_Data,HR_Data[Manager]=I4)) Q2. Filter all Employees who are Reporting to Manager Rahim having Salary >= 80,000 & Male? =VSTACK(HR_Data[#Headers],FILTER(HR_Data,(HR_Data[Manager]=I49)*(HR_Data[Salary]>=80000)*(HR_Data[Gender]="Male"))) Q.3 Salaries of People Reporting to Rahim ? Descriptive Analytics =FILTER(HR_Data[Salary],HR_Data[Manager]=B74) Q4. Filter all Employees who are Reporting to Manager Rahim (ID, Names, Gender, Age, Salary)? =VSTACK(CHOOSECOLS(HR_Data[#Headers],{1,2,4,5,7}),FILTER(CHOOSECOLS(HR_Data,{1,2,4,5,7}),HR_Data[Manager]="Rahim")) Q.5 Summarize Department wise based on Age Filter? =SORT(UNIQUE(FILTER(HR_Data[Department],HR_Data[Age]>=C163))) =COUNTIFS(HR_Data[Department],E166#,HR_Data[Age],">="&C163) =SORT(E166#:F166#,2,-1) Q.6 Find Names and No of Employees Reporting to Manager? =TEXTJOIN(", ",TRUE,FILTER(HR_Data[Full Name],HR_Data[Manager]=B188)) =COUNTA(--TEXTSPLIT(C188,", "))

❤❤❤

Thanks!

FREE Template DOWNLOAD - 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐒𝐮𝐩𝐞𝐫𝐬𝐭𝐨𝐫𝐞 𝐒𝐚𝐥𝐞𝐬 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐚𝐥 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐢𝐧 𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐏𝐎𝐖𝐄𝐑 𝐁𝐈 www.eloquens.com/tool/YPEwfZ7q/strategy/sales/advanced-sales-analytical-dashboard-in-microsoft-power-bi-dax 1. Click on Add to Cart Button 2. Click on View Cart Button 3. Click on Have a Discount Coupon? 4. Apply 100% Discount Coupon RahimZulfiqarAli 5. Click on Apply Discount Coupon 6. Click on Proceed Button 7. Download Now! ENJOY 8. Leave a Positive Feedback!

Hi there, that video is great.! no need api keys anymore.! a question; how can i reflesh the prices ?

Thank you

Really Helpful

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

Goof job. Your work is always admirable. Can we have the data file for reference?

Assalam O Alaikum Sir , thank u so much for your efforts to provide us free valuable resources to learn. Sir please confirm that whether u will upload full Quick Book course and how many lectures will be in this course?

❤Thank you for your interest in spreading knowledge and science. My greetings to you, my respected person. I have a question. Is it useful to use? Checkbox Available in Office 365, how do I apply?

✨👍🏻

Excel 365 Version Required! Install CryptoSheets from HOME Tab > Add-ins > Cryptosheets | Register and Signup via Email and Activate! Enjoy the Cryptosheets Add-in in Excel to fetch Templates on One Click Only! Or make your own Bespoke Portfolio with Live Real-Time Rates!

At 0:16 Hi, thanks for this. Normally in a traditional pivot if we click total column, it will typically open another sheet containing the break-up of that total column. How this will work with power query and data model?

Great job Rahim

❤

Thanks alot for this

Thank you so much 😊

Such a valuble video thank u so much sir

Blink = VAR __color = "Red" VAR __lineColor = "Black" VAR __lineThickness = 1 VAR __radius = 9 VAR __opacity = 1 VAR __rand = RAND() VAR __header = "data:image/svg+xml;utf8," & "<svg xmlns:dc='purl.org/dc/elements/1.1/' xmlns:cc='creativecommons.org/ns#' xmlns:svg='www.w3.org/2000/svg' xmlns='www.w3.org/2000/svg' width='100%' height='100%'>" VAR __footer = "</svg>" VAR __shapeTextCircle = "<circle cx='10' cy='20' r='" & __radius & "' fill='" & __color & "' fill-opacity='" & __opacity & "' stroke='" & __lineColor & "' stroke-width='" & __lineThickness & "'> " & "<animate attributeName='opacity' from='1' to='0' dur='1s' begin='0s' repeatCount='indefinite'/></circle>" RETURN IF([Flag],__header & __shapeTextCircle & __footer,"")

How did you get blink the svg ...how did get the code of svg

Thank you! :)

Useful in Dashboard Reporting! Screens installed at Hospitals, Call Centers, Railway Stations, Airports, Banks & More. 1. Stock Market Tracking 2. Inventory Management 3. Sensor Data Monitoring 4. Drawing Attention to Exceptions 5. Deadline Reminders 6. Task Notifications

Sub BlinkCell() Dim CellToBlink As Range Set CellToBlink = Range("B7") Do While Range("B4").Value < Range("C4").Value CellToBlink.Interior.ColorIndex = 3 Application.Wait (Now + TimeValue("0:00:01")) CellToBlink.Interior.ColorIndex = 0 Application.Wait (Now + TimeValue("0:00:01")) CellToBlink.Interior.ColorIndex = 3 DoEvents Loop If Range("B4").Value >= Range("C4").Value Then CellToBlink.Interior.Color = vbWhite End If End Sub

thank you very much

thank you

Excellent step by step! Thank you very much

Good stuff! That's what I was looking for when I encountered special characters like ( ) ? / :

Nice work. Straight forward and easy

Not working in 2016

What will we do we have more than 3,4 columns to compare

How to Install Tableau Desktop 2024 - Quick Tour | Business Intelligence and Analytics Software

Thank You sir for providing this informative video❤

good teaching sir 🙏

Very informative and helpful

Hi, I am doing some calculation of the amount (In column) as below by using the Google Sheet , I tried to use your skill but the amount unable to sum the actual number it, the result come out $,3,374.00 instead if $6,748.00, appreciate if you could assist me on this matter.Thank you. Amount per month Jan 2024:$3,374.00 Feb 2024: $3,374.00

Thank you, greetings from Brazil.

Thanks for the video. I have a question, does it work if a sheet has multiple tabs with more than 1 million rows or should I split data in between different files with one tab

Information design is the practice of presenting information in a way that's easy to understand and use. It's like translating complex data into a language everyone can comprehend. By using visual elements, typography, and layout, information designers create clear, concise, and engaging content. Key goals of information design: Clarity: Ensuring information is easily understood. Efficiency: Making information accessible and usable quickly. Effectiveness: Achieving the desired outcome or goal.