{
"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 :)