Before this starting this project, you should have learnt about:
-
Data types, operators and structures
-
Flow control (if-else statements and loops)
-
Functions
-
Filters
-
Pandas and Numpy
-
Basic Statistics
-
SQL
Vanguard, a prominent U.S.-based investment management company, embarked on a journey to evolve digital experience with the goal of enhancing client engagement. Recognizing the rapidly changing digital landscape, we aimed to refine our online process with a sleeker, more intuitive User Interface (UI). This strategic move was driven by our commitment to meeting the growing needs of our clients and ensuring a more seamless navigation experience across our digital platform.
The project centers on analyzing the impact of a new User Interface (UI) design on the online process completion rates at Vanguard, an investment management company. By conducting an A/B test comparing traditional ("Control") and revised ("Test") UIs, the study aimed to determine if the new design enhances user experience and engagement. Initial analyses focused on demographic insights and engagement patterns, followed by detailed examinations of completion rates, regressions at specific process steps, and overall user behavior. The observed improvement in completion rates for the Test group exceeded Vanguard’s minimum effectiveness threshold, indicating the new UI's potential benefit. However, distinct regression points identified for each group—step 3 for Control and step 1 for Test—highlighted specific areas requiring optimization. The project underscores the importance of continuous UI refinement to improve user navigation and process completion, aligning with broader objectives of increased engagement and potential revenue growth.
Dataset source:Client Profiles, Digital Footprints, Experiment Roster
Cleaning & Merging Corrected Data Types Removed Duplicate Rows Handled Missing Values Filtered Outliers Split Data such as date & time Created New Features like age groups
-Client Profiles, Digital Footprints, Experiment Roster
- Python: The primary programming language for data cleaning and analysis.
- Pandas & NumPy: For data manipulation and numerical analysis.
- Matplotlib & Seaborn: Utilized for generating visualizations.
- Jupyter Notebook and Google Colab: Served as the interactive environment for code execution and data exploration.
- SQL Workbench
- Tableau
-
The 6.20% improvement in the completion rate for the Test group, with the new UI design, significantly exceeds Vanguard's minimum threshold of 5%. This indicates that the redesign is not only cost- effective, per Vanguard's criteria, but also beneficial for enhancing user engagement and potentially increasing revenue.
-
Tableau graphical representation - https://public.tableau.com/views/W05GP-Marco0911/VanguardABtest?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
- Complete and clean notebook(s) containing the code, analysis, and visualizations
- Database: The exported .sql file with SQL Queries
- Python files
- Jupyter notebook containing the report in full with visualizations
- A README file with a thorough project documentation.
- A slide deck for the project presentation
- Amir Abdul
- Marco Mo
