Power BI Project Tutorial from beginners to Advanced | Step-by-step guide | The Developer
Вставка
- Опубліковано 10 вер 2024
- Download Now :-
thedeveloperyt...
Touch My Heart ❤ / @the-developer-bi
📂Data Source Folder Link-
drive.google.c...
🌍Social Media :-
Instagram : • / thedeveloper.yt
Linkdin : • / the-developer-407024292
Telegram : • www.t.me/thede...
Welcome to our comprehensive Zomato Power BI Dashboard tutorial! Whether you're just starting out or looking to enhance your skills, this tutorial is designed to empower you with the knowledge needed to create impactful and visually stunning dashboards.
Explore the world of Zomato Power BI with us! From foundational concepts to advanced techniques, we've got you covered. Expect to learn about dashboard creation, data modeling, and more. Whether you're a beginner or a seasoned user, there's something valuable for everyone in this tutorial.
In-depth Insights:
In this channel, we dive deep into Zomato Power BI's advanced functionalities including AI integration, automation, and API utilization. Learn how to craft dynamic dashboards, master data modeling, and gain insights into essential administrative tasks. Additionally, discover the art of data cleansing, drill-down analysis, and best practices in dashboard design.
Discover the potential of AI-powered visuals within Zomato Power BI. Our tutorial promises an engaging journey for both novices and those seeking advanced skills.
Whether you're seeking a crash course or a comprehensive Zomato Power BI experience, we've got you covered. Join us as we elevate your data analytics capabilities, starting from the basics and progressing to expert-level insights. We look forward to embarking on this Zomato Power BI journey with you!
Music Credit :
Track: Crushed Candy - Oh My Gawd [NCS Release]
Music provided by NoCopyrightSounds.
Watch: ncs.lnk.to/CC_O...
Free Download / Stream: ncs.io/CC_OMG
Disclaimer:
The content displayed on this UA-cam channel may include images and datasets used for educational or informational purposes only. We do not claim ownership of any shown material unless otherwise stated. Any copyrighted material is used under fair use guidelines. Views expressed are solely those of the creators and do not necessarily represent affiliated organizations or individuals.
#powerbidashboard #dashboarddesign #PowerBI #PowerbiProject #datavisualization #powerbitutorial #datavisualization #dataanalysis #dataanalyst #powerbipro #powerbideveloper #DashboardDesign #DataVisualization #DataAnalysis #BIReportDesign #powerbidesktop
Copied comment-------------
Bro, thanks a lot for your dedication. You are doing amazing work.
From now on, I want to request to bring dashboards that are more focused on problem statement, technical kinds of stuff like power query, data modeling, and more DAX for each calculation (instead of using existing columns).
You can just add brief details about the problem statement, but, freshers and even experienced watch dashboards on UA-cam for more understanding on technical concepts. Its fine if video will be more than 1 hour. In real project client dont bother about design layout but they want correct numbers. You can just use your creativity like this but long story short give more technical knowledge on power BI.
Once again thanks and keep up the good work..
So plz consider my request.
@@perfectionist6624 Duly Noted! Thank you , for the feedback.
Whole world's creator and true well wisher bless you all always and you all remember him always.
The best bower bi tutor i have ever seen❤
Oh my god..Thank you so much brother ....for making a wonderful video beginner to advanced as i prevously asked in comment section......love you brother🤩...we will always support you brother...i wish you could reach 10k😍😍 family soon....I have a small request can you make a videos in english...i couldn't understand..but i watching with english subtitles...and also it will help you to reach more peoples..if you made it in english....always we support you❤❤❤❤
A huge thank you for this much love brother ❤️ i am lucky to have you guys and love to seeing this type of support..
And don't worry i am already planning to start creating videos in English where i'll Definitely cover everything.
excel source, Google sheets , MySQL , Power dashboard Design and more with All the important summary it's a big task for me to do multiple things individually i need some time brother ❤️😊
Again thank you❤️
19:34 even after putting the filter the value still remains 148k {individual rating for veg non veg and others}
Bro u should increase the price of project wch ur selling, u deserve more than what ur selling for.
Beautiful content. Only the language barrier. Would love it if you go 100% English. It’s a general language
Hii!
Thank you so much for this tutorial! I just discovered this channel and I'm very excited to learn through these tutorials. Thank you so much for this content.
Please keep providing English content, it means a lot to me :)
Have a nice day!
Thank you so much. :)
bro, i was getting error at 6:20 it is showing error as we cannot apply the sum operation on string vales, how to resolve this??????
Go to power query> change value type text to number
Sir i have issue in 6:24 pe yeha pe apka value 989 M aa rha hai mera sirf 23M how to solve it i tried many times but its not working
Apke units areh hoge
bro, plz bring more projects on diff domain like (hr, finance, marketing, healthcare, banking) and so on....
Hr we have already done more we'll plan bro.✅
Yes absolutely especially on banking, your videos are 🔥🔥🔥 thank you for them
@@prathameshmainkar2226 sure
@@The-Developer-BI bhai mujhe Power BI sikhna hai aapse kya karna hoga wo bolo aap..ya aapne kahan se sikha wo bata de. Jo v fee aapko chahiye Mai dunga aapko
I have learnt from my job.
And having some coding which helps in logic building...
Contact on :- thedeveloper.yt@gmail.com
superb dashboard its really amazing keep going👍
The project went well, but when im selecting a particular city, the rating and type of value is showing as blank any solution for this
Share issue screenshot on thedeveloper.help@gmail.com
@@The-Developer-BI didn't find a solution yet
Really Brother, Best channel for Power bi.
#thabk you very much for this project
Thank you brother! ❤️
best power bi tutor on youtube❤
@@hamzamalimsyba-a-9446 top n sales dax query error
Hello.
Looking at the Model view, precisely at the relationship between the "Orders" table and the "Restaurants" table, i wish to understand why the Cross filter direction between these tables is "Both", and not "Single".
Thanks.
Hello,
The reason for setting the Cross filter direction between the "Orders" table and the "Restaurants" table to "Both" instead of "Single" is to ensure bidirectional filtering. This means that not only can orders filter restaurants, but restaurants can also filter orders.
Having "Both" as the cross filter direction allows for more comprehensive data analysis and ensures that filtering works seamlessly in both directions between the two tables.
If you have any further questions or need clarification, please feel free to ask.
Thank you!
Rating_Count not changed , even after put the relation between Orders and Resturant
ua-cam.com/users/shortstOvSK4ZpNOM?si=h2hWaxAS7hd5VWFb
Thank you so much for this tutorial. Really learnt a lot. Thanks for the data sources as well. Aapke karan mein ye confidently keh sakti hoon k mein bhi dashboard bana sakti hoon. I have recommended your channel to my friends as well. I completed 80% of this dashboard successfully but got stuck in the last section of the second part of this tutorial. I would request you to create a full-fledged tutorial on DAX.
Thanks a lot for the wonderful motivating Feedback😊 don't worry about the issue i'll provide a solution soon. And for the DAX we'll plan in our upcoming videos...
Can you Please give the name of the section so i can provide more accurate solution.
@@The-Developer-BI In the City Performance report, after converting the Sale Value by City into a table, we add order count, gain and loss customers. While doing this, I got stuck due to the error which says, Visual has exceeded available resources.
@@KS-rs5oe oky thanks i'll debug this issue and provide solution.
please find solution:-
ua-cam.com/users/shortsbG3Jm0-P6TY?si=18Tf4nrkym-qt0c5
keep continue the good work bro , your designs are awesome
Thank you for the support bro❤️😊
19:13 one confusion is here
if total sales is 987 million
but when we see on food category
like there is
106M Non veg , 122M Veg while others are 24 million if we calculate this numbers so we got 252millions so where are remaining sales ,Kindly clear this confusion thank you
Same doubt and also the rating counts with veg, non-veg too. Is your doubt cleared?
Sorry guys Really sorry i just kissed your comments let me know if you are still having the same doubt.
19:34 even after putting the filter the value still remains 148k {individual rating for veg non veg and others}
@@Khushi-vd8ym exactly even I have same problem yaar I dono what to do nd I'm stuck there
@@ankitpant439 ua-cam.com/users/shortstOvSK4ZpNOM?si=EeYSFLMEhCalQcD9
Thanks for the content.
I have a doubt when we calculated the Sale value measure we put orders[value] as argument but that includes both amount and quantity values and for sale value shouldnt we only include the amount value?
We have an amount/ Quantity filter
im facing some issues. after applying the reletionship btn order and restaurant ,rating count values is not changing accoding to the city...
ua-cam.com/users/shortstOvSK4ZpNOM?feature=share
It is a good project but the diminution table you have shared does not contain unique key to make relation with fact table which is Order table.
Sorry for the late response ! We have uploaded one more source with Unique key unfortunately we cannot revert the video....btw nice catch!
@@The-Developer-BI you Provide two tables orders and orders type, but there is no common column in between those tables, which is leading to miscalculation of total sales , as veg or non veg
Hi bro , im trying to anlyse your dashboard, in orders table you dont have any order_id column? how will you calculate the no of orders placed by a person ,or which restaurant has more orders in a year? and like wise.... @The-Developer-BI
Due to the Order id not available we have to calculate orders from numbers of dates of order
There is no "SelectType" DAX function in Power BI, from where have you selected it?
Ping timestamp please.
when i created the order count measure I was getting double value of count, don't know the solution for that also after uploading the orders table hierarchy was already there into the order_date column
Help me with that
Could you please share your measure
Jo year wala function use kiya aap nai, I've used Order date and us mai year ka date hierarchy use kiya to make the line chart and got the same result. Kya ye bhi theek hai ya baad mai masla hoga?
Sahi koi dikkat nhi ayega
Where is the pbix file for this project? I can't find it in the description box
Join our telegram channel 😊
bhai tumhari videos ka intezar raheta hain 👌👌👌👌
Shukriya bhai❤️
bhai video edit karte time jyda animation mat dalo jyada entertainment video lagne lagta h
Theek h . Ab nhi dalta hu bro
Hello,
While, practicing, i realized that i could merge the "Food" table with the "Menu" table. But i could not merge the "Menu" table with the "Food" table. What could be the problem?
Hi there,
Thanks for reaching out. It's great to hear about your progress with merging tables. Regarding the issue with merging the "Menu" table with the "Food" table, it could be due to mismatched columns or data types. Double-check those aspects, and let me know if you need further assistance.
@@The-Developer-BI Thanks for the tip. I looked through again and realized that the problem originated from the food table. I was supposed to remove all the null values found in the "veg, non-veg " column before merging.
Thank you for the tutorial! Could you let us know where you find such datasets?
@@VanshitaMathur-j7d kaggle.com
Hello, while practicing, i was unable to display the "city" column from the "Order" table using the "Maps" display visual.
i tried changing the "data properties" to city, but still got the same issue.
What do you think could be the problem and what is the possible solution?
Maybe some City names are incorrect or different so maps can't be processed.
Bro how do get the data can you please share me the dataset link
@@vibekprasad6174 there are two websites name kaggle and data.world where you can find dataset Based on your need
Do more real world projects Advance level
sure.
Awesome
Very good looking dashboard
Thanks
❤️❤️
I am getting an error, in filtering its showing blank values, but i have already established the relationship
Sorry for the late reply let me know if you still have the issue
@@The-Developer-BI no sir,not yet solved
4:40 my usercount is coming to be 78k despite using the same Dax formula as yours. Can you please tell me what's the error?
Can't understand by reading share issue screenshot on thedeveloper.help@gmail.com
sir agar rating change ni ho rahi toh kya kare jaise app ne kiya vaise hi same kiya par hua ni change
Watch
ua-cam.com/users/shortstOvSK4ZpNOM?feature=share
Can somebody help me out
19:34 even after putting the filter the value still remains 148k {individual rating for veg non veg and others}
ua-cam.com/users/shortstOvSK4ZpNOM?feature=share
26:17 and 30:39 par aap measure kar rahe aur kon si keyword se niche aa rahe ho jaise number diye hai
1. Top N sale =
2.
3
4
5
6
Yah counting kaise aa rahi hau
Maine table banai hai power bi ki Datatable ki function ki help se jahan par aap screen me likha hua code jab write karoge new table option choose krke same or Run krog to wo table aapki ban kr ready ho jayegi phir ...
Unme humne 3 column diye hai ek Sort krne liye ek Type matlab Top 5 se Top 100 tak phir ek or Column jisme sirf number hai....
Phir Hum Type wale ko Filter ne use karege or Un number ke according Us number ko dynamically nikal kar data dikhayenge jo bhi chahiye hai example Top 5 ya Top 50
hope apke smjh aya hoga
@@The-Developer-BI sir next enter se ho rahe hai ki shift se
@@himanshugupta3171 shift + enter
@The-Developer-BI i am getting an error The expression specified in the query is not a valid table expression for "Dynamic_topN_title = Var selectR = SELECTEDVALUE(RankTable[Type]) Var selectType = SELECTEDVALUE(orders[Type]) return selectR& " City "&selectType".
Fix last line : selectR &"City"& selectType
City , sales value , order count ke baad jab lost customer ko table mai add kar rahe tab resources exceeded bata raha usme likha try filtering to decrease the amount of data Displayed
ua-cam.com/users/shortstOvSK4ZpNOM?si=tNy4KZK5B9Gi01Zm
bro saved me today ngl
aap ka jo vejg, nonveg and Other ki value arhi hai vo meri nhi arhi hai even though i have changed the relationship from single to both but still getting the blank value when i changed the city..
Sorry for the late reply if please let me know if you still have the same issue
Getting the same error please help me too.. :(
@@The-Developer-BI help me
@@The-Developer-BI plz
This video is definitely helping, but jaldi jaldi , aur huu huu krne ke chakkar me beginner will face definately an issue, u r not saying select this then this to see this, instead showing result by huu huu
I love you for the effort and content and I will share to my colleague even, but its not beginner friendly
🥲 i am also beginners level teacher i did not done this before in my whole life and i know i am not a good teacher 🙂 but koi na me comment positive lunga definitely apko aane wali video me improvement nazar ayegi....
Or or or thank you for the love ....asha karta hu apko ane wale content se khush kr pau. .
And I like Hu hu 😂
@@The-Developer-BI Dear Creator, 1st of all thank you so much , I really wish you be among top tutor on youtube, I didn't comment in the negative way either, i really appreciate you for what you have done for people for free, people are paying for it, as a viewer bss feedback tha thoda sarcastic way, so that you and us(viewer) together built a nice place to learn and explore. Also you should not bother about my POV, you are doing great and keep doing it, I will be supporting you even, I am frontend developer, data Analyst , and Manual QA and working professional as well , let me know if i can help you in any way
@@user-ur4un3lb3i such a amezing feedback and support ❤️
Thank you so much for giving so much motivation 😊
bhai 6:20 par jese he sale_value par click karta hu toh jese apko ek no mila mere mai aa he nahi raha query jese apne dali vase he mane bhi dali hai. but error araha hai could'nt load the data for this visual karke 2 hr hou gye solve he nahi kar paa raha hiu.
Watch this :
ua-cam.com/users/shortstOvSK4ZpNOM?si=pTrU4J38rHMLZW90
Hello bhaiya, manage relaionship and menu-r_id and order-r_id also done while merging still changes not happening in cards for veg nonveg
ua-cam.com/users/shortstOvSK4ZpNOM?si=T0Ca4B-WQAeU1fbI
@@The-Developer-BI , thank you all checks done and was not happening after restarting power bi and retrying all checks it work properly
Unable to create the rank feature , slicer not working
thedeveloper.help@gmail.com send error screenshot
@@The-Developer-BI Sent
1k like done 👍 share pbix file 🎉
Photo folder not shown in power bi
What can I do pls tell me
Which photo folder?
Please Make a video on which Data is coming from API this will be more interesting in Dashboard
Oky sure
19:46 one confusion is here
if total sales is 987 million
but when we see on food category
like there is
106M Non veg , 122M Veg while others are 24 million if we calculate this numbers so we got 252millions so where are remaining sales
Also,the rating count is 148k but for non-veg its 10k, veg-12k others-14.8k. Total is 36.8k. Please clear this doubt asap.
Same doubt😮😮
Hey guys sorry for the Late reply really apologise i didn't see your comments.
Let me know if you still have the same doubt.
Bhi Developer......why you skip some important steps, this project looks eye catche but still it's hard for new learner's. Next time after completing a project , watch it very clearly.
@@mark2unofficial358 Thank you for the feedback.I agree with your point. This was one of our older videos on the channel when we were still figuring things out. If you watch our latest videos, you'll see noticeable improvements.
Why is my Rating_Count not getting affected by the Sale_Value by city? I have managed the relationship between orders and restaurant correctly, then what's the issue. Plzz do tell??
ua-cam.com/users/shortstOvSK4ZpNOM?si=5EsmfWbNtiZzHZAQ
Excellent 🏩
Is this project good enough to add in your resume?
Depending on your profile and expectations, experience
Bro can you pls tell the website from which u took this data set
Data.world and kaggle
Best video I have ever seen
Thanks Welcome to our small channel ❤️😊
19:34 even after putting the filter the value still remains 148k {individual rating for veg non veg and others}
Please teach us Power BI in real estate
Sure
Can I join your power bi class ?
Sure
Hey can we add these projects in our resume?
Sure
@@The-Developer-BI can u make a video on it?
the rating count relationship which you explained is not working when I tried anyone help me please
Did you choose the Both options in reletionship option
yes its working@@The-Developer-BI
Waiting for next part. Hope will get it soon.❤
Alredy uploaded ✅
Sir isme new measure mai query likh Raha hu aur space dekar dusri usi Mai query likh Raha but wo ho hi nahi Raha
Ek bar time ping kr do bro kis part me problem arhi h apko ....ase mujhe smjh nahi arah h ...
excelr ke sare bache ye hi dekhege
To kiya kre next mySql pr laye project?
Where did u find this data ?
Kaggle.com
Hey brother, good work man. But in my case I am not getting the rating count even after establishing a relationship. What should I do?
Are you getting blank value or value is not affected
@@The-Developer-BI value is not effected
BHAI APNE STORY BHI EXPLAIN KIYA HAI KYA ?
Konsa story
Please i cant find the zomato logo
www.pngwing.com/en/search?q=zomato
@@The-Developer-BI Please can you do another celebrity data set like akshay kumar please i will really appreciate
At 33:37 its showing selectrank cannot be created....
What error are you getting?
When I write the code for measure Dynamic_TopN_Title....and enter then it shows variable selectrank cannot be created or variable wothe same name exsist
@@Aditya_Mani try to write different Variable names like _seletectType for both of them
Didn't help
But solved
Just taken one selectRank and other as SelectType in above var
Thanks da
Bhai Dax function samjha to do...
Smjhayege
Where is the free pbx file..?? Its already 1k likes
Join our telegram channel
Please make a video on how to get data from an API using power bi
Sure...will make it
Bhaiya woh top 10 -100 vala slicer mera clustered bar chat ko change hi nhi kr rha hai
Kuch galti kar rahe hoge ap
Facing the issue with rating_count it's not charging
ua-cam.com/users/shortstOvSK4ZpNOM?si=CgJv6xoeIZBPhWpE
@@The-Developer-BI it worked but actually now the Rating_Count and Order_Count values are almost same
Great
Big Thanks❤️
bhai non tech wale hai thoda dheere dheere krwa sakte ho?
Lastest video dekho phir🙂
Can you Please Share the Data Table formula,
I am unable to implement that
Which formula do you want?
Same issue
Data table measure formula
Awesome tutorial. Can you make a video on a FIFA data with images and UI/UX like dashboards, showing players performances.
sure i am considering this is our next project.
innovative Suggestion.👌🏻
Kindly share TOP ranking measure code
In Top ranking we re-use other measures as well.
@@The-Developer-BIwhere is the code to copy ?!
bhai top 5 10 50 wala slicer work ni kr rha plz solve it
Koya problem arhi hai
@@The-Developer-BI bhai slicer bna liya code bhi shi h work ni kr rha pr
@@CHSunny99 ase problem smjh nhi ayegi dekhna padega thedeveloper.help@gmail.com screenshot bhejdo aap
@@The-Developer-BI bhai bej diya ha check kro
Hello I wanted to Purchase zomato dashboard yesterday the price was 299 rs but today its 478 can you please provide discount
Check it now!
Bro from where do i get this zomato dataset please provide us link
Kaggle
Its available like city wise one by do you modiefied all data?? Or did you get the same data if possible provide us link🙏🙏
@@vibekprasad6174 to finding the perfect data is a big task you have to search using your specific need.
How to sort slicker in order of top 5, top10, top 50
Select slicer click on 3 dots you will see the sort option.
Already tried this one but in ascending order it show top 10 first,
second top 100 then top 20 and top 5
@@GajendraTodkar ok select slicer and find Sort option on top bar .... click on that button and sort it!
Don't worry sir i figured it out
in column tool i used sort by column option its done.
Thank you for the amazing video.
Bhai ratting count nahi ho Raha hai manage relationship bhi kar chuka hu
Watch this
ua-cam.com/users/shortstOvSK4ZpNOM?si=Qmzd2pTEwhW-bPJz
Total sales is 987million and veg sales 122 non veg is 106 and others is 24 total is not coming 987
ua-cam.com/users/shortstOvSK4ZpNOM?feature=share
Mast bro
❤️😊
Bro 29:09 pe exact same Query likha hai sab sahi hai par jaisa tumhaare mien ho raha hai waise mere mein nahi
please reply kardo
Apke top filter nahi ho rahe h?
@@The-Developer-BI yes
Bro reply ni kiya kuch toh batao iss baare mien
@@atharvchaturvedi5993mujhe apka code dekhna padega ap kiya mistekr kr rahe ho ... thedeveloper.yt@gmail.com pr screenshot bhej dijiye ap
@Superb.
❤️😊
plz provide the pbix file
Join our telegram channel
Skipping many important steps to manipulate students
not manipulating it was our around 4 months old video we were in a learning period for yt tutorials.🙂
If you don't agree with me check it out our the latest vides🙂
If you still disagree Koi na will try to improve!😌
Can u sent me pibix file i already finished 26 minutes I want to see in pibix file it's really excellent video 👌👌👌
We'll Pbix file on 1k video likes...also the project in process there are 2 more pages you which we'll cover in next video
23:47 to 33:00 ka kuch smjh nhi aya bss tum bna rhe ho smjha nhi rhe kya krna hai
bro hum log City sales dikha rahe hai Top ke filter ke sath job example jab hum Top 5 ka choose karege to Top ki 5 values hume mil jayegi filter hokr ...
bhai problem isiliye aati ahi tum data samjhte nhi ho bus karna shuru kardete ho tum smart ho expert ho is feild lekin jo bhi tumahri video dekhrhe hai woh nhi hai iten expert mai khud nhi smajhpata hun ki kasie itni fast kiya hai thodi video me dataa samjhya karo or kcuh nhi ok bro
Thank you bhai for feedback....duly noted
Sir, data ka source ?
Description me
@@The-Developer-BImaine check kiya tha, par usme seperate files hai, par data kaunse source ka hai pta nhi laga paa rha (like data.world, kaggle....)
Bro I need pibix file I have many doubts
Bro we'll upload it when we complete our target😍
Bro iska 2 page or tha wo video kab dalo ge
May be Sunday ya phir Monday
bro pls upload kaggle or github link for synopsis purpose
I'll plan
6:23 I am getting error "Couldn't load the data for this visual"
ua-cam.com/users/shortstOvSK4ZpNOM?feature=share
rating_count me issue arha h solve krwa do change nhi ho rha
Relationship both hai check kra apne? On R_Id between Orders table and restaurant table
@@The-Developer-BI brother toh apni video me bhi toh karo humko kaise pata chalega
Pbix file bhi de deta toh kafi help ho jati
12:10 Bola to hai bro ....khair ap both lagalo fix ho jayegi
Join krlo telegram bro wah solution dala hai
t.me/thedeveloperyt
When next part will come
May be Sunday ⏰