Power BI End to End Project in HINDI | Data Analysis on Maven Pizza Challenge | Interview Tips
Вставка
- Опубліковано 14 жов 2022
- Can you become a Successful Business Analyst? Calculate your score and check it yourself.
topmate.io/analyticalguy/132311
--------------------------------------------------------------------------------------------------------------------------------------------------
What you will be able to do after watching this video for 1.5 hrs :
1. You will be able to analyse any dataset
2. You will be able to create your own schema (Data Modelling)
3. You will be able to create a Basic Level of DAX calculations
4. You will be able to understand the approach from a Power BI Developer point of view.
5. You will be able to understand Power BI Interview basic questionnaire.
In this tutorial, we will be implementing complete Microsoft Power BI Projects end to end. Right from requirement gathering to publishing the report. We will be importing the data from CSV files, and then cleaning and transforming the data as required. After that, we will apply various DAX & Calculated column calculations to compute our requirements. After that, we will focus on UI enhancement to make it more readable.
These videos will get to complete end-to-end knowledge of projects.
I will also tell you how to convert the time into the nearest hour so that we can analyse the hourly orders received by the restaurant. This metric is one of the most important KPIs for this analysis.
Please watch this video till the end to understand the overall concept.
Concepts covered:
Data Gathering
Data Cleaning
Data Modelling & [Star Schema vs Snowflake Schema]
DAX Calculation
Row-Level Security (RLS)
User Interface (UI Enhancement)
Calculated Columns
Working on Power Query
Dataset -- drive.google.com/drive/folder...
#powerbitraining #powerbitutorial #powerbi
I'm new learner of Power BI and i have watched n number of vedios but your vedio is full of knowledge and complete guide for me learned so much for you .. thankyou very much for this vedio
Hi Abhishek, I’m glad you benefitted from this… happy to help always 🙏🙏
I have created a column chart. sales and no of order card also made but when I click on any month my values don't change it shows data in the report. why is it so?
Thankyou So much sir.. I learned a lot from this video.
I’m glad you liked it Sukhpreet 🙏
Great tutorial, I got to know the steps involved in Power BI project 👍👍
I’m glad that you liked it 🙏
Amazing work really helpful.
I’m glad it was helpful to you!!
where can i download pizza data ?
can we use related function on the place of lookup in dax...bcz i saw there is relationship between pizza_id
Hi Seema, yes we can use Related function if there is a relationship between the two tables.
Thank you so much
Please make more videos on Data analyst project using powerBI
Sure Dilnawaz 👍
How to remove AM/PM from time. eg 11:23:45AM
Why you have again divided by this (60*24/30)
I genuinely appreciate your efforts 👌👌👌👌👌❤❤❤❤
Thank you Amit. What topics do you want me to cover ?
best explanation , such a cool way of explaining , plz make more power bi project videos
Thanks a lot for your kind words 🙏
@@analyticalguy plz make a discord channel so we can discuss with you
we can also use Related function to bring price in order_details table....
price = Related(pizzas[price]);
Yes Mahesh, that is right 👍 which DAX function do you use regularly? (Which one is your favourite?)
Superb, Thank you
Thanks Ubaid for the support.
Thank You so much sir
Thanks for your kind words 😊
Yese hi vedio bata o plzz bohot ache se sikhaya
Thanks Pragati for your kind words 🙏
Too great...
Thank you so much 😊
Great tutorial ✨✨
I am glad you liked it.
Sir what we can name the schema , is that snowflake schema or star schema
its star
In Power bi Errors and resolution ka koi videos hai to share links also for power query
Hi Umesh, yes I do have, will share them in the community. Stay tuned!
Sir can u help with the seat/table utilisation part in this dataset
Hi Rahul, I won’t be able to make a separate video on that. I’ll share the PBIX file with you.
@@analyticalguy Thank you Sir
@@analyticalguy Would you be willing to share that file with me?
Hello sir , where can i get this pizza related raw data for practice ?? please help me
www.mavenanalytics.io/data-playground?search=Pizza check this dataset.
Instead of look up function we can also use related function na
Yes, you can. But with some limitations.
Thanku so much
You're welcome, Kedare!
very helpful✌
Thank you 🙏
it is possible to learn power bi by my own and how log it take
Hi Sandesh, you can definitely learn PowerBI on you own without paying anything. Time duration will depend on your existing knowledge, but in general someone can learn the basics of PowerBI in a week.
Hi Sir, Really appreciate your efforts for such good quality content video.
Just wanted to ask a quick question, Can you explain how did you calculated Custom_Time.
(I would appreciate if any one from viewer can also explain this)
Hi Rushi,
The purpose of custom_time is to get the round figures of each time value. For example- 11:57:40 should give me 12:00:00
To achieve this
1. Convert the datatype from time to numeric.
2. Multiply this number with the time duration you want in between the two adjacent times
3. Apply round function to get the rounded figure
4. Divide this number by the time frame you multiplied in the step 2
I hope this helps..
@@analyticalguy Thank You Sir for clean explanation and quick response.
@@rushisukase2281 you’re welcome Rushi 👍
Hi. Great content and command over teaching technique. Do you have any online classes or Can you recommend a good course to learn all about power bi options. I want to create matrix with cumulative increase of same every hour how will be able to do it.
@@akshaysawant9573 Hi Akshay, if you have any doubts related to PowerBI, you can share the problem statement on my email id and schedule a call with me. I would be happy to explain the solution. Thanks!
Email ID: analyticalguys@gmail.com
Schedule a call: topmate.io/analyticalguy
Thks a lot sir
Thanks for your kind words, Pragati 👍
Its Really Good
Glad you think so!
Hi Sir, Really appreciate your efforts for such good content with easy explanation
One thing I wanted to ask is, from where we can learn all the formulas used in DAX?
Thanks Preksha for your kind words. Did you get the chance to view DAX playlist? I have created some videos for beginners.
Thank you @@analyticalguy I just watched one of the Dax videos of the Playlist, and that is too good, very well explained. Thats what I wanted.
Thankyou so much!
@@prekshasharma1216 I’m glad it was helpful to you. 🙏
Do you have this project in English Version?
Hi Dharsha, I’m sorry this project is not available in English. If you want to learn any particular concept mentioned in this video, you can connect with me on analyticalguys@gmail.com I can help you. Let me know :)
Bro iss data ko excel ya python used ker ke clean nhi ker sakte kya?
Yes, we can do that!
@@analyticalguy kis per easily clean ho sakta hey
where can i food good free data sets to analyze?
Hi, you can find datasets on www.kaggle.com/datasets, www.data.gov/, datasetsearch.research.google.com/, data.gov.au/, github.com/, registry.opendata.aws/
Hi Sir, I would love to have a complete course on DAX. Your videos are helpful.
Thanks for your kind words. Will surely make a comprehensive tutorial video on DAX.
@@analyticalguy thanks sir
Nicely explained sir...
Sir I want to learn end to end DAX function. Any suggestions from where I can learn that....
Hi Tharun, to learn DAX, you can start from this playlist, and then I’ll be adding more videos soon that will help you learn them. ua-cam.com/play/PL_JkuH1QNmGH6cvdvrQ7047i3AQ1q9ek2.html
@@analyticalguy
Thank you sir.
I have one request, can you please bring an end to end project of medical or health care related video on PowerBi..
Though I don't have any datasets regarding the medical or health care. Just asked you to make a video.
Thank you..
@@mrtharunprao Sure Tharun, today I will be uploading a video on Sales Dashboard analysis, soon I will be creating an end-to-end project on Healthcare.
@@analyticalguy
Thank you sir....
Hey, Brother plz help..I want to become a data analyst and I have a few yrs experience in BPO jobs, but now I have a long career gap. I have asked so many people but not getting a clear reply. I want to ask if I get a job by learning SQL, Power Bi, and excel with a decent salary package(3.5-5 LPA). Many people say I should also learn python, but it is not possible for me to learn python right now as my gap is increasing and also there is financial pressure. Please reply sir
Hi Jai, if you know SQL, Excel, and Power BI. You’re good to go with a decent salary. As of now you should not think about python. Once you’re doing fine, you can think of python if it’s needed to get promotion. I hope this helps, otherwise you can connect with me.
Sir how can i connect with you ?
@@macd2959 hi MacD, I’m out of station, so I won’t be able to connect on call due to limited time, though you can fix a meeting on topmate.io/analyticalguy
I'm unable to create a proper date table with Financial Year starting from April.
Okay, I’ll share the tutorial on that.
Can i put this project on my Resume
Sure Dhiraj 👍
Sir power bi sikhne ke baad kitne ka package mil jaata hai sir?
Anywhere from 4 LPA to 10 LPA. It can go up if you have accumulated more technical & Domain skill sets
@@analyticalguy sir abhi Mai python, pandas, pyspark, power bi and SQL Sikh rha hu.
I have 15 years of experience of mnc in ms word and Excel and html,
Package shi mil jayega kya sir
Yes, if you get practical knowledge of Python, SQL & Power BI, then you have a great chance to get better package. But study strategically rather than trying to learn everything at one go.
Finally done
That’s great 🙏
this is very nice video
Thank you Sudeep. 🙏
@@analyticalguy plz give me some internship or work under you..... i want to learn..... i want to become data analyst lile you
@@sudeep246 hi Sudeep, can you share your resume and mention your area of interest in the mail. I’ll check if I can help you.
Mail me at analyticalguys@gmail.com
@@analyticalguy done sir
@@sudeep246 I have received your mail. I’ll let you know. 👍
Plz bring videos on power bi project
Sure Sakshi, I have plans to provide end to end PowerBI projects. I will be uploading in this month.
@@analyticalguy tysm
Sir, do more real world project advance level
Soon I’ll be sharing advanced real time projects. Stay tuned !
Ap live class lethe kya
Not planned as of now. But I give online consultation and guidance.
Sir power bi kya course banaona sir
Yes sir, looking forward to a course
@@kristennaa thank You sir
Sure, will be making POWER BI course in my upcoming videos
Please make more videos on projects
Sure Kadi
Football project
your communication also good ,teach in english only please kind request,everyone knows english
Thank you Dinesh 🙏🙏
@@analyticalguy hindi me bolo bhai sirf jayde views milenge
Ye India yaha Hindi hi chelegi ky Desh ki rashtriya language hai
@@sayyedsahil4184 thanks Sayyed for your suggestion. But for some time I’ll be continuing with English 🙏
@@sayyedsahil4184 let me know if you want me to cover any particular topic 👍
It's really nice how you explain things. Please share your email address so I can send you the file on which I need your assistance to analyze data
I’m glad you liked it Ash.
You can mail me any query on analyticalguys@gmail.com