FOR ENQUIRY : +91 80 170 49 042 info@7boats.com

Data Analytics Training Courses in Kolkata

Data Science courses, Business Intelligence and Business Analytics Certification on R, Diploma in Data Analytics. Predictive Analytics, Advanced Excel, SQL, R, Micorsoft Power BI, Machine Learning & Data Visualization. Classroom training in Kolkata. Whatsapp us +91 8017049042

1 Year Diploma in Data Analytics & 6 Months Business Analytics Certification on R – Classroom Training in Kolkata

Get 145 hours of extensive practical classroom training on data analytics. Advanced Excel, SQL, R, Microsoft Power BI, Tableau, Predictive Analytics & more. Industry expert trainer. Weekend classes (Saturday or Sunday). Instalment facility available. Join now.

Brief Course Outline: Data Analytics Training in Kolkata, R Training in Kolkata, Advanced Excel training in Kolkata

1) Statistical Concepts & Predictive Analytics : Get hands on practical training on Predictive analytics, Linear Regression, Logistic Regression, Polynomial Regression and Time series Forecasting .

Estimated number of Sessions: 12

2) R : Learn to apply predictive analytics concepts on R. Learn to do code on R. Learn to write algorithm which can make  any report automatic on R. R is a free and open source software. Anybody can download this software from Internet and use it. Learn  basics, vectors, Matrices, Factors, data frames, functions, Lists , Graphics, simulation, profiling and more.

For 6 month course: Estimated number of Sessions: 10

Session 1 :

    • Introduction about R programming language
    • R installation and Basic R Package installation
  • R Base code.

Session 2:

  • R base code

Session 3:

  • R Base code (Optional)

Session 4 :

  • Statistics Refresher

Session 5 :

    • Introduction to Predictive Modelling..
  • Linear Regression. (Simple and Multiple  Both)

Session 6 :

  • Linear Regression & Polynomial Regression

Session 7 :

  • Logistic Regression

Session 8:

  • Logistic Regression

Session 9

  • Time Series Forecasting.

Session 10 :

Data Visualization through R

  • Each session will be 1 day. Each session should be 3 hours class at least. Overall 30 hours class for 6 months Business Analytics class.
  • There should be 3 case studies of each statistical modelling. First case study I will show, 2nd case study student will do and last case study will be homework.
  • R Base code will cover all aspect of basic programming language ( Filter, Join,If else, function, loop etc)  except data manipulation part.

For 1 year Data Analytics Classroom Course in Kolkata: Estimated no. of sessions = 16

16 session. Each session will be 3 hours / Day. Total of 48 hours class.

On this session we will cover Regression, Tree Based Modelling,Classification Problem, Clustering, Dimensionality Reduction, Linear Discriminant Analysis and Boosting Technique.
There should be Projects on Data manipulation, Linear Regression, Logistic Regression and Time series Forecasting.​

R Training in Kolkata – R course Content for 1 Year Business Analytics Course in Kolkata.

Session 1 :

    • Introduction about R programming language
    • R installation and Basic R Package installation
  • R Base code.

Session 2:

  • R base code

Session 3:

  • R Base code (Optional)

Session 4:

Data Manipulation and wrangling in R

Session 5:

Data Visualization through R

Session 6:

Statics Refresher

Session 7:

    • Introduction to Predictive Modelling..
  • Linear Regression. (Simple and Multiple  Both).

Session 8 :

  • Linear Regression & Polynomial Regression.

Session 9:

Support Vector Regression intuituion

Support Vector Regression in R.

Tree based Modelling

Decision Tree Regression intuition

Decision Tree Regression In R

Random forest Regression intuition

Random Forest Regression in R

Session 10:

Classification Problem :

          Logistic Regression intuituion

          Logistic Regression in  R

Session 11 :

Logistic Regression in R

K- Nearest Neighbors intuition

K- Nearest Neighbors in r

Session 12 :

Support Vector Machine intuition

Support Vector Machine in R

Kernel Support Vector Machine

Naïve Bayes intuition

Naïve Bays in R

Session 13 :

Decision Tree Classification intuition

Decision Tree Classification in R

Random forest Classification intuition

Random forest classification in R

Session 14 :

Clustering:

             K-Means Clustering intuition

             K- Means Clustering in R

            Hierarchical Clustering intuition

             Hierarchical Clustering In R

  Dimensionality Reduction

           Principal Component Analysis intuition

           PCA in R

          Kernel PCA in R

Session 15 :

Linear Discriminant Analysis intuition

Linear Discriminant Analysis in R

Boosting:

         K-fold cross validation in R

         XG Boost in R

Session 16:

Time Series Forecasting.

  • Each session will be 1 day. Each session should be 3 hours class at least. Overall 48 hours class for 1 Year Business Analytics class.
  • There should be 3 case studies of Base statistical modelling.( Linear Regression, Logistic Regression, Time series Forecasting ) First case study I will show, 2nd case study student will do and last case study will be homework.
  • R Base code will cover all aspect of basic programming language ( Filter, Join,If else, function, loop etc)  with data manipulation part.

3) Microsoft Power BI : This a Business Intelligence Tools for Data Visualization.  For reporting, you don’t have to pay. You can generate attractive and perfect visualization without paying and store the file into personal hard drive. Learn how to create dashboard on Power Bi.

Bonus->Tableau Overview:   There is another Business Intelligence tools for Data Visualization, named Tableau.  Tableau has 3 part – Tableau Public, Tableau server and Tableau Desktop.

One Important thing, One can master these visualization tools, if he/she is proficient in advance excel. Because, most of the visualization tools have been made based on the advance excel.So, you have to be proficient on advance excel.Otherwise you wont be able to write proper formula on Tableau and Microsoft Power Bi also.

Estimated number of Sessions: 8

4) Advance Excel : This is basic and most required analytical skill for every analyst. Every MNC and start up also checks your excel skill during interview time. so, one must have advance excel skill, Otherwise it will be difficult to get the job. Learn every possible part of advance excel (COUNT categories, SUM categories, ERROR categories, VLOOKUP, HLOOKUP, INDEX, MATCH, Nesting IF, Data Sorting and Filtering, Data Validation,Charting, Pivot tables, Text Formulas – CHAR, FIND, SEARCH, LEFT, LEN, RIGHT, MID, Date & Time Formulas – DATE, DAY, TODAY, HOUR, OFFSET Formula for Dynamic Case Handling, Using SUMPRODUCT Formula for Case Matching, Using INDEX-MATCH Hybrid Formulas as a better alternative of VLOOKUP Formula, Formula Editing Techniques, Formula Debugging Methodologies, Advanced Data Sorting and Validation, Introduction to Macros and VBA & many more )

Estimated number of Sessions: 12

5) SQL : Basic SQL will be needed, not so advance. Most of the companies want to check the data extraction part only.( Select, Group by, Join,Sub Query etc )Because, Company may provide you database access, so then you have to extract your desired data for analysis. So, data pulling skill will be needed & you will learn it here.

Estimated number of Sessions: 6

Datasets to be used in training: For each case/example, 1 dataset will be shown by trainer in class, 1 dataset will be given to students as class assignment to finish in class and 1 dataset will be given as home assignment.

About trainers: Our trainers are working professionals from direct data analytics industry having hands on experience on sales prediction using Linear Regression on R, customer profile analysis of taking loyalty-card using Logistic Regression on R, trend analysis and prediction of mobile app user by using Polynomial regression on R, making interactive Dashboard of Loyalty- card member using Microsoft Power BI, Sales Lift Analysis using SQL Server and excel, Relevancy Accuracy Test using R and Excel, Time Series Forecasting on R, Visualize the data and DAX formula into Power BI and more.

Data Analytics Training for Power & Utility Sector

Customised training course on Data Analytics, for professionals working in Power Utilities, so as to impart knowledge and idea about how to use available parameters of electrical power equipment for prediction of load pattern, fault, capex and revenue budget and other things like those.

Data Analytics Training for Power Utilities Sector- Seven Boats Academy

Contact us now

Tags: Data Analytics Training in Kolkata, Business Analytics Courses in Kolkata, R Training in Kolkata, Advanced Excel Training in Kolkata, Business Intelligence & Data Analytics Courses in Kolkata, Data Science Courses in Kolkata.

News & Events

Admission open for 2019 all digital marketing courses.
Join us at the Workshop on Digital Marketing & Entrepreneurship by Seven Boats at ICCR, Kolkata at Coca Cola Presents AIESEC Youth Speak Forum 2019 on 30th August, 2019.
Join Debajyoti Banerjee at Entrepreneur’s Business Breakfast at Hotel De Sovrani on 2nd September 8 AM – 10 AM hosted by The Bengal Chamber
Digital Marketing Workshop at The Telegraph PRSI Engage 2019 Digital Summit at ITC Sonar Kolkata on 6th August 2019.
Digital Marketing Workshop at Bengal Institute of Business Studies
Globsyn summer school 2019 at RCC Institute of Information Technology
Felicitated by B P Poddar Institute of Management & Technology
Invited as speaker in eChai Startup Networking.
In news: Bartaman Patrika & The Telegraph
Invited & Felicitated by PRCI – Kolkata Chapter, YCC, Bhavan’s Asutosh College of Communication & Management & Calcutta University
Invited & Felicitated by IIM Shillong
Felicitated by Xavier’s Commerce Society. (St. Xavier’s College)
McGraw Hill Education & IIM-B became our official Digital Marketing Book Partner
Digital Marketing Training partner for Globsyn Finishing School
Digital marketing training partner of Calcutta Business School
Digital Marketing Training partner of UWSB
Conducted workshops for 200+ employees at SZI technologies
Seven Boats is now ISO 9001:2015 certified company
Recognized by Government Of India / Ministry of Commerce and Industry under StartupIndia
Conducted workshops for Primarc, Hope foundation & more
Listed among top 10 digital marketing companies in kolkata by top10company.in, coursedom, quora, learnpact & more.
Listed among top 50 digital marketing companies by digital monster magazine
Bengal entrepreneurship recognition by Bengal Chamber of Commerce
Featured in Knowledge & News Network – KNN India news portal (a Govt. of India production)
Seven Boats at Startup Camp GES 2015 at IIT KGP
Seven Boats has been featured in Social samosa magazine
Interviewed by & Featured in Wadhani Group’s National Entrepreneurship Network (NEN)
Seven Boats has been felicitated by GMIT, Kolkata in collaboration with Entrepreneurship development Institute (EDI, Gujarat)
Seven Boats has been featured on Yourstory.in -India’s biggest platform for startups
Indian Leadership award for Industrial Development by IEDRA & AIAF
Seven Boats has been featured in Yo Success!
Top 50 Training Providers Of The Year 2016 by Silicon India Education Magazine
Featured in Startup Talkies
Featured on talking posts
Recommended by Udemy – The largest online course platform
Featured in Andhra Jyothi, Sakshi Telugu Daily, Namaste Telangana
DM Partner at Ventura ’15 by E-Cell NIT Trichy
Listed among top 3 digital marketing institutes in Kolkata by Team Sorav Jain

Admission Going on

august

20aug(aug 20)11:00 am30oct(oct 30)2:00 pmDigital Marketing Regular Career Courses

27aug(aug 27)11:00 am12mar(mar 12)2:00 pmDiploma / Advanced Diploma in Digital Marketing

september

13sep(sep 13)11:00 am29jan(jan 29)2:00 pmDigital Marketing Specialization Courses

Office & Center Address

Kolkata, India Head Office & North Kolkata Center

Seven Boats Academy
(Unit of Seven Boats Info-System Pvt. Ltd.)

Unit #304, Diamond Arcade, 1/72, Cal Jessore Road, Kolkata, West Bengal 700055, India

+91 801 704 9042
/ +91 9674 937 499 / +91 33 4064 7085

info@7boats.com

Enquiry Form

top
WhatsApp us
ENQUIRE NOW
X