Industry-oriented certification Data Analytics training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate.
Professional expert Sr. Lead Analyst / Technical Analyst With 10+ Years of working experience will provide you industrial level training.
Receive placement assistance after completion of 70% training, SLA team will arrange interviews till you’ll get the placement.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete SLA workshop.
SLA’s 7 days working admin team co-ordinates you for the fresh batch schedule/re-scheduling classes/arrange doubt classes.
Data Analytics Practical with Interview Guarantee
Our Trainer:- 10+ Years of industry experience as a Data Analyst in MNC, Education:- B.Tech
Course Duration: 150 (Hours) with Highly Skilled Corporate Trainers
(Data Analytics Training) for below Modules – Weekdays/Weekend
Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
Logical Functions:- And, Or, If, Iferror, Not, Nested If
Lookup & Reference Functions:- VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
Complete SQL in a Class
Fundamentals of SQL
How Relationships Work in SQL
Explaining SQL Strings
Numbers and SQL
SQL Functions and Clause
What are Subselects and Views in SQL
Maintaining SQL Server Database
SQL Server Job Creation
Topics Covered as follows: