Skip to content

A comprehensive repository for Data Analytics learning and projects. It includes MySQL, Python, Power BI, Tableau, and Excel. The goal is to analyze data, generate insights, and create compelling visualizations for real-world datasets.

Notifications You must be signed in to change notification settings

shafaq-aslam/data-analytics-dairy

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

30 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

data-analytics-diary banner

πŸ“ˆ Data Analytics Diary

My personal journey into the world of data-driven decision making πŸš€


🧠 About This Repository

Welcome to my Data Analytics Diary β€” a comprehensive repository for learning and practicing Data Analytics using a blend of industry-leading tools:

  • πŸ—„οΈ MySQL: Querying and managing structured data
  • 🐍 Python: Data cleaning, wrangling, and analysis
  • πŸ“Š Power BI & Tableau: Building interactive dashboards & visual storytelling
  • πŸ“— Excel: Quick analysis and spreadsheet-based models
  • ☁️ Azure & AWS: Exploring cloud platforms for data storage, pipelines, and services

πŸŽ“ Learning Resources

This journey is powered by the Data Analyst Bootcamp by Alex The Analyst β€” a beginner-friendly YouTube playlist that covers:

  • SQL fundamentals
  • Python for Data Analytics
  • Excel dashboards
  • Tableau & Power BI visualizations
  • Introduction to cloud platforms
  • Tips on Using Linkedin to land a job
  • Resume and portfolio building tips

πŸ“Ί Highly recommended for aspiring data analysts!


🧩 Skills & Tools Covered

  • βœ… SQL Queries (JOINs, Aggregations, Subqueries)
  • βœ… Data Wrangling with Pandas
  • βœ… Exploratory Data Analysis (EDA)
  • βœ… KPI Dashboards & Visualizations
  • βœ… Business Intelligence Reports
  • βœ… Cloud-based tools (Azure & AWS)
  • βœ… Real-world dataset projects

πŸ—‚οΈ Folder Structure

Each tool's folder contains:

  • πŸ“˜ Practice tasks
  • πŸ“Š Project files & screenshots
  • πŸ“ Notes, queries, and scripts

πŸ” Example Projects

  • 🏒 Sales Analysis Dashboard
  • πŸ“¦ Supply Chain Optimization
  • 🧾 Customer Churn Analysis
  • πŸ’Έ Financial KPI Reporting
  • πŸŽ“ Student Performance Insights

🌱 Why This Diary?

To track my learning journey, reinforce concepts, and showcase real-world problem-solving using data.
If you're learning analytics too β€” feel free to explore, fork, or drop a ⭐!

πŸ’¬ β€œWithout data, you're just another person with an opinion.” β€” W. Edwards Deming


πŸ“Œ Tags for SEO

data-analytics python mysql sql powerbi tableau excel data-visualization kpi-dashboard eda real-world-data data-analysis-projects business-intelligence analytics-portfolio

About

A comprehensive repository for Data Analytics learning and projects. It includes MySQL, Python, Power BI, Tableau, and Excel. The goal is to analyze data, generate insights, and create compelling visualizations for real-world datasets.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published