Projects
After ten years of working, I did a good self-reflection about my passions and interests; I realized that I love working in the analysis field to understand how human thinking and data help make decisions rather than betting only on intuition. I committed to learning everything I could about data analysis, data science, programming, and the tech industry to pursue the data career
Data Analystic for Marketing Campaign
KPMG Virtual Internship
In this project, I played a Data Analytics Consultant role in helping a Bike Shop understand its customers and then prepare a customer list to approach for their next Marketing Campaign. What I have done:
-
Data quality processing: Check the Data Source (MS Excel file with four sheets, 1000-20000 rows, 10-15 columns) to review, identify data quality issues, communicate to the client, and help to fix the problems. (ref: Email to the client)
-
Data Exploration, Model Development, and Interpretation: Create a presentation (Canva/MS-PowerPoint) that outlines the approach taken to identify which of the 1000 customers Sprocket Central Pty Ltd should target based on the dataset.
-
Visualization with dynamic dashboard, Interpretation & Presentation: Using Tableau, develop a dashboard to display data summary and analysis results. Specify who Sprocket Central Pty Ltd' should be targeting out of the customer list. (ref: please view as a fullscreen mode - Tableau Dashboard)
Please click the link or the image above to view the dashboard
Card Credit Approval
Data Analytics Capston Project at Brainstation (Tech Training Center)
In this project, I'm a Card Holder Analysis department member in helping a Bank filter its Credit Card Applicants. Then they can decide which applicants can be approved to take a Credit Card base on the customer's income, debt, occupation, year of experience, dependents, education level, etc.
I used Python for the project's tasks:
-
Data Preparation
-
Data Cleaning & Manipulation
-
Exploratory Data Analysis (EDA)
-
Descriptive Visualization
-
Modelling and Implement Machine Learning model (Logistics Regression and Decision Tree)
-
Model Evaluation & Conclusion
Please click the link or the image above to view the project's notebook
Programming languages are most in demand
Data Visualization | IBM Data Analyst Capstone project
In this project, I used Cognos - a Data Visualization tool of IBM (similar to Tableau and Power BI) to sketch some charts and set up a dashboard from this data from Stackoverflow about the Developer Survey in 2019
The potential audience of the report is HR/Hiring Managers; IT Professionals looking for trends and insight in the field
​
Please click the link or the image above to view the Dashboard
Learning Survey & Analytics
Data collection, analysis and interpretation | Training Center
In this project, I'm a learning analyst to help a Training Center (in Vietnam) do an R&D to know what programs/courses they can offer for adult learners (who are professionals) and enterprise learning. I was responsible for designing the survey, conducting interviews, collecting and analyzing data, making a report, and interpreting it.
​
Please look at the demo slide below is a part of the learning report.
Please click the link or the image above to view the Report
Checking and Design data flow
Data flow design for eLearning management system
As a learning analyst & designer for an e-learning product of Edtech, I check all. the system that acquires data from users, instructors, and its data flow, then designs the new flow and acquisition process to help users, the product team and the content department work better and avoid exhausting the collecting of data manually or in the (old) hard way. The diagrams below were drawn by diagrams.net (draw.io) - a product from Google.
Checking the system
Design and simplify the system
Please click the images to full view
Vietnam GDP 2019
Data Collect and Visualization With Power BI
In this project, I used the data source from wiki pages, imported it to Power BI, used Power Query to clean up, manage their relationship, merge the tables, do some aggregations, and build an interactive Dashboard with Power BI.
​
Since Microsoft has not developed the "web publish feature" for Power BI Desktop, I tried to post here an image of a PDF - static version.
​
Please click the image above to view the 'pdf' dashboard
Social Buzz Analytics
Accenture Intenrship - Data Cleaning and Visualization w/ Power BI
The client (Social Buzz) sent through 7 data sets and a data model, they want the Analytics team at Accenture to help them define which are the top 5 categories with the largest popularity, and what do team recommend to improve their content strategy.
​
As a Data Analyst at Accenture, I explore the data sets, define and clean up, merge them into one with Excel and Power BI (DAX). Analyzing and visualizing.
​
Make a presentation and present it to the client to uncover the insight behind the data.
​
Please click the link above to view the presentation