Návrh a implementace nástroje Business Intelligence pro analýzu zákaznického chování a využívání produktů palivových karet

This thesis focuses on the design and implementation of a Business Intelligence (BI) tool aimed at analyzing customer behavior at FuelSync, a company specializing in innovative payment solutions. The goal was to create a tool that would provide a clear and accessible overview of customer behavior and the use of fuel card products. To achieve this goal, robust ETL processes were designed and implemented to process data from Salesforce into an SQL database. Reports were created for each line of business (LOB) and subsequently consolidated into a single, unified report. Data update automation was a key component, ensuring that the reports consistently provide up-to-date and accurate information. The project delivered FuelSync's first consolidated report, enabling top management to effectively compare performance across different divisions. Additionally, areas for further improvement were identified, such as filtering by marketing campaigns and segmenting customers into "Fuel" and "EV" categories. These adjustments will be essential in future iterations, given the growing popularity of electric vehicles.