Amazon Brand Metrics Analysis for Multiple Advertising Agencies

Cleaned raw data from Google Big Query and transformed it as a presentable format by writing complex SQL queries in DBT.  The process was optimized to cut down on costs for several related platforms. A 53% cost reduction was attained.  Learned the client's requirements and analyzed the data of Advertising Campaigns, Sales and Marketing and different operations. Developed custom dashboards in PowerBI to depict the analyzed reports. Embedded the dashboard on their website and was responsible for maintenance.