This repository contains a collection of SQL scripts for performing various types of business data analysis.
Each script focuses on a specific analytical objective using structured SQL queries and window functions.
| File | Description |
|---|---|
| 01_change_over_time_analysis.sql | Analyze trends and changes in key metrics over time. |
| 02_cumulative_analysis.sql | Perform running totals and cumulative calculations. |
| 03_performance_analysis.sql | Evaluate performance metrics using ranking and aggregation. |
| 04_data_segmentation.sql | Segment data by customer, region, or category. |
| 05_part_to_whole_analysis.sql | Analyze proportions and contributions to totals. |
| 06_report_customers.sql | Generate summary reports and insights for customers. |
- Uses CTEs and window functions for advanced analytics
- Organized, modular SQL scripts for easy maintenance
- Suitable for Power BI, Tableau, or Python-based data pipelines
Run each .sql script in your SQL environment (e.g., SQL Server, PostgreSQL, or MySQL) after connecting to your database.
Created for data analysis and reporting automation.