I’m for anyone looking at these projects , they have proved to be

1: Bonus tracker 📊 – I have built online spreadsheets for customer support to record customers who are asking for goodwill bonuses.

What is in it? The spreadsheet has two sheets: one for customer support and the second for the operations team, who are responsible for adding the bonuses. The CS sheet includes columns such as the name of the CS agent, incident ticket number, customer ID, and criteria for bonus qualification. Once CS fills in those criteria using the drop-down filter, the last tab indicates whether the customer qualifies or not. If the customer qualifies, the customer information is automatically passed to the second sheet (this process is automated), allowing the responsible team to credit the customer without needing to verify on the customer support sheet.

Why is it useful? This type of project can be used for customer retention (it was created for a betting company and delivered good results) and can also be applied to the KYC process, where a team can request customer information and record it in one place. It helps reduce manual verification, improves turnaround time for bonus allocation, and ensures consistency in decision-making across teams.

2. KPIs Analysis 📈 – I have also worked on a project where I analyzed the performance of key business KPIs. For example, in a betting company, I worked on KPIs such as Registration, First Time Depositors (FTDs), Turnover, Bonuses, and Net Gaming Revenue (NGR).

What is in it? The image shows dashboard visualizations of the main KPIs and how they evolve over time, providing a complete picture to support decision-making.

Why is it useful? This type of analysis helps improve business performance as it acts as a Strengths, Weaknesses, Opportunities, and Threats (SWOT) overview. It provides a clear understanding of the business and supports making the right decisions at the right time. The same approach can also be used for competitor analysis. Depending on the need, it can be done weekly, monthly, or yearly for better results. It enables faster identification of trends, highlights performance gaps, and supports data-driven decision-making.

3. Daily KPIs monitoring/tracking ⚡ – I have implemented this using Power BI, as it is a powerful tool for daily tracking and comparisons. With clear visualizations, it allows monitoring of different KPIs, such as sales per product, and comparing them with previous days or using them to plan future performance. This improves visibility of daily performance, helps detect issues early, and supports quicker operational decisions.

For anyone reviewing these projects, they have proven to be effective in improving business operations and supporting better decision-making. I am available to work with you and support similar projects or what you have, based on your business needs