Top 10 Acronyms and Terms Used in Business Intelligence

Email | Print

An acronym can be a very beneficial thing, getting straight to the point and saving typing time.  It can also be very frustrating, resulting in miscommunication throughout an organization.  For example, if the person you’re sending an email to about an urgent deadline thinks “ASAP” means associated software adapter practices… you could have quite the miscommunication.

For those interested in business intelligence, let’s review the top 10 acronyms to make sure we’re all on the same page.

  1. BI= Business Intelligence.  BI refers to business information and business analyses that lead to decisions and actions and that result in improved business performance.  BI software enables self-service, interactive reporting and analysis in highly visual form as well as dashboards and alerts.
  2. BPM/CPM= Business Performance Management/Corporate Performance Management.   BPM/CPM is a set of management and analytic processes that enable the performance of an organization to be managed with a view to achieving one or more pre-selected goals.  BPM is also an acronym for Business Process Management.
  3. ETL=Extract, Transform, and Load.  ETL is a set of processes to copy data from source databases into a data warehouse.  Data needs to be extracted from the data source, transformed into a single, unified format, and loaded into the data warehouse.
  4. GIS=Geographical Information System.  A GIS provides location intelligence so a user can more accurately process and comprehend spatially oriented data through visualization on a map.
  5. ISV= Independent Software Vendor.  This is a business term for companies specializing in making or selling software, designed for mass marketing or for niche markets such as business intelligence solutions.
  6. KPI=Key Performance Indicators.  Such measures are commonly used to help an organization define and evaluate how successful it is, typically in terms of making progress towards its long-term organizational goals.  KPIs may be monitored using BI techniques to assess the present state of the business and to assist in prescribing a course of action.
  7. OLAP=Online Analytical Processing.  OLAP refers to programmatic analysis of data to yield actionable business intelligence.  Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time.
  8. OLTP= Online Transaction Processing.  This refers to programmatic processing for operational (rather than analytical) purposes, such as electronic banking, order processing, employee, and e-commerce.  OLTP data can be imported to an OLAP database via ETL and used for analysis in a BI application.
  9. SSRS=SQL Server Reporting Services.  SSRS is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports.
  10. SSAS=SQL Server Analysis Service.  Microsoft Analysis Services, part of Microsoft SQL Server, comprises a number of services related to BI and data warehousing, including integration services and analysis services. Analysis services includes a group of OLAP and data mining capabilities.

Clear communication is the key to success and we hope the above helps ease some miscommunication pains in your business. Feel free to print off the blog and keep as a reference. Remember that acronyms are ever evolving so it’s always a good idea to keep your own library and update it when you find a new one.

BIO Analytics Corporation is a provider of business intelligence software and services. Founded on twenty years of Microsoft Dynamics® implementation experience, all solutions are grounded in leveraging and extending existing data into real value added information to non-technical users across the organization.

By Sandi Richards Forman of BIO Analytics, Corp., a Business Intelligence (BI) Microsoft Dynamics ISV

Related Posts

Ask This Expert a Question or Leave a Comment




Get New Posts:

Distribution Software Logo