NetTechIndia

IT Certification | Software, Hardware & Networking Courses Institute

Post Graduate Certification Program in Data Analytics

download-pdf

Request for Demo Lecture

    DATA ANALYTICS:

    Data analytics is the procedure of looking at data sets to identify trends and create inferences about the knowledge they contain. Data analytics is increasingly carried out with the use of specialist hardware and software. In order to support businesses make better business decisions, data analytics technologies and methodologies are extensively used in commercial sectors. Analytics tools are also used by scientists and researchers to support or refute scientific models, hypotheses and theories.

    Topics:

    • Python
    • SQL
    • Tableau
    • Power Bi
    • Advanced Excel
    • AWS

    PYTHON

    SQL

    Tableau

    • Introduction to

    • Python

    • Python Interpreter

    • Basics of Python

    • Control Flow

    • Functions

    • Modules

    • Package

    • Numeric Types

    • String

    • List

    • Tuple

    • Dictionary

    • Set

    • Files

     

         And Many More…

    • 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

     

    And Many More…

    • Tableau And Data Visualization

    • Tableau And Data Connections

    • Data Organization
      Advanced Data

    • Preparation And Analytics In Tableau

    • Dashboards And Work Sharing

       

      And Many More…

    Power Bi

    Advanced Excel

    AWS

    • Power BI Complete Introduction

    • PBI Desktop Installation, PBI Desktop & Service Overview

    • Module 1: Power Query

    • Introduction to Power Query – Extract, Transform & Load

    • Module 2: Power Pivot

    • Power BI Data Modeling – Relationship View

    • Module 3: Power View

    • Report View / Power View

    • Module 4: Power BI Service

    • Power BI Service Introduction

      And Many More…

    • Multiple Level Subtotal Reports

    • Filtering Database & Sorting Data

    • Securing & Protecting Worksheet

    • Linking Multiple Sheets

    • 3D Reference in Excel

    • Sheet Referencing

    • Dynamic Linking Word/Excel/Power point

    • Function H lookup V lookup Lookup

    • X Lookup Dynamic H lookup V lookup

    • COUNTIF, SUMIF, SUMIFS

     

    And Many More…

    • Introduction to AWS

    • Amazon Simple Storage Service (Amazon S3) and Amazon Glacier Storage

    • AWS Identity and Access Management (IAM)

    • Amazon Elastic Compute Cloud (Amazon EC2) and Amazon Elastic Block

    • Amazon Virtual Private Cloud (Amazon VPC)

    • Network Address Translation (NAT) Instances and NAT Gateways


      And Many More…