The Ultimate BI Dictionary
These days working harder in the technology industry often finds you running in circles and implementing the same tactics and expecting different results. What if I was to tell you that you could work smarter instead of working harder?
Sounds too good to be true, doesn’t it?
With all the technical advancements going on in our industry right now there are new solutions released daily that can help you do better business. The problem often lies in knowing what to do with your company data once you get your hands on it.
That’s where BI companies (Business Intelligence) like SplashBI, can step in and help you realize patterns and trends in your information that you might not have seen before. Business Intelligence (BI) is really all about helping you use what you already have in new and different ways so you can work smarter and not harder.
Tell me more you say?
Whoa-h! Hold those horses –
You’ve got to know what you’re are talking about before you can start leading the pack!
We’ve put together a great list of some hot-button BI industry terms that will have you looking like a leader in your department and a rising star in the boardroom.
Actionable Intelligence – information that, when acted upon, can provide a competitive advantage. It can come in a variety of forms, and is imperative to helping a business stay ahead of its competition.
Some examples of Actionable Intelligence:
- Setting up automated business alerts, to inform decision-makers of critical pieces of information so that immediate action can be taken
- Scheduling and delivering reports and dashboards automatically, so that managers can always be up to date with the latest information
- Drill down functionality into live dashboards for visibility into trends and anomalies in their business to make better decisions
The end goal of actionable intelligence is to provide more than just useful data, but to empower decision-makers with accurate, insightful information, allowing them to make effective decisions and to plan for the future.
Ad Hoc Reporting – The ability to create a one-off or a modified version of a BI Dashboard or report. This is typically done by a non-technical user.
Ad-hoc is Latin for “as the occasion requires.” With BI, this means users can use their reporting and analytics platform to answer their business questions “as the occasion requires,” without having to request changes from IT.
Why use Ad Hoc reporting? The goal is to empower users to ask and answer their own questions of their data, without a request to IT. The benefit of this freedom is faster turnaround on analysis, better decision making, and more efficient workflows for both the user as well as IT.
Analytics – the discovery, interpretation, and communication of meaningful patterns in data. Organizations use analytics to gain valuable insight and knowledge from their data, which are then used to take actions or decisions.
Analysts – Analysts are the business users who use business intelligence solutions to derive insights, make better decisions, and more accurate projections. They can be across departments in an organization, but are usually more technical than a typical business user.
Anonymization: Just what it sounds like but it happens inside a database. Links between people can be severed to maintain privacy and confidentiality and to prevent the discovery of the source of the original records.
API – An Application Programming Interface (API) is a set of subroutine definitions, protocols, and tools for building application software. In general terms, it is a set of clearly defined methods of communication between various software components.
Area Charts – Area Charts are a type of graphical visualization that is most commonly used to represent cumulated totals using numbers or percentages (stacked area charts in this case) over time. Use the area chart for showing trends over time among related attributes.
Authentication – a reporting best practice that involves the verification of a user’s identity through a user name and password. This authorization is used to grant or deny access to reports, dashboards, functionality, and more, in order to ensure the security of the data.
When used in a BI solution, authentication should be two-part:
- Login Authentication with the BI or reporting tool with a User ID and Password
- That User ID would be connected to a third part application that feeds data into the BI solution, which also controls security to the data
Automated Analysis: Automated analysis can be set up to find hidden insights within your data that you didn’t even know you were looking for! Or even highlight a question you didn’t even know to ask. That’s pretty BI if you ask me.
Automated Report Scheduling – Automated Report Scheduling is the process of automating a report to run at a predetermined date and time, or recurring at an interval. This allows the delivery of data to be regular and not dependent on any one person.
Balanced Scorecard: A snapshot of your organization’s performance from several different views. Management can quickly see how sales might compare to inventory levels or if current on-board talent will be able to handle to incoming sales pipeline.
Behavioral Analytics: Ever wonder what your team members are thinking about doing in the next six months? By using data about employee behavior, BI can often predict intent or even future actions. Like your own little crystal ball right there on your screen!
Benchmarking – is comparing one’s business processes and performance metrics to industry bests and best practices from other companies and industry standards. It is critical to creating corporate performance goals and targets, as well as process improvements.
Robert Camp (who wrote one of the earliest books on benchmarking in 1989) developed a 12-stage approach to benchmarking.
The 12-stage methodology consists of:
- Select subject
- Define the process
- Identify potential partners
- Identify data sources
- Collect data and select partners
- Determine the gap
- Establish process differences
- Target future performance
- Adjust goal
- Review and recalibrate
BI Analyst: Are you really good at seeing patterns? Are puzzles and brain teasers your thing? Then becoming a BI Analyst might be right up your alley. BIA are responsible for watching and mining data to find patterns and mapping data from system to system to help solve problems.
Big Data – Data sets that are so large or complex that traditional data processing application software is inadequate to deal with them. Big Data presents special challenges, but when analyzed properly, can lead to insights into your business, customers, processes, and more that would typically be unrecognizable through traditional methods.
BI Governance: Are you the Key Master? Because BIG is the Gate Keeper. This is where all permissions over who has access to your company data originate. Governance makes the determination of who sees information, how often and when the information can be accessed.
Business Intelligence – Business Intelligence, also known as descriptive analytics, is the process of collecting and turning data into meaningful information used to make business decisions, also known as actionable intelligence. Business intelligence tools continue to evolve to provide more and better insights into data, which in turn, provides organizations the ability to better understand their business.
BI can be broken into many components, but some of the most common components are:
- Real-Time Reporting, which provides data about the company in a report format
- Dashboards and Visualizations,
Centralized BI: This is a BI model that governs data permissions to ensure heightened data security. Why would this be useful? It allows a group of users to share insights while seeing all the same original data known to be true to the organization.
Charts – Charts, also called graphs, are graphical representations of data, and are used to easily show relationships and correlations between large quantities of data. Since they are easy to quickly digest and understand, they are a better way to present data than a standard report. Charts are a critical part of any Business Intelligence solution.
There are many different types of charts, with the most common types being line, bar, pie, and histogram. Depending on the data to be displayed, it is important to choose the appropriate chart to best represent your data. This Wikipedia article goes over some of the various types of charts and what kind of data they are best suited for: https://en.wikipedia.org/wiki/Chart
Collective Knowledge: We are stronger together. That is the principle behind Collective Knowledge. It’s information that benefits the entire enterprise by enrichment from the entire group, across department or across the world.
Contextual Data: Contextual data (CD) is all the extra information about a customer that helps you have a better understanding of just who they are. CD is the intelligence that is gathered from customer’s recent web activity that helps you understand them and thus better serve that customer.
Customer Relationship Management (CRM) – CRM, or customer relationship management, is a tool designed to manage and track a company’s interactions with its prospective and current customers. CRMs are designed to improve the relationship between the organization and customers, resulting in increased sales and revenue, as well as better customer service.
This is one of the output types within SplashBI.
Dark Data: If a tree falls in the forest and no one is around to hear it, does it make a sound? If data is collected and isn’t put to use, does it really make a difference? Dark data is all the info that is collected and never put to use. Commonly, up to 90% of company data is dark data, collected but never utilized. Wow, if only some Business Intelligence could be put to work on that info – what insights could be gained??
Dashboards – Dashboards are compilations of charts and graphs with the goal of providing a snapshot of an organization, typically specific to a department or business process. They provide business analysts a way to monitor the health, performance, inefficiencies, and more of the organization.
The components that typically make up a dashboard are:
- Key performance indicators (KPIs), which are visual indicators of metrics that are important to a department or organization. Typically, once they are reached, a notification would be sent to necessary personnel.
- Charts and graphs containing business metrics and summaries
- Historical Trends
- Stock tickers or news feeds
Benefits of dashboards:
Dashboards hold many benefits to all levels of an organization. They provide an easy to digest way to represent data, which can lead to better, faster decisions. An effective dashboard should be able to be refreshed with the latest data available, have drill down capability to help with research, and be exportable for use in presentations or management summaries.
Database: Being able to access your data quickly and easily is paramount for a company. A database is a place / platform that many different programs can access to retrieve information quickly and efficiently. The beauty of a database is they are usually not software specific and can be accessed by many different programs.
Data Analyst: This position requires that same pattern-finding-passion that a BI Analyst needs to be successful. This person can look at a large amount of data and see areas of opportunity for a company or places where savings might be realized and acted upon.
Data Governance – is a set of processes that ensures that important data assets are formally managed throughout the enterprise to ensure the data can be trusted and that people can be made accountable for any adverse event that happens due to poor data quality.
Data Mart – A data mart is a simple form of a data warehouse that is focused on a single subject (or functional area), such as Sales or Finance or Marketing. It typically is static and needs to be refreshed as often as is required by the data consumers.
Data Mashup – The process of combining related data from multiple sources. “Mashing” data allows data consumers to have a more complete picture, allowing for better, more accurate reports and dashboards.
As more and more organizations move away from a large ERP system and implements a best of breed approach, related data continues to be harder to consolidate. It is critical for organizations to be have a BI solution that can mashup their data to provide a better platform for actionable intelligence.
Data Model: A data model is a plan of information that is required and how it will flow through the company. This plan is a collaborative effort between the end database users and the IT database analysts. The model must first be simply defined by the end user, what do they expect and what do they need. The next stage is for the IT team to document the process for that magic that they do to get the results the end user is wanting. Together, these processes result in a data model for the business.
Data Visualization – are ways to represent your data in a pictorial format, rather than a text and number report. They are typically shown as various types of charts, including line, bar, pie, heat maps, geographical mats, and more, and make understanding data trends easy to interpret and base decisions off.
Data Warehouse – A central repository for integrated data from one or more data sources. They are designed to help organizations better analyze large amounts of data, and are typically a core component of business intelligence.
Some of the major benefits of a data warehouse are:
- Maintain historical data in a centralized location, making historical reporting easier
- Integrate data from multiple sources into a centralized location
- Improve data quality
- Provide a single data model across sources
- Increase reporting and analysis performance
- Descriptive Analytics tell the past story of a business
- Predictive Analytics help us understand the future of the business based on past trends
- Prescriptive Analytics help guide the future of the business with certain actions
Descriptive analytics are essential to BI, as predictive and prescriptive analytics aren’t possible without a solid analysis of the past. Descriptive analytics are typically represented as reports, dashboards and visualizations showing trends and status.
Drill down is the capability to go from a high-level data down to transactions, balances, journals, subledgers, and more. As expected, this functionality provides many benefits
- product planning, purchase
- production planning
- manufacturing or service delivery
- marketing and sales
- materials management
- inventory management
- shipping and payment
Excel Hell: And yes, I think it is comprised of seven levels (or at least it can feel that way). This happens when a company’s servers become full of thousands of unnecessary copies of data. Documents get shared and re-shared and re-shared and no one is certain which version is the most recent or the original version.
Federated BI: This is the opposite of Centralized BI. This is when a company’s network is segmented and people work on separate isolated desktops, thus creating data silo’s. This causes unnecessary copies of documents and a real mess when trying to determine the most resent or original version of a specific document.
Filter: A filter is an amazing tool when you are trying to drill down to very specific data. You can filter out any unwanted information, or have the database only search for the detailed info you are looking for – an example might be you need to find customers between 50 and 65 who love to travel and have been out of the country at least once in the last year. Yes, depending on your data and filters applied, you can get that specific and really target customers with personalized marketing efforts.
Gap Analysis: Would you like to see your sales forecast for the next year, your budget performance over the last five years, and your company’s staff trajectory for the next six months?? This would all be amazing info to have at your fingertips – but, do you have the data in your database to support these reports? That is where a gap analysis is needed. A GA will let you know what info is needed to make your reporting dreams a reality.
Geo-analytic Capabilities: This is the ability for a BI platform to take your geo-targeted data and reflect that information onto maps on the user’s dashboard.
Insights: This is the good stuff. Insights are when your analysis of data help you see and realize situations that can benefit your business. A better understanding of your current business climate could help you re-direct your thinking or re-evaluate your goals. Data is important, but insights are like the cherries on top of your sundae.
Key Performance Indicator (KPI): A well-defined KPI acts as a guide post for your business. KPI’s are specific targets that are set by a company and then scored against. This strategy gives the team a clear set of markers of what is expected of them as well as a quick gauge of how the business is doing vs. what has been planned and expected.
Metadata: Metadata is literally “data about data”. Intriguing, isn’t it? So, if I have a photo on my website, that is data. The name of the photo, the file size, where it’s stored, the pictures resolution, who was the last team member to open that picture, etc.- that is metadata.
Metrics: The way a company measures its performance. These are the numbers, the brass tax – when it’s all said and done, these are the numbers that will show progression and evaluate trends for a company.
Modern BI: This is the next step for BI. This is an approach using state of the art technology from a centralized platform. The next step in BI is more intuitive reporting, self-service on-demand custom reports and less involvement from the IT team to create predefined data modules. The future is bright and SplashBI is right there leading the technology charge.
Online Analytical Processing (OLAP): OLAP is powerful data discovery software that views the data in a multidimensional database rather than the standard relational database. What does that mean and why should you care? Processing data in a multidimensional platform allows the user to compare and see their information in more intuitive and dynamic ways. Comparing and contrasting items in a 1-step report from different regions and different time periods with different filters were all but impossible in a relational database – but with the OLAP, it’s a snap. Seeing your data in a new and intuitive way is what OLAP is all about.
Self-Service BI: This is the ability for users to access and work with data even though they don’t have an analyst or computer science background. They can access all the features of the software and create reports and model the data to their needs. This type of BI must be centralized and governed by a good IT department.
Social Enterprise: Wouldn’t you like to know about a problem BEFORE it affected your bottom line?? Social enterprise utilizes a new level of social connectivity. It allows for a more efficient operation where problems are uncovered and fixed before they have time to affect your revenue streams.
Suggestive Discovery Engine: It knows you better than your bestie! It’s the power behind the program that shows the user the most relevant insights to focus on, based on their personal preferences and behavior.
Workboards: This is like a supped-up dashboard – but better. It’s an interactive visualization tool that shows you all your data with the possibility to work directly on it in order to do further analysis.