Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
Рет қаралды 378,255
Күн бұрын🏠 JOIN THE LEARN BI ACADEMY - geni.us/lbi_academy
🚀 BECOME A BI ANALYST - geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/lbia_bicm
In this video, we'll be walking you through the steps required to create a data analyst portfolio project in SQL. This project will give you a chance to demonstrate your skills and knowledge of SQL, and will help you build a portfolio of data analysis projects.
If you're interested in learning more about data analysis, then this portfolio project is a great way to start! By following along with this step-by-step guide, you'll be able to create a data analyst portfolio that will show off your skills and knowledge of SQL. We'll cover everything from data collection to data analysis to data visualization!
👉🏻 GET YOUR HANDS ON ALL OF THE PROJECT FILES
learnbi.online/pizzaproject.
(N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!)
👉🏻 CHECK OUT ALL OF OUR PROJECTS HERE
geni.us/lbia_projects
😸 NEW NAVICAT TUTORIAL - • My Favourite SQL Tool ...
🚨 This is a data analyst portfolio project that was originally posted as 3 separate videos, here they are combined to make the project easier to follow in one place.
00:00:00 Intro
00:01:41 Designing a Relational Database
00:14:44 Writing Custom SQL Queries
00:32:12 Building Interactive Dashboards
01:00:58 Outro
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
SQL For BI Analysts - geni.us/lbia_sql
Excel For BI Analysts - geni.us/lbia_excel
Power BI For BI Analysts - geni.us/lbia_powerbi
Tableau For BI Analysts - geni.us/lbia_tableau
Ultimate Guide to Looker Studio - geni.us/lbia_lookerstudio
LearnSQL.com - geni.us/learnsql
🧰 DATA ANALYST PROJECTS (PAID)
Ben’s Pizza - geni.us/pizzaproject
Hotel Reservations - geni.us/hotelproject
Multi-Channel Marketing - geni.us/multichannelproject
Call Centre - geni.us/callcentreproject
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
📊 DATA HUBS & WEBSITES:
Power My Analytics - geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#dataanalyst #sqltutorial #businessintelligence
@LearnBI Жыл бұрын
🚀 BI CAREER STARTER PROGRAM 🚀 A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS. Your new career starts here 👉🏻 geni.us/bicsp
@ezhankhan1035 5 ай бұрын
Even just passively watching this video and making notes, without directly following along, has been really helpful. In future I will create my own projects using a similar structure. Much appreciated, thank you!
@cradleofrelaxation6473 Жыл бұрын
I love the fact that you gave out the problem statement first rather than raw coding. This allows your audience to conceptualize the problem for which we’re creating the solution! You’ve just gained a subscriber!
@LearnBI Жыл бұрын
Thanks! Glad you enjoyed it
@estheticsguru 11 ай бұрын
I cannot thank you enough for this tutorial!!!!! You went from beginning to end in a very methodical, easy to understand manner!!! There are so many tips and tricks in this video that I will have to watch it a few more times to catch everything!! I particularly enjoyed the DB design and visualization portions. I just learned SQL, so the queries and subqueries were easy for me to understand. This is an excellent learning tool for any data analyst and at any learning level!!!
@LearnBI 11 ай бұрын
You're very welcome!
@cesarlensterlunas3366 Жыл бұрын
I build dbms for a months and then i saw your videos making it in hour 😭 what a life saver .... I've been interested to study data analytics in order to help in my studies And i came up to your channel 🥰 thanks a lot hope you make more videoes about it 🥰
@LearnBI Жыл бұрын
Glad I could help!
@dominiquepenn9477 5 ай бұрын
Hey quick question, on 33:48 how can I find the instance connection name? I understand he said in the google cloud back office but I need a little more guidance.
@user-wl2tv1dh3t 10 ай бұрын
Thank you, Adam. Hope to see more of you step-by-step tutorial project.
@hoanglam2814 Жыл бұрын
What you are doing is amazing! It is really rare to see an end to end real world project like that. I think this project really fit for someone to look a job in small start up, or becoming an BI analyst. Also, if we replace this excel data source with data from API (using Python to extract and load to DB), it would be exactly BI system in my start up company now.
@LearnBI Жыл бұрын
Really glad you like it! I try and produce original real world content to help people achieve their analytics goals.
@jidealo Жыл бұрын
That is really cool. Thumbs-up
@mustaphakechichi3643 Жыл бұрын
Adam deserves millions of subscribers and views he is a real educator/entertainer, you deserve it alla mate
@LearnBI Жыл бұрын
Thank you!
@givenseshoka4812 6 ай бұрын
Much appreciated, I am not a specialist but this video answered most of the questions I had😊
@print_the_code9156 Жыл бұрын
Sir this is very useful for my journey of SQL learning
@vanguard1665 8 ай бұрын
Hi, i started learning data analysis for 2 days and i found this video, it introduce me to website that will be helpful in the future, thank you very much for the knowledge
@LearnBI 8 ай бұрын
My pleasure!
@DataLauratory Ай бұрын
I've got to say, I was a bit disappointed that I couldn't follow the tutorial all the way through to the end. I saw all of the positive comments and got excited, and even bought the data to follow along, which I did until the Looker part. At about 35:00, there is a huge jump, where the instructor explains that you should connect your database to an instance of MySQL in Looker. However, there is no explanation on how to do it. I tried setting it up by myself but was so lost. I was quite disappointed that I couldn't follow the tutorial from that point onwards. I think this was a good tutorial until that part, but IT IS NOT a Follow-Along type of tutorial, so keep that in mind!
@jackson-yg7kt Ай бұрын
having the same issue, were you able to figure out how to migrate from navicat to lookerstudio??
@Hemmohammad 2 ай бұрын
I've never seen a project explained like this. This is what I was looking for in my entire career. Thank U soo much.
@famakinwamordecai 2 ай бұрын
Good day can we connect. I just finished learning SQL basics to advanced and looking up to find a mate seeing your comment is just about 23h ago
@LearnBI 2 ай бұрын
You're very welcome!
@antonioarana8002 Жыл бұрын
Gorgeous explanation! quite useful, highly appreciated ❤❤🔥
@LearnBI Жыл бұрын
You’re welcome! 🙏🏻
@ephraimmotho887 Жыл бұрын
So much fun!!! Looooved it!!!
@LearnBI Жыл бұрын
Great!
@VanongNguyen-im4dg Жыл бұрын
Your video is so useful for me, I believe it will be useful for many other people in many many years!!! Thank you so much!!!
@LearnBI Жыл бұрын
Glad it was helpful!
@manifestomarketing Жыл бұрын
Awesome video!
@vikb9537 Жыл бұрын
Thank you so much for this video Adam.
@LearnBI Жыл бұрын
My pleasure!
@johnfaber2801 Жыл бұрын
Mate!... I'm back to my business analyst career after a year+ break . Got myself into the Google certificate in business analytics to brush up knowledge, today searching for jobs I saw heaps BI jobs, then I found you clearing out the path in how to approach those jobs and how create portfolios. Thanks a lot 🙏 Pst: do you recommend to get certified in powerbi? More than 50% of BI jobs I checked here in Sydney were related with powerbi. Thanks in advance and keep up your amazing work. Legend!
@LearnBI Жыл бұрын
Welcome back! I reckon a portfolio containing well built projects made in Power BI would be more impressive than a certification.
@QuietCornerWoodsman 11 ай бұрын
Very informative training and with just the right level of detail
@raobrand5776 3 ай бұрын
Thanks for sharing your knowledge ❤
@picassoofai4061 Жыл бұрын
That's really amazing.
@san1araNN 2 ай бұрын
very clear and understandable english for not native people like me , ty god
@umnomadenaestrada 10 ай бұрын
Pretty good video! Thank you.
@LearnBI 10 ай бұрын
Only “pretty” good? 🤣 You're welcome!
@funnyVIDEO-hr8zq 9 ай бұрын
Men i never seen a project like this you are really love this domain , you are goat . keep going we love You
@LearnBI 9 ай бұрын
Thanks a lot!
@yesotv2328 4 ай бұрын
excellent video. very instructive and easy to understand.
@IgorlopezDataScience 11 ай бұрын
Thanks for sharing high-quality information.
@LearnBI 11 ай бұрын
My pleasure.
@kennethstevens3968 Жыл бұрын
This is great.
@albrightaz 9 ай бұрын
Lovely Project and description, I hope you see this and know that you are amazing, and if you don't mind I'll definitely recreate this and add as part of my portfolio. Amazing Project and scenario. Thank You once again.
@LearnBI 9 ай бұрын
My pleasure. And of course you can recreate it for your portfolio 👍🏻
@marielavassellati5439 7 ай бұрын
Thank you!!!
@dekol347 9 ай бұрын
Hi Adam great video, I'm learn a lot about designing relational database. Maybe you can add the explanation about the relationship type, is it one to many, many to many, or many to one. Also for your question about the most efficient query at 32.00 here what I find: SELECT start_time, end_time, TIME_TO_SEC(TIMEDIFF(end_time, start_time)) / 3600 AS hours_difference
@rmoreno5669 Жыл бұрын
Great tutorial!!!!
@LearnBI Жыл бұрын
Thank you!
@focusiam2027 Жыл бұрын
Thank you Adam!
@LearnBI Жыл бұрын
My pleasure!
@rahulpatel-rb7mp Жыл бұрын
Thanks, bro. that is a great project
@LearnBI Жыл бұрын
You're welcome
@khaledhamadi7720 8 ай бұрын
amazing! thank you so much
@LearnBI 8 ай бұрын
My pleasure
@ananthapadmanabhanss4553 Жыл бұрын
Thanks a lot, it's very useful :)
@LearnBI Жыл бұрын
You're welcome!
@print_the_code9156 Жыл бұрын
Thanku sir Iam waiting
@helligusvartproject Жыл бұрын
Very Inspiring
@hmmm8158 Жыл бұрын
Amazing job
@LearnBI Жыл бұрын
Thanks!
@user-cr9gw2nb3p 7 ай бұрын
This was awesome! Please do more paid projects! Can you do one for Excel, Tableau and ML?
@LearnBI 6 ай бұрын
There are 2-3 more coming in January
@MuhammadRizwan-vn6pz Жыл бұрын
Amazing Work Thanks.
@LearnBI Жыл бұрын
You’re welcome
@Vikas_Ray 9 ай бұрын
CAN YOU TELL ME HOW HE PREPARE TABLE CONNECTION IN FIRST PART. I AM NEW IN DATA SCIENCE
@accountingsapayag 11 ай бұрын
Thank You!!!
@LearnBI 11 ай бұрын
You're welcome!
@akshatchaturvedi8997 Жыл бұрын
Hi Adam, absolutely loved the video! I have a couple of question about what you did while designing the DB. 1. While choosing datatypes for date/created_date why did you choose datetime and not timestamp? 2. Does the direction of the linkage matter when you linked staff_id in rota to staff_id in the staff table? @11:57 I am just getting started so please need your help. TIA! You might see more comments from me as I progress through the video : )
@LearnBI Жыл бұрын
Glad you enjoyed the video. TBH, the answers to your questions can be found using a simple Google search. It's not that I don't want to be helpful, it's just that the articles/posts you find from there will probably explain it better than I would in the comment of a KZfaq video 👍🏻
@Emptyheads. 10 ай бұрын
You are amazing. 😍
@LearnBI 10 ай бұрын
No, you are 🤩
@bacet9280 Жыл бұрын
Grateful for that God bless
@MasterMeow21 10 ай бұрын
The fact that this video is almost a year ago and you're still replying to every comment is incredible man! great effort and explanation too. cheers from Egypt❤
@LearnBI 10 ай бұрын
I appreciate that!
@bodymohmed6493 4 ай бұрын
ممكن لو معاك الملفات تبعتهالي وشكر ا مقدما
@LearnBI 4 ай бұрын
@bodymohmed6493 yes, as it says in all caps in the description, this is a paid download. Thanks for your support!
@sharathcg4697 Жыл бұрын
That's a great project covering every aspect of data analysis and visualisation. Very good work mate... This video deserves more likes and views. Keep going with other contents as well
@LearnBI Жыл бұрын
Thanks, really glad you appreciate it 👍🏻
@muthoniwanyeki8757 Жыл бұрын
Hello Adam, I appreciate the amazing work you have done in creating this insightful video. Might you be able to point me towards a basic SQL course. I am new in all the IT stuff and currently doing a beginner Data analytics course. I need to understand the SQL formulas and how to create them. Thank you for fantastic work.
@LearnBI Жыл бұрын
Thanks for your feedback! There's a 3-part series on my channel that teaches basic SQL: kzfaq.info/sun/PLR0triVyTrBWOLNu3ato7Y9hnGVyhTe1c I'd recommend you start there. Then you could take a look at the courses offered by LearnSQL: geni.us/learnsql
@HugoLopez-ih4ut 10 ай бұрын
Hey. I am new too in the field. Have you chosen a project to do?
@kamaleshpramanik7645 3 ай бұрын
Very helpful video .. Thank you very much Sir.
@LearnBI 3 ай бұрын
Most welcome
@sujithchandrakanthnaik975 9 ай бұрын
Hi, Adam Finer I appreciate the amazing work you have done in creating this insightful video. It will be helpful if u give raw data set of these(not a cleaned dataset)
@LearnBI 9 ай бұрын
Sorry but I’m not sure I understand what you’re asking for. Raw and clean data are not opposites.
@peteru2872 6 ай бұрын
Thank you❤
@LearnBI 6 ай бұрын
You're welcome
@pegahkarimi112 10 ай бұрын
you are the best
@LearnBI 10 ай бұрын
No, you’re the best! ☺️
@galrickgak9615 Жыл бұрын
51.41 the was a negative stock value Banofie Pie but this could be because you chose random data. Thank you for the video very explicit!
@LearnBI Жыл бұрын
You’re quite right. The orders data isn’t random because it was generated by people placing “real” orders. But the stock data was generated by myself and didn’t allow for the fact that products could sell out. It could easily be fixed by just increasing the amount of inventory in the appropriate table. Glad you like the video!
@raulserrano6636 4 ай бұрын
Excellent video for those who are starting out in SQL and to learn about the tools that are being used today. But I would like to know what tool is used when creating the relational model. I found the ease with which the SQL lines are written and at the same time the table is displayed quite interesting.
@LearnBI 4 ай бұрын
It’s called quickdatabasediagrams.com
@sunilpardeshi1949 Жыл бұрын
Hello Sir , it very awesome way to explaine the difficult things to sipmle form ! can make this dashboard in MS Power BI also
@Tesseus2006 8 ай бұрын
Hi Adam and thank you for making this video. I have a question and I scrolled down and didn't see anyone asking. At 10 minutes and 44 seconds, the diagram shows the inventory table primary key is not being used on recipe table (as there is no item ID in it). Should that have been connected to the Item table instead? And bypassed recipe table altogether. Or should recipe table have an Inventory ID? Let us know it you get a chance.
@Stevenaramburo 11 ай бұрын
This is a masterpiece/ crash course on how to do reports. Im tired of using Excel, Guess im changing tools now
@LearnBI 11 ай бұрын
Glad you like it!
@bramgroenhof 11 ай бұрын
Wait so you can recreate it entirely if you get the paid project files and follow along with the video? That's insane!
@BlakeC341 Жыл бұрын
It's a shame this is the only project. I enjoyed this and would gladly pay to do others.
@LearnBI Жыл бұрын
I’d like to make more but it’s just a question of finding the time
@thaismarouelli5629 10 ай бұрын
Thank you so much for this video, it is really great ! I was wondering why do I need to do this SQL queries before taking the data to the data visualization tool if we can do this connections and calculations directly there? When will I have to do this and when not?
@LearnBI 10 ай бұрын
It will depend on the sql functionalities included with the BI tool you’re using. Most allow you to use custom queries to create data sources but you’ll need to write them before hand is they are complex and BI tools aren’t really made for that. Also, the sql queries I wrote in the project are to create data sources in the bi tool, not to get the data for individual visualizations (which might be actually what you’re referring to).
@muskanmarghani9433 2 ай бұрын
Which application is used to draw diagram
@onomeyalaju391 7 ай бұрын
@LearnBI Hi Adam, Thanks a lot for the step-by-step guide videos they've been really helpful. However I'm really new data analytics so I'm still trying to figure out a lot of things. I'm trying to follow up with you in this tutorial step by step but I don't even know where to begin, are you using looker studio to work on this project and also how do I get the data you working with? Thanks
@ayowaledelano 9 ай бұрын
This is great. If I may ask, do you have any portfolio project using design query in editor for your analysis?
@LearnBI 9 ай бұрын
No but you can export the database SQL from from quickdbd into SQL server. Then you’d just need to import the data into the database you create.
@wingsingchan8988 Жыл бұрын
I have a question on how to do the database authentication during the cloud sql for mysql part, any video on that, thank you very much
@gnanaswaroop4520 7 ай бұрын
When I try to add tables in Navicat, only 2 talbes are added to the database. I wonder where I'm going wrong. Love your videos and tutorials btw, very grateful for your channel!
@LearnBI 6 ай бұрын
You just need to execute the sql file. It already has the data in it
@nhungqnk Жыл бұрын
Hi Adam, thanks for the video. I have a question regarding the relationships you have established for the tables in QuickDBD. Looking at the diagram, it suggests that the cust_id in the orders table and the cust_id in the customers table have a one-to-many relationship, while I think it should be the other way around? Since one customer can appear several times in the orders table but should unique in the customers table. Same for the item_id field in orders and in items.
@LearnBI Жыл бұрын
Thanks for your feedback. Have you watched the entire video?
@nhungqnk Жыл бұрын
@@LearnBI Hi Adam, I have finished watching. I could think if two explanations, but not sure which is correct: 1. Have noticed at the end of part 1, there are some error messages regarding foreign key. This probably means the tables were created in Navicat with no relationships established and we would not need them for the purpose of this exercise? 2. In part 2, you used Left outer join to join the tables orders and item on the key item_id (one-to-many based on the QuickDBD diagram). I guess this could be the reason? Thank you for your reply. Your videos have helped me greatly getting into SQL.
@LearnBI Жыл бұрын
You’re very welcome, I’m glad you find them helpful. I’m not a sql expert, I just use what I know to achieve what I need to. In this project we were able to do what we set out to by creating, populating and querying the tables as we set them up. The cardinality type didn’t really come into play and “joining” the tables when I set them up in dbd was simply to demonstrate the relational model and how tables related to one another. I’m sure most sql professionals would probably cringe when they watch this but that’s fine by me. If it works, it works 😎
@nhungqnk Жыл бұрын
@@LearnBI That makes sense. Thanks Adam! Have a nice day.
@zakielmi1418 2 ай бұрын
THANK YOU SO MUCH, could you explain how to get the instance connection name?
@LearnBI 2 ай бұрын
That is my personal instance. You would need to set up your own.
@user-ky2gl4lx1p 4 ай бұрын
Thank you for this video!!! you gave us a good amount of content. I have a doubt about the data tables, from where can we get all the data that you've shown in the Excel spreadsheet? Could you please provide them?
@LearnBI 4 ай бұрын
The data is available for purchase here: learnbi.online/pizzaproject
@mugomuiruri2313 8 ай бұрын
good
@sanart41 7 ай бұрын
Hey Adam! Love the video and all that you've shown us in it. Although, I created an instance on the GCP and connected my Navicat to my instance but, when I create a database in Navicat, it doesn't show up on my GCP instance. I'm not sure if there is a permissions issue or what may be wrong. Was hoping you could help me with this issue?
@LearnBI 4 ай бұрын
Did you solve your problem?
@TatianeWuLi Ай бұрын
Hi Adam! Thank you so much for the video! I would like to clarify why we can join the inventory and s2 on different keys (item_id and ing_id)? I thought we could only join tables with the same key.
@LearnBI Ай бұрын
You can join where the values in the fields match
@TatianeWuLi Ай бұрын
@@LearnBI ohh I see, thank you so much!
@marika_zaradzka 4 ай бұрын
Hi Adam! Thank you lots for this video! Many people recommended your channel on Tiktok, and I you're truly amazing teacher! I'm wondering, is there an excel file with all data tables together? I cannot find it (for example 10:06)
@LearnBI 4 ай бұрын
Glad you like the video. The data is available for purchase here ➡️learnbi.online/pizzaproject. Thanks for your support! 🙏🏻
@sandyherbert7103 Жыл бұрын
Hi Adam - I am trying to produce a Leaderboard for a workout class showing RPM, speed, power and who's winning in real time. I have a small hub that is collecting & displaying the data in SQL. Would your pizza Project files be tweaked and work for a leaderboard real time data? TU in advance!
@LearnBI Жыл бұрын
I don’t think so. Completely different scenario, data etc.
@jongdave2691 8 ай бұрын
Hello Adam, great video! I am learning a lot about relational databases from your tutorial. I have a question about the relationship between `Ingredient.ing_weight` and `recipe.quantity`. As I understand it, `recipe.quantity` represents the weight of each ingredient in each item, and `Ingredient.ing_weight` represents unit weight as ingredient price. The way I calculate the cost of each ingredient of each item is as follows: (recipe.quantity/Ingredient_weight) * Ing_Price * SUM(orders.quantity). Am I understand it correctly?
@LearnBI 8 ай бұрын
Everything is explained in the video 🙂
@neptoonpalace4027 Жыл бұрын
Amazing project and you explained it very clearly although $19 is a bit much for me😅 hoping for a price discount so i could purchase it.
@LearnBI Жыл бұрын
Check the page again 😉
@neptoonpalace4027 Жыл бұрын
@@LearnBI Thanks Adam, just bought the dataset and let me tell you it is rare to find this type of high quality content anywhere else. I'm sure this is worth my money and eagerly await for more exciting projects like this.
@LearnBI Жыл бұрын
Thanks for your support! I’ll be creating a new project soon so stay tuned!
@rajsinha7402 5 ай бұрын
@@neptoonpalace4027hey there can please send the files actually i can't afford this can you please help me out
@nileshchakrabarty9605 4 ай бұрын
Yes plz
@user-ki6jg5vb8n 11 ай бұрын
Hi Adam, thanks for the video. I am completely stuck at the 'Database Authentication' part of the video at 33:50. I think I have successfully created an instance, but whenever I fill in the next 3 boxes I just get an error message. I've tried everything, asked for help from colleagues and googled with no luck. Can you advise please?
@LearnBI 11 ай бұрын
Hi, it's really difficult for me to help with so little information. All of the connection information you'll need can be found in Google Cloud Platform. It's possible that you'll need to whitelist your IP address in Connections>>NETWORKING in your instance.
@chisalemchukunda4148 Жыл бұрын
Nice video. Hello guys, please I need help with the SQL import and export wizard. I've been trying to set it up to SQL server native client 11.0 but I haven't even seen it as an option in the destination folder. I'm just confused. Thanks.
@LearnBI Жыл бұрын
You’ll need to give a lot more information about what you’re trying to do for anyone to give you advice.
@worldsurf3204 Жыл бұрын
that's amazing but i didn't understand how do you split out the first data file to multiple tables because it will be complicated if we have thousand orders espacially when it comes to adding customer id...could you explain that?
@LearnBI Жыл бұрын
In the real world, that first dataset shouldn't exist except maybe as an exercise to spec out the column and data you might need to collect. The idea was to build the backend database for collecting pizza orders. When an order is placed the data is automatically collected in the different tables without the need to split them up.
@withlove1887 Жыл бұрын
Why is staff_id (Staff table) to staff_id (Rota table) One-to-Many relationship ? Shouldn't it be Many-to-One ? Great video btw !!
@LearnBI 11 ай бұрын
Thanks! For our purposes and queries, it doesn’t really matter
@ppalert3984 Жыл бұрын
Hi Adam, I'm new SQL learner. I support your project file and download file already. But when I open database file in DBBrowser, It isn't shown any table. If you can help me this problem, please tell me. Love your effort to create good content like this!!
@LearnBI Жыл бұрын
Thanks for your support. DB Browser is made for SQLite files. The project file is .sql and creates a MySQL database so you would need to be running an instance of MySQL and use a tool like MySQL Workbench.
@varunmalhotra666 Жыл бұрын
Hey Adam ... everything is amazing ...can you please tell me from where i can get this data ?..ca you please share the files
@LearnBI Жыл бұрын
learnbi.online/pizzaproject
@shookmasterhistory 7 ай бұрын
When clicking run, it only gives about 4 row. How to get all the rows?
@LearnBI 7 ай бұрын
Far too little information for me to help you
@claraandres3772 Жыл бұрын
How do you upload the data into Google ? After the authentication part, there are no tables available.
@LearnBI Жыл бұрын
The Google MySQL instance belongs to me and isn't open to the public.
@matthewelliott832 7 ай бұрын
Hi i'm a novice but I couldn't get the Quick DBD model to work on SSMS, I noticed that some of the one-to-many relations are drawn the wrong way round on the diagram. Once fixed it works fine :)
@hudzaifahhudzaifah-zv6yw 7 ай бұрын
Hi.. I currently face same problem, can you show me how to fix that? really appreciate with your work.
@absoon9971 5 ай бұрын
Been a while since these comments have been posted. But the alternative I found was creating these tables in SSMS using Database Diagrams. This provides you with a similar visual way of creating the tables. You can also create these tables, export them to MYSQL and then give the code provided to chat GPT and ask it to make it compatible to SSMS.
@IsmailAbdikadir-lk6lf 10 ай бұрын
Great vid! thanks for this. Can i use Tableau instead of Google Data Studio since i know tableau better?
@LearnBI 10 ай бұрын
Yes, absolutely
@IsmailAbdikadir-lk6lf 9 ай бұрын
@@LearnBI sorry if I'm asking too much, but can i perform SQL codes in tableau as same as the Google Data Studio?
@josephlee8332 Жыл бұрын
Hi Adam. I downloaded your datasets from the link in the description and was a little confused with the "quantity" column in the recipe table. Can you explain what this column is supposed to represent? For example, PIZZ-MARG-R has an ingredient, Pizza dough ball (ING001), with a quantity of 250. Does this mean to make this pizza, we will need 250 pizza dough ball? EDIT: I guess its 250 grams of pizza dough needed to make a regular marg pizza.
@LearnBI Жыл бұрын
That is correct. Check out the ingredient table to see the unit measurement for each ingredient.
@trinityleo Жыл бұрын
hi joseph lee did you pay for the data set
@josephlee8332 Жыл бұрын
@@trinityleo Yes. You may find the link to the dataset in the video's description.
@gxa5986 11 ай бұрын
@@josephlee8332 can you the dataset with us , as i cannot afford at this point .
@rajsinha7402 5 ай бұрын
@@gxa5986hey bro i also can't afford this price
@nathanliu3263 Жыл бұрын
hey Adam, how do you use Google cloud BI? Can you give a short description? I am having a hard time logging into the cloud - the database instance log in part
@LearnBI Жыл бұрын
I use Google Cloud for things like SQL instances and BigQuery. There’s not really such a thing as Google Cloud BI unless you’re talking about Looker Studio but that’s very easy to create an account for.
@nathanliu3263 Жыл бұрын
@@LearnBI Yes, I mean speficially, in the video at 33:47. How did you get the instance connection name, database, username and password?
@LearnBI Жыл бұрын
The instance is my own that I created. I'm afraid it's not open to the public to use. You can create your own in Google Cloud easily then you would just need the .SQL file you can get from learnbi.online/pizzaproject to recreate the same database I use.
@lifebysanasaqib Жыл бұрын
A Beginner here so bear with my question - Why didn't we just import the excel tables directly into SQL instead of first running the code from Quick DBD and then copying the data into the created tables?
@LearnBI Жыл бұрын
We definitely could have done but in practice the Excel data doesn’t exist before the database is created and data is collected in it. But I collected the data by creating a dummy pizza ordering page and then used that to create the data for the Excel sheets that we imported.
@ozdurand Жыл бұрын
Hi, I have not been able to import the data from orders and rota. I have gone through the process like the other ones but no data uploading. Furthermore, I was not able to add my constraints
@LearnBI Жыл бұрын
When you run the sql file the data is included so you don’t need to reimport it. This is probably why you are getting errors because there’s duplicate data.
@Chromosome11 Жыл бұрын
Hey Adam, I'm confused a little bit . in your example (Ben's Pizza), we assume ben has a excel with that data and wants to create a chart our you invented to fetch your SQL ?. cause I am thinking if we have a folder that fully have lot of a same table in excel file, could we load to sql in this project and continue your way or excel file are imagination of ben's pizza work ?
@LearnBI Жыл бұрын
Normally Ben would have an ordering system that collected data in a sql database. The Excel data wouldn’t exist. I’m just showing that data as an example of how it would be collected in the database.
@RenatoTripi 11 ай бұрын
Hello Adam, do you have any free alternative for the navicat? I am using my sql workbench, was just wondering if you know any other good ones. Also, I´m running into problems using the import wizard where some of the tables won´t import data from the csvs
@LearnBI 11 ай бұрын
Hi Renato. Workbench is the only free one I've used but I've heard people talk about DBeaver - alternativeto.net/software/dbeaver/about/ Have you managed to solve your issue with the data imports? Remember that the .sql file you execute to build the tables also insert the data so you don't need to insert the csv data as well.
@RenatoTripi 11 ай бұрын
@@LearnBI Hello, yes i´m using DBeacer now, needed to create some indexes for the tables, and convert some dates formats, now everything was sucessfully imported and i can start the querying prart of the video haha
@jenbeauty9628 Жыл бұрын
What type of MacBook are you using? Which laptop is good for data analysis?
@LearnBI Жыл бұрын
I have a M1 MacBook Pro. I don't really have any recommendations for laptops but I would just say to find out what the minimum system requirements are for applications like Power BI, R and Python. Also remember that a lot of analysis in BI relies on cloud technologies so the computing power of your computer isn't used.
@jenbeauty9628 Жыл бұрын
@@LearnBI thanks
@sapnanayak1453 Жыл бұрын
How are the Recipe and Inventory tables connected? Through the quantity columns?
@LearnBI Жыл бұрын
This is explained in the video.
@thewhistleblower577 Жыл бұрын
great video,will be very helpful. but please can i get all the csv files you used?
@LearnBI Жыл бұрын
learnbi.online/pizzaproject
@mayorperriko Жыл бұрын
Hi Adam, I have a question. I am currently a construction worker "journeyman welder" unfortunately my body can't take being in this field anymore due severe low back bulging disk. When I was younger I was very in to computers however once i got older and started working i forgot about my interest in computers just due to constantlyhaving to work my butt off to...i want to change fields and get in to b.i data analysis field...but I will be starting from scratch...any advice on what I will need to start for example like i know ill need to buy a computer first and foremost but any other must have equipment before I jump in head first? Or what computer you recommend for a i?
@LearnBI Жыл бұрын
If you’re wanting to work with BI tools like Power BI and Tableau where you might need to install software, you would need to check the minimum system requirements for a computer. Otherwise, if you start with Google Data Studio, you could use any computer with and internet connection. Other than that there’s not really any other equipment you’d need. You may want to invest in online courses teaching sql and data analytics.
@tadiwamhinga2490 Жыл бұрын
Hey all the best with your career change! @sudoku Master
@Theeloves Жыл бұрын
Wow best with your change! i too am i Journeyman looking to change careers, best of luck
@soliarym4071 7 ай бұрын
ขอขอบคุณ
@LearnBI 6 ай бұрын
Thank you 🙏🏻
@BonCheruiyot Жыл бұрын
Hi i wanna purchase the file,am just wondering can the dataset open in my sql work bench or sql management studio??
@LearnBI Жыл бұрын
Hi, executing the sql file will create a MySQL database so it would work in Workbench but not management studio.
@gladiatpr 2 ай бұрын
ref 10:49 , how come item_id under inventory table is connected to ing_id under recipe table ?
@LearnBI 2 ай бұрын
All of the joins are explained in the video
@acp1251 5 ай бұрын
Hey I purchased your files and the Stock query one text fiile is empty, which is no big deal since I can copy from the video, but still should not be missing at all
@LearnBI 4 ай бұрын
Sorry about that. If you contact me via the website learnbi.online (About page), I'll send you the query.
Adam Finer - Learn BI Online
Рет қаралды 106 М.
techTFQ
Рет қаралды 117 М.
Absent Data
Рет қаралды 68 М.
CareerFoundry
Рет қаралды 227 М.
Adam Finer - Learn BI Online
Рет қаралды 25 М.
Avery Smith - Data Career Jumpstart
Рет қаралды 17 М.