visual data prep powered by python
Transform your data into semantic, machine-readable knowledge graphs - no coding required.
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.
IBM Generative AI Engineering Professional Certificate
The Spotify Music Analysis Dashboard provides key insights into user streaming behavior, revealing trends in track popularity, peak listening times, and artist performance.
🚀 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!
Bank Loan Data Analysis Using Power BI
assignments and projects for Yeshiva University's Katz School Information Architectures course, spring 2020
🚀 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.
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.
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.
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.
Analyzing Real time food ordering data using Excel!
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.
ETL pipeline with Airflow and astronomer - to automate and scheduling the Weather workflows
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.
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/datas…
A modern, data warehouse–native ELT pipeline using a Medallion architecture (Bronze/Silver/Gold) in SQL Server: ingested raw data into Bronze tables, transformed and cleansed it into Silver tables using T-SQL stored procedures, and published Gold-layer reporting views (star schema and flat/wide tables).
A Power BI group (AEM9) project under the Analytics Extra Mentorship Program
Add a description, image, and links to the datatransformation topic page so that developers can more easily learn about it.
To associate your repository with the datatransformation topic, visit your repo's landing page and select "manage topics."