Reporting

Analysis and insights from data

Perhaps the most essential and significant task in reporting is to process data into a format suitable for the reporting tool. Often, there is a separate data warehouse for this purpose, where data is collected (e.g. a separate relational database, redshift, snowflake, etc.). To load data, some kind of batch jobs are usually needed that regularly update the data from which reports are generated.

For example, commonly used reporting tools are Microsoft's Power BI, Tableau, AWS's QuickSight, Qlik. Reporting itself is a fairly independent area in the system, and its design and implementation are usually not part of the larger architectural design, excluding the implementation of the data warehouse and loading data into it.