Data Analytics Professional Certificate

Introduction to Data Analytics

·        Data Analytics Overview

·        Importance of Data Analytics

·        Types of Data Analytics

Excel: Basics to Advanced

·        Excel tutorial

·        Text to Column

·        Concatenate

·        The Concatenate Function

·        The Right Function with Concatenation

·        Absolute Cell References

·        Data Validation

·        Time and Date Calculations

·        Conditional Formatting

·        Using the IF Function

·        Changing the “Value if false” Condition to Text

·        Pivot Tables

·        Creating a Pivot Table

·        Specifying PivotTable Data

·        Changing a PivotTables Calculation

·        Filtering and sorting a PivotTable

·        Creating a PivotChart

·        Grouping Items

·        Updating a PivotTable

·        Formatting a PivotTable

·        Using Slicers

·        Charts

·        Creating a Simple Chart

·        Modifying Charts

·        Moving an Embedded Chart

·        Sizing an Embedded Chart

·        Changing the Chart Type

·        Chart Types

·        Changing the Way Data is Displayed

·        Moving the Legend

·        Conditional Formatting

·        Sorting

·        Filtering

·        Lookup Functions

·          

SQL

·        Introduction to Oracle Database

·        Retrieve Data using the SQL SELECT Statement

·        Learn to Restrict and Sort Data

·        Usage of Single-Row Functions to Customize Output

·        Invoke Conversion Functions and Conditional Expressions

·        Aggregate Data Using the Group Functions

·        Display Data from Multiple Tables Using Joins

·        Use Sub-Queries to Solve Queries

·        The SET Operators

·        Data Manipulation Statements

·        Use of DDL Statements to Create and Manage Tables

·        Other Schema Objects

·        Control User Access

·        Management of Schema Objects

·        Manage Objects with Data Dictionary Views

Python Basics

·        The print statement

·        Comments

·        Python Data Structures & Data Types

·        String Operations in Python

·        Simple Input & Output

Send Inquiry