1) Used Power Query to automate the
extraction and cleaning of massive datasets,
converting raw logs into structured tables.
2) Leveraged Power Pivot to build a Star
Schema, allowing for complex cross functional analysis between "Manufacturing
Costs"
,
"Shipping Timelines,
" and
"Revenue."