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
750
192
2 months ago 00:12:45 1
1000% Increase In SILVER Demand! Your GOLD & SILVER Are About To Become “Priceless“ - Lobo Tiggre
2 months ago 02:15:10 1
Catching up with Greg Hanley
2 months ago 00:02:32 1
Tesla’s robotaxis show why the EV trade is ’tricky’: Analyst
2 months ago 00:02:49 1
ATLAS | Official Trailer | Netflix
2 months ago 00:01:09 1
’More Jews than ever are leaving Israel’
2 months ago 00:18:02 1
5 Online Businesses That Are Virtually Fail Proof ($1,200+ / Month)
3 months ago 00:59:39 6
Андрон Алексанян х Павел Бухтик: Как быстро вырасти начинающему аналитику
3 months ago 00:00:32 3
Sync completed. Go show them your strength as an emotion-perception-type combat android, Marija.
3 months ago 00:14:16 1
7 HOT Tech Jobs in 2024 | Salaries REVEALED | Ranked by Pay | Entry-Level | Global Demand
3 months ago 00:11:29 1
T-14 Armata - Russia’s Latest Tank
3 months ago 01:38:25 1
Cognitive Dissidents: West is Going Full 1984, 15m Cities, & the AI Climate Scam
3 months ago 00:56:45 1
Chuck Watson: “NATO in Ukraine: from Proxy to Participants” | The Great Simplification #114
3 months ago 00:06:55 1
The ‘GREAT’ SEPTEMBER Worldwide Earthquake!? Bo Polny
3 months ago 00:20:11 1
AfD Sperrminorität: Der “Softwarefehler“ erklärt (D’Hondt vs. Saint Lague Zuteilungsverfahren)
3 months ago 00:03:26 1
Judge Jeanine Pirro: Short Biography, Net Worth & Career Highlights
3 months ago 00:07:08 1
TRUMP from the BLOODLINE of KING👑DAVID!!
3 months ago 00:12:15 1
This Is MIND-BLOWING! Central Bank’s LATEST BOMBSHELL Will Change Gold & Silver Prices - Bill Holter
3 months ago 01:25:08 1
2024💥WORLDWIDE 9-11💥A DAY Remembered for ALL Eternity! Bo Polny, Noah Christopher
4 months ago 00:11:09 1
It’ll Happen OVERNIGHT! The Fireworks Will Start Soon & Gold Will SHOCK THE WORLD - Peter Schiff
4 months ago 00:06:18 1
CNN report exhibits what Gaza resistance has proven for months, with Jon Elmer
4 months ago 00:14:58 1
Guide to Get Power BI Projects
4 months ago 00:14:33 1
500% Increase in Silver Demand! China Just Declared War on Your Gold & Silver - Andy Schectman
4 months ago 00:12:13 1
HUGE LIFETIME OPPORTUNITY! Gold & Silver Prices Will ABSOLUTELY SHOCK Everyone - Matthew Piepenburg
4 months ago 00:13:59 1
Huge News! Japan’s LATEST BOMBSHELL Will Change Gold & Silver Prices FOREVER - Peter Schiff