Comparative Analysis Dashboard in Power BI | Step by Step Design, Data Model, DAX and Publish

#PowerBI #BIDashboards
Hello Friends,
In this video, you will learn how to a beautiful Comparative Analysis Dashboard in Microsoft Power BI.
In this dashboard we have displayed the comparison of Current Year Sales with Previous Year sales and YoY sales growth%. We have displayed the Budgeted Sales data along with Budget Variance%. We have Power BI Tooltip to display Product Level comparison of Sales and Month wise Budget Variance%. We have created the Sales forecast also.
Download the practice files from below given link:
www.pk-anexcelexpert.com/comp...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@lucazarts25]

I wonder if Indians have any idea of how Brazilians love and admire them. I had the honor to work at an Indian company (Infosys) and learn directly from these brilliant and outstanding people from India. Respect, friendship and admiration is what we have for you guys. Our culture is indeed very different, but we can appeciate and recognize the greatness in Indian people. God bless!

[@paladijagadeesh7985]

You are welcome

[@vivek1930]

Welcome , we also respect brazilian people.

[@thatgoanguy4427]

If only indian were as kind to other indians like they're to foreigners 🥲

[@we3605]

Brilliant as always. Simple, clear, and to the point. No complex wiring anywhere. Thank you Priyendra Kumar.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rioafriyanto5208]

Yesterday was my 1st Day being exposed to PowerBI. This video is so excellent and matches perfectly to my need. I had few questions about power BI and this video answered them, plus, many of new tricks were explained nicely.
I think I'm gonna watch it again to help me improve my fluency in using Power BI.
Thanks Sir!

[@vsraman85]

This is one of the best Power BI tutorial. It is very clear, simple and perfect explanations. This tutorial has clarified most of my designing doubts and this is the dashboard what i exactly looking for. Thank you so much... really good work..

[@binggg4493]

Thank you very much for sharing. So far, this is the best tutorial I have ever seen - clearly explained the nitty-gritty of each method.

[@vijayt3678]

I must say you are a gem of person with clean and precise explanation about lot of topics. Thank you so much for your efforts and now we have some expectations from you in the future as well with some other topics. More power to you..

[@AnandSinghNoida]

Brilliantly explained every thing in a simple way, clear, and to the point. Thank you so much great Job.

[@ailenecarreon]

This is the best tutorial I've seen on Power BI by far (and I have watched so many). Thank you so much. This is such a huge help.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pawansharma-wo3xh]

Well explained .
And as always very nice explanation.
Thank you so much PK
You are one of the best excel expert on youtube.....

[@bntenza]

This is amazing dash board I have seen so far, its magic. Excellent explanation as well.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@akshaykalamkar1545]

Data for download?

[@rochellerobinson939]

Another great course! I really like that you always provide a practice file!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mensahacquah6194]

@@PKAnExcelExpert please kindly help me with the practice file

[@arpitmalviya6234]

Hats off pk sir. I came to know 4_5 new things , even after working for 1 year in powerbi

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@akshaykalamkar1545]

Where is the data for download

[@razzrazz9697]

Hi

[@ThePunisher005]

Love this presentation, straight to the point and very informative. I have learned allot from watching. thanks allot for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vipinpalsingh9760]

@@PKAnExcelExpert ..how could we get the data for download for this dashboard..i think data is missing from the shared link

[@michaelkulbe9930]

Super Arbeit. Ich war auf deiner Site. GENIAL! Mach weiter so! Grüße aus Deutschland. Vielen Dank für die tollen Inspirationen.

[@rahulk4254]

This is Exactly What I was looking for. Thank you. Keep Posting.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bmwslamdunk]

No other tutorial better than yours, real learnings here!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tejaswikc5370]

Excellent explanation ,Thank you so much . you have changed my perception about PowerBI

[@mrittunjoyroy3246]

The way you delivered, just incredible!! Thank you..

[@PKAnExcelExpert]

Wow, thank you!

[@boneswoodwrx]

Amazing! This is a huge help. Thank you for doing these tutorial videos.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kaushalyarajak4839]

Thank you so much for making this video. I was struggling to create a dashboard for the same requirement for last few days and you just saved me. Thank you !

[@PKAnExcelExpert]

You are very welcome🙏

[@pekahon]

Gosh! I made a similar dashboard with hard way and it took weeks to collect the data. Now I know how it should have been made.

[@nipendrabulathsinghala664]

I am Sri Lankan. This video of yours is very valuable. ThankQ very much.. 🙏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohdmuzammil3059]

Just one word Outstanding explanation 👌

[@vamshiabhilash]

Sir you have no idea how much of help was your tutorials to me especially in designing Bi dashboards I was able to land a descent job as well thank you soo so much looking forward to learn more power bi from your videos as well

[@PKAnExcelExpert]

Glad I could help!

[@SN-ty3hg]

Thank you for make detail step by step make this dashboard. Nice job !

[@PKAnExcelExpert]

Glad you liked it!

[@ap2650]

Thank you so much for all the inspirations! This is exactly what I want - an absolutely detailed step-by-step explanation for beginner, yet all the tips, features and ideas are so fantastic that they are indeed "beyond" the beginner level! I would like to continue to hone my PBI knowledge with your videos!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@claudia-rp2xl]

Excellent . Thank you very much fir all the explications. You answer so much of my questions . Great Job

[@davidsalazarbullon7633]

Simple and amazing!!, great job with the explanation!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@powerbis.1794]

Dear Lecturer, you are very gifted teacher thank you so much for video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@anilkumar-vm5bd]

Thanks PK Sir for explaining step by step. I was looking for this only in RUclips.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Hrifudusowo]

You’re a god sent. God bless you fam!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@aswinqtpi803]

One of the best that i ever come across thank you Sir!

[@bodhanandannhattuvetty3179]

Well explained. I learned many things after watching and practicing this. Excellent effort by PK. Thank you, PK.

[@PKAnExcelExpert]

Glad it was helpful!

[@user-ih7ot7vl8u]

Always, you are given to us a good explanation

[@HanaaGhaly]

Hands down the best PBI tutorial ever.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bunkoti]

Really great video. Can you please create some DAX videos? Your lessons are very helpful for people learning on their own. Thanks.

[@chikstnt]

Thank you for taking your time to share your knowledge with, just a question regarding creating column (year, month, quarter and day) in Date dim table is there a purpose behind that or we can just use the first culmn.

[@kennethchukwu6018]

This video so excellent and very simple to follow especially how you used power point to create your background and your tooltip method 100%. I will look for more of you videos. Thank you.

[@PKAnExcelExpert]

Glad you enjoyed it!

[@rameshdurgam3589]

HONESTLY ... you're just transforming knowledge without single penny.
Thank you sir

[@PKAnExcelExpert]

Most welcome

[@PrashikPatil]

Your awesome @p.k.. I follow you from last 2 years and I learned lots of new things from you. .. Thank you..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@k.manisekar1591]

Dr Ji
Ur all vedios is excellent, need inventory management and accounts vedio

[@shabnamkhan7235]

This is so amazing, thank you for sharing this with us. Keep up the good work!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@manishlalsah8075]

Thankyou sir , by this dashboard I learn lots of new things.

[@farzadsaedi1954]

Fantastic, finally I found well oil. thank you

[@pitamberbisht5786]

This is reallly good enough. I impressed enough with tooltip which I really don't know. Thank you for sharing Awesome Dashboard!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@balbirsinghkalwan4729]

Big round of applause for you PK.. 👍👏👏👏lot more to learn from every video.. It's amazing and very beautifully explained. Let me know how to connect with you for any questions and advice. Do you take sessions or classes? Really want to join that and enhance learning.. 😀

[@WalterHS2000]

Excellent video really shows how to build dashboard clearly and quickly.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@casompallipraveen860]

Thank you very much Mr.Pk I got stuck in Calender auto date which you shown in this video really appreciate

[@AshokKumar-sy2qt]

Sir you are super. you are a sun light for the users who are willing to learn new tools. :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@raghavendrasingeetham2243]

From scratch to until Dashboard presentation it is simple and clear and concept based. Thank you for this great video. Shall i download excel file which you have used for my practice as well.

[@Arctico988]

a great video, thanks for sharing. It would be lovely to get formulas explanations as well! Keep going

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@KhalilAhmad74036]

You are a brilliant teacher, sir,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jaitiwari241]

Ur way of explaining concept is amazing.. Plz upload more such power bi dashboard 🙏

[@PKAnExcelExpert]

Will upload soon

[@AshishKumar-dc2zd]

Thanks for this Awesome Dashboard. 👌 PK bhai excellent 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jananiingarshal1777]

Thanks a lot and need more videos like this. You have shown as simple as anyone can understand and in a very simple language. Thanks much... please upload more on dashboards.2

[@PKAnExcelExpert]

Will upload more.. Thanks🙏

[@yousifmohammed4841]

Lovely tool and great explanation,Sir!

[@PKAnExcelExpert]

Glad you liked it!

[@MUSICA1742]

You are doing an excellent job. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@danezuzu5768]

Pk you are a great teacher

[@PKAnExcelExpert]

Thanks

[@lynniseharrington2476]

You are amazing! This was super helpful and so easy to follow along

[@PKAnExcelExpert]

Thank you so much!

[@sajidmuhammed1484]

Bravo! Excellent video. Keep it going...PS: cue power of Scatter Charts!

[@PKAnExcelExpert]

Thanks!

[@debuvlogs20]

Great Video It will enough knowledge how to create any dashboard in Power BI..Thank you..Please make more video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mzeeshans58]

Very well explained video.Keep it up thanks

[@PKAnExcelExpert]

Thanks for liking

[@GauravKumar-hl8nj]

Hi Gud Morning Sir, These tutorials step by step beginners to advanced level skills are best qualities......... Plzzzz Sir Kindly request you to please provide tutorials in hindi also.....and I request you to Plz how to put more formulas and functions with tips and tricks provide more information about Excel spreadsheet maintain data analysis in Excel and Advanced Excel with dashboard........more........ mostly best tutorials........

[@user-ft9tp4ss2d]

WOW. Superb Sir.. Thanks you are my Guru from now onwards. Your explanation had great flow.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-ft9tp4ss2d]

@@PKAnExcelExpert Thanks Sir, If I hide those Tool tip pages, those tool tips will be showing in the Dashboard while highlighting those visuals?

[@PKAnExcelExpert]

Yes

[@user-ft9tp4ss2d]

@@PKAnExcelExpert Thanks Sir, Anyway I will hide that and publish, Sorry for the silly question :)

[@ilikedigitallogic5059]

Very good clip video thanks for your transfer knowledge :D

[@harrydre]

Thanks for this video, I have learnt some skills that will be implemented in my next project.

[@PKAnExcelExpert]

Glad it was helpful!

[@Olu_boomie]

Thanks so much for sharing this PK

[@hp7557]

Thanks for sharing 'Awesome' Dashboard....! Excellent indeed.. .. ..! Wowww

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@worldishere4178]

You are the best and our ideal 🥰🥰🥰

[@yurisousa7161]

This is SUPER excellent. Thank you so much. 1 question, if I need to keep adding data on the initial excel file like next months to come, how do I get the new data into this dashboard?

[@PKAnExcelExpert]

You just need to refresh in Power BI Desktop (Refresh button is available on home tab) then publish it again. Alternatively, you can install the Gateway and make the schedule refresh also.

[@patipattadajan5638]

Great video I have seen the power BI so far, thank you for sharing a gread thing

[@sambhunathchakraborty]

Thanks alot Sir for Simple Presentation with great example.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sambhunathchakraborty]

Sir how "Date dim" table can be created for "April To March" or Qtr1 =April to June and so on ?

[@bittujha1571]

Worth watching your video. Keep up the great work you are doing. Thank you. :)

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@nathanstamford1215]

Thank you for the video... great help

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Jimizr]

Boss you are doing an exceptional job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pallavi_joseph]

Very good AND Informative

[@PKAnExcelExpert]

Thanks 🙏

[@SuperDavidFz]

Eu amo esse canal

[@SujathaS-sx3kg]

Clean and neat explaination, can you make the video for predictive analytics in PBI, then it will be very helpful. Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video

[@sanjeevkumar-iy7st]

Hi Sir, Thanks for the detailed video. I have few doubts why the YoY growth % for product base scatter chart is coming in Negative?

[@hiteshjoshi3148]

Thanks for the dataset sir i appreciate that.

[@mukeshpatil2]

To the point explanation. Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@mahammedrafia1269]

Hi !! Really a great video and i want to clarify one doubt. When we transform the data and make some changes to the data, these all the changes, may i know where it will be stored? Is there any storage thing for the modifications if we made(In transform data). If YES please tell me. Thanks in advance.

[@sonamtamang6096]

Really helped thank you !!

[@PKAnExcelExpert]

Glad it helped!

[@Mahalakshmi_Nandhakumar10x]

Great Effort and So Informative, Thanks a lot

[@PKAnExcelExpert]

You are most welcome

[@balrajvirdee1087]

Thanks so much, very informative.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@trendingsocialthings6799]

Covered many things..thnx...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@yiyo24]

Thank you, i learned a lot.

[@debbyskitchen_by_funmi]

Excellent video, very detailed!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dibassimohamed5514]

Thanks you a lot. I will master your video. I don't know how to thanks you. So thanks you for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dibassimohamed5514]

@@PKAnExcelExpert Thank you for your reply. Just to inform you, I am learning a lot through your video, I notice out that the color mapping of YoY Sales Growth% is pointing to Budget Variance % instead of YoY Sales Growth%. Again thank you, this from far one of the best if not the way to hands-on PBI.

[@sidhantgi899]

Bhaut hee badiyaa

[@saagarpatil8890]

Awesome PK.. I'll make habbit now to check your page on daily basis to learn new things about Power BI, Also please help us with Automation Anywhere 2019 examples if you have

[@LokeshKumar-yi3ln]

Vary easy to follow good one..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@michelkant]

thanks for sharing! Great tips included.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@munirathnam1691]

Thank you Sir. Very clear, touch in point. It's really useful, and beautiful. Please could you give me the table source data? Then, I can follow the steps for practice Sir.How to download same excel file sir

[@nd_m75]

Very informative...clear and concise

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RajendraPatel.]

Tooltips is awesome 💕

[@PKAnExcelExpert]

Thanks

[@Mojochetan]

Thank You Sir
I have a question, do we need to create a seperate tooltip page everytime, if I want to show different data as a tooltip for different columns of single table.
Or any other efficient way?

[@arbazahmad7177]

Very clear explanation 👌 Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@willmoney9493]

Very cool, congrats

[@saransewatadul696]

That's great and very helpful. Thanks🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback