Charles John

Data Analyst | SQL | Python | Power BI | Tableau

Based in Brisbane, Australia

Power BI

  • Email Marketing Campaign A/B Testing Analysis (Power BI)

    Email Marketing Campaign A/B Testing Analysis (Power BI)

    Tools Used:

    Here’s a Power BI Dashboard I created to analyze an email campaign promoting a free workshop, focused on testing the effectiveness of different email tones. In total, 9,948 emails were sent, using a combination of three tones: Professional, Casual, and Urgent. The campaign ran over three consecutive days, with an equal distribution of tones each…

  • Email Marketing Campaign Analysis (Power BI)

    Email Marketing Campaign Analysis (Power BI)

    Tools Used:

    Here is the Power BI dashboard I created for the FP20 ZoomChart Challenge. I utilized ZoomCharts in the visuals to enable easy data drill-down, allowing users to explore insights at various levels seamlessly. Goal The goal of this project was to create an interactive dashboard that allows users to analyze the campaign using various filters,…

  • BellaBeat Fitness Tracker Case Study (SQL, Power BI)

    BellaBeat Fitness Tracker Case Study (SQL, Power BI)

    Tools Used: ,

    I completed this case study as part of my Google Data analytics certification. The tools used for this analysis are MySQL and Power BI. Visualization About the company Bellabeat is a high-tech manufacturer of health-focused products for women. Bellabeat is a successful small company, but they have the potential to become a larger player in…