Admission Enquiry:
+91 9829140090 | +91 8529171155
Toll Free: 18005729697
Franchise | Master Franchise :
+91 9829140090 | +91 7742420102

Give a HEAD START to your career with our Job Oriented Programs in Accounting
Digital Marketing Web Development / Data Science
or Salesforce

Data Analyst Training

durationDuration :
3 Months
Study TypeStudy Type :
Full Time
Tuition feesClasses :
On Projector
assignments-img 100% placement
assignments-img Job Oriented
assignments-img Step by step
assignments-img Daily
Go through the Course Module brochure

Introduction to Data Analytics

  • Data Analytics Overview
  • Importance of Data Analytics
  • Benefits of Data Analytics

Excel: Basics to Advanced

  • Excel tutorial
  • Text to Columns , Concatenate Function
  • Absolute Cell References , Data Validation
  • Conditional Formatting , Exploring Styles and Clearing Formatting
  • Using Conditional Formatting to Hide Cells
  • Using the IF Function , Changing the “Value if false” Condition to Text

Excel: Basics to Advanced

  • Pivot Tables
  • Using Slicers , Charting Non-Adjacent Cells
  • Creating a Chart Using the Chart Wizard
  • Chart Types
  • Formatting All Text
  • Exploding a Slice of a Pie Chart
  • Formatting Data with Text Functions
  • Conditional Formatting , Sorting , Filtering
  • Lookup Functions


  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • 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
  • The SET Operators , Data Manipulation Statements
  • Use of DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Retrieve Data Using Sub-queries

Introduction to Power BI

  • Overview: Power BI concepts
  • Upload a local CSV file
  • Connect to Excel data that can be refreshed
  • Connect to a sample

Viz and Tiles

  • Overview: Visualizations
  • Create a new report
  • Format a visualization
  • Use text, map, and gauge visualizations and save a report
  • Use a slicer to filter , Sort, copy, and paste visualizations

Reports and Dashboards

  • Modify and Print a Report
  • Create a Dashboard , Pin a report tile to a dashboard
  • Add a tile to a dashboard
  • Set a Featured (default) dashboard
  • Ask Questions about Your Data

DAX functions

  • New Dax functions , Filter functions
  • Information functions , Logical functions
  • Math & trig functions , Parent and child functions

Python Basics

  • The print statement , Comments
  • Python Data Structures & Data Types
  • String Operations in Python
  • Simple Input & Output
  • Operators in python
  • Finding Your Right Courses

    Request A Call

    Corporate Office

    1st floor, Vasant Vihar,Near Gopalpura Police Chowky, Gopalpura Bypass Jaipur Rajasthan

    Call Us

    +91 9829140090  / 8529171155
    Toll Free: 18005729697

    Email Us

    Need Help?

    Send Us A Message

    Get In Touch

    (Corporate Office) : 36, 1st Floor, Basant Vihar, Opp. Bhandari Hospital, Gopalpura Bypass, Jaipur - 302018

    (Reg. Office) : A-46, Murti Kala Colony, Gopalpura Byepass, Gopalpura, Jaipur - 302018. Rajasthan (INDIA)


    +91 9829140090 / 8529171155


    © TECHNOGLOBE. All Rights Reserved.

    The certification names and logos are the trademarks of their respective owners.