Power BI & SQL Project | Data Analyst Portfolio | End to End | Beginner to Expert |

  Рет қаралды 852,473

Data Tutorials

Data Tutorials

Күн бұрын

Пікірлер: 700
@VincentBjuremark
@VincentBjuremark Жыл бұрын
Thank you for this video, you took your time and effort into putting this video together - step by step - so that we all could follow along. The quality of this content is something that I and probably many others would pay a considerable amount of money to be able to benefit from, and yet you did it for free! Thanks again!
@sumijasukumaran1394
@sumijasukumaran1394 Жыл бұрын
This project looks like real time .This makes as understand how SQL and power bi works together. Please upload python ,power bi project
@shahnawazatharkazmi2826
@shahnawazatharkazmi2826 Жыл бұрын
Dear sir same question in my mind, what is the role of python in data analyst. Bcoz powerbi already have power query editor to cleaning data then role of python plz guide us
@Freakouts_and_found_Insane
@Freakouts_and_found_Insane Жыл бұрын
@@shahnawazatharkazmi2826 here data we get clear format but most of time data we get in multiple sources in different format their python is used in which numpy and pandas library are useful
@thanhien3282
@thanhien3282 Жыл бұрын
I think so 🤔
@sasacademy4761
@sasacademy4761 Жыл бұрын
@@shahnawazatharkazmi2826 AA vP by by by by by by by Dr ko CT CT CT
@drbh6331
@drbh6331 11 ай бұрын
​​@@shahnawazatharkazmi2826first of all python had less role in data analysis its more towards data science and data engineering
@shahnawazatharkazmi2826
@shahnawazatharkazmi2826 Жыл бұрын
One of the best project for power bi available on youtube
@datatutorials1
@datatutorials1 Жыл бұрын
Glad you think so!
@TiamiyuAjibola
@TiamiyuAjibola Жыл бұрын
I'm really grateful for the immense knowledge I've gathered from you. Within 2 months I've designed 3 completely interactive dashboard with you. . 2: Please, try and always include data dictionary of each dataset for those of us that are documenting. I've documented the Ecommerce, HR and working on this pixza dataset. Thanks once again
@terihandrick2333
@terihandrick2333 9 ай бұрын
I know I am seeing your video late but wanted to thank you so much for taking all the time it took to make this video for everyone and walk step by step through your process. So very kind of you to help those of us trying to master the whole PBI project/process.
@nilosamson5982
@nilosamson5982 11 күн бұрын
I can't pay for some paid tutorials but watching this is more than enough for me to learn a lot in one video. as a way of me thanking you. I didn't skip every advertisement. I finished every ads without skipping and hoping you get paid on it. Thank you very much
@er.sarthaksananse1704
@er.sarthaksananse1704 Жыл бұрын
One of the best KZbin channel for all Aspiring Data Analyst 😊
@haseebahmed9953
@haseebahmed9953 Жыл бұрын
Your dedication to sharing expertise is commendable, and your video significantly contributed to my learning journey in BI. Thank you for your valuable contribution; I look forward to exploring more of your content.
@SamuelOlujide
@SamuelOlujide Жыл бұрын
I want to appreciate you for the time spent and dedication to this work to instill the basic requirements and the needful things to know as a data analyst. I would love you to make a video on how to display our dashboard on our web page, Please.
@AnilKumarNyatha-l8o
@AnilKumarNyatha-l8o 11 ай бұрын
Thank you so much! Your explanation is clear and easy to understand. Anyone looking to learn Power BI from beginner to end, this is the best practice. Thanks again!!
@omotayocrownwealth4745
@omotayocrownwealth4745 9 ай бұрын
I'm amazed by how proficiently you demonstrated the use of both SQL and Power BI in a single project (start to finish).Your approach makes it easy to comprehend and practicalise, yet simple to follow, even for an average user. I am happy to have encountered your work. Thank you for sharing your expertise!
@datatutorials1
@datatutorials1 9 ай бұрын
Thabks
@athanaaa9846
@athanaaa9846 Жыл бұрын
Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤
@RK-hg4ti
@RK-hg4ti Жыл бұрын
At 1:20:14 select "match entire cell contents" option in advanced options. It will helps to reduce iterations.
@fswarsi
@fswarsi Ай бұрын
Incredibly insightful video on KZbin of end to end project of Data analysis.
@InsightswithArselane
@InsightswithArselane 11 ай бұрын
Just wanted to take a minute to say a huge THANK YOU for all the amazing content you create! Your videos have been so helpful in my learning journey, and I'm seriously grateful for your willingness to share your knowledge with the world.
@raymondbarnes5264
@raymondbarnes5264 Жыл бұрын
Absolutely amazing video, I have finally realised that as a beginner in the financial investment market, you can achieve close to nothing yourself because you still have a lot to learn. Trading with a professional broker is more profitable and my advice for beginners is to always take advantage of that.
@greenquake11931
@greenquake11931 Жыл бұрын
Instead of timing the market, you should try to diversify your portfolio in order to get a dollar-cost average when it’s time to retire. Keep in mind that you don't need a ton of money to invest. Investing in small amounts can build long-term wealth too!
@stellamoore720
@stellamoore720 Жыл бұрын
I'm an amateur making terrible picks and I really need assistance.
@mayacho4910
@mayacho4910 Жыл бұрын
Trading is Profitable with the help of a seasoned broker managing your trading account.
@raymondbarnes5264
@raymondbarnes5264 Жыл бұрын
@@stellamoore720 'BRIDGET MARY TUROW"".
@stellamoore720
@stellamoore720 Жыл бұрын
@@raymondbarnes5264 How can i reach her?.
@girishchavan1245
@girishchavan1245 8 ай бұрын
Thank you so much Sir , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt so many things.
@datatutorials1
@datatutorials1 8 ай бұрын
Glad it helped
@swarupasahu700
@swarupasahu700 Жыл бұрын
Beautifully explained each and every concept. As I am new to power BI ,it is so helpful for me to understand the end to end process. Great work 👍
@BrokenButton
@BrokenButton Жыл бұрын
This was great, thank you! One thing I did notice when adding an additional column for the day of the week (on Building the Monthly and Daily trends) is that the data on the excel sheet has a large amount of dates not formatted correctly, or different, and it shows as blank when transforming the data. When making a bar chart with this data, it shows around 29k blank spots for the day.
@roqibahaderinto1879
@roqibahaderinto1879 7 ай бұрын
Hii I'm having this same problem Did you manage to solve it?
@Techbruu_AI
@Techbruu_AI 5 ай бұрын
same problem, did you solve it?
@cc6796
@cc6796 6 ай бұрын
The way you explained the concepts from begining to end, made it really easy for us to understand it. Thank you so much for sharing your knowledge and the effort that you put in is commendable.
@richajainer
@richajainer Жыл бұрын
I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.
@amaansiddique4759
@amaansiddique4759 6 ай бұрын
Definitely I have learnt a lot from this end to end project , plss make a real time project more and more atleast two in a month
@SYEDKASHIFALY
@SYEDKASHIFALY 10 ай бұрын
sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect
@janellegomez4207
@janellegomez4207 Жыл бұрын
Thank you so much for teaching us how to do this project. The dashboard is beautiful!
@MD.ANISURRAHMAN-m9k
@MD.ANISURRAHMAN-m9k 8 ай бұрын
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
@vishalrathore2854
@vishalrathore2854 Жыл бұрын
You are a pro in terms of explaining and providing valuable content to us. I have learned many new and important steps help me to groom myself more widely. Thank you so much for the help.
@datatutorials1
@datatutorials1 Жыл бұрын
Glad it was helpful 💐
@ishankhanijo4591
@ishankhanijo4591 10 ай бұрын
This project walkthrough has been very helpful. Thank you sir!
@santhuzestvlog7330
@santhuzestvlog7330 Жыл бұрын
Thank you for sharing your knowledge. I understand you have connected the SQL server to Power BI but you didn't use the queries that you created. I see you have used only DAX functions in your visual then what's the purpose of creating queries in SQL. I just wanted to learn! But very informative session
@RaviKumar-dc2gy
@RaviKumar-dc2gy 10 ай бұрын
1:51:00 for stacked graphs, how to avoid the overlap of data label
@prratimaakaroshii5525
@prratimaakaroshii5525 Жыл бұрын
Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.
@swetaswarnkar6927
@swetaswarnkar6927 Жыл бұрын
I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch
@Piku.aka.Priyanka
@Piku.aka.Priyanka Жыл бұрын
Really wanna thank you to explain everything bit by bit ,it was so so helpful.Loved the video and I learned a lot through this video.
@BignmnShop
@BignmnShop 10 ай бұрын
in the comfortable way the lesson is prepared, really helpful.
@datatutorials1
@datatutorials1 10 ай бұрын
Glad it helped you ✨
@gamers5153
@gamers5153 27 күн бұрын
Best project available on KZbin thank you so much sir
@kevinndungu4511
@kevinndungu4511 Жыл бұрын
Amazing Amazing this is one the best well walked through project from start to end i have learned a lot keep up the good job!!
@datatutorials1
@datatutorials1 Жыл бұрын
Great to hear!
@Prabhakaran-hp1to
@Prabhakaran-hp1to Жыл бұрын
Thank you so much for very clean and easy way you explain all from beginning.
@thakurarvindrasingh7093
@thakurarvindrasingh7093 7 ай бұрын
First of all Thanks a lot because your teaching way incredible. I have never seen and watched like this video before. I really appreciate you to do this work, Definitely you are the wonderful personality as we as wonderful human being, I pay to god gives you happiness and prosperity Thanks a trillion again.
@karthikvijay5626
@karthikvijay5626 7 ай бұрын
bro have you downloaded SQL server managment Studio ?
@thakurarvindrasingh7093
@thakurarvindrasingh7093 7 ай бұрын
@@karthikvijay5626 Yeah Sir
@karthikvijay5626
@karthikvijay5626 7 ай бұрын
@@thakurarvindrasingh7093 brother could you help me to download ms SQL server & sql server management studio
@mukamafrancois2776
@mukamafrancois2776 Жыл бұрын
Wow, thank you so much for this incredible Power BI tutorial! 🙌 Your explanations are clear, and your step-by-step approach made it so easy for someone like me, who's relatively new to Power BI, to follow along. I've been struggling with some aspects of data visualization, and your video not only clarified those concepts but also gave me the confidence to dive deeper into Power BI. Your dedication to helping others learn is truly admirable. I can see the effort and time you've put into creating this tutorial, and it's greatly appreciated. Please keep up the fantastic work! Looking forward to more of your tutorials. 💪
@Saviyu_lil_munchy
@Saviyu_lil_munchy 9 ай бұрын
Thank you somuch brother , I have done several dashboard by watching others tutorial. I personally felt this is the best . That too for free . I have learnt somany things. This is the first vedio I watched . As you said " I liked , subscribed and commenting ❤👏
@datatutorials1
@datatutorials1 8 ай бұрын
You are most welcome
@datatutorials1
@datatutorials1 8 ай бұрын
Thank you
@owenonyango7075
@owenonyango7075 Жыл бұрын
i wish i could like this a thousand times. great work.
@datatutorials1
@datatutorials1 Жыл бұрын
Wow, thank you!
@govnny
@govnny 9 ай бұрын
Hi, thank you for the tutorials. This is my 2nd I am replicating from your channel as practice for interview. I am using mysql as I could not set up the server process for sql mgmt studio. In mysql many functions are either changed or not functioning so i got stuck at DATENAME query at 46:30. Solved this step today with DAYNAME, str_to_date and coalesce, as the order_date column was imported as text by default and the date data is formatted in 2 different ways: d/m/y and d-m-y. if someone is interested, this is the query: SELECT DAYNAME(coalesce( str_to_date(order_date, '%d-%m-%Y'), str_to_date(order_date, '%d/%m/%Y')) ) as Order_day, COUNT(DISTINCT order_id) AS Total_Orders from pizza_sales GROUP BY Order_day ORDER BY Total_Orders DESC
@mansimahajan388
@mansimahajan388 5 ай бұрын
thank u so much for ur comment...i have literally been struggling to resolve this issue and tried every possible way to fix it but failed but the code u provided worked perfectly....can u help me with one more thing that if he is using dax functions whts the use of SQL queries.
@faranbhutta1349
@faranbhutta1349 Жыл бұрын
Beautifully explained each and every concept
@slycop221
@slycop221 Жыл бұрын
THE BEST YT CHANNEL FOR PROJECTS
@InnovationInflux
@InnovationInflux 6 ай бұрын
A great learning and beautiful visualization. Thanks ! Small suggestion to always create a date & time table and link it to the main table. this will reduce the complexity in main table and would query the results faster.
@mohammedgamal7509
@mohammedgamal7509 10 ай бұрын
I truly appreciate your efforts, thank you for the clear and straightforward explanation. I comprehended everything in the video, and you've contributed to enhancing my skills.
@abou19850
@abou19850 Жыл бұрын
Excellent Job, thank you very much for this clear Demo! It would be great if we could have same for Tableau and QLIK. Many thanks for your work sharing.
@datatutorials1
@datatutorials1 Жыл бұрын
Glad it was helpful!
@LIPIKADHAR-y6b
@LIPIKADHAR-y6b 9 ай бұрын
Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.
@orangiruth5158
@orangiruth5158 8 ай бұрын
This is ground breaking, thanks for the dedication 🎉🎉
@datatutorials1
@datatutorials1 8 ай бұрын
Always!
@rafaelalomoto1595
@rafaelalomoto1595 Жыл бұрын
The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project
@meraki2090
@meraki2090 5 ай бұрын
This was easy to follow and amazing video on power BI and SQL. Thank you and I learned various functions through this. Thank you again!
@truemufti
@truemufti 4 ай бұрын
Great tutorial, I have a lot of queries in power bi but after watching this tutorial I cleared those. Thank you so much.
@datatutorials1
@datatutorials1 4 ай бұрын
Glad it helped
@piero141980
@piero141980 Жыл бұрын
Nice video, very informative however I fail to understand why we need to use sql for this exercise. I thought we would use the formulas created at the beginning of the video in SQL while creating the dashboard in powerbi but we didn't do that. I wonder why do we need to go through that exercise instead of uploading a cvs file into powerbi directly and saving time by doing that ?
@datatutorials1
@datatutorials1 Жыл бұрын
Whenever you are asked to build a project or dashboard in any tool you always have to validate your results shown in the dashboard. The results shown in dashboard are garbage in and garbage out, meaning it shows anything you want, how will you and client know the values are correct. It is always a best practice to test the report you build by firing SQL queries to database and validate the reports. This is explained in the video well
@yogeshpatole9595
@yogeshpatole9595 Жыл бұрын
Please make video on how to get job in power bi
@netishmb761
@netishmb761 11 ай бұрын
1:47:26 i am getting error when adding days column OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool
@bhaktikhavle9307
@bhaktikhavle9307 9 ай бұрын
Thankyou for this video, learnt many new things from just 1 video.👍🏻
@shashankreddysai
@shashankreddysai 9 ай бұрын
Best Video for PBI! Great work
@yamkelamatomane7027
@yamkelamatomane7027 Жыл бұрын
Hi, I am getting a "input string was not in a correct format. (mscorlib)" How do I fix this, this happens on the final step when I import the flat file
@koiroi1854
@koiroi1854 10 ай бұрын
Hi, I am experiencing the same thing , were you able to resolve this error?
@khansalim81
@khansalim81 10 ай бұрын
Thank you so much! Your explanation is crispy and clear. Best for anyone looking to learn Power BI from beginner to end. Thanks again!!
@datatutorials1
@datatutorials1 10 ай бұрын
Glad it was helpful!
@pranavsrivastava6834
@pranavsrivastava6834 5 ай бұрын
Thank you for this amazing portfolio project which will be truly helpful for mine data analyst journey. I just completed this amazing video, and I must appreciate your time & efforts behind such a great work which shows the real industry experience behind it. Glad to subscribe your channel. Much Appreciated!
@taisiyakaripidis9828
@taisiyakaripidis9828 Жыл бұрын
Thank you so much for this tutorial! You've done an excellent job teaching queries and PBI!
@eakubzisan3072
@eakubzisan3072 10 ай бұрын
I have watched full video with patience. It helped me learn some new tricks that can boost my working capacity with data. Thank you so much.
@uzoamakaogbonna
@uzoamakaogbonna Жыл бұрын
You’re such a good teacher
@heavyvloggers7710
@heavyvloggers7710 Жыл бұрын
Excellent explanation,bole toh maaza aagya ❤❤❤❤
@RxBrooks
@RxBrooks 10 ай бұрын
Great work. A slight mistake I noticed was how for the 2nd page, in the worst sellers section, its suppots to written that the Brie Carre Pizza contributes to the minimum Total Orders instead of the "maximum".
@softskills6
@softskills6 Жыл бұрын
It is really an excellent tutorial in an easy way, which is very helpful for beginners
@mathewmburu4920
@mathewmburu4920 9 ай бұрын
Many thanks so much for you time🧑‍🏫🧑‍🏫🧑‍🏫🧑‍🏫🧑‍🏫
@chanil1950
@chanil1950 Жыл бұрын
I have learned many things from this video. Thank you for sharing.
@sunithakumari8297
@sunithakumari8297 9 ай бұрын
sir wonderful explaination...hand off for your patience and clear explanation of complete report. even a person how is using power BI for the first time can also understand and practice .....I was expecting dynamic text box in the project....like if we select category showing text box with highlights for the selected tenure or category. If possible can you please help us with dynamic text box.
@datatutorials1
@datatutorials1 8 ай бұрын
I will do it in next project
@nishujain2443
@nishujain2443 Жыл бұрын
thank you....best content ever i watched...waiting for SQL tutorial
@netishmb761
@netishmb761 11 ай бұрын
1:47:25 when we add up day column I am getting error OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: There is insufficient memory available in the buffer pool can anyone please help regarding this thankyou in advance 😢
@aywinter6046
@aywinter6046 Жыл бұрын
First, thank you for this video which I find very helpful and easy to understand. But, I have one quick question. What if I have new data come in next year lets say 2016. How do I automatically pull in new data and update the KPI to include the 2016? Thank you.
@ketanshrivastava
@ketanshrivastava Жыл бұрын
you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇
@manaspattanaik2345
@manaspattanaik2345 Жыл бұрын
Thanks But my request is instead of one table use 10 more table so that it is useful. my request is to show dashboard using more table with join option
@datatutorials1
@datatutorials1 Жыл бұрын
Noted! Will try
@sahilkhanna5640
@sahilkhanna5640 Жыл бұрын
Sir pls one project on python so many videos on utube but your explanation is very simple and easy to adopt...
@datatutorials1
@datatutorials1 Жыл бұрын
As soon as possible, thanks
@akshay-zb4vs
@akshay-zb4vs 9 ай бұрын
Thankyou soo much sir. Thankyou for helping us build this amazing Dashboard
@datatutorials1
@datatutorials1 9 ай бұрын
Glad you liked it
@insanegamer6649
@insanegamer6649 6 ай бұрын
Boss genuinely acha content banate ho AAP ❤❤
@ektasingh1314
@ektasingh1314 6 ай бұрын
Wow what a video….You really cover most of my doubts….thank you so much for making this video
@mahekgupta-o7r
@mahekgupta-o7r Жыл бұрын
This is really informative. Can you also provide the link for ppt or upload it on same folder as of data provided link of drive for the problem statement that u had made
@dominicatuahene7303
@dominicatuahene7303 Жыл бұрын
Hello Sir, this is an amazing project with an awesome BI visualization. I do have a question though. do you have any video on automation of project? for instance how can we connect this SQL commants and the Dashboard to the data source such that whenever there is and additional transaction or change in the data, then the SQL query and the Dasboard can update by refresing it? Thank you for this wanderfull presentation
@shahidgulzar2062
@shahidgulzar2062 Жыл бұрын
server name ?
@dominicatuahene7303
@dominicatuahene7303 Жыл бұрын
@@shahidgulzar2062 MySQL server
@TAOFEEKABDULMALIK
@TAOFEEKABDULMALIK Жыл бұрын
Wow, this video is fantastic, good presentation and very explicit. Thank you
@datatutorials1
@datatutorials1 Жыл бұрын
Glad it was helpful!
@PaulJenniferZigwai
@PaulJenniferZigwai 11 ай бұрын
This work has impacted my data analytical journey. Keep up the good work, Sir. Seeing how excellent the work is, I tried making a replicate but had difficulties in returning the names of the week days and months to answering the chart requirement of 'Daily Trend for Total Orders' & ' Monthly Trend for Total Orders'. Please🙏, what could be the possible solution? I used MYSQL to run the queries. THANK YOU IN ADVANCE!!!
@datatutorials1
@datatutorials1 11 ай бұрын
Did you convert the datatype of date to date format
@reemazabdull5623
@reemazabdull5623 9 ай бұрын
Best video ever!!!!!! I have learned these two program but I didn't know how to start a project it took 3 hours from me but I really benefited and I will watch your other videos thank you very very much for this work! everything is perfect and clear even that the Word file thank you again. I just hope that you will make a video on how I can determine the KPI so that I can work with dataset and know how to clean it because it was really easy for SQL and visualization when you explained that, and no one has clarified this point. I was always asking how I can find out that columns I need in order to implement the queries.
@MaansiWakekar
@MaansiWakekar Жыл бұрын
THANK YOU VERY MUCH for describing it so clearly
@abdulbasit6334
@abdulbasit6334 Жыл бұрын
I did learn SQL a few days ago but could not find any useful SQL project and luckily ur this project came in front of my eyes. The SQL queries u performed were a mix of beginner and intermediate difficulty and ur power BI skills are really phenomenal. I learnt a lot. Thank you and God Bless!
@joefla5134
@joefla5134 8 ай бұрын
Which SQL software do you use for this application ? Which do u recommend to download?
@nutz3594
@nutz3594 Жыл бұрын
this is content really helpfull for me as beginner which who want learn Data Analyst process.. i hope u cant keep update about simillar things coz i will follow ur update for further 👍🙏
@datatutorials1
@datatutorials1 Жыл бұрын
I will try my best, thank you
@ansariozair8459
@ansariozair8459 Жыл бұрын
I have a question, as you are using distinct order id while retrieving the average order value, there might be same order id on different date or time. Is it counting that order also? And one more question can we use group by function in this case? If not, why?
@mohamedlashin4462
@mohamedlashin4462 4 ай бұрын
Thank you for this video, but I have a question: what is the use of SQL queries? I feel that we can go directly to Power BI, or is this just for practice?
@abhishekkunte2482
@abhishekkunte2482 Жыл бұрын
Thank You So much. Learning a lot from you
@datatutorials1
@datatutorials1 Жыл бұрын
Glad to hear that!
@sonalwandhare8039
@sonalwandhare8039 11 ай бұрын
Hi please help to run this command in my sql as it is giving me an error for SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date) in my sql to run it please help
@RaviYadav-zi7eb
@RaviYadav-zi7eb 10 ай бұрын
alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
@rayaneBENAKSAS
@rayaneBENAKSAS 2 ай бұрын
SELECT EXTRACT(DOW FROM order_date) AS order_day FROM pizza_sales;
@alishachhabra9414
@alishachhabra9414 8 ай бұрын
Many Thanks for such a detailed video
@datatutorials1
@datatutorials1 8 ай бұрын
Glad it was helpful !
@Datamaventech
@Datamaventech Жыл бұрын
Very well explained! Thanks for sharing such a great content. 😊❤
@vasanthkumarcroos8605
@vasanthkumarcroos8605 3 ай бұрын
Just awesome Thank you so much sir.
@sreenath2830
@sreenath2830 Жыл бұрын
Excellent videos..Quality content.
@datatutorials1
@datatutorials1 Жыл бұрын
Much appreciated!
@harshvardhandhayapule59
@harshvardhandhayapule59 Жыл бұрын
did you do the project?
@TugbaKrac
@TugbaKrac Жыл бұрын
Çok Faydalı,teşekkürler :) Emeğinize sağlık
@marcina5284
@marcina5284 Жыл бұрын
@Data Tutorials Can u add img of economic.png into drive google folder coz is missing
@sharonnwanne5098
@sharonnwanne5098 Жыл бұрын
Thank you so much for your incredible work here. It was really amazing. Thank you...
@Mokshtak
@Mokshtak 11 ай бұрын
It's showing me error when i run this query in MySQL Server. if anyone suggest what's wrong into it ? or another query to run. SELECT DATENAME(DW, order_date) AS order_day, COUNT(DISTINCT order_id) AS total_orders FROM pizza_sales GROUP BY DATENAME(DW, order_date)
@RaviYadav-zi7eb
@RaviYadav-zi7eb 10 ай бұрын
alter table pizza_sales modify order_date date SET SQL_SAFE_UPDATES = 0; update pizza_sales set order_date=str_to_date(order_date,"%d-%m-%Y"); select dayname(order_date) as order_day, COUNT(DISTINCT order_id) AS total_orders from pizza_sales GROUP BY dayname(order_date) order by count(distinct order_id)desc
@R1_Rover
@R1_Rover 10 ай бұрын
@@RaviYadav-zi7ebI tried this and it still didn’t work for me
@RaviYadav-zi7eb
@RaviYadav-zi7eb 10 ай бұрын
@@R1_Rover what's the error?
@siddhantkhairnar7519
@siddhantkhairnar7519 Жыл бұрын
I want to express my heartfelt gratitude for your dedication to sharing knowledge. It's evident that you have invested a lot of time and effort into creating this tutorial, and it has undoubtedly made a significant impact on my learning journey. Thanks to you, I now feel empowered to tackle SQL and Power BI projects confidently.
@Kishormurade02
@Kishormurade02 10 ай бұрын
Hey, can you please tell me if interviewer asked question that, what the actual use of SQL in this project, then what should be the expected answer can i give, please let me know, I`m confused in this?
@nishantnandkeolyar13289
@nishantnandkeolyar13289 7 ай бұрын
Absolutely right 😊
@UtkarshShukla-m8g
@UtkarshShukla-m8g 5 ай бұрын
@@Kishormurade02 SQL databases are more suited for handling large volumes of data with complex querying, transformation, and real-time access capabilities, while Excel sheets are useful for smaller datasets, manual analysis, and simpler reporting tasks. The choice between the two depends on the specific requirements of the BI project, including data volume, complexity, collaboration needs, and the desired level of automation and performance.
@mrbartuss1
@mrbartuss1 10 ай бұрын
If only in real life it was that easy
@RajKumar-bl2pk
@RajKumar-bl2pk Жыл бұрын
Hi, Really appreciate your efforts on this. Could you also add how we deploy this to client or end users. How they access ?
@kumarsathya250
@kumarsathya250 Ай бұрын
Great presentation. I have a question on insight section though. The text in that section is static. What if after a data refresh another pizza/ category/date range becomes best seller . Is there a way we can make it dynamic? like defining best sellers in each section and make Insight section pick those ? I guess that is my home work, will update here if I find any solution.
I Tried 50 Data Analyst Courses. Here Are Top 5
8:41
Stefanovic
Рет қаралды 153 М.
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 13 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 16 МЛН
10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO
14:39
Mo Chen
Рет қаралды 361 М.
B33-30 Azure SQL DBA Batch 33 20241125 Automation Part-II
1:00:02
GBS-GigaByteSouls
Рет қаралды 66
Data Analysis End to End | Project Analytics | Beginner Friendly
1:30:32
Lada Aura - полный разбор на компоненты.
43:47
Клубный сервис
Рет қаралды 138 М.
SQL Class 2
1:06:03
Consult Akorede
Рет қаралды 9
No More DAX? Power BI’s NEW Feature Explained (File Included)
7:30
MyOnlineTrainingHub
Рет қаралды 166 М.