*** New weekday/weekend batches Going to start - ***Hadoop,Java ,SalesForce ,Selenium , QlikView,Tableau ,Linux ,Python ,Perl,Shell,SAS ,MSBI ,SOA , AWS, Android ****
Elegant IT Services distinguished itself as the leading Data Analytics Training Institute in Bangalore. Our Data Analytics Training Consultants or Trainers are highly qualified and Experienced to deliver high-quality Data Analytics Training across Bangalore.
DATA ANALYTICS SYLLABUS
Key
Concepts of DA
Excel, SQL, Tableau, Power BI, and Python.
EXCEL
Working on Excel – Getting to know the interface.
Tabs, ribbons, and Formula bar
Challenges in Excel
Working on Data
Differences between various versions of excel.
Max & Mins
IF and Loopings in Excel
Pivot in Excel
Charts and Visuals in Excel.
Advanced concepts in Excel – Overview
SQL
Introduction to SQL
Introduction to Database
Knowledge on the data
DDL Queries
DML Queries
TCL Queries
DCL Queries
Functions in SQL (String, Numeric, Date, Conversion)
Joins concepts.
DBMS and RDBMS
ER Diagrams
Normalization and forms
Groups and Filtering
Sub Queries in SQL
TABLEAU
Installation
Tableau UI
Connecting to Datasets
Components of Tableau
Filters
Dashboard
Creating a Story
Formatting
Sorting
Joins in Tableau
Charts and types
Analytics on Tableau
Advanced Tableau – Measures and Dimensions
Clustering
Functions in Tableau
Table calculations (Type conversion & other Functions)
POWER BI
Introduction and Installation
Interface of Power BI
Introduction to Data sources and Challenges
Loading data
Creating visuals in different types
Aggregations in Power BI
Drill through data & Advanced drilling options
Solving challenges
Formatting Visual
Power Query Editor
Structuring the data
Transformation of data
Fill and Replace data
Split and Format data
Date and Time Transformations
Report and Dashboard
Relationships in Power BI
Cardinality and columns selection
Differences between the visuals
Ways of Interacting with Visuals
Bookmarks and Buttons
Data Source settings
Assignment and datasets for practice
PYTHON
What is Python?
Why Python?
Installation of Python
Python IDE
Jupiter Notebook overview
First Query of Python
Python Data Types
Lists
IF, Loops, Dictionaries, Arrays
Reading csv into notebook
Saving the project
Loading a saved project
Examples and practice
Role of Python in ML
No Interview Questions Found..
Our Data Analytics Training Trainers in our Elegant IT Services
Data Analytics Training Placement through Elegant IT Services
It is one of the best training institutes in Bangalore to learn SQL DBA, Highly Recommend..!
I Have Opted for Amazon web services Course and completed the training at Elegant IT Services. This course has helped me to come back on track and covering all important topics. Every day we used to bring our laptops in the class, thereby understanding through a practical approach. Timings are flexible even for weekday classes if we miss the class any day, there are also backup classes provided. It is the Best AWS training in Bangalore.
I attended the NetApp Training in Bangalore at Elegant IT Services. It was a good experience. Learnt a lot of new things which are helpful for my future projects. I suggest to all my friends this is the best training institute in Bangalore.
I have done an Android training course in Elegant IT Services. Very nice and good institute. Elegant IT Services is the best training institute in Bangalore, Thank you.
Its really been good to choose Elegant IT Services for Hadoop Training in Bangalore. I am satisfied with the course. And I am thankful to my trainer who is always in favour of us.