Skip to content

HienNau/Uniace_Project

Repository files navigation

  • Conducting in-depth analysis of SEO performance and marketing campaign effectiveness for Uniace over a 24-day period, utilizing a datasets comprising over 97,000 records.

  • Cleaning and preprocessing raw data using Excel VBA macros and integrating data from 3 separate Excel files.

  • ETL data: Extracting, transforming data using python and loading analytical data to SQL server.

    image

    image

    image

    image

    image

    image

    image

  • Calculating relevant SEO metrics (churn rates, conversion rates, traffic,...) using DAX Measures.

  • Developing interactive Power BI dashboard and generating some insights and data-driven recommendations that contributed to enhancing SEO strategies and optimizing marketing campaigns.

    image

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published