Glossary / Business Intelligence and Analytics & Glossary

Help Topics

Business Intelligence and Analytics
Advanced Analytics Affinity-Based Recommendations Agile Analytics Analytical Database Analytics Architecture Analytics Suite Analytics-as-a-Service (AaaS)Application Analytics Application Lifecycle Management (ALM)Behavioral Segmentation Big Data Security Business Intelligence Architecture Business Process Modeling (BPM)Call Attribution Cloud Analytics Cloud Automation Collaborative Filtering Columnar Database Connection String Contextual Data Continuous Intelligence (CI)Conversion Attribution CRM Onboarding Cross-Channel Tracking Data Activation Data Blending Data Cleaning Data Discovery Data Exploration Data Governance Data Intelligence Data Mart Data Mining Data Modeling Data Preparation Data Science Data Stewardship Data Storytelling Data Warehouse Architecture Database Security Deep Learning Descriptive Analytics DevOps Continuous Integration Edge Analytics Embedded Reporting Entity Relationship Diagram (ERD)Financial Data Management Firmographics Geo Analytics Healthcare Analytics Healthcare Informatics In-Memory BI Infused Analytics Interactive Visualization KPI Dashboard KPI Tracking Location Analytics Managed Cloud Marketing Acceleration Platform Marketing Analytics Marketing Qualified Lead Mobile Analytics MPP Database Natural Language Understanding Net Promoter Score (NPS)Next Best Action Marketing Omnichannel Retailing Operational Intelligence Operational Reporting Predictive Data Analytics Predictive Maintenance Predictive Segmentation Prescriptive Analytics Product Analytics R Analytics Real Time Dashboard Real-Time Analytics Relational Database Reporting Performance Retail Analytics Retention Marketing Self-Service Business Intelligence SQL for Data Analysis Talent Analytics Text Mining Unified Data Management Unstructured Data Visual Data Analysis Visual Workflow
Customer Analytics
A/B Testing Active Buyer Affinity Marketing Affinity-Based Recommendations Audience Buying Baby Boomers Back to Back Focus Groups Brand Identity Clickstream Behavior Cluster Analysis CRM Onboarding Customer Cohort Analysis Customer Experience Management (CEM)Customer Journey Lifestyle Research Lifetime Value Race Revenue Per Visitor Target Audience User ID User-Generated Content (UGC)
Display & Native Advertising
Ad Mediation Ad Viewability Automated bid strategy Behavioral Advertising Contextual targeting Conversion Tracking Cost per acquisition (CPA)Display Advertising Traffic Impressions Interactive Mobile Ads Location-based Advertising (LBA)Native Ads Path Length Report Playable Ads Programmatic Media Buying Rewarded Video Ads Smart Lists User ID Video Companion Impressions Video Publisher View Rate View-through conversion window Yield Management
Email Marketing
Contact Form Email Automation Email List Experience Optimization (EXO)Headline Testing Salesforce Pardot Welcome Email
Market Research & Traffic Analysis
A.C. Nielsen Retail Index A/B Testing Ad Concept Testing Ad Hoc Research Adobe Analytics Affinity Marketing Back to Back Focus Groups Cluster Analysis Core Based Statistical Area (CBSA)Cross-Device Marketing Data Collection Data Mining Direct Channel Display Channel Email Channel Engagement Rate Eye Tracking Homogeneous Groups Hypothesis Testing Index Lifestyle Research Likert Scale Market Effectiveness Market Segmentation Market Share Monthly Unique Visitors Net Promoter Score (NPS)Neural Network Niche Marketing Nielsen Ratings Observation Bias Observation Research Organic Channel Paid Search Channel Path Length Report Primary Research Qualitative Research Race Referral Channel Social Media Channel Website Survey
MarTech and AdTech
Acme Data Adobe Target Amazon CloudFront Amazon Redshift Analance AnswerMiner AppDynamics Baremetrics Bombora Bootstrap Brightcove Cisco CMX Engage Dasheroo Dundas BI Fivetran Funnel Google BigQuery Google Data Studio Google Marketing Platform Google Optimize Honeywell Operational Intelligence IBM Cognos Analytics IBM InfoSphere Data Architect Inspectlet Jenkins Kissflow KNIME Analytics Platform LiveRamp Looker Marketing Technology Stack Marketo Microsoft Power BI Microsoft SQL Server Reporting Nutanix Optimizely Pendo PowerCenter Informatica QlikView Salesforce Pardot SAP Crystal Reports Socialbakers SQLite Striim Tableau Tobii Dynavox Trade Desk Trifacta UserExperior Visual Website Optimizer (VWO)Wolfram Mathematica WooCommerce Yellowfin BI Yieldify
Mobile App Intelligence
Ad Mediation Ad Viewability Ad Whales Adjust App Churn Rate App Demographics App Monetization App Rating App Store Traffic Application Lifecycle Management (ALM)AR (Augmented Reality) Advertising Average Revenue Per Paying User (ARPPU)Cross Promotion Daily Active Users (DAU)Dynamic Testing In-App Advertising In-App Bidding Instant Messaging Interactive Mobile Ads K-Factor Location-based Advertising (LBA)Mobile Ad Fraud Mobile Attribution Monthly Active Users (MAU)Playable Ads Push Notification Rewarded Video Ads SDK Mediation Search Terms Server Side Mediation Yield Management
Organic Search
Accelerated Mobile Pages (AMPs)Algorithm Change Alt Attribute Average Order Value (AOV)Black Hat SEO Branded Keyword Breadcrumb Broken Link Duplicate content Dwell Time Featured Snippet Google Hummingbird Googlebot Heatmap Impressions Index Coverage JavaScript (JS)Keyword Cannibalization Keyword Research Link Profile Mentions Nofollow link Organic Keyword Path Length Report Redirection Responsive Website Schema Search Engine Search Terms SEO Share of Voice Sitelinks User-Generated Content (UGC)Word Count XML Sitemap Yahoo Yandex
Paid Search Advertising
Ad delivery Ad extensions Ad Mediation Ad strength Ad Viewability Automated bid strategy Average Order Value (AOV)Combined audiences Conversion Attribution Conversion Tracking Cost per acquisition (CPA)Floodlight Tag Headline Testing Impressions Keyword Research Location-based Advertising (LBA)Path Length Report Quality score Return on investment (ROI)Sitelinks Smart Bidding Smart Lists User ID View-through conversion window Yield Management
Social Media Sensing
Ad Viewability Community Manager Country Reach Impressions Instant Messaging Location-based Advertising (LBA)Microblogging Net Media Cost Pinterest Playable Ads Reach Reputation Management Rewarded Video Ads Rich Pins Snapchat Social Media Conversions Social Media Listening User-Generated Content (UGC)Video Companion Impressions
Technology and Innovation
Artificial Intelligence Big Data Blockchain Data Warehouse Deep Learning Disruptive Innovation Internet of Things Marketing Technology Stack Predictive Data Analytics Predictive Segmentation Prescriptive Analytics R Analytics Voice Assistants
TV Ad Measurement and Insights
Ad Viewability Ad-supported streaming video on demand (ASVOD)Addressable TV Advanced TV Automatic content recognition (ACR)Broadcast Addressable TV Household Data Location-based Advertising (LBA)Multichannel Video Programming Distributor (MVPD)Nielsen Ratings Over-the-top (OTT)Skinny Bundle Subscription video on demand (SVOD)Targeting Rating Point (TRP)Television advertisement Television Viewer Rating (TVR)TV Network Upfronts Video on demand (VOD)

Analytical Database

An analytic database, also called an analytical database, is a read-only system that stores historical data on business metrics such as sales performance and inventory levels. Business analysts, corporate executives and other workers can run queries and reports against an analytic database.

How to use an Analytical database?

While it doesn’t work the same way as a real-time database, it is constantly updated as new data is collected from an organizations’ pertinent data streams. Analytical databases are built for business intelligence and big data analytics, and usually, function as part of larger data warehouses. They are popular because they offer faster query times, simpler maintenance, and easier scalability due to their less volatile nature. Analytical databases are different from transactional (or OTL) databases that handle transaction processing and other operational applications.

What is OLAP database?

Short for Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining.

What are the types of the database?

A system that contains databases is called a database management system, or DBM. We discussed four main types of databases: text databases, desktop database programs, relational database management systems (RDMS), and NoSQL and object-oriented databases.

What is the difference between OLTP and OLAP?

OLTP and OLAP both are online processing systems. OLTP is transactional processing while OLAP is an analytical processing system. The basic difference between OLTP and OLAP is that OLTP is an online database modifying system, whereas, OLAP is an online database query answering system.

Free Pre-Assessment Request

Do you want to know how your competitors are doing business?

Tell us a little about yourself below to gain data for free

Hi What’s your name?

First Name
Last Name

Hi [First Name], what is your company’s name and website?

Company
Website

Is your company looking for any data on the following services:

Market Research & Website Traffic
Audience & Customer Profiling
Organic Traffic & Keywords
Paid Search Investments
Display Traffic & Creatives
TV Ads & Investments
Monitor App Performance
Social Media Monitoring
Email Journeys and Creatives

Gotcha! Do you want to monitor any specific competitor or market?

Give Me Data From

List of Competitors

Add competitor…

Finally, what’s your email address and your phone number?

Email Address
Phone Number

Send

Your Data is on the Way!

Our data scientists team is working for you by collecting data and we’ll come back to you shortly with a pre-assessment and proposal.

WYgroup BI uses the information you provide to us to contact you about our relevant content, products, and services . You can unsubscribe from communications from HubSpot at any time. For more information, check out WYgroup’s Privacy Notice.

Multiform

Name
First Last
Company
Website
Services
Country
List of competitors
Email
Phone

Help Topics

Analytical Database

Still have questions on this topic? See some articles below that may help.

How do you conduct market research to reveal business opportunities?

What are the main steps for conducting market research?

How to turn real-time data streams into business value?

Still have questions on this topic?
See some articles below that may help.