Appfluent Visibility for BI and Data Warehousing - Key Features

Appfluent Visibility for BI and Data Warehousing provides insight into business activity and usage, exposes how data is used and what data is unused, and tracks inappropriate or unauthorized user activity.

Business Activity Analysis      Data Management      User Activity & Query Performance     Security & Compliance Audits

 

Business Activity Analysis

• Map your organizational and business hierarchy to the activity and usage of your BI applications and data accessed on your databases.

• Measure trends and patterns in activity volume, amount of data used and the server time utilized by business units and departments within your organization.

• Get visibility into the business users’ access to strategic corporate data to ensure availability of business critical information

• Identify infrequent activity or inactive users, applications and data and uncover underutilized assets.

• Deliver pre-built analytics and dashboards to the business to justify your current investments and to plan for future capacity and resources.

• Utilize the built-in notification feature to get business activity reports that meet or exceed specified thresholds.

• Easily extend the solution to deliver customized business activity reports and dashboards with your existing BI applications.

[Return to Top]

Data Management

• Identify the most frequently used data by business users and applications, the impact on your applications and the data warehouse.

• Discover infrequently and unused or dormant data that is unnecessarily being stored and maintained.

• Pinpoint the last date and time that specific data was used including the users and applications to help assess data retention policies.

• Map your organizational and business hierarchy to the activity and usage of data accessed.

• Measure activity volume and amount of data used by your business units and departments within your organization.

• Deliver factual data usage metrics to the business sponsors via pre-built analytics and dashboards to facilitate collaboration on prioritizing projects.

[Return to Top]

User Activity & Query Performance

• Identify the most frequent BI application users who severely impact databases with ad-hoc reports.

• Quickly find problematic queries and isolate the sources including the BI application users and reports responsible for the problem queries.

• Identify frequently used data associated with problem SQL and assess the impact of frequent operations.

• Discover repetitive and frequent operations that cause bottlenecks on the data warehouse to help prioritize tuning efforts.

• Utilize the built-in notification feature to get reports on user activity and query performance metrics that meet or exceed specified thresholds.

[Return to Top]

Security & Compliance Audits

• Identify the users that access specific database Tables and/or Columns including their query frequency and number of records accessed.

• Track the applications that access specific data and identify the query frequency and records accessed.
  

• Analyze the context of the user activity by identifying the specific SQL statements associated with sensitive data.

• Utilize the built-in notification feature to get reports on user activity related to specific data that exceed specified thresholds such as unusual amount of queries or records retrieved.

• Map your organizational and business hierarchy to the user activity and specific sensitive corporate data.

• Track and report on activity volume and amount of data retrieved from sensitive databases by business unit and department within your organization.

• Easily extend the solution to deliver customized audit reports and dashboards with your existing BI applications.

[Return to Top]