BA 201 Applied Business Analytics

Introduces the fundamentals of business and data analytics. Covers relational database fundamentals and Structured Query Language (SQL) programming skills in the Microsoft environment. Includes topics such as relational database architecture, database design techniques, data retrieval, data integrity, and simple and complex query skills. Explores the topics of data analytic thinking and its applicability to the business world. This course is intended for students new to the SQL programming language.

Credits

4

Prerequisite

Prerequisite: BA 101B Spreadsheet Analysis with a grade of C or better.

Notes

Career Technical Education (CTE) Course

Outcomes

Upon successful completion of this course, students will be able to:
Apply database analytics and relational data sets when given raw data. Apply SQL query to retrieve relational database data. Initiate a Microsoft Excel Power Query to simplify the process of importing data from different source files. Demonstrate interactive visualizations and business intelligence using Microsoft BI software. Extract data from different systems to be able to accomplish entry level analysis.