{

"Name": "Aryan Bali",

"Passion": "Data Storytelling",

"Currently": "Working on a Data Cleaning Automation Project with Burnaby Football Club (Burnaby, BC)",

"Education": "Soon to Graduate from Business IT Management Diploma, BCIT (Burnaby, BC)",

"likes": ["food", "coffee", "running", "music", "meditation"]

}

My Projects

Segmenting AirBnB Properties in Oakland, California
Analyzing Crime Patterns in Seattle, Washington

Portfolio

In Advanced Business Analytics at BCIT, I Collaborated with team members to analyze crime in Seattle, Washington, obtained from the Seattle Police Department. Our objective was to identify key crime categories, neighborhoods, trends and demographic patterns, guiding strategic decision-making for resource allocation and community policing strategies. 

Together we leveraged Tableau Desktop and Microsoft Power Pivot to overcome challenges associated with data cleaning and analysis. We were able to identify all KPI's and convey our analysis like a story. This highlights my ability to collaborate in a team and tell a story using data.

Predicting Employee Churn

I Used Python to analyze AirBnB property data in Oakland, California, to identify neighborhoods with the highest yearly projected earnings for investors. To ensure, data reliability for analysis I used standard scaler techniques to handle outliers while preserving valuable data insights. 

Finally I used KMeans clustering (Supervised machine learning algorithm) to segmentize all AirBnB properties, which directly solved the problem. This highlights my ability to leverage data-driven insights to guide strategic investment decisions.

Diamond Pricing Prediction

As an investor,

What are my highest yearly projected earnings by neighborhood for Oakland, California?

Problem:

Python

Tools Used:

link

Dataset:

Problem:

As an investor,

What are my highest yearly projected earnings by neighborhood for Oakland, California?

Tools Used:

BigQuery, Google Colab (Python), Looker Studio

Dataset:

link

As the District Police Commissioner of Seattle,

What are my highest yearly projected earnings by neighborhood for Oakland, California?

Microsoft Power Pivot, Tableau Prep Builder, Tableau Desktop

Dataset:

Tools Used:

link

As an investor,

What are my highest yearly projected earnings by neighborhood for Oakland, California?

Problem:

Tools Used:

Python, PowerBI

Dataset:

link

Problem:

About Me

As a versatile and driven individual with a focus on data analysis and modeling, I bring a blend of leadership, technical expertise, and management skills to the table. My journey in Business Information Technology Management, specializing in Artificial Intelligence Management, has equipped me with a comprehensive toolkit for tackling dynamic business challenges.

One of my significant achievements includes co-creating a Data Cleaning Automation tool using Python for Burnaby Football Club, where I not only ensured user data integrity but increase efficiency by 300% . This demonstrates my commitment to delivering solutions that not only push technological boundaries but also prioritize data privacy.

As President of the BITMAN Association at BCIT, I led a dynamic team in organizing impactful events, fostering community engagement, and facilitating valuable connections between students and industry professionals. It's my way of giving back to the tech community and staying engaged with the latest industry trends.

As a Business Consultant/Manager at Dutchman Marine Audits & Consultancies, I collaborated closely with stakeholders, managed relationships within the marine industry, and spearheaded projects resulting in revenue growth and improved service offerings.

Suffering from skill issues

Google Colab
Python
CSS/HTML
Tableau
SQL
.NET
Power BI
Anaconda
SSMS
Visual Studio

Familiarity with

Connect with me

Are you a small business owner swimming in valuable data but unsure how to leverage it for success? Let's turn your data into actionable insights together!

Or if you are a recruiter looking for passionate individual always eager to learn :)