Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
In this video, I’m going to show you how to create a SQL database, write custom SQL queries and then create interactive dashboards. This data analyst portfolio project will help you learn how to use SQL and create interactive dashboards.
This is a step-by-step guide from SQL database design to interactive dashboard, perfect for data analysts who want to learn how to add an awesome SQL project to their data analyst portfolio. By the end of this video, you’ll be able to create a SQL database, write custom SQL queries and build interactive dashboards!
GET YOUR HANDS ON THE DATA
This is a data analyst portfolio project
🚨 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
START YOUR BI JOURNEY HERE -
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job -
Learn Basic SQL in 15 Minutes -
BI For Beginners Playlist -
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence -
Ultimate Guide to Looker Studio -
Google Data Analytics Course -
Learn SQL -
SKILLSHARE - 30-day free trial! -
UDEMY -
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design -
Skills You Need To Succeed In BI -
🧰 BI TOOLS
Power BI -
Tableau -
Data Studio -
📊 DATA HUBS & WEBSITES:
Power My Analytics:
Supermetrics:
Data Slayer:
Kaggle -
Statista -
Data World -
📕THE DATA VISUALISATION BIBLE -
🎥 MY YOUTUBE GEAR
My Camera -
Most Used Lens -
Main Key Light -
Softbox -
LED Panel Kit -
Teleprompter -
Main Mic -
Lavalier Mic -
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 -
CONSULTING CALL WITH ADAM -
JOIN MY MAILING LIST -
FACEBOOK GROUP -
#dataanalyst #sqltutorial #businessintelligence
18 views
595
144
7 months ago 00:57:55 1
Data Analyst Portfolio Project (Exploratory Data Analysis With Python Pandas)
7 months ago 01:09:38 1
Data Analyst Portfolio Project #2: Python Customer Segmentation & Clustering
7 months ago 01:01:21 1
Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
7 months ago 00:44:43 1
Data Analyst Portfolio Project #1 | Build a Database | Develop SQL | Create a Dashboard
7 months ago 00:55:38 1
EXCEL PORTFOLIO PROJECT | Build this Interactive Dashboard
7 months ago 00:40:50 1
Full Project in Excel | Excel Tutorials for Beginners
7 months ago 00:39:20 1
Из продаж в аналитика данных. Интервью с выпускником Skypro
7 months ago 01:17:20 1
DATA ENGINEER: Накрутка опыта и база для старта в DE | Интервью с Senior/Team Lead DE
7 months ago 00:56:45 1
Chuck Watson: “NATO in Ukraine: from Proxy to Participants” | The Great Simplification #114
7 months ago 00:23:05 1
Путь в IT - Data Analyst: подробный план обучения на 2024 год.
7 months ago 00:08:52 3
Как сделать сводную таблицу в Python с помощью Pandas. Функция pivot_table 🔥
7 months ago 00:01:03 1
Space junk shower lights up California sky as Chinese rocket parts re-enter atmosphere
7 months ago 00:07:57 1
NOUVEAU : Film 100% OpenAI SORA + 10 Nouvelles Démos Incroyables + Prix
7 months ago 00:58:17 1
RESURRECTION!!!
7 months ago 00:40:43 1
Webinar on SOLIDWORKS Simulation for Packaging Machinery Industry | Engineering Technique
7 months ago 01:31:03 1
ХРИСТИАНИН. МУСУЛЬМАНИН. ГДЕ ИСТИНА?(Васильев, Мухетдинов) //12 сцена
8 months ago 00:02:15 2
“C’est éffrayant“ : Découvrez le missile storm shadow au main des Russes!
8 months ago 00:03:40 1
Monte Carlo: Forecasting Stock Prices Part I
8 months ago 00:11:26 1
Russia’s Economy 2024 Continues to Outperform Predictors.
8 months ago 00:33:52 1
Вебинар «Генерации изображений» | HOW TO GENERATE IMAGES USING NEURAL NETWORKS
8 months ago 01:09:15 1
GOD’S TIMELINE🕛!! Bo Polny, Donné Clement Petruska
8 months ago 00:07:18 1
7-Years Comes to an END... NOW! Bo Polny, Kim Clement
8 months ago 02:57:10 17
Data Analytics with the Google Stack (SQL, Python, Data Visualization, Data Analysis)
8 months ago 02:14:09 1
🔴 WATCH LIVE: NVIDIA GTC 2024 Keynote - The Future Of AI!