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

Published 2022-10-14
🏠 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 - Navicat Tutorial  

🚨 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

All Comments (21)
  • @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
  • 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!
  • @ezhankhan1035
    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!
  • @estheticsguru
    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!!!
  • 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 🥰
  • @user-wl2tv1dh3t
    Thank you, Adam. Hope to see more of you step-by-step tutorial project.
  • Adam deserves millions of subscribers and views he is a real educator/entertainer, you deserve it alla mate
  • @givenseshoka4812
    Much appreciated, I am not a specialist but this video answered most of the questions I had😊
  • @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.
  • @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!
  • Gorgeous explanation! quite useful, highly appreciated ❤❤‍🔥
  • @abdirahem221
    I've never seen a project explained like this. This is what I was looking for in my entire career. Thank U soo much.
  • @san1araNN
    very clear and understandable english for not native people like me , ty god
  • 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!!!
  • @vikb9537
    Thank you so much for this video Adam.
  • @yesotv2328
    excellent video. very instructive and easy to understand.