Ask questions to make data-driven decision making

Question 1

Structured Thinking

Answer 1

The process of recognizing the current problem or situation, organizing available information, revealing gaps and opportunities, and identifying the options.

Question 2

Problem

Answer 2

Determine what advertising method is best for reaching anywhere gaming repair’s target audience.

Question 2

Problem

Answer 2

Determine what advertising method is best for reaching anywhere gaming repair’s target audience.

Question 3

6 Common Types of Problems

Answer 3

1) Making predictions
2) Categorizing things
3) Spotting something unusual
4) Identifying themes
5) Discovering connections
6) Finding patterns

Question 3

6 Common Types of Problems

Answer 3

1) Making predictions
2) Categorizing things
3) Spotting something unusual
4) Identifying themes
5) Discovering connections
6) Finding patterns

Question 3

Making predictions

Answer 3

Using data to make an informed decision about how things may be in the future.

Question 4

Categorizing things

Answer 4

Assigning information to different groups or clusters based on standard features.

Question 5

Spotting something unusual

Answer 5

Identifying data that is different from the norm.

Question 6

Identifying themes

Answer 6

Grouping categorized information into broader concepts.

Question 7

Discovering connections

Answer 7

Finding similar challenges faced by different entities and combining data and insights to address them.

Question 8

Finding patterns

Answer 8

Using historical data to understand what happened in the past and is therefore likely to happen again.

Question 9

SMART Targets

Answer 9

Specific, Measurable, Action-oriented, Relevant, Time bond

Question 10

Specific:

Answer 10

Specific questions are simple, significant, and focused on a single topic or a few closely related ideas.

Question 11

Specific Questions Example?

Answer 11

1) Are kids getting enough exercise these days? (Poor example)

2) What percentage of kids achieve the recommended 60 Minutes of physical activity at least five days a week?

Question 12

Measurable questions

Answer 12

Measurable questions can be quantified and assessed.

Question 13

Measurable questions example

Answer 13

2) How many times was our video shared on social channels the first week it was posted?

Question 14

Action-oriented questions

Answer 14

Action-oriented questions encourage change.

Question 15

Action-oriented questions example

Answer 15

2) What design features will make our packaging easier to recycle?

Question 16

Relevant Questions

Answer 16

Relevant questions matter, are essential and have significance to the problem you’re trying to solve.

Question 17

Relevant questions example

Answer 17

1) Why does it matter that Pine Barren’s tree frogs started disappearing? ( Poor example)

2) What environmental factors changed in Durham North Carolina, between 1983 and 2004 that could cause Pine Barrens tree frogs to disappear from the Sandhills Regions?

Question 18

Time Bound questions

Answer 18

Time-bound questions specify the time to be studied.

Question 19

Fairness

Answer 19

Ensuring that your questions don’t create or reinforce bias

Question 20

Fairness example

Answer 20

Unfair question and leading question example: These are the best sandwiches ever, aren’t they?

Question 21

Cloud

Answer 21

A place to keep data online rather than a computer hard drive.

Question 22

Data

Answer 22

A collection of facts

Question 23

Data analysis

Answer 23

Can help us make more informed decisions

Question 24

Data-Inspired decision-making

Answer 24

Explores different data sources to find out what they have in common.

Question 25

Algorithm

Answer 25

A process or set of rules to be followed for a specific task.

Question 26

Quantitative data

Answer 26

Specific and objective measures of numerical facts.

Question 27

Qualitative data

Answer 27

Subjective or explanatory measures of qualities and characteristics.

Question 28

2 Types of Data Presentation tools

Answer 28

1) Reports 2) Dashboards

Question 29

Report

Answer 29

Static collection of data given to stakeholders periodically

Question 30

Dashboard

Answer 30

Monitors live, incoming data

Question 31

Reports Pros

Answer 31

1) High-level historical data 2) Easy to clean 3) Pre-cleaned and sorted data

Question 32

Reports Cons

Answer 32

1) Continual maintenance 2) Less visually appealing 3) Static

Question 33

Dashboards Pros

Answer 33

1) Dynamic, automatic, and interactive 2) More stakeholder access 3) Low maintenance

Question 34

Dashboards Cons

Answer 34

1) Labor- intesnive design 2) Can be confusing 3) Potentially uncleaned data

Question 35

Pivot table

Answer 35

A data summarization tool that is used in data processing. Pivot tables are used to summarize, sort, reorganise, group, count, total or average data stored in a database.

Question 36

Metric

Answer 36

Single, quantifiable type of data that can be used for measurement.

Question 37

Revenue Equation

Answer 37

Revenue/ # of sales X the sales price

Question 38

(ROI) Return on Investment

Answer 38

Net profit over a period of time / net investment

Question 39

Metrics in Marketing

Answer 39

Metrics can be used to help calculate customer retention rates, or a company's ability to keep its customers over time.

Question 40

Metric Goal

Answer 40

A measureable goal set by a company and evaluated using metrics.

Question 41

Small data

Answer 41

1) Specific 2) Short-time period 3) Day-to-day decisions

Question 42

Big data

Answer 42

1) Large and less specific 2) Long period of time 3) Big Decisions

Question 43

Bed Occupancy Rate

Answer 43

Total # of impatient days for a given period X 100 / ( Available beds X # of days in the period)

Question 44

Pivot chart

Answer 44

A Chart is created from the fields in a pivot table.

Question 45

SMART methodology

Answer 45

A tool for determining a question's effectiveness based on whether it is specific, measurable, action-oriented, relevant, and time-bound

Question 46

Some Common Maths Functions

Answer 46

1) Sum 2) Average 3) Count 4) Min 5) Max

Question 47

Spreadsheet tasks

Answer 47

1) Organise your data 1a) Pivot table 1b) Sort and filter 2) Calculate your data 2a) Formulas 2b) Functions

Question 48

Different data sources

Answer 48

1) World Bank 2) World Health Organisation (WHO) 3) Google Public Data Explorer 4) U.S. Census Bureau

Question 49

Formula

Answer 49

A set of insturctions that performs a specific calculation.

Question 50

Operator

Answer 50

A symbol that names the type of operation or calculation to be performed.

Question 51

4 Operators

Answer 51

+ Addition, - Subtraction, * Multiplication, / division.

Question 52

Cell reference

Answer 52

A cell or a range of cells in a worksheet can be used in a formula.

Question 53

Range of cells

Answer 53

A collection of two or more cells

Question 54

#DIV/0!

Answer 54

A formula is trying to divide a value in a cell by 0 or an empty cell

Question 55

#ERROR!

Answer 55

Formula can't be interpreted as input ( also known as a parsing error)

Question 56

#N/A

Answer 56

Data in formula can't be found by the spreadsheet

Question 57

#NAME?

Answer 57

A formula or function name isn't understood.

Question 58

#NUM!

Answer 58

A formula or function calculation can't be performed as specified

Question 59

#VALUE!

Answer 59

A general error that could indicate a problem with a formula or referenced cells.

Question 60

#REF!

Answer 60

A formula is referencing a cell that is no longer valid or has been deleted

Question 61

Function

Answer 61

A preset command that automatically performs a specific process or task using data.

Question 62

Problem domain

Answer 62

The specific area of analysis encompasses every activity affecting or affected by the problem.

Question 63

Structured Thinking

Answer 63

The process of recognizing the current problem or situation, organising available information, revealing gaps and opportunities, and identifying the options.

Question 64

Scope of work (SOW)

Answer 64

An agreed-upon outline of the work you will perform on a project.

Question 65

Scope of work (SOW) Examples

Answer 65

1) Deliverables 2) Timeline 3) Milestones 4) Reports

Question 66

A statement of work

Answer 66

A statement of work is a document that identifies the products and services a vendor or contractor will provide to an organisation. It includes objectives, guidelines, deliverables, schedules, and costs.

Question 67

The scope of work

Answer 67

The scope of work is project-based and sets the expectations and boundaries of a project. A range of work may be included in a statement of work to help project outcome.

Question 68

Deliverables

Answer 68

1) Invitation options 2) List and addresses of invitees 3) Printed invitations 4) Addressed envelops 5) Stamps 6) Mailing

Question 69

Context

Answer 69

The condition in which something exists or happens

Question 70

Average

Answer 70

A spreadsheet function that returns an average of the values from a selected range.

Question 71

Borders

Answer 71

Lines that can be added around two or more cells on a spreadsheet.

Question 72

COUNT

Answer 72

A spreadsheet function that counts the number of cells in a range that meet specific criteria.

Question 73

Equation

Answer 73

A calculation that involves addition, subtraction, multiplication, or division (also called a math expression)

Question 74

Unfair question

Answer 74

A question that makes assumptions or is difficult to answer honestly.

Question 75

Stakeholders

Answer 75

People that have invested time, interest, and resources into the projects you will be working on as a data analyst.

Question 76

Turnover rate

Answer 76

The rate at which employees leave a company

Question 77

Before you communicate, think about

Answer 77

1) Who your audience is 2) What they already know 3) What they need to know 4) How you can communicate that effectively to them.

Question 78

How to solve a problem

Answer 78

1) Reframe the question 2) Problems 3) Challenges 4) Solutions 5) Timelines

Question 79

Things to do during a meeting

Answer 79

1) Come prepared 2) Be on time 3) Pay attention 4) Ask questions --------------------------------------------------- 5) Bring what you need 6) Read the meeting agenda 7) Prepare notes and presentations 8) Be ready to answer questions

Question 80

Don't do this during meetings

Answer 80

1) Show up unprepared 2) Arrive late 3) Be distracted 4) Dominate the conversation 5) Talk over others 6) Distract people with unfocused discussions.

Question 81

Fill Handle

Answer 81

A box in the lower-right corner of a selected spreadsheet cell can be dragged through neighbouring cells to continue instruction.