Logo

Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863

MA-2016

Data Analytics Certificate Program

Description

The Data Analytics Certificate program is designed to help business professionals develop their skills with tools for extracting, manipulating, and presenting data.  This knowledge is fundamental for entering the IT field as Data Analysts or Statistical Assistants.

Outline

Excel Level 1 - Foundations

In this course you will learn how to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

Excel Level 2 - Analyzing and Presenting Data

In this course you will get hands on experience with guided labs on how to organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

Excel Level 3 - Advanced Functions and Data Forecasting

In this course you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

Fundamentals of SQL

Many organizations use databases to store their most critical information: the information that manages their day-to-day operations. After the data is stored in databases, however, it is useless unless you can retrieve it for further business analysis. One example of a database management system is Microsoft SQL Server. The language you use to retrieve information from SQL Server databases is the Structured Query Language (SQL). This course, SQL Querying: Fundamentals, will teach you to use SQL as a tool to retrieve the information you need from databases.

Microsoft Power BI: Data Analysis Practitioner

As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.

The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.

Career Services

• Strengths Workshop
• Emotional Intelligence Workshop

PreRequisites

Students should have basic computer skills, access to a computer and internet access. Students should have basic typing skills and be familiar with Microsoft Office – particularly Microsoft Excel.

 

$0.00 List Price


Categories: , ,
Loading ...