Data Analytics Course

BY
Digital Vidya

Enrol in the Data Analytics course by Digital Vidya and become a certified Data Analyst. Master the PowerBI, SQL, Excel, Advanced Excel, QlikView, and Tableau.

Mode

Online

Duration

16 Weeks

Fees

₹ 12500

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based

Course overview

The Digital Vidya Data Analytics Course uses a combination of theoretical and practical tools to provide an unparalleled discourse on data science and data visualisation. The training modules are built to strengthen your understanding of the core elements of QlikView, PowerBI, SQL, Excel, and Tableau. Coupled with the Advanced Excel training, the Data Analytics Course training provides an overview of data cleaning, data manipulation, data analysis, data comparison, data visualisation, data sorting, and data filtering with Excel. 

You will get pre-recorded instructional sessions by industry leaders, hands-on projects, and assignments in a self-paced module. The Data Analytics programme will allow you to undertake capstone projects for real-time exposure in Data Analytics and Data Management. Digital Vidya offers three projects for risk assessment in the banking and finance industry, data analysis of the sporting league Indian Premier League (IPL), and the study of data science in the computer rental business.

In the 16-week Data Analytics Course, you have an option to audit the course by applying for a demo session. Along with lifetime access to the learning modules, you will also be eligible for a dual certification from Digital Vidya and Vskills.

The highlights

  • Self-paced module
  • 16 Data Analytics learning modules
  • 3 Hands-on projects
  • Lifetime access to LMS
  • Interactive training sessions
  • Practical assignments
  • Bi-monthly live question and answer panels
  • Real-time case studies
  • Dual certification
  • Pre-recorded course material

Program offerings

  • Self-paced module
  • Online learning
  • Interactive training sessions
  • Capstone projects
  • Bi-monthly live question and answer panels
  • 24*7 online assistance
  • Dual certification
  • Real-time case studies
  • Hands-on assignments
  • Free sample class

Course and certificate fees

Fees information
₹ 12,500

You can subscribe to the Digital Vidya Data Analytics course training by paying a programme fee, inclusive of GST. However, depending on several factors, you can also avail occasional discounts on the course fee. 

Data Analytics Course Fee Structure

Training Option

Fee in INR

Self-paced learning

Rs. 12500 + GST

certificate availability

Yes

certificate providing authority

Vskills +1 more

Who it is for

The Data Analytics Specialisation course is a smart choice to improve your understanding of analytics. This course is ideal for;

  • Freshers interested in the Data Analytics industry
  • Individuals in the sectors of finance, supply chain, sales, or customer relationship management
  • Professionals in the field of accounting, trading, manufacturing, logistics, research or development
  • Anybody looking to upskill in data visualisation and data science
  • Graduates interested in foraying into the Data Analytics industry

Eligibility criteria

The Data Analytics Training Course by Digital Vidya does not have an eligibility criterion as such. Since the course is based on statistics, algebra, calculations, and probability, candidates should have the fundamental knowledge and understanding of Mathematics.  

Certificate Qualifying Details

Furthermore, to receive the Data Analytics certification from Digital Vidya, candidates need to complete the Data Analytics course successfully; including all the practical assignments and case studies. 

What you will learn

Knowledge of excel Sql knowledge Knowledge of data visualization Tableau knowledge

The Digital Vidya Data Analytics Course is modelled to turn you into an expert data analyst. After completing the certification course, you will be adept in the following skills:

  • Use Excel and SQL tools for running data analytics
  • Strong groundwork in statistics to draw and utilise meaningful insights from large datasets
  • Discovering and using best data visualisation techniques via Excel 
  • Familiarity with inferential and descriptive statistics
  • Using Power BI for building interactive dashboards, data visualisation, and importing data from multiple sources
  • Understand the usage of analytics tools such as QlikView, PowerBI, and Tableau 

The syllabus

Data Science and Data Analytics

  • Data Science 
  • Data Analysis Pipeline?
  • Types of Data
  • What is Data Extraction?
  • Raw Data and Processed Data
  • Overview: Business Intelligence, Business Analytics, Analytics Techniques
  • Data Wrangling
  • Industry Examples

Fundamentals of Excel

Basics
  • GUI
  • Cell Referencing
  • Freeze panes
  • Sum function
Functions
  • Counting functions
  • Averaging functions
  • Summing functions
  • Rounding functions
Understanding Sorting and Filtering
  • Custom Filter
  • Multi-level sort
Duplicates
  • How to remove duplicates?

Data Cleaning with Excel

Text
  • Concatenate
  • Left, Right, Upper, Lower?
Conditions
  • Understanding Logical Operations
  • Use IF, AND, OR, Nested IF
  • Conditional Formatting
Data Functions
  • Create Dates
  • Data Splitting

Using Advanced Excel for Data Manipulation

How to fetch and compare data sets?
  • Understanding Vlookup and Hlookup
  • What is $ Referencing?
  • Understanding Match and Index
Named Ranges
  • Understanding Name Box

Using Advanced Excel for Data Visualisation and Data Analysis

Studying the What-if-Analysis
  • Looking at Data Tables
  • What is Goal Seek?
  • Understanding the Scenario Manager

Solver Plug-ins

Pivot Tables
  • Measures and Dimensions 
  • Summarise Values by
  • Show Values as Grouping
  • Multi-layer Pivot Table
Charts
  • Pivot Charts
  • Various Charts
  • <li style="list-style-type: none !important;"- Sparklines
  • Combo Charts?
Applying Statistics to Excel
  • Inferential Statistics 
  • Descriptive Statistics
  • Correlation
  • Regression
  • Anova
  • Histogram
  • Covariance

Understanding SQL

Core Concepts
  • TablesSolver Plug-ins
  • Relational Database Concepts
  • Data types
Understanding SQL Queries
  • Insert, Select, Update, Delete

Learning about SQL views
  • Update and Create SQL Views

PowerBI

PowerBI: Introduction
  • Calculated Measures and Columns
  • Dashboard
  • Excel Tables
  • Data Import
  • Power BI Components
  • Data Modelling
  • Clean & Transform Data
PowerBI- Data manipulation using DAX, Data Import from multiple sources, and Building Dashboards
  • DAX Functions
  • Excel and Power BI 
  • Power BI Service
  • Visualisations
  • Data Import
  • Publishing
  • Power BI Mobile
  • Dashboards

Admission details

Follow these steps to register for the Data Analytics course by Digital Vidya:

Step 1. Sign up for the course on Digital Vidya’s official website

Step 2. Tap on the “Download Course Brochure” or “Download Course Curriculum” button.

Step 3. Enter your requisite details. Register yourself for the free orientation session.

Step 4. Eventually, when you proceed to pay the subscription fees via your preferred mode; remember to download the fee transaction receipt for future reference.


Filling the form

Digital Vidya will need to register your name, email id, and phone number for applying to its Data Analytics Course. After entering the correct information, you can finish the payment and start learning right away.

Evaluation process

The Data Analytics Training Programme makes you eligible for a dual certification as soon as you complete the course, with an average attendance of 80%. 

Digital Vidya offers you the Data Analytics certification after you submit all the case studies, assignments and projects. To acquire a certificate from Vskills, you would have to pass an examination—either at an exam centre or via an online system. The fees for the Vskills certification exam is Rs. 1,770.

How it helps

The learning module has all the ingredients of making you a certified Data Analyst. Industry experts lead the training modules for the Digital Vidya Data Analytics Certification course. Since the classes are online, you can join the sessions from anywhere. You will not miss a beat, pace your learning, and complete your notes with the recorded sessions. 

The practical sessions will equip you with the industry-based skills of the modern-day Data Analyst, with proficiency in SQL, Excel, Power BI, QlikView, and Tableau. Additionally, Digital Vidya offers counselling from their team of senior advisors to guide you along your career trajectory. On completion of the Data Analytics programme, you will receive dual certification—from Digital Vidya and Vskills.  

Instructors

Mr Dilnoor Singh
Instructor
Freelancer

Mr Jeet Shah
Instructor
Freelancer

Mr Mandar Mulay

Mr Mandar Mulay
Instructor
Freelancer

Mr Rushabh Shah

Mr Rushabh Shah
UI Developer
Freelancer

FAQs

How do I become a Data Analyst?

You can become a data analyst with several offline and online courses available today. The 16-week Data Analytics Course by Digital Vidya provides you with extensive guidance in data management, data science, data analysis, and data visualisation. The projects and assignments ensure that you are skilled in using Excel, Advanced Excel, Tableau, QlikView, Power BI, and SQL tools.    

Is this course challenging?

The Data Analytics Course is made appealing, accessible, and understandable to almost anyone. You only need to have a firm grasp over Mathematics and be interested in learning about data science. If you follow the sessions religiously and complete the assignments and projects, you should not find this course hard. 

What is the eligibility criterion for Data Analytics Course by Digital Vidya?

It would help if you had an analytical mind interested in logic and data analytics. Since this course relies heavily on algebra and statistics, an understanding of Mathematics is also necessary. 

What makes this course from Digital Vidya special?

Digital Vidya is dedicated to offering certification in skills belonging to particular niches. To deliver just that, it has brought together industry experts to curate and create the Data Analytics Course. Moreover, this programme offers double certification and comprehensive modules in self-paced learning.  

How do I receive the double certification?

Digital Vidya will offer you a course completion certificate as soon as you complete the course and submit all the projects, assignments and case studies. Vskills offers the second certification, and to obtain that you will have to pass an examination. You may take the test either at a centre or online. The examination fee is Rs. 1,770.

What is the duration of the Digital Vidya Data Analytics Course?

Data Analytics Course by Digital Vidya is a 16-week programme, and after completion, you are expected to complete your assignments and projects.

What if I cannot find my query?

Reach out to Digital Vidya over call or email at +91-84680-02880 and info@digitalvidya.com respectively to have your query answered.

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books