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.
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 Mohammed Saifuddin,
-
Design and build enterprise-grade SQL Server Data Warehouses
-
Implement Medallion Architecture (BronzeโSilverโGold)
-
Develop scalable analytics-ready data models
-
Deliver executive & operational insights using Tableau & Power BI
-
Optimize SQL, semantic models, and BI performance
-
SQL Server Data Warehouse using Medallion Architecture
-
Data quality, validation & governance
-
Performance tuning (indexes, partitions, aggregates)
-
Analytics Engineering best practices
- Databases: SQL Server, Oracle, MySQL
- BI Tools: Tableau, Power BI
- Data Modeling: Star & Snowflake schemas
- ETL / Prep: SQL, Tableau Prep, Power Query (M)
- Cloud: Azure (Fundamentals)
- Languages: SQL, PL/SQL, Python
- Version Control: Git, GitHub
๐น Enterprise SQL Server Data Warehouse โ Medallion Architecture
๐น Healthcare Analytics KPI Framework
๐น SQL Performance Optimization Playbook
๐ซ Connect with me:
- LinkedIn: https://www.linkedin.com/in/mohammed-saifuddinbi/
- Email: saif.tab83@gmail.com