Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

aetheris-consulting/data-project

Open more actions menu

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 

Repository files navigation

SAP-Style Inventory Data Cleanup & Power BI Prep

This project simulates a real-world data analyst workflow using a grocery inventory dataset to mimic operational SAP exports. It demonstrates skills in data extraction, cleaning, transformation, and reporting—aligned with enterprise requirements for analytics and BI integration.

📊 Live Dashboard

🔗 Click to view the interactive Power BI Report


🔧 What This Project Does

  • 🧼 Loads and cleans raw operational data
  • 🔄 Standardizes column formats and handles missing values
  • 🧠 Adds classification logic (e.g., "Low" vs "Healthy" inventory)
  • 📊 Outputs a clean CSV ready for Power BI dashboards

📁 File Structure

data project/
├── data/
│   ├── clean_inventory.csv       ← cleaned, dashboard-ready dataset
│   └── raw data/
│       └── inventory_data.csv    ← original raw inventory file
├── etl_pipeline.ipynb            ← Jupyter Notebook used to process the data
├── README.md                     ← you are here

About

a simple data project

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published
Morty Proxy This is a proxified and sanitized view of the page, visit original site.