A collection of Facts
Data
The process of ingesting, storing, organizing, and maintaining the data created and collected by an organization
Data Management
Benefits of Data Management
- Visibility
- Reliability
- security
- Scalability
It is the collection, transformation and organization of data to draw conclusions, prediction and drive decision making?
Data Analysis
Data Analyst - someone who collects, transforms and organizes data.
These are Qualities and Characteristics associated with solving problems?
Analytical Skills
What are the Six Problem Types in Data Management?
- Making prediction
- Categorizing things
- Spotting something unusual
- Identifying themes
- Discovering connections
- Finding Patterns
What is Data-driven Decision Making?
It is the ability to use facts as a guide for business/organizational strategy.
Give me the characteristics of a SMART Question?
Specific
Measurable
Action Oriented
Relevant
Timebound
What are things to avoid when asking questions for your survey or any techniques for data gathering?
- Leading Questions - “This product is too expensive isn’t it?”
- Close-Ended Questions - questions that ask for a one word or brief response.
- Vague Questions - “Does the tool work for you?”
Primary data vs Secondary data
Primary Data - are info collected from first-hand sources like interviews, surveys, and questionnaires.
Secondary Data - gathered by other people or other research.
Internal vs External Data
Based from the name itself ID are data that lives inside a company’s system while ED lives outside.
Continuous vs Discrete Data
Continuous - measurable and can have any numerical values like Height and Temperature
Discrete** - has limited number of values like number of people on hospitals who can visit in a daily basis or Rooms maximum capacity
Qualitative vs Quantitative Data
- Qualitative - subjective and explanatory.
- Quantitative- specific, objective and often numerical.
Nominal vs Ordinal Data
- Nominal - a qualitative data that isn’t categorized.
- Ordinal - it has a set of order or scale.
Structured vs Unstructured
Structured Data - it is organized in a certain format, like rows and columns.
Unstructured Data - not organized so its not easily identifiable like emails, videos and social media posts
It is a spreadsheet program dveeloped by google?
Google Sheets
What is a command? Google sheet-wise
An action that allows you to make something happens.
In refers to a set of rows and columns? It forms the same patterns, rectangular boxes called cells?
Sheet
The vertical set of cells?
Column
Horizontal set of cells?
Rows
It is a selection of cells extending across a row, column or both?
Range
It is a built-in operation you’ll use to calculate and manipulate data on your spreadsheet?
Function
It is the combination of these built-in operation to obtain a specific result?
Formula
