What is Data Analyst?

A data analyst is a professional who collects, organizes, interprets, and presents data to help organizations make informed decisions. Data analysts work with large sets of data from various sources, such as databases, spreadsheets, or software applications, and use statistical techniques and analytical tools to extract meaningful insights.

Data analysts play a crucial role in various industries, including finance, marketing, healthcare, e-commerce, and technology. They help businesses identify trends, optimize processes, improve performance, and make data-driven decisions. Strong analytical skills, proficiency in data analysis tools, and a solid understanding of statistical concepts are essential for a successful career as a data analyst.

Who can be Data Analyst?

• Software IT Professionals
• Non-IT Professionals
• Fresher
• Sales & Marketing Professionals
• Banking Professionals
• Anyone having passion for problem-solving and an interest in the intersection of business, Data, Math’s and technology

Data Analytics: Career Scope

02-04 Years          7.7 – 9.8 L

05-07 Years       11 – 13 L

08-09 Years       14 – 18 L

Please note that these figures are just approximate and can vary based on the factors mentioned above. Additionally, salaries can also vary based on the city and region the job is located in.

Source https://www.ambitionbox.com/profile/senior-data-analyst-salary?experience=9&department=data-science-analytics

About Us

• Affiliation with multiple Certification Board
• 9 Years old Edu-Tech Institution
• Served/Serving 10+ Corporates
• Trained Professionals from 20+ Countries
• 300+ Professionals Trained as Business Analysts
• 300+ Professionals Trained in AWS + DevOps
• 400+ Agile Certified Professionals
• 4.8 Rating by 600+ Professionals on Google
• 2000+ Professionals Trained in Automation
• 2,800+ (99.8%) Passed ISTQB Professionals
• 5,800+ Professionals Trained
• 11,000+ Hours of Training
• 1,00,000+ Professionals Network
• 1,50,000+ Jobs Shared

Mode of Teaching

Class Execution

Course Content

• Class Availability: Weekend/Weekdays
• Mode: Online Trainer Led
• Duration: 90 Days

Business Statistics

Introduction to Statistical Analysis

• Counting, Probability, and Probability Distributions
• Sampling Distributions
• Estimation and Hypothesis Testing
• Scatter Diagram
• Anova and Chisquare
• Imputation Techniques
• Data Cleaning
• Correlation and Regression

 Introduction to Data Analytics

• Data Analytics Overview
• Importance of Data Analytics
• Types of Data Analytics
• Descriptive Analytics
• Diagnostic Analytics
• Predictive Analytics
• Prescriptive Analytics
• Benefits of Data Analytics
• Data Visualization for Decision Making
• Data Types, Measure Of central tendency, Measures of Dispersion
• Graphical Techniques, Skewness & Kurtosis, Box Plot Descriptive Stats
• Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval

Excel: Basic to Advanced

• Excel tutorial
• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function with Concatenation
• Absolute Cell References
• Data Validation
• Time and Date Calculations
• 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
• 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
• Charting Non-Adjacent Cells
• Creating a Chart Using the Chart Wizard
• 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
• Formatting Charts
• Adding Chart Items
• Formatting All Text
• Formatting and Aligning Numbers
• Formatting the Plot Area
• Formatting Data Markers
• Pie Charts
• Creating a Pie Chart
• Moving the Pie Chart to its Own Sheet
• Adding Data Labels
• Exploding a Slice of a Pie Chart

Data Analysis – Overview

• Types of Data Analysis
• Data Analysis Process
• Working with Range Names
• Copying Name using Formula Autocomplete
• Range Name Syntax Rules
• Creating Range Names
• Creating Names for Constants
• Managing Names
• Scope of a Name
• Editing Names
• Applying Names
• Using Names in a Formula
• Viewing Names in a Workbook
• Copying Formulas with Names
• Difference between Tables and Ranges
• Create Table
• Table Name
• Managing Names in a Table
• Table Headers replacing Column Letters
• Propagation of a Formula in a Table
• Resize Table
• Remove Duplicates
• Convert to Range
• Table Style Options
• Table Styles
• Cleaning Data with Text Functions
• Removing Unwanted Characters from Text
• Extracting Data Values from Text
• Formatting Data with Text Functions
• Date Formats
• Conditional Formatting
• Sorting
• Filtering
• Lookup Functions
• Pivoting

Tableau

Module 1: Tableau Course Material

• Start Page
• Show Me
• Connecting to Excel Files
• Connecting to Text Files
• Connect to Microsoft SQL Server
• Connecting to Microsoft Analysis Services
• Creating and Removing Hierarchies
• Bins
• Joining Tables
• Data Blending

Module 2: Learn Tableau Basic Reports

• Parameters
• Grouping Example 1
• Grouping Example 2
• Edit Groups
• Set
• Combined Sets
• Creating a First Report
• Data Labels
• Create Folders
• Sorting Data
• Add Totals, Sub Totals and Grand Totals to Report

Module 3: Learn Tableau Charts

• Area Chart
• Bar Chart
• Box Plot
• Bubble Chart
• Bump Chart
• Bullet Graph
• Circle Views
• Dual Combination Chart
• Dual Lines Chart
• Funnel Chart
• Traditional Funnel Charts
• Gantt Chart
• Grouped Bar or Side by Side Bars Chart
• Heatmap
• Highlight Table
• Histogram
• Cumulative Histogram
• Line Chart
• Lollipop Chart
• Pareto Chart
• Pie Chart
• Scatter Plot
• Stacked Bar Chart
• Text Labe
• Tree Map
• Word Cloud
• Waterfall Chart

Module 4: Learn Tableau Advanced Reports

• Dual Axis Reports
• Blended Axis
• Individual Axis
• Add Reference Lines
• Reference Bands
• Reference Distributions
• Basic Maps
• Symbol Map
• Use Google Maps
• Mapbox Maps as a Background Map
• WMS Server Map as a Background Map

Module 5: Learn Tableau Calculations & Filters

• Calculated Fields
• Basic Approach to Calculate Rank
• Advanced Approach to Calculate Ra
• Calculating Running Total
• Filters Introduction
• Quick Filters
• Filters on Dimensions
• Conditional Filters
• Top and Bottom Filters
• Filters on Measures
• Context Filters
• Slicing Filters
• Data Source Filters
• Extract Filters

Module 6: Learn Tableau Dashboards

• Create a Dashboard
• Format Dashboard Layout
• Create a Device Preview of a DashboardCreate Filters on Dashboard
• Dashboard Objects
• Create a Story

Module 7: Server

• Tableau online
• Overview of Tableau Server
• Publishing Tableau objects and scheduling/subscription

SQL

Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browse.

Course Objectives Learn about SQL – Structured Query Language

• Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures and Functions stored in database.
• Write and manage database triggers, cursors and Index.

Pre-requisite / Target Audience This SQL server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.

Module 1 Introduction to Basic Database Concepts

In this module we learn about Basic concepts and advantages of DBMS and limitations of file management system and also about 3 data base models.

• What is Data, Field, Record and database?
• Limitations of File Management System.
• Basic Concepts of Advantages of DBMS.
• Exploring Relational DBMS.
• Understanding Client and Server

Module 2 E-R Modelling and Diagram

In this module we learn about entity, attributes and relationship, identify the entities and attributes How to draw a E-R diagram and translating the E-R diagram in relation schema.

• Analyzing the Requirement.
• Identify Entities and their Relationships.
• Drawing E-R Diagram.
• Conversion of E.R. Diagrams into Tables.

Module 3 Normalization

In this module we learn about what is normalization, types of normalization, data before and after normalization, benefits of normalization.

• First Normal Form
• Second Normal Form
• Third Normal Form Practically Normalizing Tables

Module 4 Introduction to SQL Server

In this module we learn about SQL Server, history of SQL server, types of system databases, communication between frontend and backend and SQL server editions.

• What is SQL Server Version history and different editions.
• Basic Features Components and Tools.
• Starting and Stopping SQL Server Instances / Services.
• Introduction to Management Studio.
• Types of System Databases in SQL.

Module 5 Introduction to SQL

In this module we learn about types of SQL statements, databases in SQL server, how to create a database, data types in SQL server, and about DDL Statements.

• Basics of SQL Types of SQL Statements.
• DDL, DML, DQL, DCL and TCL.
• Create Database using Management Studio.
• Data types in SQL Server.
• Exploring DDL Statements on Table using Management Studio.

Module 6 DDL and DML Statements

In this module, we learn about how to create a table, alter and drop a table, and about DML statements, like insert update and delete statements.

• Why write statements in Frontends?
• Create, Alter and Drop Table Insert.
• Update and Delete Statement Truncate Statement.

Module 7 Working with Queries (DQL)

In this module we learn about select statement, top, distinct string and arithmetic expressions, Sorting the data and about sub queries and where clause (condition).

• Understanding Select Statement
• Usage of Top, Distinct, Null etc…keywords
• Using String and Arithmetic Expressions
• Exploring Where Clause with Operators
• Using Advanced Operators
• Sorting data using Order By clause
• Working with basic of Sub Queries

Module 8 Aggregate Functions

In this module we learn about how to use aggregate functions like sum, mean, max, what is difference between having and where clause, group by clause rollup and cube operator.

• Using functions in Queries
• Using Predefined functions
• Count, Sum, Min, Max, Avg Group By and Having Clause
• Using Group By with Rollup and Cube

Module 9 Joins and Set Operations

In this module we will know about joins and types of joins how to join the tables and about Sub queries, types of operators like union, intersect and except and how to add the tables and relationship between them.

• Introduction to Joins Cross Joins
• Inner Join
• Outer Join
• Self Join
• Co-related Sub Queries
• Set Operations using Unions, Intersect and Except

Module 10 Working with Constraints

In this module, we will learn about how to create a constraint, types of constraints, and difference between unique, not null and primary key constraints.

• Unique
• Not NULL
• Primary Key
• Default check foreign key

Module 11 Implementing Views

In this module, how to create a view, advantages of views, altering and dropping a view and advanced options while creating a view.

• Introduction & Advantages of Views
• Creating, Altering, Dropping Views
• Advance Options while Creating a View
• SQL Server Catalogue Views

Module 12 Data Control language (DCL)

In this module, we will learn how to grant permission and revoking of roles.

• Creating Users & Roles
• Granting & Revoking of Roles & privileges
• Managing using Management Studio

Module 13 Working with Indexes

In this module, how to create a index, advantages and disadvantages of index, and types of index and dropping index, and also about index structure.

• Introduction Clustered and Non Clustered Index
• Creating and Dropping Indexes

Module 14 Writing Transact-SQL (T-SQL)

In this module, what is script and what is batches, variables and if else statements and working with temporary tables, and checking with the existence of database objects.

• What is T-SQL?
• Scripts and Batches Declaring Variables
• Using Statements
• Working with Temp tables
• Error Handling
• Using System Functions / Global Variables Using Dynamic SQL

 Module 15 Working with Stored Procedures and Functions

In this module, we will learn how to create a stored procedure and the difference between stored procedure and table, advantages of procedures and about types of parameters.

• Introduction to stored procedures
• Benefits of Stored Procedures
• Creating, Executing Modifying, Dropping
• Input–Output and Optional Parameters
• System defined SP’s and Functions.
• User defined Functions

Module 16 Implementing Triggers

In this module, we will learn about what is trigger and how to create a trigger, types of triggers How to use a rollback tran.

• Introduction to triggers
• Constraints/Triggers
• Creating, Altering, Dropping triggers
• for/after/instead of triggers
• Using Rollback Tran

Module 17 Working with Cursors

In this module, how to create a cursor, what is cursor, types of cursor and benefits of cursor.

• Creating Cursors
• Cursors vs. Select
• Types of cursors
• Locks on cursors
• Advantages of cursors

Module 18 Transaction Control Language (TCL)

In this module, we will learn what is transaction, transaction management and what are acid properties, what are isolation levels and about implicit and explicit transactions.

• Introduction Transactions process
• Types of transactions (Implicit, explicit)
• Working with Locks, Types of locks

Module 19 Backup and Restore

In this module, how to backup database and how to restore a database and how to generate a SQL script, and executing a SQL script and how to attach and de attach a database.

• Generating SQL Script
• Executing SQL Script
• Generating Change Script
• Taking database Backup
• Restoring database using backup
• Attaching and Detaching of database

Module 20 Advance Features

In this module we will learn about ranking functions and about how to use xml data type.

• Pivot Table
• Common Table Expression
• Ranking Functions Using BLOB data type
• Using XML data type

Power BI

Module 1 Introduction to Power BI

• Get Started with Power BI
• Overview: Power BI concepts
• Sign up for Power BI
• Overview: Power BI data sources
• Connect to a SaaS solution
• Upload a local CSV file
• Connect to Excel data that can be refreshed
• Connect to a sample
• Create a Report with Visualizations
• Explore the Power BI portal

Module 2 Viz and Tiles

• Overview: Visualizations
• Using visualizations
• Create a new report
• Create and arrange visualizations
• Format a visualization
• Create chart visualizations
• Use text, map, and gauge visualizations and save a report
• Use a slicer to filter visualizations
• Sort, copy, and paste visualizations
• Download and use a custom visual from the gallery

Module 3: Reports and Dashboards

• Modify and Print a Report
• Rename and delete report pages
• Add a filter to a page or report
• Set visualization interactions
• Print a report page
• Send a report to PowerPoint
• Create a Dashboard
• Create and manage dashboards
• Pin a report tile to a dashboard
• Pin a live report page to a dashboard
• Pin a tile from another dashboard
• Pin an Excel element to a dashboard
• Manage pinned elements in Excel
• Add a tile to a dashboard
• Build a dashboard with Quick Insights
• Set a Featured (default) dashboard
• Ask Questions about Your Data
• Ask a question with Power BI Q&A
• Tweak your dataset for Q&A
• Enable Cortana for Power BI

Module 4: Publishing Workbooks and Workspace

• Share Data with Colleagues and Others
• Publish a report to the web
• Manage published reports
• Share a dashboard
• Create an app workspace and add users
• Use an app workspace
• Publish an app
• Create a QR code to share a tile
• Embed a report in SharePoint Online

Module 5: Other Power BI Components and Table Relationship

• Use Power BI Mobile Apps
• Get Power BI for mobile
• View reports and dashboards in the iPad app
• Use workspaces in the mobile app
• Sharing from Power BI Mobile
• Use Power BI Desktop
• Install and launch Power BI Desktop
• Get data
• Reduce data
• Transform data
• Relate tables
• Get Power BI Desktop data with the Power BI service
• Export a report from Power BI service to Desktop

Module 6 DAX functions

• New Dax functions
• Date and time functions
• Time intelligence functions
• Filter functions
• Information functions
• Logical functions
• Math & trig functions
• Parent and child functions
• Text functions

Python Basics

• The print statement
• Comments
• Python Data Structures & Data Types
• String Operations in Python
• Simple Input & Output
• Simple Output Formatting
• Deep copy
• Shallow copy
• Operators in python

Additional   

• Hands-on-lab
• Study Materials
• Real-time examples
• Live projects practice
• 100% Job Placement/100% Placement Assistance
• Mock Interviews
• Resume Preparation
• WhatsApp Job Support Group
• Dedicated Staff during the training program
• Life Time Classroom Recorded Sessions
• Course Completion Certificate (Recognized in Organization)
• Letter of Recommendations
• Guaranteed Internship

Testimonials