Data Analytics Courses

Rated Among the Top 10 Data Analytics

 

Data Analytics Training in Bangalore Offered by Prakalpana is the most powerful Data Analytics Training ever offered with Top Quality Trainers, Best Price, Certification, and 24/7 Customer Care. 

 

Learn Virtually Anywhere. Get Started Prakalpana Online Training Now!

Learn Virtually Anywhere.

 Get High-Quality Training, Certification, Best Price and 24/7 Customer Care.  

Success Factors of Data Analytics :

  • High-Quality  Training
  • Top 10+ years of Technical Trainers
  • Comprehensive Course Curriculum
  • 100% Placement Assistance
  • Superb Satisfaction Score
  • Internship in Real-Time Project 

About Program

The Data Analytics Course covers technologies like Excel, Advanced Excel, Tableau, SQL, Power BI, Basics of R & Python. Apart from the theory classes, there are hands-on assignments and projects that help you apply the concepts that are learnt by a student.

Drop Us a Query!





    Curriculum of Data Analytics course

    1. Excel: Basics to Advanced
    2. SQL
    3. Tableau
    4. Power BI
    5. R Basics
    6. Python Basics

    • Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
    • Introduction to Hypothesis Testing
    • Hypothesis Testing (2 proportion test, 2 t sample t test)
    • Anova and Chisquare
    • Data Cleaning
    • Imputation Techniques
    • Scatter Diagram
    • Correlation Analysis

    An overview of the screen, navigation and basic spreadsheet concepts
    • Customizing the Ribbon
    • Worksheets
    • Format Cells
    • Various selection techniques
    • Shortcuts Keys
    • Protecting and un-protecting worksheets

    • Sorting tables
    • Using multiple-level sorting
    • Using custom sorting
    • Filtering data for selected view (AutoFilter)
    • Using advanced filter options

    • Specifying a valid range of values for a cell
    • Specifying a list of valid values for a cell
    • Specifying custom validations based on formula for a cell

    • Upper, Lower, Proper
    • Left, Mid, Right
    • Trim, Len, Exact
    • Concatenate

    • Basic Function –Sum, Average, Max, Min, Count, Count A
    • Conditional Formatting
    • Logical functions (AND, OR, NOT)
    • Lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
    • V-lookup with Exact Match, Approximate Match
    • Nested V-lookup with Exact Match
    • V-lookup with Tables, Dynamic Ranges
    • Nested V-V-lookup with Exact Match
    • Using V-lookup to consolidate Data from Multiple Sheets
    • Mathematical Functions
    • SumIf, CountIf, AverageIf etc
    • Date & Time Function

    • Creating Simple Pivot Tables
    • Basic and Advanced value field setting
    • Grouping Based on number and Dates
    • Calculated field and Calculated items

    • Using Charts
    • Formatting Charts
    • Using 3D Graphs
    • Using Bar and Line Chart together
    • Using Secondary Axis in Graphs
    • Sharing Charts with PowerPoint / MS Word, Dynamically

    • Designing the structure of a template
    • Using templates for standardization of worksheets

    • Introduction to VBA
    • What is VBA ?
    • What can you do with VBA ?
    • What can you do with VBA ?
    • Procedures and Function in VBA

    • What is Variables ?
    • Using Non-declared variables
    • Variable Data Types

    • Customize Message-Box and Input-box
    • Reading cell values into messages
    • Various button groups in VBA

    • If and Select statement
    • Looping in VBA
    • Mail Function –send automated email
    • Automated report will be shown

    • Databases
    • Introduction to DBMS
    • Popular DBMS Software
    • Concepts of RDBMS
    o Tables
    o Tuples
    o Attributes
    • Normalization
    o First Normal Form
    o Second Normal Form
    o Third Normal Form
    • NoSQL Databases
    o Types of NOSQL
    • Comparision

    • Types of SQL Commands
    • Data Definition Language
    o Create, Drop, Truncate, Alter and Rename Objects
    • Data Query Language
    o Select Statements
    • Data Manipulation Language
    • DCL and TCL
    o Grant, Revoke and transaction statements
    • SQL Data Types
    o Numeric, Date and TIme, LOB Types
    • DML Commands
    o Insert, Update and Delete Statements
    • DDL Commands
    o Create and Drop Databases

    • Types of Constraints
    o Relational Integrity Constraints
    o Key Constraints
    o Domain Constraints
    o Referential Integrity
    • Types Of Constraints
    o Primary and Foreign Keys
    o Application of Indexes
    o Checking Constraints
    • Alter Tables

    • SQL Transactions
    o Examples
    • ACID Properties
    • TCL Statements
    o Start, Commit and Rollback Statements
    • Auto Commit
    • SavePoints
    o Identifier
    o Rollback and Release

    • Tables
    o Creating, Altering and dropping tables
    • Sequences
    o Auto Increments
    o Re-Sequencing
    • Views
    o Advantages
    o Creating and Dropping Views
    • Indexes
    o Types of Indexes
    o B-Tree and Hash Indexes
    o Creating and dropping Indexes

    • Stored Objects
    o Types of Stored Objects
    • Stored Procedures
    o Create, call and drop stored procedures
    o Using Variables
    o Handling Exceptions
    o Named Errors and Resignals
    • Programming
    o If-then-Else and Case Statements
    o Loops
    o Repeat and Leave Statements
    o Cursors
    • Operators and Functions
    • Joining Tables
    o Inner Join, Left Join, Right join
    • Advantages of Procedures

    • Triggers
    o Database Triggers
    o Data Definition Language (DDL) Triggers
    o Data Manipulation Language (DML) Triggers
    o CLR Triggers
    o Logon Triggers
    o Triggers v/s Stored Procedures
    • Accessing Database from R
    o Install R Packages
    o Configuration Information
    • Python Database Access
    o Databases Supported
    o Libraries
    o Read Operations
    o Insert, Update and Delete
    o Performing Transactions
    o Handling Errors

    • Advantages & Disadvantages of visualizations

    • Why Data visualization Important
    • Understanding data
    • Examples of Data visualizations in Action
    • Different data visualizations

    • Design Principles
    • Best Practices
    • Data Viz Inspiration

    • What is Tableau
    • Overview Of Tableau Tool(Servers , data , visualizations)
    • Tableau Architecture
    • Advantages & Disadvantages

    • Tableau Desktop
    • Tableau Public
    • Tableau Prep
    • Tableau Online
    • Tableau Server
    • Tableau Analytics

    • Tableau Workbook
    • Tableau Data Source
    • Tableau Data Extract
    • Tableau Packaged Workbook (TWBX)
    • Tableau Packaged Data Source (TDSX)
    • Tableau Book Mark
    • Tableau Map Source
    • Tableau Preferences

    • Connecting to Data from servers
    • Connecting Data from ODBC
    • Connecting data from local repositories

    • What are Joins in Tableau
    • Types Of Joins in Tableau
    o Inner Join
    o Left Join
    o Right Join
    o Full Outer Join
    o Union
    • Creating Joins Using Data

    • Dimensions
    • Measures
    • Parameters
    • Sets

    • Basic Charts
    • Text Tables
    • Highlight Tables
    • Bar charts
    • Stacked Bar
    • Line Graphs
    • Dual axis
    • Pie chart etc.

    • Symbol Maps
    • Filled maps
    • Combined maps
    • Map layers
    • WMS
    • Polygon Maps
    • Custom coding etc.

    • Actual Profit vs Budget Profit Analysis
    • Market wide Analysis etc

    • Correlation Analysis
    • Direction of Relationship
    • Strength of Relationship etc.

    • Distributive Analysis, Bin Sizes, Custom bin sizing etc.

    Distributive Analysis, Quartile Analysis, 5 Point Chart Analysis

    • Understanding of data types, discussing about dimensions and measures etc.

    • Attribute functions
    • Quick table calculations
    • Creation of calculated fields
    • Aggregate and disaggregate functions etc.

    • Understanding If-else statements, applications of if-else statements (eg: high profit , low profit etc.)

    • Understanding Case Statements with examples
    • Applications of case statements

    • Creation of ZN functions
    • Application of ZN functions
    • Dealing with calculated fields etc.

    • Calculations using parameters
    • Sets
    • Filters etcand applications

    • Understanding different string functions etc.
    • Forecasting ,LOD Expressions , Functions, Groups, Filters, etc
    • Dashboards Hands-On in Tableau

    • Understanding concept of Dashboards
    • Building Interactive dashboards
    • Dashboard actions, etc.

    What is R?
    • R software, installation , R studio , Understanding basic interface of R .
    Connecting Tableau with R
    • Rservepackage, using functions such as SCRIPT_REAL etc, Understanding with examples.
    How to integrate Tableau with R?
    • Rservepackage, external connections, ports, Understanding with examples.

    • Introduction of R
    • Data Types
    • Data Structures
    • Decision Making Statements
    • Conditional Loops
    • Flow Control Statements
    • If Statements
    • For loops
    • While Loops
    • Built Functions in R : Base, datasets, dplyrand ggplot

     

    Introduction to Python
    • Introduction to Python & Data Science Python Installation on laptops
    • Python Basics -Variables -Python Build in functions -Modules -Python Libraries installation using PIP
    • Python Basics -Python Operators
    • Python Basics -Flow Control Statements -If Statements -While Loops
    • Python Basics -Data & time modules in python -Interfaces in Python -For Loops
    Python modules for Data Analysis
    • Python Basics -Webscrapping-Python custom functions -Lambda Function -Regular Expressions
    • Data science Life cycle -NumpyModule
    • Data science Life cycle -PandsModule
    • Data science Life cycle -MatplolibModule

     

    Introduction
    • Introduction to PowerBIPreview
    • Download the Training Data Files
    • Introduction to Signing Up for Power
    • Signing up for PowerBIPreview
    • Load Data into the Power BI Service Preview
    • Practical Activity
    The Power BI Desktop
    • Intro to PowerBIDesktop Section
    • Introduction to the Power BI Desktop Preview
    Creating Reports in Power BI Desktop
    • Create Reports in Power BI Desktop Section
    • Creating Tables in Power BI
    • Table Styles and Formatting Preview
    • Matrix Visualization 06:11
    • Tables and Metrics Practical Activity
    • Answers to Tables and Metrics Practical Activity
    • Changing the Method of Aggregation
    • Methods of Aggregation Challenge
    • Methods of Aggregation Challenge Completed
    • Cards and Multi Row Cards
    • Cards, Matrix and Multi Row Card Challenge
    • Answers to Cards Challenge
    • Percentage Calculations
    • Filtering Data -Using Slicers
    • Filtering Data -Visual Filters
    • Filtering Data -Page Filters
    • Filtering Data -DrillThrough Filter
    • Practical Activity -Filters
    • Practical Activity Filters Completed
    Graphs and Visualizations
    • Introduction to Visualization Section
    • Clustered Column Graphs
    • Stacked and 100% Graphs
    • Column Graph Challenge
    • Column Graph Challenge Completed
    • Graph Options
    • Trend Analysis Graphs
    • Area Graphs
    • Ribbon Graphs
    • Additional Graphs
    • Scatterplots and Bubble
    Interactive Dashboards
    • Creating Interactive Dashboards
    • Challenge -Create an Interactive Report
    • Completed Challenge -How to Create an Interactive Report
    • Publishing Reports to the Power BI Service
    • Pinning Visualizations to Dashboards
    • Mobile Reports
    • Q and A
    • App Workspaces
    • Publishing an App
    • Using Themes in Power BI
    • Using Custom Visualizations
    DAX Formulas
    • DAX Formulas Section
    • DAX Formulas
    • Date Functions
    • Formatting Dates
    • Date Master Tables
    DAX Measures
    • Introduction to Measures Section
    • Introduction to DAX Measures
    • DAX Measures Practical Activity
    • DAX Measures Activity Completed
    • The =Calculate Formula
    Relationships
    • Relationships Section
    • Creating and Managing Relationships in Power BI
    • Relationship Calculations
    Power BI Query Editor
    • Introduction to Power BI Query Editor
    • Basic Transformations -Part 1
    • Basic Transformations -Part 2
    • Aggregating Data

    Reviews

    Priyanka HS
    Priyanka HS
    Read More
    I've been here for SpringBoot & Microservices course. Tutors are professional with in-depth knowledge, using simple examples and making it easy to understand. Course work is scheduled in such a way it includes much of assignments. I got zero knowledge on programming when i started, But now I'm able to code. I would recommend it to anyone.
    Vikash Kumar
    Vikash Kumar
    Read More
    I have been Learning Docker & Kubernetes course. My trainer taught me very in-depth hands on using simple examples and making it easy to understand. It help me to grab job in very good MNC.
    Habeeba Taj
    Habeeba Taj
    Read More
    Thank u so much for your very valuable training and Prakalpana support team also helped me lot answering all of my question the instructor also very excellent.

    FAQ's

    Data Analytics is one of the accelerating and most promising fields, considering all the technologies available in the IT market today. In order to take advantage of these opportunities, you need a structured Data Analytics Training Course with the latest curriculum as per current industry requirements and best practices.

    Besides a strong theoretical understanding, you need to work on various real-world Data Analytics projects using different industrial Data Analytics  as a part of solution strategy.

    Additionally, you need the guidance of a Data Analytics expert who is currently working in the industry on real-world Data Analytics projects and troubleshooting day-to-day challenges while implementing them. All of which can be acquired from the Data Analytics Course.

    Prakalpana Technologies provides many suitable modes of training .

    • Classroom training 
    • Online training 
    • Fast track & Super fast track
    • Live instructor online training
    • Customized training

    We do, however, provide recordings of each session you attend for your future reference.

    Yes. We arrange a free demo for all the courses either in the Classroom or Live-Online demo. Please fill the Schedule demo  form to schedule a free demo.

    All our trainers are certified and are highly qualified, with multiple years of experience in working with front-end development technology.

    You will receive Prakalpana Technologies globally recognized course completion certificate

    Yes you will get placement assistance after the course.

    Give  us a quick CALL to our course advisor  at +917505363802 / +919945619267 OR email at [email protected]

    You can reach to the support team for your queries 24/7 .  The team will help you in resolving queries, during and after the course. 

    You can reach to the Corporate Training team at 24/7 on this +917505363802 / +919945619267 OR email at [email protected]

    Training Features

    Classroom Training

    Prakalpana offers Classroom training for all courses in Bangalore and top courses as a scheduled batch in Prakalpana.

    Live-Online Training

    Prakalpana offers Live - Online training for all courses in Bangalore and top courses as a scheduled batch in Prakalpana.

    Real-life Case Studies

    Prakalpana offers Real - Lifecase study training in all courses in Bangalore with our top IT 10+ Years Instructures.

    Forum

    Prakalpana have a community forum for our learners that further facilitates learning through peer interaction and knowledge sharing.

    24 x 7 Expert Support

    Prakalpana have a lifetime 24x7 online support team to resolve all your technical queries in a short time.

    Certification

    After successfully completing your final course , Prakalpana will certify you as an Data Analytics.