Start: IICS IPU Data Transformation

Load Input Files: - IPU Usage Data (CSV) - Date Table (PepsiCo Calendar) - Azure Resource Metadata - Azure Cost Data

Format Dates in Usage Data Join with Date Table to Map Week & Period

Aggregate Azure Cost Data Join with Date Table

Aggregate Azure Cost - By Resource - By Environment Cost = % Usage x Total Cost

Output Final Table: Org ID, Asset, Usage, % Usage, Cost

Platform IPU Metering Data Download

Authenticate User

Initialize Session

Send Request Using CDIPC Endpoint

Send Request Using Metering Endpoint

Poll for Job Completion

Download and Save Data