Skip to content

Latest commit

 

History

History
44 lines (34 loc) · 1.89 KB

File metadata and controls

44 lines (34 loc) · 1.89 KB

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: