IBC Let's Talk Data

What does ERP stand for?

(type of business system)

• Employee Retirement Plan

• Enterprise Resource Planning

• Excel Requirement Project

• Educational Resource Project

What is the max amount of rows in a standard Excel spreadsheet?

• ~100,000

• ~500,000

• ~1,000,000

• ~10,000,000

What are the first two Data Analysis steps?

• Set Clear goals and collect the data

• Define questions and set clear measurement priorities

• Collect data and clean it

• Collect data and analyze it

Jira is a database language

• True

• False

Power Query is available in Excel for free

• True

• False

What does CRM stand for?

(type of business system)

• Customer Relationship Management

• Consumer Requested Meeting

• Customer and Resource Management

• Collaborative Relationship Monitoring

Salesforce is a type of ERP?

• True

• False

Is Salesforce the #1 CRM?

• Yes

• No

Where can Xlookup be used to join data?

• Excel

• SQL

• Tableau

• All of these

TIEBREAKER

What is the EXACT amount of rows in a standard Excel Spreadsheet?