Skip to content

hamzeh-khanpour/Python_SQL_Machine_Learning_Microsoft_PowerBI_Microsoft_Azure

Repository files navigation


Python | SQL | Machine Learning | Microsoft Power BI | Microsoft Azure

A structured hands-on learning repository covering Data Analysis with Python, SQL for Data Science, Machine Learning fundamentals, Power BI, and Microsoft Azure.

This repository contains practical notebooks and exercises designed to build strong foundational and applied data skills.

🎓 Certifications

  • Databases and SQL for Data Science with Python – Coursera
    📜 View Certificate

  • Machine Learning Specialization – Coursera
    📜 View Certificate

  • Python for Data Science – Coursera
    📜 View Certificate

  • IBM Data Science Professional Certificate – Coursera
    📜 View Certificate

  • Machine Learning with Python – Coursera
    📜 View Certificate

  • Data Analysis and Visualization with Power BI – Coursera
    📜 View Certificate

  • Microsoft Azure Data Scientist Associate (DP-100) Professional Certificate – Coursera
    📜 View Certificate

  • Microsoft Power BI Data Analyst Professional Certificate – Coursera
    📜 View Certificate

  • Microsoft Azure Data Scientist Associate (DP-100) Exam Prep Professional Certificate – Coursera
    📜 View Certificate

  • Microsoft Azure Machine Learning for Data Scientists – Coursera
    📜 View Certificate

  • Perform data science with Azure Databricks – Coursera
    📜 View Certificate

  • Build and Operate Machine Learning Solutions with Azure – Coursera
    📜 View Certificate


📌 Overview

This repository is organized as a practice and learning workspace for:

  • Data loading and preprocessing
  • Exploratory Data Analysis (EDA)
  • Data cleaning techniques
  • Statistical summaries
  • Introductory machine learning concepts
  • SQL querying
  • Cloud-based data workflows (Azure)
  • Data visualization (Power BI)

📂 Repository Structure

Python_SQL_Machine_Learning_Microsoft_PowerBI_Microsoft_Azure/
│
├── Data Analysis with Python/
│   ├── examples/
│   └── practice notebooks
│
├── SQL examples/
│
├── Machine Learning examples/
│
├── Azure practice/
│
└── README.md

🐍 Data Analysis with Python

Topics covered:

  • Importing CSV datasets from URLs
  • Assigning and modifying column headers
  • Handling missing values (?NaN)
  • Dropping invalid records
  • Inspecting data types (.dtypes)
  • Generating statistical summaries (.describe())
  • Reviewing dataset structure (.info())

Example datasets used:

  • Automobile dataset
  • Laptop pricing dataset

🧠 Machine Learning (Foundations)

Planned and ongoing topics:

  • Linear Regression
  • Train/Test Split
  • Model Evaluation
  • Feature Engineering basics
  • Data preprocessing pipelines

🗄 SQL for Data Science

Examples include:

  • SELECT queries
  • Filtering (WHERE)
  • Aggregation (GROUP BY)
  • JOIN operations
  • Working with structured datasets

☁ Microsoft Azure & Power BI

Hands-on exploration of:

  • Azure Machine Learning
  • Azure Databricks
  • Cloud-based data workflows
  • Power BI dashboards and reporting basics

🛠 Technologies Used

  • Python 3.x
  • Pandas
  • NumPy
  • Jupyter Notebook
  • SQL
  • Microsoft Azure
  • Power BI
  • Git & GitHub

🚀 Getting Started

Clone the repository

git clone https://github.com/<your-username>/Python_SQL_Machine_Learning_Microsoft_PowerBI_Microsoft_Azure.git
cd Python_SQL_Machine_Learning_Microsoft_PowerBI_Microsoft_Azure

Install required packages

pip install pandas numpy matplotlib scikit-learn

Run notebooks

You can open the notebooks using:

  • VS Code
  • Jupyter Notebook
  • GitHub Codespaces

🎯 Purpose

This repository serves as:

  • A structured learning environment
  • A practical data science lab
  • A portfolio demonstrating technical skills
  • A foundation for advanced ML and cloud projects

📌 Future Improvements

  • Add data visualization examples
  • Add full end-to-end ML projects
  • Add Azure ML deployment workflows
  • Add CI/CD examples for data projects

About

Python_SQL_Machine_Learning

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors