Brian Van

Jr. Data Analyst

Talent

Vancouver, Metro Vancouver Regional DistrictMember since June 8, 2023

Hire this person

Send a job offer directly to this candidate

About

Results-driven professional with extensive experience in business intelligence and analytics. Hands on multiple projects using Excel, SQL, PowerBI, and Python. Analyzed and visualized project requirements into interactive dashboards. Currently looking to join the workforce to gain real-world experience. Ability to complete tasks on time in both individual and team settings. Dependable and reliable, ready to learn and grow with your company.

Experience

Personal Projects

Self-learning, July 2021-Present

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