Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada
Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada
Hi! I'm Sarmad,
Data Analyst
based in Edmonton, Canada
Provide end-to-end solutions for data challenges, turning information into insights
Provide end-to-end solutions for data challenges, turning information into insights
Provide end-to-end solutions for data challenges, turning information into insights
Tools which I use on a daily basis.
Tools which I use on a daily basis.
Tools which I use on a daily basis.
Databricks
Cloud-based platform to help enterprises build, scale, and govern data and AI, including generative AI and other machine learning models.
Databricks
Cloud-based platform to help enterprises build, scale, and govern data and AI, including generative AI and other machine learning models.
Explore My Projects
Explore My Projects
Explore My Projects
Explore My Projects
My Amazon Spending
Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn
Advanced Data Processing
Data Acquisition
Tableau Workflow
View Project
My Amazon Spending
Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn
Advanced Data Processing
Data Acquisition
Tableau Workflow
View Project
My Amazon Spending
Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn
Advanced Data Processing
Data Acquisition
Tableau Workflow
View Project
My Amazon Spending
Analyzes personal Amazon purchases from 2020 showing insights into spending pattersn
Advanced Data Processing
Data Acquisition
Tableau Workflow
View Project
PostgreSQL Database
Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis
Webscraping with Python
PostgreSQL
Synthetic Data Generation
View Project
PostgreSQL Database
Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis
Webscraping with Python
PostgreSQL
Synthetic Data Generation
View Project
PostgreSQL Database
Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis
Webscraping with Python
PostgreSQL
Synthetic Data Generation
View Project
PostgreSQL Database
Created a dataset by webscraping Gymshark product page and imported it into a PostgreSQL database for analysis
Webscraping with Python
PostgreSQL
Synthetic Data Generation
View Project
Credit Card Fraud Model
Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters
Advanced Data Preprocessing
Machine Learning
Feature Engineering
View Project
Credit Card Fraud Model
Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters
Advanced Data Preprocessing
Machine Learning
Feature Engineering
View Project
Credit Card Fraud Model
Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters
Advanced Data Preprocessing
Machine Learning
Feature Engineering
View Project
Credit Card Fraud Model
Detect fraudulent credit card transactions using the XGBoost algorithm and fine-tune the model parameters
Advanced Data Preprocessing
Machine Learning
Feature Engineering
View Project
YuGiOh PowerBI Dashboard
Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard
API Integration
Design Principles
Power BI
View Project
YuGiOh PowerBI Dashboard
Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard
API Integration
Design Principles
Power BI
View Project
YuGiOh PowerBI Dashboard
Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard
API Integration
Design Principles
Power BI
View Project
YuGiOh PowerBI Dashboard
Leveraging Python scripting for API integration, data cleaning techniques to create a Power BI dashboard
API Integration
Design Principles
Power BI
View Project
Work Experience
Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings
20 %
faster querying load times by optimizing DAX expressions
Business Data Analyst
Explore Edmonton
Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.
Work Experience
Work Experience
Work Experience
20 %
faster querying load times by optimizing DAX expressions
Explore Edmonton
Explore Edmonton
Business Data Analyst
Business Data Analyst
Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings
Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings
Conducted survey analysis using Python, transforming responses into actionable recommendations that improved venue operations through 15% parking cost reduction and expanded amenity offerings
Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.
Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.
Championed and implemented an enterprise-wide Databricks data lake solution that streamlined ETL processes and enhanced cross-organizational data accessibility for 200+ users.
Developed PowerBI dashboards analyzing $28M provincial budget allocation, enabling senior leadership to optimize fund distribution to different Indigenous nations in Alberta.
Developed PowerBI dashboards analyzing $28M provincial budget allocation, enabling senior leadership to optimize fund distribution to different Indigenous nations in Alberta.
2x
faster reporting analysis by automating data entry
Government of Canada
Data Analyst
Trained employees on PowerBI that streamlined data monitoring processes, resulting in improved reporting efficiency across departments.
Trained employees on PowerBI that streamlined data monitoring processes, resulting in improved reporting efficiency across departments.
The Process
Approach to Data Analysis
Approach to Data Analysis
1
1
1
1
Problem Definition
Understand the requirements for the business and define what success looks like
Have a clear problem statement
Have a clear problem statement
Communicate with stakeholders to understand needs
Communicate with stakeholders to understand needs
Define specific KPIs
Define specific KPIs
Data Collection
Gathering all necessary data from relevant sources while ensuring proper access and permissions.
Creating a data inventory that shows potential data sources
Document data relationships and schemas
Document data relationships and schemas
Document data relationships and schemas
Assess data quality
Assess data quality
Assess data quality
2
2
2
2
3
3
3
3
Data Cleaning
To ensure the data is reliable and suitable for analysis, this step is crucial. Detect errors, inconsistencies, and inaccuracies
To ensure the data is reliable and suitable for analysis. Detect inconsistencies, and inaccuracies
Identify missing values, outliers, and inconsistencies
Identify missing values, outliers, and errors
Develop and implement standardized cleaning procedures
Develop and implement standardized cleaning procedures
Document cleaning steps
Document cleaning steps
Exploratory Data Analysis
Discover patterns, spot anomalies, and form hypotheses
Generate summary statistics and basic visualizations
Identify potential relationships between variables
Create initial hypothesis based on observed patterns
4
4
4
4
5
5
5
5
Detailed Analysis and Insights
Test hypotheses and validate findings and offer actionable insights by translating analytical results into business value
Apply appropriate statistical tests and models
Apply appropriate statistical tests and models
Create executive summary highlighting key findings
Create executive summary highlighting key findings
Design clear visualizations to communicate results effectively
Design clear visualizations to communicate results effectively