Download INFS 2036 Exam Review: Business Intelligence and Data Analytics and more Lecture notes Business in PDF only on Docsity!
BI
BUSINESS INTELLIGENCE
INFS 2036
Business Intelligence
We e k 1 0
You’re the CEO!
(exam review)
- Key points for your curriculum vitae/job
applications
- Exam Info To Know
- Help Leading Up to the Exam +
Exam Technique
W h a t w e ’ r e d o i n g t h i s w e e k
2
Agenda – Week 10
You pass the exam
like a champion! J
THEORY PRACTICE
Focus On … • EXAM Preparation
INFS 2036
YOUR PASSPORT TO ANY ORGANISATION
ANYWHERE IN THE WORLD
Key Points + Workshop Activities This Week’s Case Study
Privacy Ethics
YOUR PASSPORT TO ANY ORGANISATION ANYWHERE IN THE WORLD
Priority Questions Information Data Visualisation Data Quality Ethics^ Metrics and Performance Indicators Insights (^) Questions...More Machine Learning Available
- • Does it exist? Is it being collected?Is it in an internal system? Or easy-to-get to external system?
- • • Are there confidentiality restrictions to accessing or sharing the data?Are there technical restrictions to accessing and sharing the data?METADATA Useable
- • Is there enough data?Is it complete data?
- • • Can we join it with other data?Does it need an expert to interpret the data?DATA QUALITY + DATA STANDARDS + MASTER DATA Reliable^ •^ •^ Can we makeNow?^ And in the future? Automate?^ decisions^ based on this data? Discovery Response Monitoring Predicting Goals PIs + Metrics Quality^ Data Standards^ Data Master Data^ Metadata Management Data^ Big Business Analytics Algorithm Science^ Data Learning^ Deep mining^ Data DATA INFORMATION events data metric Get the data Use the data organisational performance^ Optimise^ Drive changes organisational processes^ in build trust making as part of their usual procedures, and SMEs are the ones pres- ently struggling to enhance top management decisions while adding more data for the analysis process. Aligning the people, technology, and organizational resources to become a data-driven company is problematic ( making and increase organizational output; this is possible when aWeill & Ross, 2009). Given BD can enhance the decision- selection of analytical methods is used to extract sense from the data, such as:
- descriptive analytics rent state of a business situation in a way that developments, patterns and exceptions become evident, in the form of producing standard re- scrutinizes data and information to define the cur-
- ports, ad hoc reports, and alerts (inquisitive analytics propositions, for example, analytical drill downs into data, statistical is about probing data to certify/reject businessJoseph & Johnson, 2013);
- analysis, factor analysis (predictive analytics ling to determine the future possibilities ( is concerned with forecasting and statistical model-Bihani & Patil, 2014Waller & Fawcett, 2013); );
- prescriptive analytics assess how businesses enhance their service levels while decreasing the expenses (Joseph & Johnson, 2013 is about optimization and randomized testing to); and
- pre-emptive analytics ary actions on events that may undesirably in tional performance, for example, identifying the possible perils and is about having the capacity to take precaution-fluence the organiza- recommending mitigating strategies far ahead in time ( Henne, & von Voigt, 2012). Szongott, improved decision-making and organizational performance by making^ Advocates assert that these types of analytical methods support in everything more translucent and quanti inconsistencies as well as potential concerns and opportunities. illustrates the classification of BDA methods and the SLRfiable, while further uncovering findings for Fig. 2 Q2 are based on these five categories.
- Research methodology In an attempt to better understand and provide more detailed insights to the phenomenon of big data and bit data analytics, the authors respond to the special issue call on Technology and Organizational Resource Management (speci Big Data and Analytics infically focus- ing on conducting Big Data Challenges and Big Data Analytics methods theorized [in extant research literature], proposed [by research scholars], and employed [by – A comprehensive state-of-the-art review that presents organizations]) descriptive reviews ( Charters, 2007; Wang, Gunasekaran, Ngai, & Papadopoulos, 2016 through a SLR methodology as opposed to narrative orTranfield, Denyer, & Smart, 2003; Kitchenham &). In support of the former approach, report that SLR is a rational, transparent and reproducible research methodology for the analysis of extant literature. Lettieri, Masella, and Radaelli (2009) Kitchenham and Charters (2007) and it is a distinct approach to establish, explore and deduce accessible proof associated to a particular research question (e.g. Q1 and Q2) in a also highlight that SLR is a form of secondary study way that is unprejudiced and (to a certain degree) repeatable. Alterna- tively, meta-based-approaches can be used to conducting a literature review and include the work of Mishra, Gunasekaran, Papadopoulos, and Childe (2016) approach to obtain and compare in (in this example, Big Data in Supply Chains)., which adopt a bibliometric and network analysisfluential work in a specific domain DESCRIPTIVE Analytics PREDICTIVE Analytics PRESCRIPTIVE Analytics Inquisitive Analytics Analytics that help in^ Pre-Emptive^ Analytics happened in the Business?”^ understanding e.g. “What anticipating e.g. “What is likely to happen in the future?”^ Analytics that help in responding “So What?”^ Analytics that help in and “Now What?” comprehending e.g. “Why is something happening in^ Analytics that help in the business?” recommending “What is required to do more?”^ Analytics that help in Information Insights Decision Action Fig. 2. Classification of types of big data analytical methods. 266 U. Sivarajah et al. / Journal of Business Research 70 (2017) 263– 286 DIAGNOSTIC Analytics DIAGNOSTIC Analytics STRUCTURED DATA UNSTRUCTURED DATA PIs Metrics Choose an effective visual (^) Reduce Clutter Focus the attention^ Identifying engaging and stakeholders^ project What are the business priorities and expected benefits? BI/analytical^ Which tools will be delivered? build the BI?^ Who will the costs?^ What are How will the BI be maintained and governed after the project? methodologies^ Which are best? development^ System methodology project^ BI phases engagement^ Stakeholder Internet of Things Industry 4. Volume Variety Velocity Veracity Value Elementary Intermediate Overall Priority Embedded insight Choose Strong Association Rules Associations^ Look for items that^ Look for co-occur^ transactions^ Data from^ POS Performance Management^ Organisational BI Capability Finance Dashboard Project Data Quality Project Executive Dashboard Project Mapping Technology Project The Secret Ingredients of BI An A3 copy is available online J Points + terms: your Curriculum Vitae
Ø Can help build a data driven culture.
Ø Understand the roles of the key factors involved when partnering with
external stakeholders to provide quality information.
Ø Can design and develop visualisations to enable interactive, clear
insights that are scalable with new filters, metrics and segment splits.
Ø Experience in development using visualisation tools (Tableau) to use a
range of appropriate charts and techniques.
Ø Can develop and test business reports, visualisations and user
interfaces for agreed business requirements.
Ø Can translate complex technical issues into business terms to support
alignment to, as well as development of, organisational strategic plans.
Ø Understand the role of Data Warehouses for data collection and
utilisation.
Ø Can identify key organisational priorities.
4
The Exam INFS 2036 7 Help + Resources to Review Sample Only INFS 2036 8
Can I go backwards and forwards to work on questions?
- Yes J The exam answers will be entered in a downloadable Word booklet so you can go backwards + forwards (up + down) all you like J
Will I get to practice downloading and submitting the exam?
- Yes J We’ll have a separate practice exam (short) with a downloadable booklet pre-populated with shapes for Impact Diagrams J You can also practice submitting the answers. The practice exam will not be marked - it is designed to help you practice the process.
I can’t find this answer in my notes
- The exam is designed to test your abilities in BI so most questions will be open-ended while a small number will be specific focus. Rote-learned and Googleable answers will be at a minimum. The Exam
INFS 2036 9 Focus on Exam Prep
Q U E S T I O N T Y P E S
EACH EXAM QUESTION IS EITHER SPECIFIC-FOCUS
or OPEN-ENDED
APPLICABLE AREA OF COURSE SPECIFIC EXAMPLE TO USE? ADAPT IT FOR THE QUESTION NO SPECIFIC EXAMPLE? USE FUNDAMENTAL PRINCIPLES OF THE TOPIC OPEN-ENDED QUESTIONS PROVIDE THE REQUIRED STEPS/OPTIONS and/or EXPLANATION SPECIFIC-FOCUS
1 QUESTIONS
INFS 2036 10 Focus on Exam Prep
Q U E S T I O N T Y P E S
APPLICABLE AREA OF COURSE SPECIFIC EXAMPLE TO USE? ADAPT IT FOR THE QUESTION NO SPECIFIC EXAMPLE? USE FUNDAMENTAL PRINCIPLES OF THE TOPIC OPEN-ENDED QUESTIONS PROVIDE THE REQUIRED STEPS/OPTIONS and/or EXPLANATION SPECIFIC-FOCUS
1 QUESTIONS
Question: What are the two main Information System Development Approaches in BI Project Management? Describe each one briefly.
1. Waterfall: performs each stage once and in sequence. It is often not possible to move forward until the previous stage has been completed. 2. Agile: each stage of development is repeated as a series of iterations.
14
E X A M — C A S E S T U D Y D I S C U S S I O N
Case Study 1 : Vodafone in Australia Vodafone is a multinational telecommunications giant headquartered in the U.K. and predominantly offers services in Asia, Africa, Europe, and Oceania through owned and operated and/or partnered networks. Vodafone has a strong culture centring around delighting customers, anticipating their needs and delivering greater quality and more value, faster than any other market competitor. This dedication to service is one key reason why Vodafone benefits from having high brand awareness and trusted customer service. However the market is highly competitive. Telecommunications infrastructure in Australia is still undergoing development, allowing room for growth in emerging markets. With access to a lot of structured and unstructured data both internal and external to the organisation, cultural alignment has been an ongoing challenge, impacting overall performance. Current corporate-level strategy is low diversification of products with a focus on providing mobile phone services however in what is recognised as an increasingly competitive market, Vodafone would like to harness the power of data and technology to support growing their presence in Australia over the next 5 years. 14 Week 10: Full Project Focus on Exam Prep INFS 2036 16
Q U E S T I O N T Y P E S
APPLICABLE AREA OF COURSE SPECIFIC EXAMPLE TO USE? ADAPT IT FOR THE QUESTION NO SPECIFIC EXAMPLE? USE FUNDAMENTAL PRINCIPLES OF THE TOPIC OPEN-ENDED QUESTIONS PROVIDE THE REQUIRED STEPS/OPTIONS and/or EXPLANATION SPECIFIC-FOCUS
1 QUESTIONS
Question 1: What is the Priority?
Focus on Exam Prep
17
Q U E S T I O N T Y P E S
Question 1: What is the Priority?
Focus on Exam Prep INFS 2036 18
Q U E S T I O N T Y P E S
Vodafone wants to integrate internal and external enrichment data — hundreds
of thousands of structured and unstructured + internal and external data sources
— to increase their competitiveness in the Australian market by providing
increased operational efficiencies, improved customer insights and one-to-one
buying experiences across multiple touchpoints.
For now we’ll work with the following Priority:
Question 2:
Write 1 descriptive question, 1 predictive and 1 prescriptive question to
support this priority.
Focus on Exam Prep
INFS 2036 21
Question 12: Vodafone would like to better understand the combinations of items that are purchased by
customers. What technique could they use to better understand how items are purchased in sets?
Give an example of a relevant itemset for Vodafone items/services.
Question 11: Vodafone would like to understand whether customers prefer to purchase
phones, tablets, phones and plans, tablets and plans or NBN/Home Internet.
- Write a two-class classification question that would encompass this interest.
What type of regression model would you use?
- Write a multi-class classification question that would encompass this interest.
What type of regression model would you use?
- Write a classification question that would be modelled using linear regression.
Q U E S T I O N T Y P E S
Focus on Exam Prep INFS 2036 22
Question 13: How would the ETL process support the creation of Business
Intelligence for Vodafone? Name two key success factors in implementing a high-
performance ETL process for Vodafone.
Question 14: How would Vodafone use a Data Warehouse in this instance to support
Business Intelligence?
Question 15: How could the Internet of Things offer an opportunity for innovation for
Vodafone to get ahead of competitors? Are there any concerns with ethics or consent?
Q U E S T I O N T Y P E S
Focus on Exam Prep
INFS 2036 23
Q U E S T I O N T Y P E S
Focus on Exam Prep Competitors Vodafone Customer Insights - Vodafone INFS 2036 24
Question 16: For the Vodafone dashboard visualisations write an:
**- elementary level question
- intermediate level question and
- overall level question**
for the visual Positive Sentiment. Which levels of decision making could these questions apply to?
(Strategic/Tactical/Operational).
Q U E S T I O N T Y P E S
Focus on Exam Prep Competitors Vodafone Customer Insights - Vodafone
