A comprehensive collection of SQL scripts for data exploration, analytics, and reporting. These scripts cover various analyses such as database exploration, measures and metrics, time-based trends, cumulative analytics, segmentation, and more.
This repository contains SQL queries designed to help data analysts and BI professionals quickly explore, segment, and analyze data within a relational database. Each script focuses on a specific analytical theme and demonstrates best practices for SQL queries.
sql-data-analytics-project/
├── datasets/ the data as CSV files
├── docs/ No Files in it.
└── scripts/ the queries for analysis.
└── 00_init_database.sql builds the database from the CSV files
The project has two parts, and the scripts follow them:
- Exploratory data analysis, scripts
01to06: you get to know the data, from the tables and dates to the big numbers and the top performers. - Advanced analytics, scripts
07to13: you go deeper with trends, running totals, performance, part-to-whole and segments. Two reports close the project, one for customers and one for products.
| Project | Materials |
|---|---|
| Data Warehouse | Repository |
| Exploratory Data Analysis | this repository |
| Advanced Data Analytics | this repository |
This project is licensed under the [MIT License]. You are free to use, modify, and share this project with proper attribution.
Hi there! I'm Karthick. Results-driven Business & Data Analyst with 4+ years in Amazon Tech Ops, serving as the primary bridge between global business stakeholders and cross-functional engineering teams to drive catalog expansion, competitor intelligence, and data-led strategic initiatives across JP, SG, AU, Far East, and MENA marketplaces.