This article focuses on terms that will educate and help those who are new to the BI/CPM realm.
Have you ever started a new job in an industry you have no experience in? Learning the industry jargon can be overwhelming. I can personally attest to this because prior to working in the
Business Intelligence (BI) and Corporate Performance Management (CPM) worlds, I was in the food, public relations, and entertainment industries, and did not have much experience in BI or CPM. If you have recently been exposed to BI tools, such as report writers, budgeting and planning solutions, dashboards, data warehouses (DWs) and you feel like a deer in headlights, there is no need to panic. In this article, we will discuss ten acronyms in the BI/CPM realm that will help you understand and enhance your experience with BI and CPM processes.
Here are the top 8Â terms that may be resourceful when dealing with BI/CPM solutions:
- Extraction, Transformation, and Loading (ETL) â ETL represents three database functions that are combined into one tool to extract data from one data source. The ETL process is the practice of extracting data from data sources and transferring it into the DW. ETL isnât necessarily three defined steps, but rather a broad process.
- Data Warehouse (DW) â Informatica defines a DW as a âtechnology that aggregates structured data from one or more sources so that it can be compared and analyzed for greater business intelligence.â The term âData Warehouseâ was coined by William H. Inmon, an American computer scientist. This is an analystâs dream because all the metrics about the organizationâs activities are gathered in one place. You can find out more about the details of a successful data warehouse here.
- Relational Database Management System (RDBMS) â A RDBMS is a program that enables users to administer, create and update a relational database. Commercial RDBMS typically use the Structured Query Language (SQL) to access the database. A relational database is described as âa set of tables containing data fitted into predefined categoriesâ by TechTarget.
- Online Analytical Processing (OLAP) â OLAP, also known as âOLAP cube,â performs multidimensional analysis of data and offers the ability for complex calculations, advanced data modeling, and trend analysis.
- Key Performance Indicator (KPI) âA KPI is a lot like a GPS navigation system as it allows the driver to be in complete control when making decisions about where to steer next. KPIs are navigational tools that your company will utilize to understand whether the business is on a successful route or whether itâs veering off. According toÂ Klipfolio, a KPI is âa measureable value that demonstrates how effectively a company is achieving key business objectives.â You can learn more about KPIs and KPI strategies in detail in the following articles: 10 Steps to Successful KPI and Metric Design Using Dynamics GP, Part 1 and 10 Steps to Successful KPI and Metric Design Using Dynamics GP, Part 2. Keep in mind that there are vertical specific KPIs; therefore, do some research.
- User Interface (UI) â In the IT world, UI is designed into a device within which a user can interact. This includes keyboards, display screens, a mouse, and a desktop. It can also include how a user interacts with the application or the website. Companiesâ dependence on applications has led organizations to prioritize improving the userâs overall experience, also known as UX.
- SQL Server â Microsoft SQL Server is a relational database management system that was developed by Microsoft.
- SQL Management Studio (SSMS) â SSMS is an integrated environment used to administer a SQL Server Infrastructure. If youâre not familiar with a SQL Server, it is a relational database management software developed by Microsoft.
- SQL Server Integration Services (SSIS) â SSIS is used to execute a wide range of data migration tasks.
- SQL Server Reporting Services (SSRS) â SSRS is also part of the SQL Server services. It is a server-based report generating system that stores metadata and object definitions. You can learn more about the SQL Server on the Microsoft site.
- Amazon Web Services (AWS) – AWS is a subsidiary of Amazon, and offers cloud computing platforms. AWS is also the competing platform against Microsoft Azure, formerly known as Windows Azure. Companies will be more exposed to AWS and Microsoft Azure as the cloud gets bigger. Cloud Computing platforms provide an easy way to access storage, servers, databases, and applications. It also provides quick access to flexible and low-cost resources.
If you are in the BI/CPM space, you may have seen the terms above used widely. For those who are new to the industry, I hope defining and laying out these terms give you a better understanding of the BI/CPM industry as well as the industry jargon. Solver, Inc. is happy to answer questions and generally review BI360âs web-powered, easy-to-use Excel and mobile BI tools with both real-time or data warehouse integrated analysis, budgeting and collaboration as a way to accelerate your company performance management experience.
Solver enables world-class decisions with BI360, a leading web-based CPM suite made up of budgeting, reporting, dashboards, and data warehousing, delivered through a web portal. Solver is reinventing CPM with its next generation solution. BI360 empowers business users with modern features including innovative use of Excel in the model design process. If youâre interested in learning more, our team is excited to hear about your organizational needs and goals.