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
😸 NEW 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 -
Learn Basic SQL in 15 Minutes -
BI For Beginners Playlist -
🎓 RECOMMENDED COURSES
SQL For BI Analysts -
Excel For BI Analysts -
Power BI For BI Analysts -
Tableau For BI Analysts -
Ultimate Guide to Looker Studio -
-
🧰 DATA ANALYST PROJECTS (PAID)
Ben’s Pizza -
Hotel Reservations -
Multi-Channel Marketing -
Call Centre -
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design -
Skills You Need To Succeed In BI -
📊 DATA HUBS & WEBSITES:
Power My Analytics -
-
Kaggle -
Statista -
Data World -
📕THE DATA VISUALISATION BIBLE -
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
1 view
1944
732
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
3 months ago 00:01:09 1
’More Jews than ever are leaving Israel’
3 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
4 months ago 00:07:08 1
TRUMP from the BLOODLINE of KING👑DAVID!!
4 months ago 00:12:15 1
This Is MIND-BLOWING! Central Bank’s LATEST BOMBSHELL Will Change Gold & Silver Prices - Bill Holter
4 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