Full Data Analysis Portfolio Exercise (SQL, Excel, Tableau)
A complete data analytics project walkthrough using SQL, Excel, and Tableau. Watch generate a dataset using SQL and use the dataset to create a Tableau dashboard, as well as an MS Excel dashboard.
Download sample dataset:
Timestamps:
0:00 Introduction
2:03 Data analysis process
SQL Section - 4:06
- 4:25 Writing SQL query
- 17:44 SQL query results (dataset)
Excel Section - 19:29
- 19:32 Connecting SQL dataset to Excel Workbook
- 24:11 Creating PivotTables and PivotCharts
25:40 Stopping PivotTable Grouping from affecting another PivotTable
29:24 Creating a graph with multiple lines (series)
35:07 Creating map chart
- 32:22 Setting up Excel dashboard
- 50:52 Adding slicers to make Excel dashboard interactive
Tableau Section - 1:00:35
- 1:01:12 Connecting Excel dataset to Tableau Workbook
- 1:02:08 Setting default properties
- 1:02:49 Making
1 view
531
202
4 weeks ago 00:06:30 1
Leadstal vs. Leads Sniper: Which Email Extractor REALLY Gets the Job Done? 😎
4 weeks ago 06:02:40 1
🔥НАВЕЩАЕМ СТАРОГО ХРЫЧА (КОРДОН)! 2: HEART OF CHORNOBYL НА ВЕТЕРАНЕ! #5
2 months ago 00:02:02 12
DayZ Update Teaser
2 months ago 00:02:41 2
[K-POP IN PUBLIC | ONE TAKE] (여자)아이들((G)I-DLE) - ’Super Lady’ Rock Version by MYSTERIⱯ
2 months ago 00:12:33 1
Beyond Good and Evil 2, Space Marine 2, Dragon Age, Sniper Elite, Fallout 76 | НОВОСТИ
2 months ago 00:01:21 1
Sound of Earth’s magnetic flip 41 000 years ago
2 months ago 01:07:37 1
Big Brother Is Watching: Hackers Fight The Rapid Rise Of Surveillance | HAK_MTL (2019) | Full Film
2 months ago 00:26:46 1
Endless OS | Best Linux Distro That’s Chock Full of Apps
2 months ago 00:01:27 3
glow dm skills android handcam
2 months ago 00:50:16 1
Undercover Cops [ARCADE] Gameplay Walkthrough FULL GAME [4K 60FPS] - No Commentary
2 months ago 00:06:20 1
Arctic MX-6 vs MX-4
2 months ago 00:54:25 1
Boost energy and reduce cravings with these hacks | Glucose Goddess Jessie Inchauspé & Tim Spector
2 months ago 00:06:15 7
Sauerbraten: Geometry Jailbreak (mesh mover)
2 months ago 00:23:24 1
Carla Morrison: Tiny Desk Concert
2 months ago 00:04:59 1
Romancing SaGa 2: Revenge of the Seven – Launch Overview Trailer – Nintendo Switch
2 months ago 00:30:32 1
OceanGate Wreck Shows Why Sub Wasn’t Strong Enough To Survive - NTSB Shares Important Details
2 months ago 00:08:56 1
Charlie’s Angels: Full Throttle (2003) (3/3) | Pertempuran | Cameron Diaz, Drew Barrymore, Lucy Liu
2 months ago 00:09:56 11
Prijon Kayaks Beast PR-X “Detailed Walkthrough“
2 months ago 01:08:48 1
The Economy of Tomorrow | Aging Future | Documentary Economy
2 months ago 00:03:15 1
MOIKALOOP x GHOST DATA | Animated Music Video
2 months ago 00:16:56 1
Big Tech AI Is A Lie
2 months ago 00:04:58 5
Romancing SaGa 2: Revenge of the Seven | Overview Launch Trailer
2 months ago 00:05:00 1
Romancing SaGa 2: Revenge of the Seven - Overview Launch Trailer | PS5 & PS4 Games
2 months ago 00:07:20 1
Outscraper Vs. Leads Sniper | Which is the best Google Maps Scraper? 🔥