Brian Van

Data Analytics Capstone Project
Tools needed: MS Excel, MS PowerBI
 

• Used PowerBI to append and build Entity Relation Diagram (ERD) to enhance connections and relations within the dataset itself
• Wrote DAX to perform several key insights and information on the dashboard
• My final dashboard included interactive bar charts and line charts to help end users understand the report better

Sales Report
Tools needed: SQL Mgmt Studio, MS PowerBI
 

• Mainly used Structured Query Language to extract necessary data, analyze, and create tables for my ERD
• Used PowerBI to link related tables and DAX to perform key insights

Income vs Transit Expenses
Tools needed: MS Excel, MS PowerBI
 

• Processed data cleansing and validating to make my analysis more effective later
• Compared key insights in my analysis to understand how and how much l spent on my transit to travel around the city for work

Monthly Expense Analysis
Tools needed: MS Excel, Python, Jupyter Notebook
 

• Used Jupyter notebook and Python language to do my research about how l spent every month in some categories, locations, monthly, annually, etc.
• Visualized my key insights in bar charts, pie charts, etc.

Account Specialist

Shaw Communications Inc., August 2022-Present

Store Associate

TJX Canada, September 2020-May 2022

Customer Experience Associate

Bank Of Nova Scotia, December 2021-April 2022

Graduate Certificate In Data Analytics,   Coursera  

Google Inc., July 2021

Associate of Arts in Business,   BC

Alexander College, April 2021

Certificate: Business Fundamental,   BC

British Columbia Institute of Technology, April 2019

Bachelor of Science in Computer Science,   Ho Chi Minh

HCMC Open University, March 2016