BUS 2400 - Business Analytics I

4 Credits
Learn the technical and creative skills used by Business Analytics professionals. Develop the technical skills needed through hands-on experience and industry-leading, self-service business intelligence applications such as Alteryx and Tableau and understand and perform technical processes such as ETL (extract, transform, load). Students will complete a data visualization project.

Pre-Requisites BUS 1100

Major Content Areas
Tableau dashboards created from Tableau worksheets 25%

Field types: string, numeric, date, data time, spatial, Boolean. 5%

Tableau worksheets created from Alteryx master datasets. 30%

ETL processes (Extract, Transform, Load). 5%

Alteryx: Blend data from multiple data sources to create “master data sets.” 25%

Best practice dashboard design principles. 5%

Relations database elements: columns, rows, and primary keys. 5%

Learning Outcomes
Create Alteryx Designer workflows utilizing the following Alteryx tools: Browse,Input Data, Output Data, Text Input, Data Cleansing, Filter, Formula, Sample, Select,Sort, Join, Union, Text to Columns, and Summarize.

Utilizing workflow data output from Alteryx, continue data preparation in Tableau to include dimensions, measures, hierarchies, and groups.

Develop Tableau Worksheets which visualize data, including creating the following charts: Scatter Plot, Combined Axis, Dual Axis, Stacked Bar. Also, C4

Perform Tableau Quick Table calculations to analyze data.

Leverage Tableau built-in functions for trend analysis, including sales forecasts and reference lines.

Create calculated fields in Tableau to perform profitability and outlier analysis.

Create dashboards with Tableau which including filters and actions.

Study best-practice dashboard design principles including interactivity for desktop and mobile devices