Kuis Data Analytic

 Ø  Which role needs the most technical and working experience?

-> data scientist (Benar)

Data scientists typically have lots of real-world working experience. They are fluent in coding, math, and statistics, as well as all other required data roles, like data engineering, data cleaning, and reporting outcomes.

-> data engineer

-> data analyst

Ø  What is a form of data cleaning and transformation?

-> building VLOOKUP or XLOOKUP functions to bring in data from other worksheets

-> building pivot tables, crosstabs, charts, or graphs

-> deleting columns or adding calculations to an Excel spreadsheet (Benar)

Ø  Which choice is not a valid data type?

-> Number

-> Start date (Benar)

Start date is a field name and is likely a date and time data type.

-> Boolean

-> Text or String

Ø  When data analysts consider all the data from any object, this is an example of them turning on their _____.

-> join lens

-> spreadsheet lens

-> query goggles

-> data lens (Benar)

The data lens is something that a data analyst will improve over time. The more exposure to data you have, the more likely you are to think of data points when they are not exactly in front of you on a table or spreadsheet.

Ø  When starting a new data project, what is one of the best sources to help you begin?

-> existing reports (Benar)

Learning about what is currently being reported will help you understand the organization. Using existing reports, you can often reverse engineer the data to begin your own projects.

-> the database

-> technical documentation

-> queries

Ø  What does a cross join or no join accomplish?

-> It shows only equal records or matching records on both tables.

-> It shows no records.

-> It associates every record to every record in both tables. (Benar)

When multiple tables are brought into a query, they must have a common field that links them together through a join. When this join line is missing, it will tie every record from one table to every record in another table.

-> It shows every record from the left table.

Ø  You want to join records in tables that match with fields in other tables. To do this, which join will you use?

-> a right outer join

-> an inner join (Benar)

-> a left outer join

-> a cross join

Ø  Which items are examples of data cleaning?

A. removing unnecessary columns

B. changing the case of data (upper, lower, etc.)

C. connecting to the data in a database

D. removing unnecessary spaces from data

 

-> B, C, D

-> A, B, C, D

-> A, B, D (Benar)

Removing columns, spaces, and changing case of data are all examples of data cleaning.

-> A, C, D

Ø  Maintaining your original data set provides you with which option(s)? A. the benefit of not starting entirely back over after a mistake

B. an audit trail

C. a better understanding of your data

D. none of these answers

 

-> A, B (Benar)

Keeping a copy of the original data provides you the ability to just quickly start back over after a mistake. It will also give you the ability to return to the original data for auditing the work.

-> D

-> C

Ø  When you are learning a new database, when should you look at a sample of the data?

-> after you look at the queries

-> after you look at the table names (Benar)

-> after you look at the relationships

Ø  Reviewing table design is important for a data analyst. What is something you will discover in the design of tables?

-> workflow

-> data types (Benar)

-> queries

-> record counts

Ø  Knowing the statistical significance of any data point or set is an example of the _____ truth.

-> data

-> stats (Benar)

-> business

Ø  Which items are best practices for being effective in a meeting?

A. Dive right into the data and information when it's your turn.

B. Ask to be on the agenda and state how much time you need.

C. Provide a list of key definitions and consider a slide deck.

 

-> A, B, C

-> B, C (Benar)

As a data analyst, it is important that you have time to cover the information you need answers for your questions. Providing a key list of definitions up front is important to reduce time spent answering questions that you can answer with a simple document. Including a slide deck will help you stay focused and on point.

-> A

Ø  In data, numbers are _____ aligned by default.

-> justified

-> left

-> right (Benar)

Numbers are typically best read when they are right aligned by their last value. In data, it's also an indicator that the program sees values as numbers because it will default to right aligned.

-> center

Ø  One of the key ways to validate your queries is by knowing how many _____ you have in each data set.

-> calculations

-> fields

-> records (Benar)

It is beyond important to know how many records are in the tables you are working with. This is one of the simplest ways to validate your joins.

-> data types

Ø  Which truth is a measure of an organization's production?

-> the stats truth

-> the data truth

-> the business truth (Benar)

Ø  You should _____ the headers on a new sheet tab to provide valuable information with your data.

-> cut and paste

-> manually type

-> copy and transpose (Benar)

Transpose allows you to flip data from horizontal to vertical, which can be helpful when documenting information about fields and while providing data sets to others.

Ø  A file that is not connected to a live data set, and that you receive through either email or an export, is an example of a(n) _____.

-> query

-> flat file (Benar)

Flat files are data sets that are not directly connected to the data source. They are typically are exports to .csv or Excel files that you run yourself or have been emailed to you.

-> Excel file

Excel files can sometimes be connected to data sources with live connections of data.

Ø  Data governance involves _____.

-> the IT department only

-> data regulations

-> people, technology, and processes (Benar)

The best data governance will include not only people, but technology and processes to ensure that data is the highest quality, secured and meeting requirements.

Ø  Changes we make to our data in Power Query are recorded in _____.

-> Applied Steps (Benar)

When making changes to the data in Power Query, it automatically tracks each step in the Applied steps.

-> VBA

-> Macros

Ø  You need a report for every day that occurred in a period of time. To determine if you had transactions on those days, which join would you use between your transactions table and date table?

-> outer join (Benar)

In order to pull every date from a range of dates you will tie your transactions table to a date table through an outer join.

-> cross join

-> inner join

Ø  Which option is not a reusable data set?

-> postal code data

-> date table

-> order transactions (Benar)

Order transactions will change and be an overall part of the data we report and visualize. However, it is not what we consider reusable, like a date table or postal code data.

Ø  _____ code is written by recording macros in Microsoft Office.

-> C++

-> VB (Visual Basic)

-> JavaScript

-> VBA (Visual Basic for Applications) (Benar)

VBA is the code language that runs Microsoft Office products. When you create a macro, it is coding in the VBA.

Ø  In Power Query, merge queries allow us to _____.

-> clean leading zeros

-> join data together (Benar)

Merge queries are the database equivalent to writing a select query.

-> change data types

-> compile equal data sets

Append queries are used to compile like data sets.

Ø  What command do you use to create aggregated data sets in Power Query?

-> Reference Data Set

Reference Data Set is the ability to duplicate a data set and maintain a cleaning reference to the original data set. It may be used in the process but it is not the function that creates the aggregated data.

-> Group By (Benar)

Group By will allow you to group data and add aggregate functions like SUM, COUNT and AVERAGE.

-> Append Queries

-> Merge Queries

Merge Queries are used to join data. They do not create aggregated data sets.

Ø  There are many reasons to change case of any data. Using Proper() changes case to proper in Excel. What is the equivalent command in Power Query?

-> Transform > Capitalize each word (Benar)

Transform > Capitalize each word is the same outcome as using the Proper() function in Excel.

-> Transform > UPPERCASE

-> Transform > Change Case > UPPERCASE

There is not a Change Case step between Transform and any case change command. UPPERCASE capitalizes every letter, not just the first.

Ø  It's not always obvious when looking at large data sets that data is duplicated. Which command in Excel lets you easily highlight duplicate values?

-> Remove Duplicates

Remove Duplicates will actually remove the data from the data set. It does not highlight the duplicated data.

-> Sort

-> Conditional Formatting (Benar)

Excel Conditional Formatting has a highlight option that will immediately apply formatting that shows duplicated data.

Ø  What is not an example of a logical function?

-> CountIF

-> Average (Benar)

Average is not considered a logical function, but an aggregate function.

-> IFS

-> SUMIF

Ø  Merge Columns replaces what function in Excel?

-> VLOOKUP

-> Match()

-> Concat() or Concatenate()  (Benar)

Concat() and Concatenate() both combine values in Excel, and the outcome of Merge Columns is the same as both of these commands in Excel.

-> SUMIF()