Analysis in electronic tables

Содержание и основные понятия

01
New table level
The table becomes an analytical tool when the question is formulated before the formula: what to compare, by what condition to calculate and how to explain the limitation of the result.
Grade 11
EEG No. 9
02
Alt data quality auditor
Mobile Visualizer
Find the problem before the report.
In a sample of water flow, there's a repeat, a pass, and different units hidden in the sample, so correct only the storage method without making up the measurement.
03
Route
49.1
Data quality
Types, passes and range checks.
49.2
Summary and projection
Criteria, aggregates and trend line.
49.3
Select a parameter
Purpose, variable and limitation of the model.
49.4
Workshop
Tasks for meaningful analysis.
49.5
Outcome
Practical scenario and column.
04
How to Choose a Method
Question
Tool
Result
Risk
What happened?
Report, filter, grouping
Subtotals by category
incorrect analysis unit
How did it change?
Time series, trend line
Dynamics and seasonality
Date slips
What happens on condition?
scenario, parameter selection
result dependency
Unreal restrictions
Is there a connection?
Dispersion diagram, correlation
force of joint change
correlation doesn't prove why.