/BI_PROJECT_2

Create and deploy an efficient data warehouse using Microsoft SQL Server tools, optimizing loading processes with SSIS for ETL workflows. Extend functionality with SSAS, SSRS, and pivot tables for in-depth analysis, enhancing insights through Power BI visualization.

Primary LanguageTSQL

Problem Scenario and Business Needs

This project addresses the ongoing organizational restructuring by implementing a robust Data Warehouse solution for the KGB dataset. The objective is to provide actionable insights and support informed decision-making to streamline operations.

Business Objectives:

  • Streamline spending across diverse markets.
  • Implement sustainable procedures for improved logistical systems.
  • Enhance insights into sales for strategic decision-making.

Key Questions to Address:

  1. Identify top-selling products by market and date.
  2. Analyze average transportation costs by transport type, product, and market.
  3. Determine the client segment with the biggest sales by market and date.
  4. Create a comprehensive customer profile based on products, categories, and subcategories.
  5. Analyze product sales variations throughout the year.
  6. Calculate average revenue per sale per product type.
  7. Evaluate regional profits and recommend optimal investment resolutions.