GitHub topics: datatransformation

Azmary413/Enterprise-Data-Warehouse-Project

Building a modern data warehouse using PostgreSQL, covering the full data pipeline from raw data ingestion to analytics. This includes designing robust data models, implementing ETL processes, and organizing data into bronze, silver, and gold layers to support efficient analysis and reporting.

Language: TSQL - Size: 1.18 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 0

00anubhav00/NIFTY50-analysis

To analyze historical NIFTY 50 index data and uncover market behavior patterns by modeling return transitions between different states.

Language: Jupyter Notebook - Size: 655 KB - Last synced at: 4 days ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

MuhammadBinNasir0123/titanic-eda-project

End-to-end EDA project on the Titanic dataset, from data cleaning to Python-based analysis and reporting.

Language: Python - Size: 60.5 KB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 0 - Forks: 0

Ninashaz/Power-Query-Data-Transformation

Excel Power Query project demonstrating data cleaning, transformation, and preparation for analysis

Size: 231 KB - Last synced at: 11 days ago - Pushed at: 12 days ago - Stars: 0 - Forks: 0

amphi-ai/amphi-etl

Visual Data Preparation and Transformation. Low-Code Python-based ETL.

Language: TypeScript - Size: 2.86 MB - Last synced at: 10 days ago - Pushed at: 10 days ago - Stars: 1,095 - Forks: 72

FiredKreeper/AdventureWorks-SplitPackage

This repository contains an SSIS package that splits employee data from the AdventureWorksDW2017 database into country-specific tables (United States, United Kingdom, Germany, and others). It demonstrates ETL processes using tools like Merge Join, Conditional Split, and OLE DB Destination for efficient data integration.

Size: 1000 Bytes - Last synced at: 14 days ago - Pushed at: 14 days ago - Stars: 0 - Forks: 0

Jxx1234567890jxx/DataTransformationChecker

A Python-based utility for testing and visualizing data transformations. Includes normality tests (Shapiro-Wilk and Lilliefors), a variety of transformation methods, and visual analysis tools for histogram and Q-Q plots.

Size: 1000 Bytes - Last synced at: 15 days ago - Pushed at: 15 days ago - Stars: 0 - Forks: 0

itsyashk1406/sql-portfolio-data-warehouse

A comprehensive modern data warehouse with SQL Server, including ETL processes, & data modeling.

Language: TSQL - Size: 1.02 MB - Last synced at: 20 days ago - Pushed at: 20 days ago - Stars: 0 - Forks: 0

SharanyaT1/Power-BI_-Data-Analysis-Dashboard

This project aims to analyse a fictitious chocolates company sales and visualse them in an interactive dashboard using Power BI

Size: 754 KB - Last synced at: 20 days ago - Pushed at: 21 days ago - Stars: 0 - Forks: 0

NBGamer99/Data-Analysis-StockMarket-Prediction

This project uses Python and Streamlit to analyze and predict stock market trends. It includes data visualization, ETL processes, and machine learning-based predictions. The project integrates historical data, LSTM-based stock price forecasting, and features an interactive Power BI dashboard for enhanced data insights.

Language: Python - Size: 15 MB - Last synced at: 22 days ago - Pushed at: 22 days ago - Stars: 0 - Forks: 0

msg-systems/datatransfer

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

Language: C# - Size: 7.98 MB - Last synced at: 6 days ago - Pushed at: about 1 month ago - Stars: 5 - Forks: 0

Anjali25112/Pharmaceutical-Drug-Sales-Analysis

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

Size: 612 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 1 - Forks: 0

jimhouserock/Data_Transformation_Data_Parsing_DOM_Manipulation

Design Pattern for Dashboard analytics - metrics with time-series data | E-commerce catalogs - products with reviews and ratings

Language: JavaScript - Size: 13.7 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

rahulraimau/Shopper-Spectrum_-Segmentation-and-Recomm

Language: HTML - Size: 1.81 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

264Gaurav/airflow-with-astro

Airflow with astronomer - to automate and scheduling the workflow

Language: Python - Size: 8.79 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

imdad132/Data-Analysis-and-Visualization_SIPRI-Milexp-Dataset

This analysis and visualization helps us understand the rise or decline of military spendings in different regions of the world during the last three decades.

Language: Jupyter Notebook - Size: 454 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

anushreebiswas/Laptop-price-prediction

Machine learning concepts

Language: Jupyter Notebook - Size: 0 Bytes - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

DaviMacielCavalcante/desafio2-prof-artemisia

🚀 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!

Language: Python - Size: 6.12 MB - Last synced at: 4 months ago - Pushed at: 4 months ago - Stars: 2 - Forks: 0

Sarvesh-Prajapati/data-analysis-pandas

Repository showcasing data transformation & analysis skills using Pandas package of Python.

Language: Jupyter Notebook - Size: 12.9 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

MantriYash/Airline-PowerBi-Analysis

This project uses Power BI to transform airline data into actionable insights. It identifies top-performing routes, improves underperforming ones, optimizes resources, and tracks booking trends. With interactive dashboards and secure data access, it helps airlines enhance customer satisfaction, boost revenue through data-driven decision.

Size: 1.06 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

MohammedDerouiche/CS50-s_FinalProject

This result of this project "Uk Salaries Analyser is a WebApp that helps job seekers know more about a specific job in UK regions.

Language: Jupyter Notebook - Size: 24.4 MB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

amalomer11/data-wrangling-

This file shows the analysed result of a consumer delivery dataset with handling the missing values , removes the outliers and correcting the dataset completely

Language: Jupyter Notebook - Size: 104 KB - Last synced at: 5 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

likhi815/Microsoft-Powerbi-Capstone-Project

A Power BI dashboard created using Netflix movies dataset

Size: 2.88 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

likhi815/L

Bank Analytics Project

Size: 18.3 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

EdoChiari/Amazon_Sales_Analysis-Project

Advanced SQL project analyzing over 20,000 sales records from an Amazon-like e-commerce platform. Focuses on customer behavior, product performance, and sales trends using PostgreSQL. Includes data cleaning, revenue analysis, inventory management, and an ERD diagram to visualize database schema.

Size: 1.09 MB - Last synced at: 3 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

Shivabajelan/Flight_Insights_Delays_and_Cancelations

Flight Insights is a Power BI project analysing 2,000,000 commercial flights from major US airports to uncover patterns in flight delays and cancellations. The project leverages a structured business intelligence workflow, including data transformation, modelling, and visualisation, to create an interactive dashboard to bring our data to life.

Size: 22.5 KB - Last synced at: 6 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

RGANDHI8/WORKFORCE-MANAGEMENT-OPTIMIZATION-POWER-BI

Developed an HR Analytics Dashboard for ATLIQ using Power BI, DAX, Power Query, and Excel to analyze workforce trends, employee performance, and attrition rates. This project focused on transforming raw HR data into actionable insights for data-driven decision-making in workforce management.

Size: 701 KB - Last synced at: 6 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

oshinrathor/Power-BI-Analytics-Dashboards

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.

Size: 12.3 MB - Last synced at: 5 months ago - Pushed at: 7 months ago - Stars: 1 - Forks: 0

aafshar17/Netflix_shows_movies_2022

Deep dive analysis into Netflix's shows and movies library for content up until 2022 using PostgreSQL, Power Query, and Power BI (DAX, Visuals, and Dashboard). Led to potentially actionable insights regarding platform content.

Size: 0 Bytes - Last synced at: 7 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

Nel-zi/Nuga_bank

Developed an automated data exploration and cleaning pipeline for Nuga Bank to streamline data preparation, ensure consistent data quality, and normalize datasets into structured databases for efficient analysis and reporting.

Language: Jupyter Notebook - Size: 616 KB - Last synced at: 4 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

Zeekersky/AdventureWorks-SplitPackage

This repository contains an SSIS package that splits employee data from the AdventureWorksDW2017 database into country-specific tables (United States, United Kingdom, Germany, and others). It demonstrates ETL processes using tools like Merge Join, Conditional Split, and OLE DB Destination for efficient data integration.

Size: 862 KB - Last synced at: 6 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

Nel-zi/InsightHire_agency

Built a web scraping solution using BeautifulSoup to extract job listings from MyJobMag, cleaned the data, and loaded it into PostgreSQL with SQLAlchemy for better job data management.

Language: Jupyter Notebook - Size: 336 KB - Last synced at: 4 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

Nikhil-Donthusaram/ConnectX-Telecom-Dashboard

This project showcases a comprehensive analysis of customer churn using real-world telecom data. It employs advanced visualization tools to highlight patterns and trends. The analysis aims to uncover actionable insights for reducing churn and increasing customer satisfaction.

Size: 983 KB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

kinleydhinata/DataTransformationChecker

A Python-based utility for testing and visualizing data transformations. Includes normality tests (Shapiro-Wilk and Lilliefors), a variety of transformation methods, and visual analysis tools for histogram and Q-Q plots.

Language: Python - Size: 7.81 KB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

saivardhan08/My-Projects

In this repository you'll find projects that I have worked on for my own practice and upskilling

Size: 0 Bytes - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

tasneem-badar/Market-Trend-Analysis-and-Price-Prediction-on-Used-Cars

Market Trend Analysis and Price Prediction on Used Cars - A machine learning project for analyzing market trends and predicting car prices.

Language: Jupyter Notebook - Size: 5.86 MB - Last synced at: 8 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

najmaelboutaheri/Scopus-Data-analysis-Morocco

Ce projet vise à analyser les publications scientifiques des universités marocaines en exploitant les données de la base Scopus.

Language: Jupyter Notebook - Size: 37.4 MB - Last synced at: 6 months ago - Pushed at: 8 months ago - Stars: 0 - Forks: 0

yamiiyamu/Unveiling-Trends-in-Hospitality-Analytics

An analysis of hospitality industry trends using Python for data exploration, cleaning, transformation, and visualization.

Language: Jupyter Notebook - Size: 300 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Sakshiistwal13/Spotify

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

Size: 1.46 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 1 - Forks: 0

Anu0408/Truck_Delays_Classification-End-to-End-Machine-Learning-Application

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.

Language: Jupyter Notebook - Size: 19 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Thomas-Nyanumba/HR-Excel-Dashboard-Project

Individual Human Resources project

Size: 748 KB - Last synced at: 5 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

Thomas-Nyanumba/Atlanta-PD-Power-BI-Group-Project

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

Size: 7.24 MB - Last synced at: 5 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

Thomas-Nyanumba/Adidas-US-Sales-Analysis-Power-BI-Project

Application of Power BI Concepts and Tools

Language: Jupyter Notebook - Size: 4.03 MB - Last synced at: 5 months ago - Pushed at: 10 months ago - Stars: 1 - Forks: 0

nigelnuique/layoffs-data-analysis-2023-24

This repository contains an SQL-based analysis of layoffs data, focusing on cleaning, standardization, and exploratory data analysis (EDA).

Size: 123 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

Shashank190/Power-Bi-Project

In this Project, I created a Power BI report/dashboard using Amazon Prime Movies and TV Shows data.

Size: 0 Bytes - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

fasalmhd14/Python-and-Power-BI---HOSPITALITY-CHAIN--REVENUE-PERFORMANCE-ANALYSIS

A data analysis project conducted to analyze the revenue performance of AtliQ Grands hotel chain and provide insights and suggestions necessary to improve revenue.

Language: Jupyter Notebook - Size: 4.53 MB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

fasalmhd14/Business-Insights-360

A comprehensive project delved into the data analysis of various functions of a Hardware manufacturing company like Finance, Sales, Marketing & Supply Chain which will help to generate insights and make data driven decisions in these departments.

Size: 12.7 KB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

RoshniRanaDS27/World_Health_Organization_Data--Women_Of_The_World

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)

Language: Jupyter Notebook - Size: 15.3 MB - Last synced at: 12 months ago - Pushed at: 12 months ago - Stars: 1 - Forks: 0

HarshSingh-27/SuperStore-Sales-Dashboard-Power-BI-

Super Store Sales Dashboard(Power BI)

Size: 1.67 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Chaitanya-0310/Impact-player-analysis Fork of damletanmay/Impact-player-analysis

Conducted a comprehensive data visualization analysis using PowerBI on IPL data to determine the optimal candidate for the Impact Player role. This analysis focuses on evaluating various match situations to identify which player, among the potential impact players, is most likely to create a significant impact when needed.

Language: Python - Size: 14.7 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

IamArshaad/Power-BI

Welcome to the Power BI Projects Repository, a curated collection of my data-driven projects created using Power BI. This repository serves as a platform to showcase my expertise in data analysis, visualization, and reporting using Power BI.

Size: 3.15 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

divithraju/divith-raju-Customer-Sales-ETL-Pipeline

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.

Language: Python - Size: 7.81 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 1 - Forks: 0

glambengco/Coffee-Shop-Business-Strategy---Analysis-of-The-Great-American-Coffee-Taste-Test

The project utilizes real-world survey data to identify the target audience, product offering, and pricing strategy, presenting a data-driven strategy for opening a coffee shop in the United States. This project uses Power Query and Power Pivot in Excel to transform and analyze different question types used in surveys.

Size: 7.76 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

AhanaPodder97/Evolution_of_Video_Games

This repository is a data analytics project using Excel and Tableau. The project is about analyzing and getting insights about video games sales, and users and critics reviews.

Size: 1.24 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Snigdha1078/Netflix-Recommendation

Netflix Recommendation engine

Size: 1.04 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

PranavlovesData/ExcelR_Data_Science_Assignments

This repository contains all the assignments and related files for excelR data science and machine learning course.

Language: Jupyter Notebook - Size: 10.2 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

selvakrishnan/DataFusion_CDAP_Wrangler_Directives

Google Cloud Data Fusion - Data Transformation Logics using CDAP Wrangler Directives.

Size: 83 KB - Last synced at: about 1 year ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

Ackson507/Data-pipeline-with-Airflow-Orchestration

This is the process of automatically extracting data from websites. This can include text, images, and other media types from various web pages.

Size: 49.8 KB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Akshay2515/Cricket_Data_Analytics_Project

Cricket Player Analysis to find the best Players to Play the Final Match

Language: Jupyter Notebook - Size: 4.66 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Adi-200/Bank_Loan_Data_Analysis_Using_Power-BI

Bank Loan Data Analysis Using Power BI

Size: 2.94 MB - Last synced at: 2 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Hariharann16/-Employee-details-Dashboard-for-HR

This dashboard includes interactive visualizations and reports on employee attendance, preferred working modes, and utilization of work-from-home and sick leave policies, demonstrating the impact on strategic decision-making and employee wellbeing

Size: 69.3 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

saeidEmadi/BinaryConvolutionalCode

Error Correcting Codes - Binary Convolutional Code

Language: C++ - Size: 61.5 KB - Last synced at: 6 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

devashish-patel47/DataCo-Global-Data-Analysis

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.

Language: Jupyter Notebook - Size: 9.2 MB - Last synced at: over 1 year ago - Pushed at: almost 4 years ago - Stars: 1 - Forks: 0

MaheshKumarMK/Compressive-strength-prediction

The main purpose of this repository is to build the pipeline for training of regression models and predict the compressive strength of concrete to reduce the risk and cost involved in discarding the concrete structures when the concrete cube test fails.

Language: Python - Size: 187 KB - Last synced at: over 1 year ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

Aishwarya-TheAnalyst/HR-Analytics-using-Power-BI

HR Analytics dashboard specifically designed for the HR department to save 3 - 4 hours of HR work daily

Size: 362 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

LauraMutheu/Ms-Excel-project-one

In this project, I use Microsoft Excel to perform data analysis on a given data set.

Size: 1.68 MB - Last synced at: over 1 year ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

dheerajsk26/AdventureWorks_PowerBI_Dashboard

Power BI Dashboard tracking KPIs and sharing Product & Customer Insights for Adventure Works company

Size: 9.19 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

nileshsingal/CDAC-DBDA-FINAL_PROJECT--NYC-taxi-trip-visualization

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.

Language: Python - Size: 1.46 MB - Last synced at: over 1 year ago - Pushed at: over 4 years ago - Stars: 1 - Forks: 2