data 1 Flashcards
IMPACT Cycle
Identify the Questions: Define the specific questions or problems to be addressed.
Master the Data: Understand the data available and ensure its quality and relevance.
Perform the Analysis: Apply appropriate analytical techniques to the data.
Communicate Insights: Present the findings in a clear and actionable manner.
Track Outcomes: Monitor the results to assess the effectiveness of the analysis and make adjustments if necessary.
Data Analytics
is the process of evaluating data with the purpose of
drawing conclusions to address business questions. Effective Data
Analytics provides a way to search through large structured and unstructured data to identify unknown patterns or relationships.
Big Data
refers to datasets which
are too large and complex to be analyzed traditionally. Remember the 3V ’s:
Volume refers to size
Velocity refers to frequency
Variety refers to different types
types of attributes
Primary keys are unique identifiers.
Foreign keys are attributes that point to a primary key in another table.
Composite keys are a combination of two foreign keys used for line items.
Descriptive attributes include everything else.
Intersection tables
a special type of database table, is used to remove many-to-many relationships.
four main categories of
data analytics
Descriptive analytics are
procedures that summarize existing data to determine what has happened in the past.
Diagnostic analytics are
procedures that explore the current data to determine why something has happened the way it has, typically comparing the data to a benchmark.
Predictive analytics are
procedures used to generate a model that can be used to determine what is likely to happen in the future.
Prescriptive analytics are
procedures that model data to enable recommendations for what
should be done in the future.
SELECT, WHERE, ORDER BY, JOIN ON
SELECT column FROM table, WHERE price>500, ORDER BY ASC DESC, JOIN inventory ON Sales.IventoryID = Inventory.InventoryID