📌About

Welcome to Nordic Sphere, a simulation of working as a business analyst at a European online retailer of Scandinavian furniture. In this project, I solve real-world business problems posed by my AI manager using data and logic.

🚀 Cases and Solutions

Case #1: Marginality analysis

Case #2: Inventory Optimization (ABC Analysis)

Case #3: Returns Process Optimization

💫 Project Goals

• Practical training for the role of business analyst/project manager/data analyst
• Creating a strong database architecture for e-commerce
• Automated business metric calculations (Margin, Profit) at the SQL level
• Daily solutions for business process optimization cases

🛠 Technology

• Database: PostgreSQL
• Tools: VS Code, Git/GitHub
• Documentation: Notion
• Visualization: PowerBI, Lucid

🏗 Data architecture

<aside> 💡

The technical code for database initialization is available in my https://github.com/Pryma-Dar/Nordic-Sphere

</aside>