{"id":1524,"date":"2011-08-04T12:35:00","date_gmt":"2011-08-04T12:35:00","guid":{"rendered":"http:\/\/www.b.shuttle.de\/hayek\/Hayek\/Jochen\/wp\/blog-en\/2011\/08\/04\/business-intelligence-microsoft-press\/"},"modified":"2011-08-04T12:35:00","modified_gmt":"2011-08-04T12:35:00","slug":"business-intelligence-microsoft-press","status":"publish","type":"post","link":"https:\/\/wp.jochen.hayek.name\/blog-en\/2011\/08\/04\/business-intelligence-microsoft-press\/","title":{"rendered":"Business Intelligence &#8211; Microsoft Press"},"content":{"rendered":"<p>\t\t\t\t<a href=\"http:\/\/oreilly.com\/catalog\/9780735626607\">Business Intelligence &#8211; Microsoft Press<\/a>: &#8220;Business Intelligence&#8221;<\/p>\n<div>\n<a href=\"https:\/\/i0.wp.com\/covers.oreilly.com\/images\/9780735626607\/cat.gif\"><img data-recalc-dims=\"1\" decoding=\"async\" border=\"0\" src=\"https:\/\/i0.wp.com\/covers.oreilly.com\/images\/9780735626607\/cat.gif\"><\/a><\/div>\n<p><\/p>\n<div>\n<\/div>\n<div>\nbought the paper book through Amazon as a used book, purchased the PDF at the o&#8217;Reilly&#8217;s web-site.<\/p>\n<p>Update 2011-08-08 : dead tree book arrived at my favourite\u00a0<a href=\"http:\/\/maps.google.com\/maps?q=Welserstr.+14,+Berlin+10777,+Germany+(DHL+Packstation+122)&amp;hl=en&amp;sll=52.49754,13.34211&amp;sspn=0.012763,0.02974&amp;z=17\">DHL Packstation 122<\/a> nearby.<\/p>\n<\/div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<div>\n<span>Glossary<br \/>\n<\/span><br \/><span>80\/20 rule <\/span><span>A theory invented by Vilfredo Pareto in the late 1800s, also<br \/>\nknown as the Pareto principle, that describes the percentage imbalance<br \/>\nbetween input and output. The Pareto principle is not a law of science;<br \/>\nrather, it is a rule of thumb that can apply to many aspects of life. One of the<br \/>\nmost common business examples is when 80 percent of a company\u2019s revenue<br \/>\ncomes from 20 percent of its customers.<br \/>\n<\/span><br \/><span>actionability <\/span><span>A criterion used to grade the importance of a BI opportunity<br \/>\narea based on its prospects of empowering people to take action in an organization. Actionability ratings are high, medium, and low.<br \/>\n<\/span><br \/><span>ad hoc analysis <\/span><span>The impromptu and flexible examination of data without<br \/>\npredefined or fixed formats. Ad hoc analysis gives users the ability to ask and<br \/>\nget answers to an infinite variety of questions quickly.<br \/>\n<\/span><br \/><span>affinity grouping <\/span><span>A descriptive data mining task that describes which items<br \/>\ngo together based on a set of characteristics.<br \/>\n<\/span><br \/><span>alternate hierarchy <\/span><span>A different grouping of levels in a dimension. A dimension can have several alternate hierarchies to meet various analysis needs.<br \/>\n<\/span><br \/><span>analysis gap <\/span><span>A gap between the information that decision makers require<br \/>\nand the mountains of data that businesses collect every day.<br \/>\n<\/span><br \/><span>ancestor <\/span><span>Any member of a dimension at any higher level in relation to<br \/>\nanother member of the same dimension.<br \/>\n<\/span><br \/><span>base measure <\/span><span>A measure that is captured at the transaction level in an<br \/>\noperational system.<br \/>\n<\/span><br \/><span>benchmark <\/span><span>A measure used for making comparisons, for example, industry-specific ratios such as a price\/earnings ratio.<br \/>\n<\/span><br \/><span>BI <\/span><span>See <\/span><span>business intelligence.<br \/>\n<\/span><br \/><span>BI cycle <\/span><span>A performance management framework; an ongoing cycle by<br \/>\nwhich companies set their goals,\u00a0<\/span><\/p>\n<ul>\n<li><span><i>analyze<\/i> their progress,<\/span><\/li>\n<li><span>gain <i>insight<\/i>,<\/span><\/li>\n<li><span>take<br \/>\n<i>action<\/i>,<\/span><\/li>\n<li><span><i>measure<\/i> their success,<\/span><\/li>\n<li><span>and start all over again.<\/span><\/li>\n<\/ul>\n<p><span>BI solution <\/span><span>A mechanism that brings together people, technology, and data<br \/>\nto deliver valuable information to business users.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div title=\"Page 203\">\n<div>\n<div>\n<div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>blueprint <\/span><span>A table that documents the measures and dimensions for answering business questions and reflects the most fundamental requirements for<br \/>\nbuilding BI solutions.<br \/>\n<\/span><br \/><span>business intelligence (BI) <\/span><span>An approach to management that allows an<br \/>\norganization to define what information is useful and relevant to its corporate decision making. Business intelligence is a multifaceted concept that<br \/>\nempowers organizations to make better decisions faster, convert data into<br \/>\ninformation, and use a rational approach to management.<br \/>\n<\/span><br \/><span>business reporting and analysis process <\/span><span>A subset of processes responsible<br \/>\nfor taking data from a BI system, such as a data warehouse, assembling it<br \/>\ninto a business-friendly format, and delivering data to business users.<br \/>\n<\/span><br \/><span>business-to-business (B2B) <\/span><span>The exchange of products, services, or information between businesses.<br \/>\n<\/span><br \/><span>business-to-consumer (B2C) <\/span><span>The exchange of products, services, or information between businesses and consumers.<br \/>\n<\/span><br \/><span>business unit <\/span><span>An organizational structure in which a coherent set of functional activities rolls up into one line of business.<br \/>\n<\/span><br \/><span>calculated measure <\/span><span>A measure that is calculated or derived from a combination of base measures.<br \/>\n<\/span><br \/><span>child <\/span><span>A member that is directly subordinate to another member in a<br \/>\nhierarchy.<br \/>\n<\/span><br \/><span>classification <\/span><span>A predictive data mining task that assigns records to specific<br \/>\ncategories according to the rules of a data mining model.<br \/>\n<\/span><br \/><span>click-stream analysis <\/span><span>The analysis of a user\u2019s interaction with a Web site by<br \/>\ninvestigating the data that is generated with each user\u2019s click in a Web<br \/>\nbrowser. The goal of click-stream analysis is to understand the behavior of<br \/>\nWeb site visitors, identify their likes and dislikes, and use this information to<br \/>\nimprove the quality of the Web site.<br \/>\n<\/span><br \/><span>closed-loop analysis <\/span><span>A process that allows end users to act on the outcomes of their analyses to automatically drive business processes.<br \/>\n<\/span><br \/><span>clustering <\/span><span>A descriptive data mining task that divides data into small<br \/>\ngroups based on similarity without predefinition of the data groups.<br \/>\n<\/span><br \/><span>cube <\/span><span>A multidimensional data structure that represents the intersections of<br \/>\neach unique combination of dimensions. At each intersection there is a cell<br \/>\nthat contains a data value.<br \/>\n<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>Glossary<br \/>\n<\/span><\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<span>custom aggregation <\/span><span>A method of summarizing data from its lowest level of<br \/>\ndetail to its highest level of detail in which measures are aggregated differently across different levels of a dimension.<br \/>\n<\/span><br \/><span>database <\/span><span>A collection of related data that is organized in a useful manner<br \/>\nfor easy retrieval. There are different applications of databases depending on<br \/>\nthe type of data to be stored and how the data is to be used.<br \/>\n<\/span><br \/><span>data modelers <\/span><span>Specialists who work with businesspeople and the technical<br \/>\nexperts during the implementation of a BI solution. Data modelers are<br \/>\nresponsible for gathering business requirements and translating these<br \/>\nrequirements into a realistic design of dimensions and measures.<br \/>\n<\/span><br \/><span>data mining <\/span><span>An automated process that uses a variety of analysis tools and<br \/>\nstatistical techniques to reveal actionable patterns and relationships in large,<br \/>\ncomplex data sets.<br \/>\n<\/span><br \/><span>data mart <\/span><span>A collection of data that is structured in a way to facilitate analysis. Data marts support the study of a single subject area, with all relevant<br \/>\ndata from all operational applications brought together into that data mart.<br \/>\nData marts may be of the relational (RDBMS) variety or the OLAP variety<br \/>\ndepending on the type of analysis to be performed.<br \/>\n<\/span><br \/><span>data warehouse <\/span><span>A repository for data. Many experts define the data warehouse as a centralized data store that feeds data into a series of subject-specific data stores\u2014called data marts. Others accept a broader definition of<br \/>\nthe data warehouse as a collection of integrated data marts.<br \/>\n<\/span><br \/><span>descendant <\/span><span>Any member at any lower level in relation to another specific<br \/>\nmember.<br \/>\n<\/span><br \/><span>decision tree <\/span><span>A model for breaking data into groups. A decision tree uses a<br \/>\nstatistical algorithm to split the set of data being mined into branches of\u00a0a tree.<br \/>\n<\/span><br \/><span>descriptive data mining <\/span><span>A form of data mining that produces a model to<br \/>\ndescribe patterns in historical data and requires human interaction to determine the significance and meaning of these patterns.<br \/>\n<\/span><br \/><span>desktop online analytical processing (DOLAP) <\/span><span>An OLAP storage mode<br \/>\nthat keeps data on a client\u2019s machine and provides local multidimensional<br \/>\nanalysis.<br \/>\n<\/span><br \/><span>dimension <\/span><span>A categorically consistent view of data. All members of a dimension belong together as a group.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div title=\"Page 205\">\n<div>\n<div>\n<div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>dirty data <\/span><span>Data that is uncleansed or invalid because it is missing, incorrect, or duplicated.<br \/>\n<\/span><br \/><span>DOLAP <\/span><span>See <\/span><span>desktop online analytical processing (DOLAP).<\/span><br \/><span>EDI <\/span><span>See <\/span><span>electronic data interchange (EDI).<br \/>\n<\/span><br \/><span>electronic data interchange (EDI) <\/span><span>A standard for the electronic exchange<br \/>\nof business data.<br \/>\n<\/span><br \/><span>enterprise resource planning (ERP) system <\/span><span>A business management system that integrates all facets of the business, including planning, manufacturing, sales, and marketing. ERP systems are most often implemented using<br \/>\npackaged software applications that support each facet of the business.<br \/>\n<\/span><br \/><span>ERP system <\/span><span>See <\/span><span>enterprise resource planning (ERP) system.<br \/><\/span><span>estimation <\/span><span>A predictive data mining task used to assign a new record with\u00a0<\/span><span>a predicted value according to the rules of a data mining model.<\/span><br \/><span>ETL <\/span><span>See <\/span><span>extract, transform, and load (ETL) processes.<br \/>\n<\/span><br \/><span>Extensible Markup Language for Analysis (XML\/A) <\/span><span>A standard protocol<br \/>\nthat OLAP clients can use to talk to OLAP servers. XML\/A is based on the<br \/>\nwidely adopted XML (Extensible Markup Language) standard and uses the<br \/>\nprogramming language Multidimensional Expressions (MDX).<br \/>\n<\/span><br \/><span>extract, transform, and load (ETL) processes <\/span><span>Processes that are responsible for transporting and integrating data from one or more source systems<br \/>\ninto one or more destination systems.<br \/>\n<\/span><br \/><span>front-end tool <\/span><span>A category of software that harvests the data stored in a data<br \/>\nwarehouse and presents the data to users in the form of reports and interactive reviews.<br \/>\n<\/span><br \/><span>functional area <\/span><span>A department of a business unit that is focused on a specific function.<br \/>\n<\/span><br \/><span>hierarchy <\/span><span>The organization of levels within a dimension that (1) reflects<br \/>\nhow data is aggregated from detailed levels to summarized levels and<\/span><br \/><span>(2) serves as the drill-down path for top-down business analysis.<br \/>\n<\/span><br \/><span>HOLAP <\/span><span>See <\/span><span>hybrid online analytical processing (HOLAP).<br \/>\n<\/span><br \/><span>hybrid online analytical processing (HOLAP) <\/span><span>An OLAP tool that can store<br \/>\ndata in both multidimensional databases and relational databases.<br \/>\n<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>information consumer <\/span><span>A community of business users that requires the<br \/>\nability to dynamically query the database via a \u201cguided\u201d user experience that<br \/>\nallows drill down and pivoting when desired, while eliminating options that<br \/>\nmay create undesirable results.<\/span><\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<span>information user <\/span><span>A community of business users that generally requires<br \/>\nstandard reports without needing to analyze the data on an ad hoc basis.<br \/>\n<\/span><br \/><span>interoperability <\/span><span>A product\u2019s ability to work together and interact with other<br \/>\nproducts.<br \/>\n<\/span><br \/><span>key performance indicator (KPI) <\/span><span>A measure that ranks as one of the most<br \/>\nimportant metrics in an organization. KPIs guide businesses in making decisions that affect particular business units as well as the company at large.<br \/>\n<\/span><span>Key performance indicator <\/span><span>is used interchangeably with <\/span><span>metric.<br \/>\n<\/span><br \/><span>KPI <\/span><span>See <\/span><span>key performance indicator (KPI).<br \/>\n<\/span><br \/><span>leaf member <\/span><span>A bottom-level member in a dimension.<br \/>\n<\/span><br \/><span>materiality <\/span><span>A criterion used to grade the importance of an BI opportunity<br \/>\narea based on how financially significant the opportunity is to the organization. Materiality ratings are high, medium, and low.<br \/>\n<\/span><br \/><span>measure <\/span><span>A numeric value that is of interest to business analysis.<br \/><\/span><span>member <\/span><span>An item in a dimension that represents one or more occurrences\u00a0<\/span><span>of data.<\/span><br \/><span>mental model <\/span><span>A collection of everything that we think we know about how<br \/>\nsomething works (in this case our business). This labeling of our understanding applies to not only people but also organizations. Some people refer<br \/>\nto the company\u2019s mental model as \u201ctribal wisdom.\u201d<br \/>\n<\/span><br \/><span>metadata <\/span><span>Information about the properties of data, such as business logic<br \/>\nthat describes the structure and content of dimensions and measures.<br \/>\n<\/span><br \/><span>metric <\/span><span>A measure that guides businesses in making decisions that affect<br \/>\nparticular business units as well as the company at large. <\/span><span>Metric <\/span><span>is used<br \/>\ninterchangeably with <\/span><span>key performance indicator.<br \/>\n<\/span><br \/><span>MOLAP <\/span><span>See <\/span><span>multidimensional online analytical processing (MOLAP).<br \/>\n<\/span><br \/><span>multidimensional analysis <\/span><span>A way of analyzing data in a top-down<br \/>\nfashion by examining measures simultaneously broken out by multiple<br \/>\ndimensions.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div title=\"Page 207\">\n<div>\n<div>\n<div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>multidimensional online analytical processing (MOLAP) <\/span><span>An OLAP storage<br \/>\nmode in which data is placed into special structures that are stored on a central server(s).<br \/>\n<\/span><br \/><span>OLAP <\/span><span>See <\/span><span>online analytical processing (OLAP).<br \/>\n<\/span><br \/><span>OLE DB <\/span><span>An application programming interface (API) for accessing data.<br \/>\nOLE DB supports accessing data stored in any format (databases, spreadsheets, text files, and so on) for which an OLE DB provider is available.<br \/>\n<\/span><br \/><span>OLE DB for OLAP <\/span><span>Formerly the separate specification that addressed<br \/>\nOLAP extensions to OLE DB. Beginning with OLE DB 2.0, OLAP extensions<br \/>\nare incorporated into the OLE DB specification.<br \/>\n<\/span><br \/><span>OLTP <\/span><span>See <\/span><span>online transaction processing (OLTP).<br \/>\n<\/span><br \/><span>online analytical processing (OLAP) <\/span><span>Multidimensional analysis that is supported by interface tools and database structures that allow instantaneous<br \/>\naccess and easy user manipulation. Online analytical processing got its name<br \/>\nbecause this name contrasts well with OLTP, a term that was already in widespread use when the term OLAP was created. There are fundamental differences between transaction processing and analytical processing. OLAP systems<br \/>\nsupport multidimensional analysis at the speed of thought. OLAP typically<br \/>\nfollows the client\/server paradigm, where an OLAP database <\/span><span>server <\/span><span>is accessed<br \/>\nby many users who use multidimensional <\/span><span>client <\/span><span>tools to analyze data.<br \/>\n<\/span><br \/><span>online transaction processing (OLTP) <\/span><span>A data processing system designed<br \/>\nto record all the business transactions of an organization as they occur.<br \/>\nOLTP systems are structured for the purposes of running the day-to-day raw<br \/>\ndata of business, which requires efficiency and minute processing of transactions at the lowest level of detail. An OLTP system processes a transaction,<br \/>\nperforms all the elements of the transaction in real time, and processes<br \/>\nmany transactions on a continuous basis. OLTP systems usually offer little or<br \/>\nno analytical capabilities.<br \/>\n<\/span><br \/><span>open database connectivity (ODBC) <\/span><span>A data access application programming interface (API) that supports access to any data source for<br \/>\nwhich an ODBC driver is available. ODBC is aligned with the American<br \/>\nNational Standards Institute (ANSI) and International Organization for<br \/>\nStandardization (ISO) standards for a database call level interface (CLI).<br \/>\n<\/span><br \/><span>operational database <\/span><span>A database that supports the day-to-day operations of<br \/>\nan organization. Operational databases host the systems that organizations<br \/>\nuse to run their business day to day. Most operational databases are OLTP<br \/>\nsystems and store the data in a relational database management system.<br \/>\n<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<\/div>\n<div>\n<div>\n<div>\n<span>opportunity area <\/span><span>In BI technical terms, the logical grouping of measure<br \/>\nrequirements, where data can be obtained consistently across all the dimensions at the same lowest level of detail. In business terms, similar to a project where a consistent set of requirements for a group of users can be<br \/>\naccommodated more or less from the same end-to-end system structures or<br \/>\nsolution.<\/span><\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<span>parent <\/span><span>A member that is directly above another member in a hierarchy.<\/span><br \/><span>pilot project <\/span><span>A short-term BI project that tests the feasibility of pursuing a\u00a0<\/span><span>specific opportunity area.<\/span><br \/><span>pivot and nest <\/span><span>Point-and-click manipulations that facilitate multidimensional analysis. Pivoting means rotating rows to columns, and columns to<br \/>\nrows, in a cross-tabular data browser. Nesting is layering multiple dimensions on the rows or columns of a browser.<br \/>\n<\/span><br \/><span>power analyst <\/span><span>A community of business users that requires the full analytical power of the data mart. These users are willing to learn the details of<br \/>\ndatabase design and the query tool in order to obtain the necessary results.<br \/>\n<\/span><br \/><span>predictive data mining <\/span><span>Data mining that produces a model for use with<br \/>\nnew data to forecast a value or predict a probable outcome based on patterns<br \/>\ndiscovered in historical data.<br \/>\n<\/span><br \/><span>proof-of-concept project <\/span><span>A BI project that evaluates and selects technologies that can be used to host a data mart.<br \/>\n<\/span><br \/><span>ragged hierarchy <\/span><span>A hierarchy that has an inconsistent number of drill-down<br \/>\nlevels.<br \/>\n<\/span><br \/><span>ratio <\/span><span>A measure where the result is calculated specifically from dividing<br \/>\none measure by another.<br \/>\n<\/span><br \/><span>RDBMS <\/span><span>See <\/span><span>relational database management system (RDBMS).<br \/>\n<\/span><br \/><span>refresh rate <\/span><span>The frequency by which data is updated. Typically the refresh<br \/>\nrate corresponds to the lowest level of detail of a time dimension required<br \/>\nfor a group of measures.<br \/>\n<\/span><br \/><span>relational database management system (RDBMS) <\/span><span>A set of programs that<br \/>\nallows users to create, update, and administer data that is stored in a database of related tables.<br \/>\n<\/span><br \/><span>relational online analytical processing (ROLAP) <\/span><span>An OLAP storage mode<br \/>\nwhere data is stored in relational databases.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<div>\n<div>\n<\/div>\n<\/div>\n<\/div>\n<div>\n<div>\n<div>\n<span>ROLAP <\/span><span>See <\/span><span>relational online analytical processing (ROLAP).<br \/><\/span><span>roll-up <\/span><span>The hierarchical aggregations of data typical in multidimensional\u00a0<\/span><span>structures.<\/span><br \/><span>segmentation <\/span><span>A data mining technique that analyzes data to discover<br \/>\nmutually exclusive collections of records that share similar attribute sets. A<br \/>\nsegmentation algorithm can use unsupervised learning techniques such as<br \/>\nclustering or supervised learning for a specific prediction field.<br \/>\n<\/span><br \/><span>semiadditive aggregation <\/span><span>A method of summarizing data from its lowest<br \/>\nlevel of detail to its highest level of detail in which measures are not aggregated uniformly across all dimensions.<br \/>\n<\/span><br \/><span>sibling <\/span><span>A member that is at the same level as one or more other members<br \/>\nsharing the same parent.<br \/>\n<\/span><br \/><span>slice and dice <\/span><span>Two complementary methods for interacting with data.<br \/>\nSlicing means isolating a specific member of a dimension for analysis. Dicing<br \/>\nmeans breaking a data set into smaller pieces by examining how measures<br \/>\nintersect with multiple dimensions.<br \/>\n<\/span><br \/><span>slowly changing dimension <\/span><span>A term that describes how dimensions reflect<br \/>\ndata changes over time.<br \/>\n<\/span><br \/><span>SQL <\/span><span>See <\/span><span>structured query language (SQL).<br \/>\n<\/span><br \/><span>structured query language <\/span><span>(SQL; pronounced <\/span><span>sequel) <\/span><span>An industry<br \/>\nstandard language for accessing data (also called querying) in a relational<br \/>\ndatabase management system (RDBMS).<br \/>\n<\/span><br \/><span>uniform aggregation <\/span><span>A method of summarizing data from its lowest level<br \/>\nof detail to its highest level of detail, where data can be aggregated the same<br \/>\nway across all dimensions.<br \/>\n<\/span><br \/><span>visualization <\/span><span>A graphical representation of data that sometimes reveals<br \/>\npatterns that are more apparent to the human eye.<br \/>\n<\/span><br \/><span>write back <\/span><span>The ability for users to update data in an underlying data mart.<br \/>\n<\/span><br \/><span>zero client footprint <\/span><span>A tool that does not require software to be installed<br \/>\non a business user\u2019s desktop, thus making the client application easier to<br \/>\ndeploy to more users.\u00a0<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Business Intelligence &#8211; Microsoft Press: &#8220;Business Intelligence&#8221; bought the paper book through Amazon as a used book, purchased the PDF at the o&#8217;Reilly&#8217;s web-site. Update 2011-08-08 : dead tree book arrived at my favourite\u00a0DHL Packstation 122 nearby. Glossary 80\/20 rule A theory invented by Vilfredo Pareto in the late 1800s, also known as the Pareto [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_share_on_mastodon":"0"},"categories":[55,91,341,822],"tags":[],"class_list":["post-1524","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-data-warehouses","category-microsoft","category-oreilly-publishers"],"share_on_mastodon":{"url":"","error":""},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paO0kP-oA","jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts\/1524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/comments?post=1524"}],"version-history":[{"count":0,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts\/1524\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/media?parent=1524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/categories?post=1524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/tags?post=1524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}