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

  Рет қаралды 676,332

Data Tutorials

Data Tutorials

Күн бұрын

#powerbi #sql #tableau #excel
Data Analyst Portfolio Project | Power BI + SQL | Beginner to Advanced |End to End
Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.
Whether you are a beginner or an experienced data analyst, this tutorial will provide you with the necessary knowledge and hands-on experience to successfully complete a data analysis project. Join me on this journey and unlock the power of these essential data analysis tools.
Data Download - drive.google.com/drive/folder...
📱Follow me on Facebook - profile.php?...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Content
Introduction 0:00
Steps in Project 08:25
Problem Statement 13:25
Software Used 18:51
Raw Data 20:28
Import Data in SQL 23:01
SQL Queries for KPI's 30:24
SQL Queries for Daily and Monthly Trend 44:30
SQL Queries for % of Sales by Category & Size 51:33
SQL Queries for Top 5 & Bottom 5 01:03:46
Power BI Intro 01:10:28
Connecting Power BI to SQL DB 01:12:23
Data Cleaning using Power Query 01:15:57
KPI's Building 01:22:29
Data Processing in Power Bi 01:46:21
Building Daily and Monthly Trend Charts 01:49:09
Building % of Sales by Category & Size 02:05:44
Adding Insights 02:17:30
Worst and Best Sellers Dashboard 02:15:49
Add Navigator Buttons 02:42:08
Outro 02:46:04
Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
=
➖➖➖➖➖➖➖➖➖➖➖➖➖
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project

Пікірлер: 594
@user-bn5oq1nf4b
@user-bn5oq1nf4b 8 ай бұрын
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!
@er.sarthaksananse1704
@er.sarthaksananse1704 10 ай бұрын
One of the best KZbin channel for all Aspiring Data Analyst 😊
@terihandrick2333
@terihandrick2333 2 ай бұрын
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.
@haseebahmed9953
@haseebahmed9953 9 ай бұрын
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.
@InsightswithArselane
@InsightswithArselane 5 ай бұрын
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 8 ай бұрын
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 8 ай бұрын
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 8 ай бұрын
I'm an amateur making terrible picks and I really need assistance.
@mayacho4910
@mayacho4910 8 ай бұрын
Trading is Profitable with the help of a seasoned broker managing your trading account.
@raymondbarnes5264
@raymondbarnes5264 8 ай бұрын
@@stellamoore720 'BRIDGET MARY TUROW"".
@stellamoore720
@stellamoore720 8 ай бұрын
@@raymondbarnes5264 How can i reach her?.
@mukamafrancois2776
@mukamafrancois2776 7 ай бұрын
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. 💪
@athanaaa9846
@athanaaa9846 10 ай бұрын
Very good explanations and thanks you man for share your knowledge to us without any expectations ❤❤❤❤❤
@user-on9pb1qx9d
@user-on9pb1qx9d 8 ай бұрын
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
@prratimaakaroshii5525
@prratimaakaroshii5525 9 ай бұрын
Very systematic explanation and easily understandable content. Thanks for such a knowledgable video.
@janellegomez4207
@janellegomez4207 6 ай бұрын
Thank you so much for teaching us how to do this project. The dashboard is beautiful!
@swarupasahu700
@swarupasahu700 9 ай бұрын
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 👍
@user-wp4tc7fr2q
@user-wp4tc7fr2q 4 ай бұрын
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!!
@SamuelOlujide
@SamuelOlujide 8 ай бұрын
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.
@omotayocrownwealth4745
@omotayocrownwealth4745 2 ай бұрын
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 2 ай бұрын
Thabks
@swetaswarnkar6927
@swetaswarnkar6927 9 ай бұрын
I want to express my heartfelt gratitude for your dedication to sharing knowledge..thanku somuch
@Prabhakaran-hp1to
@Prabhakaran-hp1to 9 ай бұрын
Thank you so much for very clean and easy way you explain all from beginning.
@ishankhanijo4591
@ishankhanijo4591 3 ай бұрын
This project walkthrough has been very helpful. Thank you sir!
@slycop221
@slycop221 8 ай бұрын
THE BEST YT CHANNEL FOR PROJECTS
@sumijasukumaran1394
@sumijasukumaran1394 10 ай бұрын
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 10 ай бұрын
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 9 ай бұрын
@@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 5 ай бұрын
I think so 🤔
@sasacademy4761
@sasacademy4761 5 ай бұрын
@@shahnawazatharkazmi2826 AA vP by by by by by by by Dr ko CT CT CT
@drbh6331
@drbh6331 4 ай бұрын
​​@@shahnawazatharkazmi2826first of all python had less role in data analysis its more towards data science and data engineering
@mohammedgamal7509
@mohammedgamal7509 4 ай бұрын
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.
@user-xp3xd6pt3l
@user-xp3xd6pt3l Ай бұрын
Thanks, I have just completed your full tutorials. leaned a lot from your tutorials. Please give us more Power Bi and SQL Related Projects
@careeracademy6
@careeracademy6 8 ай бұрын
It is really an excellent tutorial in an easy way, which is very helpful for beginners
@user-gk1zs8cp9p
@user-gk1zs8cp9p 2 ай бұрын
Really your Dashboard is so impressive, always try to learn lots of things on Power BI dashboard creating.
@user-fb9kh1wb2g
@user-fb9kh1wb2g 9 ай бұрын
"Fantastic content! Thanks for sharing this insightful video!"
@faranbhutta1349
@faranbhutta1349 5 ай бұрын
Beautifully explained each and every concept
@Push_Harder
@Push_Harder 8 ай бұрын
You are doing a wonderful job brother. It was a great learning experience. Thank you so much. Keep growing and keep sharing the knowledge.
@siddhantkhairnar7519
@siddhantkhairnar7519 9 ай бұрын
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 3 ай бұрын
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 27 күн бұрын
Absolutely right 😊
@ravikumar-uu5ph
@ravikumar-uu5ph 9 ай бұрын
Thanks a lot, it was my first project and learned lot from your video. thanks !
@ketanshrivastava
@ketanshrivastava 8 ай бұрын
you make it so simple ..... thankyou for making these kind of videos ..........to the point videos .....very systematic.😇
@rafaelalomoto1595
@rafaelalomoto1595 7 ай бұрын
The best video i haev found to learn power BI and SQL , Thanks for the time and effort U have invested in this project
@bodasoumya8514
@bodasoumya8514 9 ай бұрын
Very good explanation for beginners, thank you so much neat explanation 👏👏
@santhuzestvlog7330
@santhuzestvlog7330 9 ай бұрын
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
@ektasingh1314
@ektasingh1314 2 күн бұрын
Wow what a video….You really cover most of my doubts….thank you so much for making this video
@Datamaventech
@Datamaventech 9 ай бұрын
Very well explained! Thanks for sharing such a great content. 😊❤
@Ak-io7fl
@Ak-io7fl 10 ай бұрын
Nice work keep posting we will be practicing with you please also explain datasets and please make dedicated video for time intelligence functions
@chanil1950
@chanil1950 8 ай бұрын
I have learned many things from this video. Thank you for sharing.
@user-nj5ld9jy7m
@user-nj5ld9jy7m 10 ай бұрын
Nice and informative session
@shashankreddysai
@shashankreddysai 2 ай бұрын
Best Video for PBI! Great work
@user-uz1py1gi2t
@user-uz1py1gi2t 5 ай бұрын
THANK YOU VERY MUCH for describing it so clearly
@sharonnwanne5098
@sharonnwanne5098 6 ай бұрын
Thank you so much for your incredible work here. It was really amazing. Thank you...
@taisiyakaripidis9828
@taisiyakaripidis9828 9 ай бұрын
Thank you so much for this tutorial! You've done an excellent job teaching queries and PBI!
@heavyvloggers7710
@heavyvloggers7710 8 ай бұрын
Excellent explanation,bole toh maaza aagya ❤❤❤❤
@nishujain2443
@nishujain2443 9 ай бұрын
thank you....best content ever i watched...waiting for SQL tutorial
@reemazabdull5623
@reemazabdull5623 2 ай бұрын
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.
@kinjalpatel848
@kinjalpatel848 8 ай бұрын
Thank you for posting the video. This helped me to enhance my knowledge for data analysis
@abou19850
@abou19850 9 ай бұрын
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 9 ай бұрын
Glad it was helpful!
@kanikaaggarwal9648
@kanikaaggarwal9648 7 ай бұрын
thank you so much for such good projects, really helpful for a fresher, please keep making such projects
@bhaktikhavle9307
@bhaktikhavle9307 2 ай бұрын
Thankyou for this video, learnt many new things from just 1 video.👍🏻
@TugbaKrac
@TugbaKrac 9 ай бұрын
Çok Faydalı,teşekkürler :) Emeğinize sağlık
@muhammadwaqasahmad240
@muhammadwaqasahmad240 9 ай бұрын
Excellent project
@phtrindadeful
@phtrindadeful 9 ай бұрын
Congratulations very well organized, clear language! Liked and subscribed!!!👏👏👏👏
@vanshitasingh4144
@vanshitasingh4144 9 ай бұрын
Thnks for all the projects video ..very well explained!!!!🙏
@aryankumar-ik4uk
@aryankumar-ik4uk 5 ай бұрын
Awesome video... thank you so much for sharing your knowledge
@arju1010
@arju1010 9 ай бұрын
Finished! Thanks for your wonderful project. Keep it up.
@abdulbasit6334
@abdulbasit6334 7 ай бұрын
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 Ай бұрын
Which SQL software do you use for this application ? Which do u recommend to download?
@lakshmig5939
@lakshmig5939 29 күн бұрын
Excellent Information. Very well explained.
@SupCortez
@SupCortez 6 ай бұрын
God bless you friend. Knowledge is Power
@existingfarhan
@existingfarhan 3 ай бұрын
I'm so grateful to you. You've given so much information and explained everything in such detail. I'm definitely subscribed. Much love from Pakistan.
@Happycampie
@Happycampie 9 ай бұрын
Clear explanation valuable video
@vyankateshkongari5128
@vyankateshkongari5128 7 ай бұрын
Thank you bro for explening each and every single fun how to use in very simple method this session is very useful for me .
@SYEDKASHIFALY
@SYEDKASHIFALY 3 ай бұрын
sir u r the greatest of all the teacher an step by step process.... Respect Respect and Respect
@morratunoobs423
@morratunoobs423 10 ай бұрын
Thak you bro make this wonderful video please do this like video more 🙏🙏🙏
@vishalrathore2854
@vishalrathore2854 6 ай бұрын
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 6 ай бұрын
Glad it was helpful 💐
@uzoamakaogbonna
@uzoamakaogbonna 5 ай бұрын
You’re such a good teacher
@Freakouts_and_found_Insane
@Freakouts_and_found_Insane 9 ай бұрын
Thank you so much sir for sharing ..🙏❤️❤️
@owenonyango7075
@owenonyango7075 9 ай бұрын
i wish i could like this a thousand times. great work.
@datatutorials1
@datatutorials1 9 ай бұрын
Wow, thank you!
@shahnawazatharkazmi2826
@shahnawazatharkazmi2826 10 ай бұрын
One of the best project for power bi available on youtube
@datatutorials1
@datatutorials1 10 ай бұрын
Glad you think so!
@eakubzisan3072
@eakubzisan3072 3 ай бұрын
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.
@RajKumar-bl2pk
@RajKumar-bl2pk 7 ай бұрын
Hi, Really appreciate your efforts on this. Could you also add how we deploy this to client or end users. How they access ?
@chaitanyakasala1879
@chaitanyakasala1879 9 ай бұрын
Thank you so much to make us to start learning.....🙂
@ansariozair8459
@ansariozair8459 8 ай бұрын
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?
@raginishrivastav4264
@raginishrivastav4264 5 ай бұрын
Thanks 🙌 Learned a lot new things with this project
@shubhanshisharma3337
@shubhanshisharma3337 7 ай бұрын
Amazing learning experience
@shrutithakur5682
@shrutithakur5682 9 ай бұрын
Sir,the videos are providing wonderful knowlegde. Can you please make more vidoes on Tableau dashbaoards as well.Thank you for providing the information.
@parissaamin7996
@parissaamin7996 3 ай бұрын
You are the Best ever!!!
@emilymalkin270
@emilymalkin270 8 ай бұрын
Very nice! Thank you, keep making new videos!
@digitallectra295
@digitallectra295 2 күн бұрын
Thank you for this video , the content was useful .
@keshavkarki7775
@keshavkarki7775 2 ай бұрын
Thank you Data Tutorials it is really helpful and awesome !!!
@BrokenButton
@BrokenButton 5 ай бұрын
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 13 күн бұрын
Hii I'm having this same problem Did you manage to solve it?
@user-tb6ms8vy9g
@user-tb6ms8vy9g 8 ай бұрын
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
@thang4280
@thang4280 Ай бұрын
Perfect ! Thank you so much
@1515renegade
@1515renegade 6 ай бұрын
enjoyed this, AWESOME lesson!
@Piku.aka.Priyanka
@Piku.aka.Priyanka 8 ай бұрын
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.
@riobagaskara6382
@riobagaskara6382 6 ай бұрын
oh I have seen this on kaggle, love it man
@shubhamralli3965
@shubhamralli3965 4 ай бұрын
Thank you so much! You're the best!
@TAOFEEKABDULMALIK
@TAOFEEKABDULMALIK 8 ай бұрын
Wow, this video is fantastic, good presentation and very explicit. Thank you
@datatutorials1
@datatutorials1 8 ай бұрын
Glad it was helpful!
@bobbypratama8397
@bobbypratama8397 9 ай бұрын
Love your video sir. Thanks ❤
@shravanrao5008
@shravanrao5008 7 ай бұрын
Thank you brother! Grateful to you
@nishantnandkeolyar13289
@nishantnandkeolyar13289 27 күн бұрын
Very nice content and super explained in this video 😊
@noraguerrero2358
@noraguerrero2358 8 ай бұрын
excelent!!!!!!!
@eguonoisuekevbo6184
@eguonoisuekevbo6184 Ай бұрын
Thank you for making this video
@egsshekhar
@egsshekhar 2 ай бұрын
nice knowledge
@abdullaamr1028
@abdullaamr1028 7 ай бұрын
Thank you, I learned a lot from you
@yashsrivastava4878
@yashsrivastava4878 9 ай бұрын
just incredible 👏👏
@gopichand5717
@gopichand5717 10 ай бұрын
Thank you sharing
@datatutorials1
@datatutorials1 10 ай бұрын
Thanks for watching!
@khansalim81
@khansalim81 3 ай бұрын
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 3 ай бұрын
Glad it was helpful!
@uzmanshaikh8237
@uzmanshaikh8237 8 ай бұрын
Your awesome teacher.❤
@user-gu5zt6cp3v
@user-gu5zt6cp3v 8 ай бұрын
Very very useful. Just awesome. Thank you so much
@gayathria1795
@gayathria1795 7 ай бұрын
Very clear video 😊Thanks for the effort
NO NO NO YES! (50 MLN SUBSCRIBERS CHALLENGE!) #shorts
00:26
PANDA BOI
Рет қаралды 92 МЛН
Follow @karina-kola please 🙏🥺
00:21
Andrey Grechka
Рет қаралды 21 МЛН
Power BI Tips and Tricks
16:21
Kevin Stratvert
Рет қаралды 165 М.
NO NO NO YES! (50 MLN SUBSCRIBERS CHALLENGE!) #shorts
00:26
PANDA BOI
Рет қаралды 92 МЛН