Business intelligence, or BI, is an umbrella term that refers to a variety of software applications used to analyze an organization’s raw data. Companies use BI and several related activities, including data mining, online analytical processing, querying and reporting to improve decision making, cut costs, identify new business opportunities and identify inefficient business processes that are ripe for re-engineering.
2) What is Visual Analytics, dashboards, data warehouse, data dictionary, meta data, ETL, schema, attributes, hierarchy, cube, OLAP, “drill down”, data mining, data mapping.
The concepts given in the question are discussed below:
1. Visual Analytics: Visual analytics is the science of analytical reasoning supported by interactive visual interfaces.
2. Dashboards: A …show more content…
Hierarchy: A hierarchy is a set of members organized into a structure for convenient analysis. For example, the store hierarchy consists of the store name, city, state, and nation. The hierarchy allows you to form intermediate sub-totals: the sub-total for a state is the sum of the sub-totals of all of the cities in that state, each of which is the sum of the sub-totals of the stores in that city.
10. Cube: An OLAP cube is a term that typically refers to multi-dimensional array of data.
11. OLAP: an online analytical processing (OLAP) engine, responsible for data discovery, including capabilities for limitless report viewing, complex analytical calculations, and predictive “what if” scenario (budget, forecast) planning. It performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.
12. “Drill down”: To drill down means to go through the hierarchy of folders to find a specific file or to click through drop-down menus in a GUI or access database.
13. Data Mining: Data mining is the process of identifying valid, novel, useful and understandable patterns in