Abiola Adebanjo
Oldbury,West Midlands
Summary
Experienced data analyst with expertise in Power BI, advanced DAX, and advanced Excel, including VLOOKUP and pivot tables. Proficient in SQL and Microsoft Azure, with a strong background in data cleaning and workforce analytics. Demonstrated ability to manage stakeholders effectively and track key performance indicators (KPIs). Career goals include leveraging analytical skills to drive business insights and optimise performance.
Overview
7
7
years of professional experience
7
7
years of post-secondary education
1
1
Certification
Work History
Data Analyst/Database Administrator
Chest Heart & Stroke Scotland
Edinburgh
10.2022 - 03.2025
- Develop and maintain Power BI reports to track constituent metrics such as total number, new additions, retention rates, and demographics
- Create fundraising metrics reports to monitor total donations, average donation amounts, donor retention rates, recurring donations, and major gifts for specific period
- Analyse fundraising efficiency through ROI, cost per pound raised, and other fundraising efficiency metrics
- Develop Power BI reports to assess campaign performance, including revenue, goal achievement, number of donors, and average donations
- Create dashboards for event metrics, tracking total events, attendance, revenue, costs, and net revenue
- Manage the Assemble system to track and report on volunteer metrics, including total volunteers, hours volunteered, retention rates, and activities
- Connect Power BI to Google Analytics to create comprehensive reports on website performance, Track page visits, online resource usage, and fundraising and donation page visits to optimise website effectiveness
- Collaborate with stakeholders to understand data needs and provide training on using Power BI reports
- Gather feedback to improve reporting solutions and support strategic decision-making continuously
- Administer Power BI workspaces and coordinate the distribution of reports across departments to ensure access to each report is relevant and data security is not compromised
Data Reporting Analyst
Quatro Consulting Limited
Bromley, Kent
09.2018 - 10.2022
- Company Overview: seconded to B & S Property Service
- Extracting, loading, and modelling data in Power BI, I craft interactive dashboards that narrate the business's story, pinpointing key trends and insights
- This aids stakeholders in making informed decisions and steering business improvement initiatives
- Created over 10 reports that helped my stakeholders and business have seamless visibility about their customer, properties and income
- Automated the generation of daily, weekly, and monthly reports encompassing business KPIs across all functions
- Employing Excel, Power Query, and advanced DAX in Power BI, this streamlined report delivery
- Produced impactful business intelligence on processes and outcomes for all strategic business units, contributing valuable insights
- Actively involved in supporting transformation and migration projects to ensure data integrity
- Responsively addressed ad-hoc queries and customised report requests, ensuring timely, accurate, and reliable data
- Cultivated relationships with key stakeholders to comprehend their data requirements and translate them into actionable reports
- Collaborated with business units to standardise data attributes, establishing consistency for robust reporting and insights
- Regularly generated data reports and dashboards, facilitating decision-making and pinpointing potential gaps
- Maintained a focus on continuous improvement, enhancing the quality and accuracy of Business Intelligence Information
- Monitored overall progress and proposed data-driven solutions for refinement
Education
Bachelor of Science - Computer Networks and Systems Security
University of Hertfordshire
Hatfield, Hertfordshire 09.2021 - 09.2023
Bachelor of Science - Mechanical Engineering
Olabisi Onabanjo University
Ogun, Nigeria 12.2010 - 12.2015
Skills
- Power BI: Advanced Dax
- Advanced Excel: Vlook up, Pivot Table
- SQL
- Microsoft Azure
- Data Cleaning
- Stakeholder Management
- Workforce Analytics
- Assemble
- Key Performance Indicators (KPIs) Tracking
Certification
Google Data Analytics Professional Certificate
References
References available upon request.
Timeline
Data Analyst/Database Administrator
Chest Heart & Stroke Scotland
10.2022 - 03.2025
Bachelor of Science - Computer Networks and Systems Security
University of Hertfordshire
09.2021 - 09.2023
Data Reporting Analyst
Quatro Consulting Limited
09.2018 - 10.2022
Bachelor of Science - Mechanical Engineering
Olabisi Onabanjo University
12.2010 - 12.2015
Similar Profiles
Abiola AdebanjoAbiola Adebanjo
Google Data Analyst / Database Administrator at Chest Heart & Stroke ScotlandGoogle Data Analyst / Database Administrator at Chest Heart & Stroke Scotland
Lynsey DuncanLynsey Duncan
Deputy Head of Clinical Services at Chest Heart & Stroke ScotlandDeputy Head of Clinical Services at Chest Heart & Stroke Scotland
Krystal EdwardsKrystal Edwards
ACLS Product Specialist at Heart and Stroke FoundationACLS Product Specialist at Heart and Stroke Foundation