Skip to main content
Join our Live Demos, Every Thursday. Register Now

Glossary

AJAX progress indicator
  • a

  • What is Ad Hoc Analysis? Ad hoc analysis refers to the process of getting an answer to one single business query at a time. It enables deep analytics where users ask a question and based on the answer they ask the next question, and the cycle continues. Using this, business users can drill ... Read More
  •   What is Advanced Analytics?   It refers to the study or analysis of data using more sophisticated methods and tools rather than traditional BI tools in order to get advanced insights into massive data volumes for improved decision making. These techniques are majorly used to generate ... Read More
  •   Aggregate/Smart aggregation   Aggregation is the process of summarizing multiple values into a single value. Aggregations can be understood as precalculated summaries of data from leaf cells. Aggregations improve query response time by preparing the answers before the questions are ... Read More
  •   What is Amazon Redshift?   Amazon Redshift is a popular data warehouse service made for the cloud. Enterprises use it to store their growing business data in order to perform analysis using their existing BI tools and standard SQL. This cloud data warehouse platform provides business ... Read More
  • Amazon S3 Amazon Simple Storage Service (Amazon S3) is an object storage service enabling web-scale computing. It is a scalable, high-speed, web-based cloud storage service designed for data storage and archiving, application hosting for deployment, installation, and management of web apps, ... Read More
  • Attributes Each dimension contains attributes. Each attribute is bound to one or more columns in a dimension table. Attributes can be, and are generally, arranged into user-defined hierarchies that provide the drill-down paths by which users can browse the data in the measure groups to ... Read More
  • b

  • BI Acceleration BI acceleration platform supercharges your existing BI tools to analyze billions or trillions of rows of data with instant response times. By adding a BI acceleration platform to your enterprise architecture, you can deliver self-service and interactive analysis on massive ... Read More
  • Big Data Analytics Big data is a collection of massive and diverse data sets coming from various data sources, especially new sources covering every aspect and detail of the business. This vast amount of data can be used to solve previously unanswerable business problems. Big data analytics ... Read More
  • Business Intelligence Business Intelligence (BI) is the process or infrastructure that collects, stores, and analyses data from a company's day-to-day operations. It presents easy-to-understand reports that assist users in making better business decisions. It encompasses data mining, process ... Read More
  • c

  • Calculated Measures Calculated Measures are the expressions that operate on aggregations of data defined and are computed at run time to return values based on the current context. Calculated Measures are evaluated for understanding context-based calculations in real-time. It is evaluated ... Read More
  • Cardinality Cardinality is the term used to define the uniqueness of data values included in a specific column of a database table. Cardinality can refer to two things in databases– Relationship Cardinality - While designing a database, cardinality is something that can be referred to as ... Read More
  • Chart Definition A chart is a graphical representation intended to organize and represents a set of numerical or qualitative data to make data visualization easier to understand. Charts enable slicing, dicing, and drilling-down of your data so that you can examine it from different ... Read More
  • Cloud Analytics In this virtual expanse, data is no longer a static entity confined to silos. Data is a dynamic force that is brimming with insights waiting to be discovered. Cloud analytics plays a pivotal role in driving business innovation as it transcends traditional data management by ... Read More
  • Cloud BI Acceleration Over the years, there has been a massive increase in the amount of data enterprises deal with. This surge in the flow of data has created limitations for the BI and analytical tools making it difficult for them to perform. It takes from minutes to hours to fetch the ... Read More
  • Cloud Data Platform Cloud Data Platforms are the modern means of data management. They let users store, access, and analyze enterprise data via the cloud. As data volumes increase, enterprises find it difficult to store and manage their data securely using the traditional on-premise data ... Read More
  • Cloud Data Warehouse What is a Cloud Data Warehouse? A cloud data warehouse is a database solution that serves as a central repository of information for analytics, scale, and ease of use and is delivered as a managed service in a public cloud. Cloud-based data warehouses provide agility ... Read More
  • Cloud Migration Cloud Migration is the process by which organizations move some or all of their data infrastructure, applications, and IT processes from legacy data centers to the cloud. It can also mean the transition organizations undergo while moving from one cloud resource to another. ... Read More
  • Cloud OLAP Cloud OLAP is the modern-day solution to generating interactive, multidimensional analytics on cloud data using BI and analytical tools. With rising data volumes, BI and analytical tools face performance issues while connecting directly to the massive data loads on the cloud. This ... Read More
  • Customer Journey Analytics Customer journey analytics is collecting and analyzing data related to customer behavior so that businesses can improve their experience. This analysis is performed across multiple customer touchpoints and channels to assess the impact of behavior on business ... Read More
  • d

  • Data Architecture Over the past decade, businesses have been flooded with an avalanche of data. Some estimates indicate that the total global volume of data is expected to grow to 181 zettabytes by 2025. This data wave has created compelling strategic opportunities for adaptive companies ... Read More
  • Data Catalog In today's data-driven landscape, businesses are inundated with vast amounts of data from various sources. Effectively managing, analyzing, and deriving insights from this data is critical for making informed decisions and gaining a competitive edge. This is where a data catalog ... Read More
  • Data Cube What is a data cube? A data cube is a multidimensional representation of data intended to facilitate effortless retrieval and structured analysis of the underlying data. When organized in a cube rather than a network of relational tables, it becomes easier for the user to establish ... Read More
  • Data-Driven Insights When insights are derived from data collection, analysis, and interpretation, they are termed as data-driven insights. A data-driven approach enables enterprises with evidence to base their strategies and decision-making on rigorous analysis of their data and not on broad ... Read More
  • Data Fabric What is Data Fabric? Data fabric is a data architecture approach that automates data management functionalities to offer a unified view of all databases and data assets. It simplifies data access by connecting organizational data and reducing complexities of data storage ... Read More
  • What is a Data Lakehouse? A data lakehouse is a data management solution that combines the best features of a data warehouse and data lake to accelerate data processing speeds and perform advanced analytics with cost efficiency. The scalability and flexibility of the data lake merged with ... Read More
  • Data mart Data mart isn't a new concept; it has been around for decades. But as data is growing continually, businesses are challenged by issues like data silos, inadequate data governance and other security concerns. Data silos inhibit seamless access and collaboration, inadequate data ... Read More
  • What is Data Modeling? Data modeling is the process of defining and analyzing all the different data types and the relationships shared by those data types. It involves the creation of a structured representation of data that enables its physical organization to support analytical queries. ... Read More
  • Data Science Data science is a field of study devoted to creating and using tools and techniques to extract information from raw data. In other words, data science makes use of complex machine learning algorithms to make sense of the massive volumes of unstructured data and derive meaningful ... Read More
  • Data Storytelling When presented in massive quantities, data can be hard to digest. Therefore, data owners need to create a sequential flow of information while presenting the data. However, tabular data might still not be straightforward enough, requiring assistance from graphical and ... Read More
  • What is Data Virtualization? Data virtualization works as an abstraction layer for the organization’s data assets. This involves aggregating data on-demand from various sources including databases, cloud services and other data repositories. Data virtualization reduces the reliance on ... Read More
  • Data Visualization Data visualization is the process of representing data in visual form using elements like graphs, maps, charts, infographics, and diagrams. Data visualization makes it easy to understand and analyze massive volumes of data by highlighting the hidden trends, patterns, and ... Read More
  • Data Warehouse A data warehouse is a type of data storage and management system that consolidates data from multiple sources in a structured form. A single data warehouse can store data from multiple databases. This central repository of all business data creates a single source of truth ... Read More
  • What is DAX? DAX stands for Data Analytics Expressions, a formula expression and query language designed for working with tabular models and provides specialized syntax for querying and analysis. It is used mainly in Power BI along with Excel Power Pivot and SQL Server Analysis Services ... Read More
  • e

  • Elasticity Elasticity is the ability to dynamically allocate resources to workflows, processes, projects and meet varying demands without bothering about the capacity planning and engineering for peak usage. Elasticity is managed by the system monitoring tools that automatically allot or ... Read More
  • Enterprise Business Intelligence Business Intelligence (BI) is the process that collects, stores and analyzes data from a company’s day-to-day operations. It is akin to a hidden power of businesses, making them intelligent by transforming boring data into intelligent insights and helping ... Read More
  • MS Excel Excel is a part of the Microsoft Office suite used to create worksheets (spreadsheets) and record data in the form of tables. Businesses use Excel to organize their data into something useful to perform business analysis, reporting, operations management, human resources ... Read More
  • f

  • Fact Table A fact table is a table that contains all the facts, or the business information used in the dimensional model as a central table in a star schema of a data warehouse. Fact table includes fields that outline Facts such as measurements and metrics used for analysis and reporting ... Read More
  • Financial Analytics Financial analytics refers to analyzing large amounts of financial data, predominantly historical facts, and figures. It focuses on cost reduction and profit maximization techniques that help companies draft a power budget for the upcoming year. Such data helps the ... Read More
  • m

  • [vc_row type="in_container" full_screen_row_position="middle" column_margin="default" column_direction="default" column_direction_tablet="default" column_direction_phone="default" scene_position="center" text_color="dark" text_align="left" row_border_radius="none" ... Read More
  • o

  • "Online Analytical Processing" (OLAP) The term "Online Analytical Processing" (OLAP) is an approach to computing that groups data into multidimensional structures to make it easier for users to access information and analyze the data from various angles. Business users can use it to run ad ... Read More
  • r

  • Risk Analytics Risk analytics refers to the techniques that measure and predict risk more accurately. Companies can now leverage the power of their business data due to the rise of big data, enhanced computing capabilities, and advanced analytics. Businesses use artificial intelligence, ... Read More
  • s

  • What is Self-Service Analytics? Earlier, data and reports were restricted by the number of users and the high cost of analytics tools. So, the companies were mindful of providing access to data and reports. However, organizations are now willing to offer democratized access to domain experts ... Read More
  • Single Source of Truth When an organization makes data-driven decisions, it might face difficulties when the database systems are organized in silos because not all employees use the same data. To overcome this difficulty, businesses are currently moving toward a single source of truth model. ... Read More
  • What is a Snowflake Schema? Used in data warehousing, a snowflake schema is a multi-dimensional data model in which dimension tables are further broken down into subdimensions to represent multiple levels of granularity. The snowflake schema can be seen as a step forward from star schemas. As ... Read More
  • What is a Star Schema? Star schema is a database model created with a central table containing facts and dimensional tables having descriptive details about the data's context. Facts and dimensions are created using foreign keys that define the relationships between these tables. When simple ... Read More
  • What is Supply Chain Management? Supply chain management is the effective management of the flow of goods and services that includes procurement of raw material, manufacturing and delivery of the final product or service to the end consumer. Supply chain management includes supplier ... Read More
X
Close Menu