click below
click below
Normal Size Small Size show me how
ACFM 329
Exam 1
| Term | Definition |
|---|---|
| Data | Raw figures and facts |
| Knowledge | Technology helps convert that data to information, which is the _________________ gained from the data. |
| Data Analytics | Process of analyzing raw data to answer questions or provide insights |
| Self-Service Business Intelligence Software | Provides extended data processing capabilities for preparing data, analyzing data, and reporting data analysis results |
| Null Value | Indicates an unknown or missing value |
| Auditing | Perform risk assessment and substantive procedures |
| Financial Accounting | Perform routine accounting functions such as recording journal entries, creating trial balances, doing preliminary account analysis, and creating financial statements |
| Dashboard | Graphical user interface that shows key performance indicators for an organization |
| Managerial Accounting | Internal reporting and performance analysis |
| Tax Accounting | Analyze tax efficiency of business units, identify tax opportunities, and aid in evaluating global opportunities |
| Plan Analyze Report | What are the stages of the Data Analysis Process? |
| Motivation Objective Strategy Analysis Interpret Communicate | Remember MOSAIC to help with the Data Analysis Process, what does it stand for? |
| Descriptive Diagnostic Predictive Prescriptive | What are the types of Data Analytics? |
| Data Profiling | Process of reviewing the data for possible issues |
| Data Analytics Mindset | Professional habit of critically thinking through the planning, analysis, and reporting of data analysis results before making and communicating a professional choice/decision |
| Critical Thinking | Disciplined reasoning to investigate, understand, and evaluate an event, opportunity, or an issue |
| Reasoning | Human process of logically forming conclusions, judgements, or inferences from facts |
| Data Literacy | Ability to understand and communicate data |
| Technological Agility | Awareness of the latest technological developments and a willingness to try new things |
| Stakeholders Purpose Alternatives Risks Knowledge Self-Reflection | To remember how a data analytics mindset is applied remember SPARKS, what does it stand for? |
| Relational Databases | Collection of logically related data that can be retrieved, manipulated, and updated to meet users' needs |
| Table | How data related to an object of interest are stored in a relational database |
| Resources | Identifiable objects that have economic value to business entity |
| Events | Organization's business activities |
| Agents | Represent people/organizations about which data are collected |
| Primary Key | Unique value for each data row in a database table |
| Foreign Key | Column in a table that is a primary key in another table |
| Query | Request for data from a database so the data can be retrieved or manipulated |
| Structured Query Language (SQL) | Standard query command language for database management |
| Join | Process of combining rows from two or more tables based on related columns between them |
| Inner Join | Selects rows from both tables with matching values & will not have null values |
| Left Join | Returns all records from left table and matching records from right table & could have null values |
| Right Join | Returns all records from right table and matched records from left table & could have null values |
| Full Join | Returns all records when there is a match in either table & null values could be present |
| Functions | Predefined formulas built into analysis software that perform frequently used calculations |
| Data Organization | Rearranging data to make them easier to understand for analysis purposes |
| Pivot Table | Analysis tool that summarizes and reorganizes selected columns and rows of data |
| Slicers | Analysis tool that separates analysis measures per selected dimension |
| Measures of Location | Measures that determine the average or typical observation in the data set |
| Measure of Central Tendency | Single value that describes a set of data by identifying central position within that data set |
| Measures of Dispersion | Measures that describe an amount of variation in the data to help us understand what causes that disparity |
| Measures of Shape | Measures that describe distribution of data in a data set |
| Skewness | Describes the lack of symmetry of data in distribution of data; right is positive and left is negative |
| Kurtosis | Refers to how peaked or flat data are in histogram |
| Frequency Distribution | Summary of activity in observations within given group or interval |
| Histogram | Bar chart of frequency distribution; height of bar reflects frequency within interval |
| Correlation Analysis | Analysis that shows relationships in data by measuring linear relationship between two variables |
| Data Visualization | Graphical representation of data and information to provide meaning and insights during data analysis process |
| Exploratory | Examine data to find insights |
| Explanatory | Communicate results of an analysis |
| Categorical Data | Labeled or named data that can be sorted into groups according to specific characteristics |