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 in quickly exploring, segmenting, and analyzing data within a relational database.
In any Data Science project the most crucial step is Data Analytics, which helps in understanding the data, identify patters, and uncover insights that might not be immediately apparent. This is why this project includes Data Analytics in 2 phases Exloratory Data Analytics and Advanced Data Analytics.
- Exploratory Data Analytics(EDA): It focuses on Database, Dimension, Date and Measures Exploration & understanding the Magnitude and Rankings of the data. Scripts
01 - 07focuses on EDA. - Advanced Analytics: It contains advanced analytical SQL Queries for analysing Change-Over-Time, Cumulative Analysis, Performanse Analysis, Part-to-Whole Proportionality, Data Segmentation and Reporting. Scripts
08 - 13includes Advanced Analytics.
The Data-Anayltics-Project roadmap includes 12 steps in order to establish a proper understanding to the Database:
Everything is for Free!
- 🔥Database: Set-Up the project's Database by importing the backup file for the database or by following the another repository project Data-Warehouse-Project1
- SQL Server Express: Lightweight server for hosting your SQL database.
- SQL Server Management Studio (SSMS): GUI for managing and interacting with databases.
- Git Repository: Set up a GitHub account and repository to manage, version, and collaborate on your code efficiently.
- DrawIO: Design data architecture, models, flows, and diagrams.
Hi there! I'm Ayushman Bhargav. My field of interest include Internet of Things(IoT), Data Science and Machine Learning(AI/ML) , working towards upgrading my skills and knowledge through a combined learning of Theoretical Concepts as well as using practical projects to advance my learning.
Let's stay in touch! Feel free to connect with me via LinkedIn:
