This chapter presents the following content: Importance of presentation capability of BI, technologies that support decision making, tactical decisions, strategic decisions, online analytical processing (OLAP), visual analytics, performance dashboards. | Chapter 6: Technologies Enabling Presentation Introduction Importance of presentation capability of BI Technologies that support decision making Tactical decisions Strategic decisions Online analytical processing (OLAP) Visual analytics Performance dashboards Online Analytical Processing Transactional databases are accessed by online transaction processing (OLTP) applications OLAP was coined by Edgar Codd [1970 ] OLAP is used essentially to query the DW OLAP supports the presentation of data in a multi-dimensional format called a cube The numeric facts in the DW known as the measures OLAP Cubes OLAP offers the ability to have more than three dimensions (hypercube) Pivot Table – A data summarization tool OLAP cubes enable slicing and dicing the data OLAP Cube, Data Slice and Dice Visual Analytics Visual analytics refers to the use of computer graphics to create a visual representation of large collections of information Purpose of visualization is to enable knowledge discovery . | Chapter 6: Technologies Enabling Presentation Introduction Importance of presentation capability of BI Technologies that support decision making Tactical decisions Strategic decisions Online analytical processing (OLAP) Visual analytics Performance dashboards Online Analytical Processing Transactional databases are accessed by online transaction processing (OLTP) applications OLAP was coined by Edgar Codd [1970 ] OLAP is used essentially to query the DW OLAP supports the presentation of data in a multi-dimensional format called a cube The numeric facts in the DW known as the measures OLAP Cubes OLAP offers the ability to have more than three dimensions (hypercube) Pivot Table – A data summarization tool OLAP cubes enable slicing and dicing the data OLAP Cube, Data Slice and Dice Visual Analytics Visual analytics refers to the use of computer graphics to create a visual representation of large collections of information Purpose of visualization is to enable knowledge discovery Importance: visualization helps users see patterns Example: study of a hurricane BI in Practice: The Need for BI for Visual Analytics in Emergency Response National Visualization and Analytics Center, located at the Pacific Northwest National Lab, supports the US Dept. of Homeland Security The science of analytical reasoning Visual representation and interaction technologies Data representations and transformations Production, presentation, and dissemination Privacy and security issues that are based on an interoperable architecture BI in Practice: Improving Sales Performance via Visual Business Intelligence Field sales representatives’ organizational structures Example: for those working in pharmaceutical and healthcare businesses Visual information mapping tools are helpful to build these sales structures Using color coding to map the sales territories offers several advantages Visual information mapping tools may also allow combining and integrating different values associated with .
