Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for big data.
PRODUCTS SALES & CUSTOMER VALUE SEGMENT ANALYSIS Mar 2023
· SQL to transform data from 9 relatable tables from products sales databases using Join and key SQL concepts like As, From, and Into
· Transformed and summarized data using aggregate functions alongside Group By to effect valuable insights
· Exported and visualized data with Excel to identify key intelligence that can boost sales performance
· Utilized SQL to extract data for the creation of a customer value segment, and PowerBI to analyze the values and contribution of each segment based on criteria that will help to boost marketing strategy
PRODUCTS SALES ANALYSIS Dec 2022
· Implemented PowerBI to refine data from Excel
· Transformed data by using DAX in PowerBI to ensure data validity
· Incorporated DAX function to perform calculations for calculated columns and measures
· Produced a report with PowerBI to highlight sales proportions and identify key drivers of performance
· Created an interactive dashboard which was communicated to stakeholders to provide decision support
AWS Cloud Practitioner (CLF-C01) 2023
AWS Solutions Architect-Associate (SAA-C03) 2023