Aishat Alli
Data Analyst
- |-Gothenburg, Sweden
www.linkedin.com/mwlite/in/aishat-alli-84609a157/ | https://github.com/kemiscut
https://public.tableau.com/app/profile/aishat2600
SKILLS
Programming: SQL, R, Python, Version Control (Git) Data Visualization: Advanced Excel, Power BI, Tableau, Google Analytics
Soft Skills: Teamwork, Critical Thinking, Communication, Problem Solving, Storytelling, Logical reasoning, Attention to detail
FEATURED PROJECTS
Web Search study (https://github.com/kemiscut/WebSearch-Study)
May
2023
● Utilized R studio to perform statistical analysis on a study in which participants were asked to find distinct facts using
different search engines.
● Visualized effort and frequency of how search engines were used using histograms and box plot.
● Performed post hoc pairwise comparisons of efforts among levels of search engines using Holm’s sequential Bonferroni
procedure.
● Tools used: R (plyr, reshape2 and ez packages)
Statistical Analysis to determine a more effective Ad campaign (https://github.com/kemiscut/Statistical_Analysis)
● Used Excel to create histograms for clicks and conversions data to determine the data distribution.
● Performed hypothesis and A/B testing to determine statistical difference between the two ad campaigns.
● Applied a simple linear regression model to predict ad conversions given a certain number of ad clicks.
May 2023
Sprocket Target Marketing Analysis (https://github.com/kemiscut/Sprocket-target-marketing-analysis)
Apr. 2023
● Cleaned and transformed Sprocket customer data using PowerBI to gain insights on resource allocation for targeted
marketing
● Analyzed existing customer databases to determine customer trends and behaviors.
● Recommended potential customers to be targeted for upcoming campaigns.
TECA Data Analysis (https://github.com/kemiscut/TECA-Data-Analysis)
Apr. 2023
● Created a dashboard with PowerBI to help a client compare between summer and winter sales.
● Transformed and processed client’s data using DAX and Excel to ensure data completeness and validity.
● Provided technical insights on top most sold products with high profit margin and also complementary products consumers
often purchase together.
Yelp Dataset Analysis (https://github.com/kemiscut/Data-profiling-and-analysis-with-sql-)
Jan 2023
● Performed descriptive analysis on a dataset from a US dataset organization called Yelp, which provides a platform for users
to provide reviews and rate their interactions with varieties of businesses and organizations.
● Transformed and filtered data by using aggregating and filtering functions.
● Utilized SQL to analyze reviews given by users.
RELEVANT WORK EXPERIENCE
HERITAGE GLOBAL ACADEMY(Educator), Lagos
Jan 2022 – Aug 2022
● Used Microsoft forms to gather learners’ responses to surveys in order to make data driven decisions.
● Revived learners’ interest and enthusiasm in technical drawing using project-based learning
● Provided administrative support for supplemental education and intervention classes which improved middle and low fliers
performance by 40%.
● Used vlookup to assign letter grades to learners’ scores.
● Collected and analyzed data on learners’ performance using Excel.
AUTOMATION AND ENGINEERING ACADEMY (Civil Engineer), Lagos
Dec 2020 – Jan 2022
● Carried out traffic counts during morning and evening peak time to create effective traffic sequence
● Successfully adhered to company data governance standards
● Reduced traffic congestion on 22 traffic light junctions by 65% using actuated and intelligent traffic signal lights
● Prepared minutes of site meetings
FREUND LIMITED (Assistant Resident Engineer), Lagos
● Assisted with planning and scheduling projects using Gantt charts.
Aug 2018 – Sept 2020
●
●
Monitored project progress using key metrics.
Prepared project progress reports.
EDUCATION/ CERTIFICATIONS
Higher National Diploma, Civil Engineering [Upper Credit], Yaba College of Technology, Lagos
Dec 2010 – May 2016
Google Data Analytics Professional Certificate (Google), Coursera e-learning
Aug – Oct 2022
Courses: Ask Questions To Make Data-Driven Decisions, Prepare Data For Exploration, Process Data From Dirty To Clean, Analyze Data
To Answer Questions, Share Data Through The Art Of Visualization & Data Analysis with R Programming
Excel Fundamentals for Data Analysis (Macquarie University), Coursera e-learning
Aug 2022
Cleaning and Manipulating Text, Working With Numbers and Dates, Cell Referencing and Defined Names, Tables for Automating Data
Manipulation, Logical and LookUp Functions
Business Metrics for Data Driven Companies (Duke University), Coursera e-learning
Sept 2022
Revenue, Profitability and Risk Metrics, Data Centric Roles, Companies As They Relate To Big Data,Web Marketing Metrics, Financial
Services; Money Management, Applying Business Metrics To a Business Case Study
Data Visualization with Tableau Specialization (University of California, Davis), Coursera e-learning
Sept 2022
Data Visualization and Its Importance, Importing Data Into Tableau, Make a Dashboard and Add Some Interactions, Tableau
Community Projects and Visualization Best Practices
Data Analytics Essentials with Power BI (Ahmed Oyelowo & Foresight BI), Udemy
March 2023
Visualizing Reports in PowerBI, Understanding Data Modeling in PowerBI, Data Analysis Expressions DAX, Visualizing the Measures,
Data Preparation Techniques
Google Digital Marketing & E-commerce (Google), Coursera e-learning
May 2023
Marketing analytics and measurement, Use metrics from Google Analytics and Google Ads, Measure the success of marketing
campaigns, Share metrics and insights with stakeholders
Statistics for Marketing (Meta), Coursera e-learning
May 2023
Measures of central tendency, measures of dispersion, Frequency tables, Sampling, Distributions, Variable types, Experiment Design
and Hypotheses, Hypothesis and AB Testing, Statistical Modeling, Simple linear Regression and classification methods, Cluster
analysis, Time series
Microsoft Data Analytics (Microsoft Technologies, Continuous Learning)
Discover Data Analytics, Explore Data in PowerBI, Use Visuals in PowerBI & Publish and Share in PowerBI
