(Power BI, mySQL, Excel) Power BI Forecast Tracking
1. Developed query (MySQL) to model the data 2. Developed basic visualization that would capture basic business 3. Communicate with stakeholders and user to add
Data Visualizer
Data Analyst
Microsoft Excel
Microsoft Power BI
MySQL
(Python pandas, Excel) Transform SurveyMonkey Data - Audiovisual
Transform double headers dataset from SurveyMonkey for further use in latter analysis pipeline.
Data Analyst
Microsoft Excel
pandas
Python
(VBA, Power Query) Remodeling Quotation Workbook
Overhauling for the workbook to work as automated quoting system. Challenges: Data tables are not well-organized. Formulas are not optimized for automation.
Data Modelling Analyst
Data Analyst
Microsoft Excel