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.
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.