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

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
(N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!)

👉🏻 CHECK OUT ALL OF OUR PROJECTS HERE

🚨 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

=============================
CHOOSE A LEARNING PATH
=============================

=============================
🧰 LEARN TOOLS & SKILLS
=============================

=============================
📊 DATA PROJECTS ($)
=============================

=============================
🎥 RECOMMENDED VIEWING
=============================

=============================
📕 FREE EBOOKS
=============================

=============================
📊 DATA HUBS & WEBSITES
=============================

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!
=============================

#dataanalyst #sqltutorial #businessintelligence

[LearnBI]

🚀 BI CAREER STARTER PROGRAM 🚀
A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS.

[Hemmohammad]

I've never seen a project explained like this. This is what I was looking for in my entire career. Thank U soo much.

[cradleofrelaxation]

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!

[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!

[cesarlensterlunas]

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 🥰

[ezhankhan]

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!

[MCPeeBoy]

This video is phenomenal. I noticed that most other tutorials on youtube don't really touch on the process of cutting and stitching data together so I really appreciate you going over it in such simple manner.

[mustaphakechichi]

Adam deserves millions of subscribers and views he is a real educator/entertainer, you deserve it alla mate

[hoanglam]

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.

[night_in_Rome]

Hello, thank you for the video, it is quiet helpful. For the calculation of shift duration i suggest this way : SELECT
start_time,
end_time,
ROUND(TIME_TO_SEC(TIMEDIFF(end_time, start_time)) / 3600, 1) AS shift_duration_hours
FROM
shift;
It is very simple, hope it helps !

[estheticsguru]

I cannot thank you enough for this 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!!!

[vanguard]

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

[print_the_code]

Sir this is very useful for my journey of SQL learning

[RichardNicolas-sl]

Thank you, Adam. Hope to see more of you step-by-step tutorial project.

[osoriomatucurane]

Awesome SQL project, crystal clear and consice. This is precisely what I have long been looking for, the essential SQL skills relevant to data analytic workflow.

[أواني_لمزابي]

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

[givenseshoka]

Much appreciated, I am not a specialist but this video answered most of the questions I had😊

[sanaraNN]

very clear and understandable english for not native people like me, ty god

[harrisonzeigler]

Great video from start to end. Very useful information and great use of complimentary visuals. I appreciate your ability to effectively teach a complicated topic so well! Thank you.

[MasterMeow]

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❤