Database Systems Management > EXAM > CIW Data Analyst Exam Prep ALL ANSWERS 100% CORRECT SPRING FALL-2022/23 SOLUTION GUARANTEED GRADE A+ (All)

CIW Data Analyst Exam Prep ALL ANSWERS 100% CORRECT SPRING FALL-2022/23 SOLUTION GUARANTEED GRADE A+

Document Content and Description Below

Data Analysis - The primary way to an organization extracts value from a business Goal of data analysis - Remove biased data and use historical data to create actionable forward-looking recommendations and predictions. Must be high quality. What kind of quality must data be, to use it? - High Quality/ Good Quality Data collection process - Capture Data, Analyze Data, Use Data Capture Data - Recording and storing data that has been collected, error free. The data capturing process must be valid (follows all processes) and timely (fast, so it's not outdated by the time we use it). Analyzing Data - discovering trends and patterns Using Data - Integrate and use insights from data analysis. This is the point of decision making. What is a company doing whenever they "decide" to do something? - They are "using" the data they've "captured" and "analyzed" to make data driven decisions. What makes data good? - Valid: Follow the rules the organization has set up for us Timely: It needs to be collected quickly Accurate: Error free Tree Data Structure - Hierarchical made up of nodes Difference between structured and unstructured data - ease with which the data can be stored in a meaningful and retrievable way Structured Data - Customer name, DOB, email address, date of transaction, transaction amount Unstructured Data - Comments on a webpage or social media site, text messages, videos of a presentation, Centralized database - database stored in a single location which helps ensure accuracy, consistency, and lowers data redundancy. Disadvantage of centralized databases - data silos and shadow databases can be created Shadow Database - Microsoft Excel spreadsheets, emails and non-formal storage that make it difficult to manage data Goal of centralized data - eliminate silos and have one version of the truth Third Party Data - A way to expand your database. Must follow privacy laws and any licensing rules that come with them. Why would we collect customer data? - To know which customers are buying our products and who our high value customers are How do we define data? - Three V's: volume, velocity, and variety What happens if you fail to secure private employee and customer data? - It can end up as a liability because that data can be stolen Data Architecture - sum of the models, rules, and processes for managing data within a problem domain Leaked information to competitors can be a big issue within an organization. What is one way to prevent this from happening? - Have employees with access to sensitive information sign a nondisclosure agreement (NDA). If the information gets leaked by someone who works or worked for the company, that employee can be sued. How do we secure client and employee data? - mask credit card and social security numbers, password protect files, don't leave your computer unattended without locking it What is a consequence that a business may face if they gave a data breach? - Customers and employees could have a case for a lawsuit and may sue the company and any individuals who were in charge of keeping that information safe. How does data need to be scaled in order to be converted to a cloud based system? - Data must be scaled horizontally to move to the cloud Your business is storing data in a vertical architecture, but wants to transition to a cloud based system. What could be an issue? - Data architects will have to change t

[Show More]

Last updated: 3 years ago

Preview 1 out of 7 pages

Buy Now

Instant download