ETL Reporting

EIQ2 provides a range of 50 plus SSRS parameter driven monitoring reports to help track and make aware of any possible issues. In challenging times, good decision-making becomes critical. The best decisions are made when all the relevant data available is taken into consideration.

EIQ2 monitors processing and active tasks and provides an array of ease-of-use reports (Status, Trends, Counters, Dashboards, Process Flows, Graphs and KPIs, Drill-Downs etc.) in an easily consumable format, to support the administration and maintenance of the EIQ2 solution. Some of these reports concentrate on ETL process flows, such as timings, record counts and data changes. Other reports focus on historical comparisons, data cleansing and auditing and error management.

While helping to recognize issues before users experience degradation in performance or possible availability, these SSRS reports make it easier to ensure that the EIQ2 environment is running as expected.

EIQ2 server ETL reports reflect the following categories:

EIQ2 provides server ETL information that is decision ready. It allows the analysis of current and long-term trends, instant alerts to possible problems, and provides continuous feedback on the effectiveness of decisions been made. Having immediate access to current, actionable information, can make a huge difference.

Front End (Sample Report):

Note: Areas highlighted in Blue, reflect Drill-Downs