Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard

Hey - I just downloaded the project, but it seems to be missing the Stock1 query code. Could you please review this?

Where will i get the content of excel sheet.??

Hello Adam, can you explain the fix for the orders by address, what I understood was that you added "united states" to the end of the full address for each order therefore putting them all in the same country, but why does the geo map still show a map of the UK?

what application you used to created this query? can u give me I hand? iam a beginner learners

amazing! thank you so much

Can you please share All files links.

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.

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?

how do i ger the instance connection link pls

good

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

How can i get this dataset?

This is great. If I may ask, do you have any portfolio project using design query in editor for your analysis?

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

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)

Men i never seen a project like this you are really love this domain , you are goat . keep going we love You

Hi Adam, great video, although I got stuck when it came time to connect to Google Looker, I wish I was able to complete this with you, alas, I don't know how to "configure the back office" to connect to Navicat's database. If you could please one day read this comment and help me out, I would greatly appreciate it. Thank you so much Adam.

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.

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❤