A business intelligence solution used to analyze the company’s business operations and interactions with customers. The customer had a number of data sources and a variety of databases. The customer was interested in a data solution based on open source to reduce costs.
Business activity analysis:
Growth and expansion trends of customers by marketing channels (Funnel) and products, customer usage patterns of products and services, Customer abandonment trends by products and marketing channels.
Quarterly reports and quarter comparison reports, annual reports and annual comparison reports.
Operational reports that deal mainly with measuring the day-to-day activity, which allowed making decisions during a workday – in order to improve daily business outcomes.
Planning a system that is able to process and retrieve very large amount of data in a short time. For this purpose, we developed a complex data warehouse that included data from a variety of very large databases.
Accessibility to very large amounts of data via reports, in a way that the report gives a clear and articulate business answer through a minimum use of data screens. We chose to use an end-user Self Service BI tool, whereby the end user can develop their own reports.