Our experience shows that the need arises to have Business Intelligence quite soon after implementation in the users of systems processing mass data. Requirements come up to automatically analyze data stored in the system, to make reports and dashboards, to exchange standard data without users’ intervention, to create interfaces. For the BI layer it is practical to create data marts that serve the reports and dashboards directly. We use Big Data tools to handle unstructured mass data, and the results are loaded into data warehouses and data marts. By stream analysis we make it possible to process and analyze mass data online. In this case data go straight from the source to the analysis tool (e.g. Power BI).
Our solutions have been introduced successfully to various clients. Our technological repertoire is quite diverse, we use Oracle and Microsoft SQL Server Database, different BI tools (MS PowerPivot, Power BI, MS Reporting Services), and in case of our Big Data solutions both on-premise (e.g. Cloudera or Hortonworks) and cloud-based (e.g. MS Azure or Google) solutions are available.