Skip to content

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

License

Notifications You must be signed in to change notification settings

saif-dataworks/SQL-Data-Analytis-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

18 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

SQL-Data-Analytis-Project

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.


๐Ÿ›ก๏ธ License

This project is licensed under the MIT License. You are free to use, modify, and share this project with proper attribution.

๐ŸŒŸ About Me

Hi there! I'm Mohammed Saifuddin,

๐Ÿš€ What I Do

  • 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

    ๐Ÿงฑ Current Focus

  • SQL Server Data Warehouse using Medallion Architecture

  • Data quality, validation & governance

  • Performance tuning (indexes, partitions, aggregates)

  • Analytics Engineering best practices

๐Ÿ› ๏ธ Tech Stack

  • 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

๐Ÿ“Œ Featured Projects

๐Ÿ”น Enterprise SQL Server Data Warehouse โ€“ Medallion Architecture
๐Ÿ”น Healthcare Analytics KPI Framework
๐Ÿ”น SQL Performance Optimization Playbook

๐Ÿ“ซ Connect with me:

About

This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages