SQL
What SQL command is used to retrieve data?
SELECT
Who’s the current VP of BANA club?
Dora
This option uses player statistics, ticket sales, and fan attendance data to make better business decisions. What specialization combines analytics with the sports industry?
Sports Business Option
What does the abbreviation BANA stand for in OSU's course listings?
Business Analytics
This SQL clause filters rows based on a condition, such as selecting only sales greater than $100
WHERE
Who’s the current President of BANA club?
Norah
This option analyzes transaction records to identify unusual expenses, detect potential fraud, and improve the accuracy of its financial statements.
Accounting Option
This course is the introductory course in OSU's Business Analytics core.
BANA 270
This SQL clause sorts query results in ascending or descending order
ORDER BY
Who made the awesome marketing materials?
Zoya
This option wants to understand why employees are leaving, predict turnover, and improve employee satisfaction
People Analytics Options
This course focuses on exploring data and creating visualizations to uncover insights
BANA 372
You want to calculate total revenue for each product category. This clause groups rows so aggregate functions can be applied to each category
GROUP BY
Who takes all our notes?
Adam
This option tracks website traffic, click-through rates, social media engagement, and advertising conversions to determine which online campaigns generate the most sales.
Digital Marketing Analytics
This course combines machine learning with the analysis of text for business applications
BANA 472
You want to show only product categories whose total revenue exceeds $10,000. This clause filters groups after aggregation
HAVING
Who on the board makes all of our cool reels?
Laiba
Before launching a new product, a company studies customer surveys, purchasing habits, and competitor offerings to understand consumer preferences and estimate demand.
Market Research and Consumer Analytics
Name the four required BANA courses in OSU’s Business Analytics core
BANA 270, BANA 371, BANA 372, BANA 472