If you wish to see how I made visualization (Dax), please find attachment named "Website_Traffic_Analysis.pbix"
Else if you want to see the final report, please go to the file named "Data Analysis Report.pdf"
Thank you! If you see this helpful, don't forget to drop a STAR for motivation :) Any comment, feedback are also welcomed and appreciated guys <3
The given datasets are the website traffic including information about Region, Category, and Source from 2020 to 2022 among cities of Viet Nam. This report is made to give the overview performance and find factors that may affect our website traffic.
By analysing both internal and external data, I have gained many key facts about the traffic performance.
- Website traffic is facing a decrease (significantly dropped in March 2021)
- Direct sources played a key role in website traffic (Daily active users)
- The most attractive product did not have the highest CVR, Lead CR*
- The laptop was a non-linear relationship with other products
- Ho Chi Minh City remained the most contributed traffic
Social commerce and conversational commerce, or sales through interactive chat and message channels with customers in the Internet environment, have grown in popularity.
Brands may begin concentrating on social commerce and conversational commerce in the future, with the potential to achieve two to three times the effect by leveraging the trend.
The impact of COVID-19 on consumption and purchasing behavior will be long-lasting, and companies must prepare for the new digital normal in the post-pandemic phase.
We should keep COVID-19's behavioral shifts in mind, and rethink supply chains to digitally service customers and deliver to their homes.