visual data prep powered by python

ETL console command tool using xml job files transfering/synchronizing ADO.Net, LDAP, JSON, XML, CSV data sources

Transforming Bitly User activity dataset who shorten .gov links into readable tabular data from json file to a DataFrame to eventually a CSV.

🚀 ETL Challenge: A hands-on project to explore ETL concepts and Data Lake creation in the cloud! Ideal for those who want to understand how to extract, transform, and load data in a scalable environment and integrate it with BI tools for visualization and analysis!

The Spotify Music Analysis Dashboard provides key insights into user streaming behavior, revealing trends in track popularity, peak listening times, and artist performance.

assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020

This repository contains the data analysis of DataCo Global's supply chain dataset performed by our project group called Dream Five. We are a group of 5 students from St. Clair college who studied Data Analytics for Business as a Post Graduate Diploma.

Analyzing Real time food ordering data using Excel!

Automated Wafer Sensor Fault Detection with CI/CD Pipeline This project implements a system for wafer sensor fault detection using machine learning.

This project is an interactive Mobile Sales Dashboard built using Microsoft Power BI. The dashboard provides deep insights into mobile sales performance across different cities, brands, payment methods, and time periods.

The data set contains data about city fuel cycle consumption of vehicles. This report demonstartes data cleaning and preparation techniques using SAS to prepare it for statistical analysis. It uses arrays, concatenation, data type converison, outlier removal and standardization. The dataset is downloaded from https://archive.ics.uci.edu/ml/datasets/Auto+MPG in July 2021.

This project focuses on Retail Store Sales Analysis using SQL, applying EDA and data cleaning techniques directly within SQL to extract meaningful business insights from transactional retail data.

ETL pipeline with Airflow and astronomer - to automate and scheduling the Weather workflows

This interactive Power BI dashboard explores drug sales performance across multiple pharmaceutical categories over time.

A dbt project that transforms raw retail data into a clean data warehouse for supply chain and inventory analytics. Tracks KPIs like inventory turnover, stockout rate, and supplier lead time. Features a layered modeling approach, data quality tests, and historical snapshots.

Bank Loan Data Analysis Using Power BI

🚀 Excited to share my latest project, a Bank Loan Analysis Dashboard developed in Power BI. This dashboard provides a consolidated view of key metrics, offering deep insights into loan applications, funding, and repayments.

A Power BI group (AEM9) project under the Analytics Extra Mentorship Program

This repository contains a collection of interactive Power BI and EXCEL dashboards, offering insights across various datasets. Key dashboards include career data analysis, store product pricing, NIA case trends, and Uber ride data analysis. They provide valuable visualizations for decision-making.

A store who sells bikes in North America, Europe, and Pacific needed some help in analyzing the raw data they have . The data is comprised of 1026 rows, and 13 attributes.

Modern machine learning project development - This end-to-end project implementation provides the real-time delay updates to logistic companies. It uses MLflow for model tracking and management, Hopsworks Feature Store for storing and managing the dataset, and Streamlit for building an interactive web application to predict truck delays.

🚀 Excited to share my latest project, a Bank Loan Analysis Dashboard developed in Power BI. This dashboard provides a consolidated view of key metrics, offering deep insights into loan applications, funding, and repayments.

Data analysis and visualization of New York Yellow Taxi Trip data, The core objective of this is to find the most pickups, drop-offs of public based on their location, time of most traffic and how to overcome the needs of the public, by using BigData Technologies and Tableau.

Doing ETL from database management system to POWERBI. To aid AtliQ Hardware company with their market growth and issues in terms of tracking sales. Giving Bhavan Patel insights with this business through PowerBI Dashboarding

Women's_Maternal and Reproductive Health around the world (WHO Data cleaning, Data transformation, Data Normalization, Data Engineering, Data modeling, ERD Dia, Exploratory Analysis, Data visualization)

IBM Generative AI Engineering Professional Certificate

This ETL project was designed to demonstrate the development of a scalable data pipeline for customer sales analysis. It covers all essential steps, from data extraction to transformation and loading into a database, with Apache Airflow used.

Cleaning a Messy Data using excel

🚀 Financial Performance & Business Optimization for a Fast Food Chain 🍔📊

Application of Power BI Concepts and Tools