Skip to content

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

 
 
 

Contributors

Languages