Purpose

This documentation outlines the process for creating a Power BI report that allows users to toggle between Volume-Based, Sales-Based, and ICM-Based decompositions using a single-page layout.
The report integrates three datasets:

  • ICM dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_icm

  • Sales dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume 

  • Volume dataset: gcp-sqo-data-pricing-d.DS_SpecialtyPolymers.V_FACT_FIDB_sales_history_volume

Functional Requirements

  • Toggle Switch: Three buttons/segmented control – Volumes, Sales, ICM.

  • Persistent Filters: User-applied filters remain active when switching between datasets.

  • Waterfall Chart: Displays decomposition (Added/Lost Key, Variation, FX Conversion, etc.).

  • Data Table: Displays detailed breakdown by Market Cluster, BDM, Business Line, Region, Final Customer, Sold-to Name, H4/Product L4, Variation values.

  • Filters on Report:

    • gbu_region

    • sold_to_group

    • sold_to_code

    • sold_to_name

    • market_cluster

    • h4_product_l4

    • gbu_product_family

    • product_code

    • product_name

ICM Dataset

Source: V_FACT_FIDB_sales_history_icm
Required columns: (GBU, Market Cluster BDM, Investor MKT Group, Business Line, GBU Region, Final Customer, Sold-to Name, Sold-to Code, H4 / Prod L4, Product, Product Code, Volumes YTD Jul 2024 (KG), Volumes YTD Jul 2025 (KG), Sales YTD Jul 2024 (€), Sales YTD Jul 2024 Restated (€), Sales YTD Jul 2025 (€), Sales YTD Jul 2025 Restated (€), Unit Price YTD Jul 2024 (€/KG), Unit Price YTD Jul 2024 Restated (€/KG),  Unit Price YTD Jul 2025 (€/KG), Unit Price YTD Jul 2025 Restated (€/KG), ICM YTD Jul 2024 (€,) ICM YTD Jul 2024 Restated (€),   ICM YTD Jul 2025 (€), ICM YTD Jul 2025 Restated (€), Unit ICM YTD Jul 2024 (€/KG), Unit ICM YTD Jul 2024 Restated (€/KG), Unit ICM YTD Jul 2025 (€/KG), Unit ICM YTD Jul 2025 Restated (€/KG), % ICM YTD Jul 2024, % ICM YTD Jul 2025, % ICM Variation, Added/Lost Key (€), Volume Variation (€), Volume Exceptions (€),  Total Volume (€),  Price Variation (€), Variable Costs Variation (€),     FX Conversion (€), Pricing Power (€),  Equivalent Grades, Equivalent Customers, is SAMPLE, is SMOG, is By Product, is Credit/Debit Notes, is Push to Price, is Push to Volume, is Push to VC   is Price Outlier)

ICM metrics: (YTD previous year, Added/Lost Key, Volume Variation, Price Variation, Variable Costs Variation, FX Conversion, YTD current year)

Sales Dataset

Source: V_FACT_FIDB_sales_history_volume
Required columns: (GBU, Market Cluster BDM, Investor MKT Group, Business Line, GBU Region, Final Customer, Sold-to Name, Sold-to Code, H4 / Prod L4, Product, Product Code, Volumes YTD Jul 2024 (KG), Volumes YTD Jul 2025 (KG), Sales YTD Jul 2024 (€), Sales YTD Jul 2024 Restated (€), Sales YTD Jul 2025 (€), Sales YTD Jul 2025 Restated (€), Unit Price YTD Jul 2024 (€/KG), Unit Price YTD Jul 2024 Restated (€/KG), Unit Price YTD Jul 2025 (€/KG), Unit Price YTD Jul 2025 Restated (€/KG), Added/Lost Key (€), Volume Variation (€), Volume Exceptions (€), Total Volume (€), Price Variation (€), FX Conversion (€), Equivalent Grades, Equivalent Customers, is SAMPLE, is SMOG, is By Product, is Credit/Debit Notes, is Push to Price, is Push to Volume, is Price Outlier)

Sales metrics: YTD Sales (EUR), Added/Lost Key (EUR), Price Variation (EUR), FX Conversion (EUR), YTD current year (EUR)

Volume Dataset

Source: V_FACT_FIDB_sales_history_volume
Required columns: (GBU, Market Cluster, BDM, Investor MKT Group, Business Line, GBU Region, Final Customer, Sold-to Name, Sold-to Code, H4 / Prod L4, Product, Product Code, Volumes YTD Jul 2024 (KG), Volumes YTD Jul 2025 (KG), Added/Lost Key (KG), Volume Variation (KG), Equivalent Grades, Equivalent Customers, is SAMPLE, is SMOG, is By Product, is Credit/Debit Notes, is Push to Price, is Push to Volume, is Price Outlier).

Volume metrics: YTD Volume (KG), Added/Lost Key (KG), Volume Variation (KG), YTD current year (KG) 


Dashboard KPIs link


  • No labels