Week 3

Question 1

Structured Data

Answer 1

• Clearly defined data fields (e.g. names, age, address,
  phone number, etc.)
• The data are easily searchable.
• Additional work undertaken to copy data from
  organisation systems into a data warehouse
  specifically for reporting and analysis.
• Sources include: databases within systems,
  Online Forms, Point of Sales Systems.
  Even with the rapid rise of new (unstructured) data
  sources companies continue to use structured data to
  produce insights to show new ways of doing business.

Question 2

Unstructured Data

Answer 2

Found mostly in external (big data) sources.
* The data not as easily searchable.
* Hard to manage and creativity is required to pull
relevant data for analytics.
* Sources include: social media, mobile applications,
location services, sensors, e-mails, spreadsheets, PDFs,
PowerPoint, Word docs, voice recordings and Internet
of Things (IoT) technologies.
* > 80% of data in any organisation is unstructured
Unstructured data growing in influence as organisations
try to leverage new and emerging data sources.

Question 3

Decision Types managerial - Strategic

Answer 3

Strategic
Long term
Complex
e.g. aim to be
market leader

Question 4

Decision Types managerial - Tactical

Answer 4

Tactical Operational
Medium term Day-to-day
Less complex
e.g. launching a
new product

Question 5

Decision Types managerial - Operational

Answer 5

Operational
Day-to-day
Simple and routine
e.g. regular ordering of
supplies

Question 6

Data to Information

Answer 6

Contextualizing: Understanding the purpose and context of data collection. Example: Analyzing petrol sales with traffic data for comprehensive insight.

Categorizing: Identifying the main elements of data.

Calculating: Processing data through mathematical or statistical operations.

Correcting Quality: Removing errors or inconsistencies from the data.

Condensing: Summarizing data into a more compact form, like aggregation.

Question 7

Left join

Answer 7

Keeps all data in the left table (i.e. Table 1) and adds to it
using matching entries from Table 2.

Question 8

Inner Join

Answer 8

Focuses on the common items (intersection) between the
two tables

Question 9

Outer join - right

Answer 9

Keeps all data in the right table (i.e. Table 2) and add to
it using matching entries from Table 1.

Question 10

Outer Join: Full Outer

Answer 10

Combines and returns all data from two or more tables,
regardless of whether there is a match between tables.
Also called the Union between tables.

Question 11

What is a OISees

Answer 11

Operational Information Systems
OISes using Available > Useable > Reliable data is important

Question 12

7 EIM blocks (Enterprise Information Management)

Answer 12

Vision
Strategy
Metrics
Governance
People
Process
Infrastracture

Question 13

How to manage OIS across a management?

Answer 13

Use Enterprise Information Management (EIM)

Question 14

What is EIM?

Answer 14

Set of business processes policies - software to manage OIS ie. data and flow across an organisation through daily ops.

Question 15

What is Operational Information Systems (OIS)?

Answer 15

Help with everyday work tasks like selling products, paying employees, and tracking inventory.
Who uses them: Employees who handle day-to-day jobs.
What kind of data: Current, like today’s sales or this week’s work hours.
Main goal: Make everyday work tasks easier and faster.