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
427
162
2 months ago 00:36:17 1
Сказки опасны для детей!
2 months ago 00:03:36 1
Oratrice Mecanique but the whole song is voicelines
2 months ago 00:00:40 1
The Ocean Race Atlantic 2026
2 months ago 00:24:28 1
Почему слушать сигналы тела зачастую опасно
2 months ago 00:09:34 1
Прохождение Call of Duty: Modern Warfare 2 - Часть 1: Д.Д.Б.Т.
2 months ago 00:08:03 1
Vancouver, Canada 1920s in color [60fps,Remastered] w/sound design added
2 months ago 00:08:28 1
Лучшие бесплатные курсы и книги по Python в 2024 год.
2 months ago 01:06:23 1
Energy power meters 3 units connect wtih WinCC Explorer SCADA Server and Client configuration
2 months ago 00:08:59 1
San Francisco 1903 in color, Market Street Before Parade [60fps,Remastered] w/sound design added
2 months ago 00:07:47 1
ASTEROID IMPACT Comparison 🌑💥
2 months ago 00:31:14 1
INTENSE Full Body Workout - 30 Min No Equipment
2 months ago 00:31:41 1
CYBERPUNK MUSIC No Copyright Mix (No Copyright Music Tracks)
2 months ago 02:53:32 1
Русская рыбалка 4. 💲Медное!!!Шанс на калибр x3 💲Помощь новичкам🐠 Карусель 🎁Турниры