OLAP TOOLS IN EDUCATION release_7wknnn7rnjeqbewx34y7xvzbvm

by Danijela Subotić, Patrizia Poščić, Vanja Slavuj

Entity Metadata (schema)

abstracts[] {'sha1': 'a775bec8872757f242bcd303079722f21c6ab6eb', 'content': "Business intelligence systems are becoming a growing trend on the market nowadays. Reason for this is the increasing amount of information generated and collected within the company and from many external sources. In order to remain competitive on the market, it is very important to collect and select relevant information in time, from which a business decision can be made. OLAP (On Line Analytic Processing) systems represent one part of business intelligence systems. Their goal is analytic processing and data extraction for business decision-making. Given the increasing demands of the market, it is important to prepare students to work with these tools as early as in the classroom. In this paper we present an overview of the development and characteristics of OLAP systems and a method of their implementation for educational purposes. We compare the characteristics of two selected OLAP tools used in the classroom. 1. Introduction Information is the key element of today's business. To get the information we need, first we have to collect data-facts, numbers or text-that can be processed by a computer. Relationships among data give us information, which we then convert into knowledge. That is why many business organizations collect and store vast amounts of data in different formats and in different databases. However, there is a problem of finding meaning in that vast amount of data and transforming it into useful information. The solution to this problem can be found in the implementation of business intelligence systems (henceforth BI) and Online Analytical Processing (henceforth OLAP) tools. BI systems enable business organizations to isolate large sets of data from various sources and convert them into meaningful information. OLAP tools are a part of business intelligence systems. The goal of OLAP tools is analytical processing and data extraction for the purpose of business decision making. With the help of OLAP tools, business organizations can accurately know the state within the company and all its parts, taking into consideration the conditions of the market. These tools can reveal hidden patterns in the collected data and, thus, help managers and analysts in making good business decisions. The paper gives an overview of the concept and structure of an OLAP system, explains the OLAP schema and the difference between OLAP and", 'mimetype': 'text/plain', 'lang': None}
container
container_id
contribs[] {'index': 0, 'creator_id': None, 'creator': None, 'raw_name': 'Danijela Subotić', 'given_name': None, 'surname': None, 'role': 'author', 'raw_affiliation': None, 'extra': None}
{'index': 1, 'creator_id': None, 'creator': None, 'raw_name': 'Patrizia Poščić', 'given_name': None, 'surname': None, 'role': 'author', 'raw_affiliation': None, 'extra': None}
{'index': 2, 'creator_id': None, 'creator': None, 'raw_name': 'Vanja Slavuj', 'given_name': None, 'surname': None, 'role': 'author', 'raw_affiliation': None, 'extra': None}
ext_ids {'doi': None, 'wikidata_qid': None, 'isbn13': None, 'pmid': None, 'pmcid': None, 'core': None, 'arxiv': None, 'jstor': None, 'ark': None, 'mag': None, 'doaj': None, 'dblp': None, 'oai': None, 'hdl': None}
files[] {'state': 'active', 'ident': 'ihju2gw4rvhzldbqkfzsumruxe', 'revision': '67b23765-999a-4dea-bfd4-f05573748f3d', 'redirect': None, 'extra': None, 'edit_extra': None, 'size': 842714, 'md5': '9f68364d89681bd0fc258f8a9ac72941', 'sha1': '5dfaa21732d8bcaf4a095abe8b1d9e7db1de3257', 'sha256': '0698253f07f6b3e77a7493933eb9837941d3b9ca4f7856010a35b08af23609f1', 'urls': [{'url': 'https://web.archive.org/web/20180416064025/https://hrcak.srce.hr/file/149534', 'rel': 'webarchive'}, {'url': 'https://hrcak.srce.hr/file/149534', 'rel': 'web'}], 'mimetype': 'application/pdf', 'content_scope': None, 'release_ids': ['7wknnn7rnjeqbewx34y7xvzbvm'], 'releases': None}
filesets []
issue
language
license_slug
number
original_title
pages
publisher
refs[] {'index': 0, 'target_release_id': None, 'extra': {'authors': ['/ Claybrook', 'G Billy', 'Oltp']}, 'key': 'b0', 'year': 1992, 'container_name': None, 'title': 'Online Transaction Processing Systems', 'locator': None}
{'index': 1, 'target_release_id': None, 'extra': None, 'key': 'b1', 'year': 2010, 'container_name': None, 'title': '/ Modelling according to: Pavlić, M., Informacijski sustavi. Odjel za Informatiku, Sveučilište u Rijeci', 'locator': None}
{'index': 2, 'target_release_id': None, 'extra': {'authors': ['/ Codd', 'E Codd', 'S Salley', None], 'volume': '32'}, 'key': 'b2', 'year': 1993, 'container_name': None, 'title': 'Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate', 'locator': None}
{'index': 3, 'target_release_id': None, 'extra': {'authors': ['/ Kimball Ralph', 'Ross Margy', 'Thornthwaite Warren', 'Mundy Joy', 'Becker Bob']}, 'key': 'b3', 'year': 2008, 'container_name': None, 'title': 'The Data Warehouse Lifecycle Toolkit', 'locator': None}
{'index': 4, 'target_release_id': None, 'extra': {'authors': ['/ Kimball Ralph', 'Caserta Joe']}, 'key': 'b4', 'year': 2004, 'container_name': None, 'title': 'The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming and Delivering Data', 'locator': None}
{'index': 5, 'target_release_id': None, 'extra': {'authors': ['Joe / Celco']}, 'key': 'b5', 'year': 2006, 'container_name': None, 'title': "Joe Celko's Analytics and OLAP in SQL", 'locator': None}
{'index': 6, 'target_release_id': None, 'extra': {'authors': ['H / Inmon William', 'E ; / Codd', 'S Codd', 'C Salley'], 'volume': '32'}, 'key': 'b6', 'year': 1993, 'container_name': None, 'title': 'Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate', 'locator': None}
release_date
release_stage
release_type article-journal
release_year 2013
subtitle
title OLAP TOOLS IN EDUCATION
version
volume
webcaptures []
withdrawn_date
withdrawn_status
withdrawn_year
work_id 3zz2z2tznbfp3j6j3mke54ysry
As JSON via API

Extra Metadata (raw JSON)

container_name OLAP TOOLS IN EDUCATION Media, culture and public relations
longtail_oa True