Certificate Curriculum
12 Credits Total
(BUAN 640) - 3 credits
This course provides students with a basic understanding of the role of statistics in the gathering of data, the creation of information and its use in decision-making. Students will learn methods for summarizing data, both numerically and graphically, and for drawing conclusions from sample data. Statistical analyses will be carried out using the computer and statistical software. The focus of the course is on how statistical methods can be applied to business problems to improve outcomes; stress is placed on the design of statistical studies, collection of data, and the interpretation of results. The course will also focus on interpreting computer output and less on generating numbers through hand calculations.
(BUAN 600) - 3 credits
This course teaches students how to perform data analysis using spreadsheet based methods to effectively and efficiently solve management problems. Students will learn how to effectively build, present and communicate advanced Excel spreadsheet models, forecasting models, optimization models and simulation models to drive managerial decision making. Students will also learn how to build interactive, data driven dashboards using Power BI to discover new insights and monitor key performance indicators.
Prerequisites: NONE
(BUAN 610) - 3 credits
This course will focus on developing the ability to understand the business needs for data insights, crafting those into an analytics problem statement, and developing a coherent and persuasive narrative of any data findings. Students will learn to create well-crafted data narratives and dashboards for business leaders while being able to translate insights into managerial decisions. Students will also be able to prepare raw data sets for their data narratives, executive summaries and technical memos. The Data Narratives course focuses on providing these fundamental data narrative and storytelling abilities while leveraging various tools to assist in the process.
Prerequisites: NONE
(BUAN 620) - 3 credits
This course covers the life cycle of data for analytics from the structure of relational and non-relational data stores, through the extraction, transformation, and loading (ETL) process into the analysis and presentation of data using data dashboards. Students will learn and practice acquiring, extracting, cleaning, and loading data from databases and other data stores. Students will learn to interpret and create data models, write and interpret the results of Structured Query Language (SQL), practice and apply industry ETL tools to solve business problems, and effectively communicate about data through the use of a dashboarding tool.
Prerequisites: NONE