Keywords
Skills
Google Data Studio (Campaign)
- Data understanding by exploring raw data in BigQuery.
- Query SQL in BigQuery to create tables suitable for analysis (experience in: unstructured to structured, structured to meaningful format)
- Built dashboards in Google Data Studio to track campaign performance and target achieved during campaign period.
- Built dashboards for A/B testing
- Conducted A/B testing with the product team and conclude which test is better than the other using statiscal method.
- Worked closely with the product team and marketing team to understand requirements given via JIRA
- Documented technical understanding and analysis results via Confluence
- Built multiple dashboards as per specified in functional specification document.
- Communicated with functional team and the design team to deliver dashboards developed.
- Developed queries using DAX and MDAX to ensure the data presented in dashboards were accurate.
- Improved the existing data modeling to ensure the relationship between tables were joined correctly.
- A project leader to research on new ideas for dashboards and improve current process.
- Researched on ways to improve current dashboards.
- Implemented new ideas for demo’s dashboards templates, such as Social Media Analytics.
- Extracted coordinates and Google reviews data for various outlets using Google API and R or Python.
- Harvested data from website using R.
- Involved in requirement gathering with clients.
- Communicated with developers to further understand client’s database.
- Researched on ways to build data warehouse to store data marts.
- Involved in creating PostgreSQL queries to automate ETL processes.
- Built multiple dashboards with almost real-time analysis by using Microsoft Power BI, which included data preparation, data modelling and creating DAX queries.
- Performed analysis on sales growth and trend.
- Created a new dashboard specifically to compare data.
- Presented dashboard reports to business users.
- Wrote user guidelines and designed storyboards during project handover phase.
- Involved from ideation phase to presenting demo to potential clients.
- Experienced in preparing dummy data to build almost-real analysis to potential clients.
- Experienced in data modelling and creating DAX queries.
- Improvise existing dashboards to provide better analysis and visualization.
Project history
Local Availability
Only available for the countries
Malaysia
Remote; Canada; Europe; USA
