WPC 300 Exam 1 Business Analytics 2026 – 90 Questions on ETL, SQL, A/B Testing & Data Analysis Exam

This document contains approximately 90 exam-style questions with verified answers based on business analytics, database management, and data-driven decision-making concepts, aligned with Bulletproof Problem Solving by Charles Conn & Robert McLean and foundational data analytics coursework. It provides comprehensive coverage of analytics frameworks, ETL processes, SQL queries, experimental design, and Excel-based data manipulation. The content is structured in a clear Q&A format to support both conceptual understanding and exam-focused preparation. As shown in the document (page 1), foundational topics include key cognitive biases such as anchoring bias (over-reliance on initial information) and gambler’s fallacy, along with distinctions in data types such as secondary data sources. Early sections (pages 2–4) focus on analytics frameworks including descriptive, predictive, and prescriptive analytics, as well as agile analytics processes (starting with business discovery). The document also covers database fundamentals such as referential integrity, entity-relationship modeling (e.g., traveler as an entity), and SQL operations like SELECT and INNER JOIN. Mid-sections (pages 4–7) emphasize practical tools and techniques including Excel functions (CONCATENATE, SUMIF, TRIM, RANDBETWEEN), ETL processes (extract, transform, load), and data warehousing concepts. For example, page 6 highlights data transformation practices such as splitting and aggregating data, while page 7 explains ETL architecture requirements like data integration and security. Later sections (pages 8–10) cover experimental design and statistical reasoning, including A/B testing, double-blind experiments, confounders, spurious correlations, and sampling methods, ensuring strong alignment with real WPC 300 Exam 1 expectations. This resource is ideal for students enrolled in WPC 300 or similar Business Analytics and Data Analysis courses. It is suitable for courses such as Business Analytics, Database Management, Data Science Fundamentals, and Decision Analytics. Additionally, it benefits business students, analysts, and professionals seeking to strengthen their skills in SQL, ETL processes, experimentation, and data-driven decision-making for exams and real-world applications. Keywords: WPC 300 exam 1 questions, business analytics fundamentals, ETL extract transform load process, SQL select inner join queries, referential integrity database, descriptive predictive prescriptive analytics, A B testing experimental design, confounder spurious correlation, excel functions concatenate sumif trim randbetween, data warehouse ETL architecture, agile analytics business discovery, anchoring bias sunk cost fallacy, database entity relationship model, OLAP decision support systems, data cleaning parsing matching