SQL
What are the 3 required statements when writing a SQL query?
SELECT
FROM
WHERE
What menu on the top ribbon should you navigate to when importing the CNA theme to a new report?
What is the most used/viewed report in the CNA Workspace?
CNA Sales Analysis
What are the 4 CORE Values of Clark National Accounts?
Conscientious Approach
Ownership Mentality
Relentless Innovation
Excellence in Everything
What are the 4 Dimensions of Behavior in DiSC?
Dominance
Influence
Steadiness
Conscientiousness
What are the 2 main databases we use?
EDWOlap
ClarkChains_Qlik
What are the possible table connections when data modeling in Power BI?
one-to-one (1:1)
one-to-many (1:*)
many-to-one (*:1)
many-to-many (*:*)
What is the name of the report we pull for prospects and cold outreach to show historic Web spend?
Datamine
What are CNA’s 3 uniques?
QuickSupply Platform
Nationwide Distribution Network
Unlimited Sourcing Capabilities
What are the 5 Distribution Companies of Clark Associates?
Clark National Accounts
11400
Clark Food Services Equipment
The Restaurant Store
Webstaurant Store
If you use /* */ or -- in a query, what does that allow you to do?
Add notes/comments to your query
In the Filter pane, at what levels can you apply a filter?
Visual Level
Page Level
Entire Report Level
What is the correct order of operations for building out a new report?
Query Writing
Power Query
Data Modeling
Build Visuals
What year was Clark National Accounts founded?
2017
What were the brother’s names that founded Clark Associates in 1971?
Glenn & Lloyd
What database would you use to bring in Stock Information?
Bonus: What table?
EDWOlap
vw.FactInventoryItemLocationCurrent
When writing a measure that requires multiple variables to calculate, what function should you use?
VAR
RETURN
What is the Data & Analytics team Mission Statement?
Consistent delivery of intuitive reporting, actionable insights, and data-driven guidance.
What are the 5 divisions of Business Operations?
Account Support
Logistics
Partner Services
Employee Optimization
Data & Analytics
The Restaurant Store is opening its twelfth location in what state this week? Hint: It is the first location in this state!
Florida
What is the Server Name you must enter when importing a SQL query in Power BI?
EDWNonOlap-ro.prod.mssql.db.backends.tech
What is the difference between Merging Queries and Appending Queries?
Merging Queries joins data horizontally (adds columns)
Appending Queries join data vertically (adds rows)
What is the Ticket ID for the Data & Analytics Epic in Azure?
4488
When an Account Manager submits a Price Changes from the Playbook, where does the data get sent for the Platform team to adjust in Marketplace?
CNA Catalog Management
Clark Associates is passionate about giving back to the community. As part of this effort, what was started in 2001 to help provide financial support to non-profits that employees can nominate?
Clark Associates Charitable Foundation