Jesumbo Oludipe
Excel Expert automating processes and building dashboards
New to Contra
Jesumbo is ready for their next project!
I’m a Microsoft Certified Data Analyst Associate, skilled in transforming raw data into clear insights using Power BI, DAX, data modeling, and end-to-end BI workflows.
I use these capabilities to help businesses build reliable dashboards, automate reporting, and make faster, data-driven decisions.
Open to freelance projects involving Power BI dashboards, Excel automation, SQL analysis, data cleaning, and complete BI solutions.
Let’s create something impactful.
0
5
Automated Excel Invoice Generator with PDF Export using Macros
I built an automated Excel invoicing system using formulas, VBA, and macros to generate invoices from a customer database. It features dynamic dropdowns, automatic customer lookup, and instant field updates.
With one click, users can export invoices as PDFs, save them to a folder, or email them. Each invoice is logged into a master record, and a reset button prepares the form for the next entry.
This project shows my ability to create clean, efficient Excel automation that reduces manual work.
14
82
As a Data Analyst, I analyzed customer records to uncover behavior patterns and cross-selling opportunities. After cleaning the data in Python and refining 949k unique customers, I built a Power BI model with segmentation and DAX-based product ownership metrics.
The analysis revealed clear opportunities, like promoting debit cards to current account holders and pension products to payroll customers, leading to targeted marketing recommendations aimed at boosting revenue and improving customer experience.
17
110
Developed an interactive Personal Budget Planner in Excel to track income, expenses, and savings performance. The solution features dynamic formulas, automated KPIs such as savings rate, and visually appealing dashboards for real-time financial monitoring.
I implemented advanced logic to handle late-month income or expenses, allowing users to automatically treat income or expenses received after a specified day as part of the following month's budget, ideal for those with irregular pay schedules.
3
14
106