Chapter 2 - Database Analytics
A collection of related files containing records on people, places, or things
Database
A chart that displays data in proportional wedges of a circle
Pie chart
When the null hypothesis is false, but the hypothesis test incorrectly fails to reject it, this is called
Type II Error
Coding categorical data as zero’s and one’s to include in a regression model
Dummy coding
______ is a leading data visualization tool used for data analysis and business intelligence
Tableau
Data that comes from experimentation or observation
Empirical data
Data (often in a map or table) that is color coded by size forms a
Heatmap
When the null hypothesis is true, but the hypothesis test incorrectly rejects it, this is called
Type I Error
An assumption that the variation about the regression line is constant for all values of the independent variable
Homoscedasticity
An element in Tableau that allows you to modify a view's design, visualization type, user experience
Marks Cards
An analysis which relies on sorting data and calculating the cumulative percentage of the characteristic of interest
Pareto Analysis
A type of scatterplot in which the size of each data marker correspondents to a third value
Bubble chart
An inference about two contradicting propositions
Hypothesis
A condition occurring when two or more independent variables in the same regression model contain high levels of the same information and, consequently, are strongly correlated with one another and can predict each other better than the dependent variable
Multicollinearity
creates a view based on the fields already used in the view and any fields you’ve selected in the Data pane
Show Me
Displaying data in a meaningful fashion to provide insights
Data Visualization
Charts that combine features of line and pie charts
Area charts
The probability of making a Type 1 error
Level of significance
When the effect of one variable is dependent on another variable
Interaction
Multiple data visualizations combined to give an overview of key business measures
Dashboard
Another term for important business metrics
Key Performance Indicators (KPIs)
Another name for a variable of interest
Factor
Another name for R^2 (r-squared)
Coefficient of determination