XBUS-400 - Data Analytics

Course Description

In this course the student will develop technical analytical skills to support data-driven decision-making. Beginning with the study of SQL and Python, students will learn how to to store, access, and manipulate data in relational databases. Statistical tools will be discussed to understand uncertainties and predictive capabilities of data models in supporting decisions. Visualization techniques will be introduced to understand how the presentation and communication of data provides insight into the analysis and decision making.  The course concludes with a capstone project in which students work in teams to apply the knowledge and skills that are applicable to a real world problem and data set. Capstone projects will be presented on the last day of class.

Minimum Computer Requirements for the Data Analytics Bootcamp:

• Webcam, microphone, and speaker
• Connectivity: A broadband connection
• Browser: The most recent version of Google Chrome, Safari, or Firefox  
• Platform: A computer with at least a 1.6 GHz processor, 4GB of RAM and 20 GB free hard disk space  
• Operating system: Windows 8 or newer, OS X 10.6 or newer, or Ubuntu 12.04 or newer, or the equivalent. OS X and Linux are strongly encouraged.
• A command prompt available (Powershell on Windows, Terminal on OS X or Linux).
• Administrative Rights to install software on your computer
  • IMPORTANT: If you are using your employer's computer to take the Data Analytics Bootcamp, it is likely you may not have administrative rights due to security reasons. It is critical prior to the first day of class you have access to a computer with administrative rights.
  • To determine if you have administrative rights, please read
    • Apple OS - https://support.apple.com/guide/mac-help/asked-administrator-password-mhosxlogo1438/10.15/mac/10.15
    • Wndows - https://www.cnet.com/how-to/how-to-check-if-your-windows-10-account-is-administrator/

Course Objectives

Learning Objectives:

• Explore the programming technologies involved in data analysis and visualization

• Acquire an understanding of how data analysis improves the decision-making process

• Explore the strategic and operational value of using data for decision making.

• Identify data sources and create analytical data sets

• Perform statistical analysis to test the validity of data analysis and decisions

• Demonstrate the ability to clearly communicate analysis results

• Understand ethical considerations in data analysis and decision making

Notes

Minimum Computer Requirements for the Data Analytics Bootcamp:

• Webcam, microphone, and speaker
• Connectivity: A broadband connection
• Browser: The most recent version of Google Chrome, Safari, or Firefox  
• Platform: A computer with at least a 1.6 GHz processor, 4GB of RAM and 20 GB free hard disk space  
• Operating system: Windows 8 or newer, OS X 10.6 or newer, or Ubuntu 12.04 or newer, or the equivalent. OS X and Linux are strongly encouraged.
• A command prompt available (Powershell on Windows, Terminal on OS X or Linux).
• Administrative Rights to install software on your computer
  • IMPORTANT: If you are using your employer's computer to take the Data Analytics Bootcamp, it is likely you may not have administrative rights due to security reasons. It is critical prior to the first day of class you have access to a computer with administrative rights.
  • To determine if you have administrative rights, please read
    • Apple OS - https://support.apple.com/guide/mac-help/asked-administrator-password-mhosxlogo1438/10.15/mac/10.15
    • Wndows - https://www.cnet.com/how-to/how-to-check-if-your-windows-10-account-is-administrator/

Applies Towards the Following Certificates

• Certificate in Data Analytics : Required