Go to ONet. Perform a search for the job of BI Analyst.
When you arrive on the relevant webpage, you will be viewing the ‘summary’ version; change to the ‘details’ version by clicking on the ‘Details’ tab, located just under the Sample of reported job titles.
Once you have switched to the ‘details’ view, find the following information:
– list two other possible job titles that a BI analyst may have in some organizations.
– what is the most common task a BI Analyst is asked to perform?
– what is the highly required skill for a BI Analyst to possess?
– what is the most commonly-occurring work activity for a BI Analyst?
– what is the most highly rated occupational interest for a BI Analyst?
– what is the median wage for a BI Analyst within Georgia?
This article by Gandomi & Haider (2015) explores the notion of ‘big data’ and its potential for supporting analytics. Read this article and answer the following:
– What is ‘big data’?
– What type of opportunities do you see ‘big data’ may provide some organizations?
This video outlines 4 challenges/problems a data warehousing solution may seek to address. Summarize each challenge/problem.
In Margal & Word (2012), when describing the role of data within enterprise systems, the authors make specific reference to the term “organizational data,” which is a term commonly used within the SAP world (e.g., during ERP configuration). However, in MIKE 2.0 (the open source standard for information management) this terminology is not used.
– Of the types of data mentioned in MIKE 2.0 (e.g., metadata, reference data, master data, etc.) where do you think organizational data fits? Explain your reasoning.
– What is the purpose of information structures within SAP ERP?
Watch the below video and then answer the following questions:
In terms of Data Warehousing, what is meant by ETL (Extract, Transform & Load)?
Why do data warehousing solutions require ETL?
Why should purchasing an ETL tool be viewed as a strategic decision?
Distinguish between dimensions, measures, and hierarchies. Provide two examples of each.
What is meant by the term ‘grain of the data’? watching the following video will help you to understand these concepts.
GOOD TO KNOW
BI is very much a data focused role. One cannot do much without a good data infrastructure. Below are two additional frameworks for different organizational data types.
Typology 1: (MIKE 2.0)
Typology 2: LeBlanc (2008) Data Pyramid (slightly different terminology)
The below image provides an example of the format (words are nonsense) you must adhere to when submitting your review questions. It is important to include only ‘answers’ in your submission (i.e., do not put into your submission the text of the question you are answering – just include your answer), as this hinders plagiarism checking. (Grading penalty for including questions is 20% of maximum grade). But you must number your answers.
Please also include proper references to material you have used within your submission (as you are obliged to do).
Use a consistent 12 point font.