DataWithBaraa /sql-data-analytics-project
Exploratory data analysis and advanced analytics in SQL, from the first look at the data to a customer report and a product report. The data and every query.
★ 302⑂ 167👁 4⑃ 1● 0▤ 1
+0
日增长
302
stars
167
forks
4
watchers
1
prs
0
issues
1
releases
README
SQL Data Analytics Project
The materials of the data analytics project: the data, every query from the videos, and the project roadmap.
⭐ If this project helps you, star the repository so other learners can find it too.
You explore a sales database step by step, then go deeper with trends, segments and two full reports.
New here? Open the setup guide in the 00_setup folder. It walks you through installing SQL Server and creating the database, on Windows and Mac, with the fixes for the common errors.
sql-data-analytics-project/
├── 00_setup/ the setup guide, and the one-click Docker start for Mac
├── 01_datasets/ the data, as a backup and as CSV files
│ ├── DataWarehouseAnalytics.bak the database, ready to restore
│ └── csv-files/ the same data, to build the database yourself
├── 02_docs/ the project roadmap and notes
└── 03_scripts/ the queries, in the order of the videos
└── 00_init_database.sql builds the database from the CSV files
Get the database in one of two ways:
- Restore 01_datasets/DataWarehouseAnalytics.bak in SSMS. It needs SQL Server 2022 or newer.
- Or run 03_scripts/00_init_database.sql. It builds the database from the CSV files in C:\sql\sql-data-analytics-project\01_datasets\csv-files\.
The videos show the folders without numbers: datasets there is 01_datasets here, scripts is 03_scripts.
The chapters of both videos: the minute in the video and the script of each one
Exploratory data analysis (the video)
| | Chapter | Video | Script |
|--:|:--|:--|:--|
| 1 | Intro | 0:00:00 | |
| 2 | What is EDA? | 0:00:41 | |
| 3 | Download Project Materials | 0:01:58 | the setup guide |
| 4 | Dimensions & Measures | 0:06:09 | |
| 5 | 1 Database Exploration | 0:11:03 | 01_database_exploration.sql |
| 6 | 2 Dimensions Exploration | 0:14:20 | 02_dimensions_exploration.sql |
| 7 | 3 Date Exploration | 0:18:08 | 03_date_range_exploration.sql |
| 8 | 4 Measures Exploration | 0:23:22 | 04_measures_exploration.sql |
| 9 | 5 Magnitude Analysis | 0:31:54 | 05_magnitude_analysis.sql |
| 10 | 6 Ranking Analysis | 0:43:05 | 06_ranking_analysis.sql |
| 11 | What is Next? | 0:50:01 | |
Advanced analytics (the video)
| | Chapter | Video | Script |
|--:|:--|:--|:--|
| 1 | Intro | 0:00:00 | |
| 2 | What is Data Analytics Project? | 0:00:46 | |
| 3 | Download Project Materials | 0:02:07 | the setup guide |
| 4 | 1 Changes Over Time Analysis | 0:06:39 | 07_change_over_time_analysis.sql |
| 5 | 2 Cumulative Analysis | 0:14:42 | 08_cumulative_analysis.sql |
| 6 | 3 Performance Analysis | 0:22:32 | 09_performance_analysis.sql |
| 7 | 4 Part-To-Whole Analysis | 0:34:56 | 10_part_to_whole_analysis.sql |
| 8 | 5 Data Segmentation | 0:42:19 | 11_data_segmentation.sql |
| 9 | 6 Build Customer Report | 0:58:08 | 12_report_customers.sql |
| 10 | 7 Build Product Report | 1:17:21 | 13_report_products.sql |
| 11 | Commit Cod