Data Analytics   

Data analysis is rapidly becoming one of the most in-demand skills in the workplace. While companies gather vast amounts of data, few have the expertise to analyze it effectively to identify trends and make informed predictions. By acquiring data analysis skills, you can add a valuable skill set to your portfolio and significantly contribute to the success of your organization.
Course Overview:

Start by gaining a solid understanding of how to analyze data in a business context, learning the fundamental techniques used to uncover insights. You’ll explore how to compare groups to identify differences and relationships, with a focus on the statistical methods behind these comparisons. Finally, you'll learn how to conduct inquiries that will provide actionable insights for your business, and how to communicate your findings effectively through graphs and written reports that are clear and understandable to colleagues.

Whether you work for a small home-based business or a large corporation, this certificate will elevate your ability to make data-driven decisions that impact your organization’s success.

Course Requirements:

Students must have Microsoft Excel to complete this certificate.

Course Sequence:

1. Introduction
2. Intermediate
3. Advanced

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free.

Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time.

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results.

This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions.

This Certificate must be taken in the following order:

1. Introduction
2. Intermediate
3. Advanced

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst.

You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables.  You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.

Requirements:

- Windows 10 or later. Macs are not compatible.

- Necessary rights (local administrative rights) to install programs on the computer.

This Certificate must be taken in the following order:

- Introduction

- Intermediate

- Advanced

Improve your decision making success with an advanced practical how-to process for gathering statistics. Help your organization design effective surveys to improve business and workplace effectiveness.

Then road test evaluation research for your organization. You won’t be disappointed. Finally, discover the features of action research and how it can be directly applied to answer questions and solve problems in collaboration with others in your specific professional context.

Come away with the ability to develop an action research plan to partner with your key stakeholders to collect data, analyze data, and make better decisions.