Ask questions to make data-driven decision making Flashcards

1
Q

Structured Thinking

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Problem

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Problem

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

6 Common Types of Problems

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

6 Common Types of Problems

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Making predictions

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Categorizing things

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Spotting something unusual

A

Identifying data that is different from the norm.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Identifying themes

A

Grouping categorized information into broader concepts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Discovering connections

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Finding patterns

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

SMART Targets

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Specific:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Specific Questions Example?

A

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?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Measurable questions

A

Measurable questions can be quantified and assessed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Measurable questions example

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Action-oriented questions

A

Action-oriented questions encourage change.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Action-oriented questions example

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Relevant Questions

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Relevant questions example

A

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?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Time Bound questions

A

Time-bound questions specify the time to be studied.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Fairness

A

Ensuring that your questions don’t create or reinforce bias

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Fairness example

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Cloud

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Data

A

A collection of facts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Data analysis

A

Can help us make more informed decisions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Data-Inspired decision-making

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

Algorithm

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

Quantitative data

A

Specific and objective measures of numerical facts.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Qualitative data

A

Subjective or explanatory measures of qualities and characteristics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

2 Types of Data Presentation tools

A

1) Reports
2) Dashboards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Report

A

Static collection of data given to stakeholders periodically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

Dashboard

A

Monitors live, incoming data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

Reports Pros

A

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

32
Q

Reports Cons

A

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

33
Q

Dashboards Pros

A

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

34
Q

Dashboards Cons

A

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

35
Q

Pivot table

A

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.

36
Q

Metric

A

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

37
Q

Revenue Equation

A

Revenue/ # of sales X the sales price

38
Q

(ROI) Return on Investment

A

Net profit over a period of time / net investment

39
Q

Metrics in Marketing

A

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

40
Q

Metric Goal

A

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

41
Q

Small data

A

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

42
Q

Big data

A

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

43
Q

Bed Occupancy Rate

A

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

44
Q

Pivot chart

A

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

45
Q

SMART methodology

A

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

46
Q

Some Common Maths Functions

A

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

47
Q

Spreadsheet tasks

A

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

48
Q

Different data sources

A

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

49
Q

Formula

A

A set of insturctions that performs a specific calculation.

50
Q

Operator

A

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

51
Q

4 Operators

A

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

52
Q

Cell reference

A

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

53
Q

Range of cells

A

A collection of two or more cells

54
Q

DIV/0!

A

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

55
Q

ERROR!

A

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

56
Q

N/A

A

Data in formula can’t be found by the spreadsheet

57
Q

NAME?

A

A formula or function name isn’t understood.

58
Q

NUM!

A

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

59
Q

VALUE!

A

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

60
Q

REF!

A

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

61
Q

Function

A

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

62
Q

Problem domain

A

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

63
Q

Structured Thinking

A

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

64
Q

Scope of work (SOW)

A

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

65
Q

Scope of work (SOW) Examples

A

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

66
Q

A statement of work

A

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.

67
Q

The scope of work

A

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.

68
Q

Deliverables

A

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

69
Q

Context

A

The condition in which something exists or happens

70
Q

Average

A

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

71
Q

Borders

A

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

72
Q

COUNT

A

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

73
Q

Equation

A

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

74
Q

Unfair question

A

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

75
Q

Stakeholders

A

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

76
Q

Turnover rate

A

The rate at which employees leave a company

77
Q

Before you communicate, think about

A

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.

78
Q

How to solve a problem

A

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

79
Q

Things to do during a meeting

A

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

80
Q

Don’t do this during meetings

A

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

81
Q

Fill Handle

A

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