Spreadsheets, Spreadsheets Everywhere
Name 2 KPIs where LOW is GOOD
CPC, CPA, Bounce Rate
What are the 3 sections of the marketing funnel
Awareness, Consideration, & Call To Action
What is Tableau?
Tableau is an interactive visualization software and tool that allows users to see and understand their data. This software performs to transform data from spreadsheets, databases, and the cloud to name a few, into actionable insights through dashboards, allowing for analysis of the data with just a few clicks.
What are the 3Ws?
1. Where I've been
2. Where I am
3. Where I'm going
How long must a visitor be inactive on a webpage for Google Analytics to count a session as over?
30 minutes
Name 3 KPIs where HIGH is GOOD
Conversion Rate, CTR, ROI
What are the 3 types of media? (NOT media channels like TV or OOH)
Paid, Owned, & Earned
What is SQL?
“Sequel” (Structured Query Language) is a standardized query language used for managing relational databases and performing various operations on the data in the databases.
What are 3 PowerPoint presentation Best Practices that were mentioned during Data Project 1 Presentation feedback?
Ex. Consistent Formatting (font, font size, labels), Sources, Title/Header on every slide, Agenda if relevant, Intuitive Data Visualization
What are 3 things to avoid doing when giving a presentation?
Being Unprepared
Poor Delivery
Bad Presentation Design
Not relating to your audience
Poor Content Prep
Unrealistic Expectations
Other answers that Claudia + Juliana agree on
What are 3 Excel Best Practices to always follow?
1. Renaming tabs to something appropriate
2. All KPI metrics are correctly formatted
3. For charts, add labels for the x-axis, y-axis, title
4. Label rows & columns
4. Consistent formatting throughout the workbook
5. Other answers that Claudia + Juliana agree on
What is Data Analytics?
Data Analytics is the process of examining data sets
in order to draw conclusions about the information they contain, often through the aid of specialized systems and software.
What are the 3 main clauses (or commands) used when writing a SQL query
SELECT, FROM, and WHERE
Name at least 3 of the 5 rules for writing an email (Email 101 lesson)
Subject Line - Concise and specific
Salutation - Appropriate “Hello” with name spelled correctly
Structure - Key point in the first paragraph and use a lot of white space
Signature - Leave updated contact info, Name, number, etc...
Spelling/Grammar
Fill in the blanks (Programmatic 101)
_____ is purchased via ______ using _______
Inventory is purchased via Exchanges using Real Time Bidding
Inventory can also be called ad space
What does VLOOKUP stand for and what does it do?
VLOOKUP = Vertical Lookup
VLOOKUP is a spreadsheet function that helps you find and output information quickly within a table
What are the 3 major reasons Data Analytics is important? (According to our Data Industry 101 lesson)
1. Cost Reduction
2. Faster & Better Decision Making
3. New Products & Services
What is a Google Analytics Primary Dimension vs. Secondary Dimension?
A Primary Dimension is the default dimension applied to a report in GA.
The Secondary Dimension is the second dimension that you apply to a report by clicking 'Secondary Dimension' and selecting from the drop-down menu to filter the data more specifically.
How should every bullet point on your resume tell a story? Hint: (____ → _____ → _____)
Action → Result → Significance (why it mattered to the org, team, or client)
What is Real-Time Bidding?
Real-time bidding refers to the buying and selling of online ad impressions through real-time auctions that occur in the time it takes a webpage to load. Those auctions are often facilitated by ad exchanges or supply-side platforms.
What are Pivot Tables and the names of the 4 sections to categorize fields? (It's those 4 boxes that you drag your fields into in order to form a table)
Pivot Tables are a powerful tool to summarize data that transforms rows and columns into a refreshable, customizable, calculated table
4 sections: Filters, Columns, Rows, Values
Name 2 examples of Structured Data and 2 examples of Unstructured Data (Data Industry 101 lesson)
Structured Data: Spreadsheets, Phone Numbers (phone book), Databases, Library Catalogues (date, author, place, subject, etc.), Census Records (birth, income, employment, place etc.)
Unstructured Data: E-mail, Messages, Word Documents (txt, docx, etc.), Videos, Photos, Audio Files, Webpages and Many Other Kinds of Business Documents
In Tableau, explain Dimensions vs. Measures and their designated colors
Dimensions (always blue) are the categories of things in your data that you want to compare.
Dimensions Contain qualitative values (such as names, dates, or geographical data). You can use dimensions to categorize, segment, and reveal the details in your data.
Measures (always green) are the different metrics you want to use to compare those things.
Measures Contain numeric, quantitative values that you can measure. You can apply calculations to them and aggregate them.
What are the 2 major sections of COOP's interview rubric? Name some qualities that fall under each section
Persona: How you come across
(positive energy, passionate, authenticity, present, personable)
Substance: What you have to say
(preparation, stories, storytelling, knowledge, resume)
What is a DSP, SSP, DMP?
Demand-Side Platform (DSP): software used to buy advertising inventory in an automated fashion
Supply-Side Platform (SSP): software used to sell advertising inventory in an automated fashion
Data Management Platform (DMP): data warehouse used to analyze and target audiences