We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Business Intelligence (BI) Industry Jargon
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Warehousing > Business Intelligence (BI) Industry Jargon
Business IntelligenceData Warehousing

Business Intelligence (BI) Industry Jargon

RickSherman
RickSherman
4 Min Read
Business Intelligence (BI) Industry Jargon
Illustration generated with Qwen Image.
SHARE

More Read

Fraud Prediction - Decision Trees & Support Vector Machines
Fraud Prediction – Decision Trees & Support Vector Machines
Guest Post: Information Retrieval using a Bayesian Model of Learning and Generalization
The Case for a ‘New IT’ Operating Model
Moving from the PC Era to the Mobile Era
From Hiring To Payroll: Managing HR Data Across Business Systems

When teaching people about business intelligence (BI), data integration and data warehousing, after introductions and reviewing the syllabus or agenda, I present my jargon and acronym slide. I always tease that there will be a quiz on these terms. I do this with people from IT, business groups, software vendors or students (in a Master’s degree program at an engineering university.) It does not matter what the technical expertise of the crowd – they always laugh.

Any IT specialty has its jargon, but we seem to have more than our share in business intelligence. Having a lot of terms and acronyms is usually fine, but in BI we do not always agree on the definition and, even worse, we sometimes use different terms for the same thing.

If the experts, industry analysts and pundits cannot agree then how does everyone else understand what is going on? How do people learn this field and leverage others’ experiences?

My New Year’s wish is that it becomes easier for people to get through the jargon and build or have access to better BI solutions.

My jargon list includes these terms or acronyms:

  • Business Intelligence (BI)
  • Performance Management (PM)
  • Operational BI
  • On-Line Analytical Processing (OLAP)
  • MOLAP, ROLAP, DOLAP
  • Analytical Applications
  • Predictive Analytics
  • “Slice & Dice” and Drill down
  • Data Mining
  • Data Visualization
  • Dashboards, Scorecards
  • Key Performance Indicators (KPIs)
  • Data Shadow Systems or Spreadmarts
  • DW & BI Appliances
  • Data Warehouses (DW)
  • Enterprise Data Warehouse (EDW)
  • Data Marts (DM)
  • Operational Data Stores (ODS)
  • Hub & Spoke Architecture
  • Data Integration
  • Extract, Transform & Load (ETL)
  • Enterprise Application Integration (EAI)
  • Enterprise Information Integration (EII)
  • Extract, Load & Transform (ELT)
  • Change Data Capture (CDC)
  • SOA (Service Oriented Architecture)
  • Real-time Access, BI, DI or DW
  • SaaS (Software-as-a-Service) or On-Demand Software versus On-Premise Software
  • Cloud Computing
  • E/R Modeling versus Dimensional Modeling
  • Dimensions & Facts
  • Star & Snowflake Schemas versus 3NF (3rd Normal Form)
  • Conformed Dimensions
  • Slowly Changing Dimensions (SCD)
  • MDM (Master Data Management)
  • CDI (Customer Data Integration)
  • PIM Product Information Management)
  • Open Source Software (OSS)
  • Relational versus Columnar Databases
  • Unstructured Data
  • Enterprise Data Mashups
  • Data Governance
  • Metadata Management
  • Enterprise Information Management (EIM)
  • BICC (BI Centers of Excellence)
  • ICC (Integration Centers of Excellence)
  • Data quality (DQ) & data cleansing
  • SMP versus MPP

Happy New Year

P.S. The graphic was generated by using Wordle. This is not an endorsement of the site.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Flat editorial illustration: The article connects downstream report failures, data-quality gaps, and conflicting metric definitio
Signs Your Data Architecture Needs an Outside Review
Big Data Exclusive
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive
Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Data Management Technology Helps Recover Deleted Photos from Digital Cameras
News

Data Management Technology Helps Recover Deleted Photos from Digital Cameras

7 Min Read
3 Essential AI And Cloud-Based Tools Modern Business Needs To Thrive
Artificial Intelligence

3 Essential AI And Cloud-Based Tools Modern Business Needs To Thrive

8 Min Read
Generative AI models
Artificial IntelligenceBusiness IntelligenceExclusiveInfographicMachine Learning

Thinking Machines At Work: How Generative AI Models Are Redefining Business Intelligence

3 Min Read
Business Planning Benchmark Shows No Improvement in How Companies Plan and Budget
Business IntelligenceCulture/LeadershipDecision ManagementPolicy and Governance

Business Planning Benchmark Shows No Improvement in How Companies Plan and Budget

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?