Analytic Techniques using Excel & Power BI

Download the detailed course curriculum & Complimentary invite for Online Demo Session!

Limited Seats Available!
Date : 22nd Mar, 2018 (Thursday)
Time : 3 PM to 4 PM (IST/GMT +5:30)

  • This field is for validation purposes and should be left unchanged.

Introduction to Data Analytics Certification Training with Excel and Power BI

Enhance your Analytics Skills and make a transition into the ever-growing Analytics industry.

Learn high demand tools such as Advanced Excel, PowerBI, and SQL used by more than 70/100 Analysts in Europe.

Represent Data Visually and derive added value from you data possessions.

 Start working on Data by extracting it directly from the cloud.

 Get prepared to devise solutions to real-time industry problems

Data Analytics Excel Training Program Highlights

3 hrs/week Live Sessions

Industry Experts Faculty

3-week Industry Project

Placement Support

3-5 hrs/week Assignments

Govt. of India
(Vskills Certified Course)

Lifetime Access To
Updated Content

24X7 Support On Discussion Forum

Money Back Guarantee

Career Mentoring

Industry Relevant Curriculum

Hands-on Approach

Madhukar Kumar

Digital Vidya is working towards creating a learning infrastructure which is flexible enough to change per the dynamic pace of development in digital world.

Madhukar Kumar
Chief Data Scientist

Naresh Mehta

Good to see Digital Vidya becoming increasingly more involved in covering data science vertical, look forward to collaborate with DV to help shape this industry.

Naresh Mehta
AVP Data Science & Analytics

Madhu Vadlamani

I can see a good course structure and well-designed syllabus for those who are passionate enough to enter into the analytics world.

Madhu Vadlamani
Lead Analytics

Ajay Ohri

Ajay Ohri

Yes, I like the huge investment Digital Vidya is doing to create the next generation of talent. Initial feedback suggests Digital Vidya produces high-quality Data Analysts.

Ajay Ohri
Data Scientist

Shivaram K R

Shivaram K R

We like the approach of hands-on practice and capstone projects. We have plans to mentor students of Digital Vidya and take some students for an internship at Curl.

Shivaram K R
Co-Founder, and CEO

Digital Vidyarthis Speak

Amit Kumar Sinha

General Manager / Leela's Foundation For Education & Health

Came to know new and advanced technical knowledge about Excel and Power BI platform.

Hareesh Kumar

Software Development Engineer / Mcafee(Intel Security)

The attachment with Digital Vidya is memorable.Thanks

Dhanashree Bagal

Associate Software Engineer / Accenture

It was good learning with digital Vidya. The whole team is supportive. Trainer was able to answer almost every asked question.

Nanddeep Nasnodkar

Sr. Software Developer / Remote Software Solutions

This course gets you started from very basics, makes you think and solve the assignments, and suddenly you find yourself doing Data Analytics all by yourself!

Ranjan Kumar

Map Analyst / Lionbridge Tech

I would like to sincerely offer my thanks and gratitude to Digital Vidya for providing me with the most efficient and relevant mentors and course materials to learn Data Analytics and R. I would specifically like to mention weekly assignments during my course tenure to learn R were the best.

Vani Ananthamurthy

Business Operations Senior Analyst / Accenture

I was looking for customized content and I found the same in Digital Vidya. Content is structured and well planned. Classes were very interactive and trainer’s presentation skills were very good. People who are new to the subject can also understand clearly. Thank you so much!


Dates Duration Days Course Fees
Apr 14, 2018 - July 21, 2018 12 weeks Sat USD 459/- | Early Bird off till 31st March Register Now

Money Back Guarantee: If you do not like our training, ask for 100% course fees refund after your 1st live session.
Group Discount: 10% discount for 3 or more registrations
Two Offers can not be clubbed together. 

The Digital Vidya Data Analytics Course Advantage

Highly researched industry-relevant content with systematic delivery

Top faculty with real-time experience in the industry

Regular sessions with industry veterans

Comprehensive hands-on training based on real business examples

Individual attention to each learner

Personalised assignment feedback

Tie-ups with leading organizations

100% Placement Assistance

A promise to make you job ready


  • Introduction to Analytics Techniques
    You will learn about Analytics, Data Analytics and Business Intelligence
  • Fundamentals of Excel
    This module deals with the Fundamentals of Excel without which you cannot learn the Advanced features and functions. You will learn how to run calculations on numbers, sort and filter your data.
  • Data Cleaning and working with Conditions using Excel
    Data cleaning is a must, without which your data is of no use. You cannot generate any kind of reports from unclean data. You’ll go on to learn conditions that form a big part of any programming language or spreadsheet application. Here you will learn how to effectively use conditions in Excel and logic behind each function.
  • Data Manipulation using Advanced Excel
    In this module, you’ll learn about data and how it needs to be fetched, matched and compared – across datasets and  sheets.
  • Data Analysis & Visualization using Advanced Excel
    This module covers a vast array of topics like reverse calculations, sensitivity analysis and comparing scenarios. It’ll deal with situations like working in a factory, and wanting to reduce your cost of production, or working in the sales department and wanting to increase your overall sales across products and markets. Learn how to summarize data and use it to generate reports. This section teaches you  how to create your charts directly from your pivot tables reports.
  • Introduction to Statistics & Application in Excel

    A plethora of Statistical Techniques will be taught such as:

    • Descriptive Statistics
    • Inferential Statistics
    • Regression
    • Anova
    • Correlation
    • Covariance
    • Histogram
  • Introduction to MS SQL & MS Access

    This module deals with understanding of difference between SQL and Excel

    SQL Queries & Views

    You’ll learn about how to get data in required format out of SQL and also the manner to build your own tables in SQL

    Power BI – Introduction

    You’ll learn how Excel tables are different from Ranges. Importing data from different sources into Power BI as well as Data cleaning in Power BI is also from the topics taught in this module. Finally you’ll learn about relationship building in Power BI

  • Power BI – Building Dashboards, Manipulating data using DAX, Importing Data from multiple sources

    This deals with the DAX Functions basics

    Hands-on Capstone Project

  • It is not just hours of Theory! As a part of the course, the learners have to undertake the Capstone project which is the culminating assignment that will allow them to have an integrated experience of the program. The approach to this project is to think, define, design, code, test and tune your own solution, in such a way that you apply all aspects of the data analytics process. 

Download Detailed Curriculum (.pdf)


Rushabh Shah Digital Vidya Data Analytics Trainer

Rushabh Shah

Founder & CEO of

Course Advisors

Shweta Gupta

VP, Technology Vertical, Digital Vidya

Vishal Mishra

CEO & Co-Founder, Right Relevance

Ajay Ohri Digital Vidya Data Analytics Trainer

Ajay Ohri

Sr. Data Scientist at Kogentix Inc.

Manas Garg Digital Vidya Data Analytics Course Advisor

Manas Garg

Architect at PayPal Holdings, Inc      

Placement Services

We partner with 10+ organizations who directly source their Data Analytics manpower needs from us. From resume creation to helping you crack the final interview, our dedicated placement team is always on toes to connect talent with the right opportunity.

The Placement Process

The Candidates resume is refined and polished as per Market Standards to help them be searchable.

The Resume is shared with relevant organisations by our placement team.

The Candidates are prepared for a initial quiz and an coding test.

Finally, the candidates are prepared for the final round of interview.

Data Analytics Tools Covered



Benefits of Learning Data Analytics Course with Excel and Power BI

  • According to Gartner, Excel is still the No. 1 reporting tool
  • Data Analytics using excel Excel and Power BI opens great prospects as they are the most widely used solutions in the industry for Analysing Data
  • Improve your productivity with hacks not available with any other data analytics course or tool
  • Analyse more data with improved visualizations and sophisticated business logic
  • Be able to use Data from any source, with highly flexible copy pasting abilities allowed
  • Limit your dependency on the IT department and get your thing done all by yourself
  • One of the best online data analytics excel courses in India with a short learning path

Digital Vidya is Training Partner For

Microsoft & Google Partners
Digital Vidya is the trainer for Google & Microsoft Partners to lead their workshops & sessions


Data Analytics Excel Certification Process

How to get Data Analytics Certification?

  1. On registration, you will receive participation details for a 17 weeks live instructor-led online training program. You can attend these sessions from anywhere. You can access these sessions even on the go through your mobile from any city and any country provided you have a good stable internet connection.
  2. Once you complete this 17 week training course with a minimum of 60% attendance, you will become eligible to appear in the Certification Exam, at your preferred testing center across India. You can also take it online if you are an international candidate. Following are the exam details:

    • Exam Duration: 60 minutes
    • No. of Questions: 50
    • Maximum Marks: 50, Passing Marks: 35 (70%)
    • There is No Negative Marking in this Exam
    • 70+ Exam Centers in India

Data Analytics Excel Course FAQS

Who is this course for?

People from all functional areas like HR, Marketing, Sales, Supply Chain, Customer Satisfaction, Logistics, Accounting & Finance, Operations, Trading, Administration, Purchase & Production, Manufacturing, Research & Development

What is the focus area of learning?

The curriculum allows learners to enhance their analytical skills and make a transition into the analytics industry with high-in-demand skill-sets of Advanced Excel, Business Intelligence or Visualization tools PowerBI and SQL.

What should you expect after completing your Course?

The course is designed in a way that within a few weeks the program, learners will be prepared to devise solutions for real-time problems in the industry.

What are the Projects that are a part of this course?

The Capstone project is the culminating assignment that will allow a learner to have an integrated experience of the program. The approach to this project is to think, define, design, and work your way to your solution, in such a way that you apply several aspects of your learning.
In the project you will be the ‘Indian Premier League Statistician’, solving the project using different features & functions to arrive at your answers. This project will allow demonstrating a sound application of analytic techniques on a very interesting dataset.

Who will award the Certification?

Both Digital​ ​Vidya​ ​and​ ​Vskills​ ​will​​ ​offer​ ​the certifications.

What is V-Skills?

Vskills​ ​is​ ​the​ ​largest​ ​certification​ ​body​ ​in​ ​India.​ ​Vskills​ ​certification​ ​exams​ ​are conducted​ ​by​ ​ICSIL,​ ​a​ ​Govt.​ ​of​ ​India​ ​Undertaking​ ​and​ ​Govt.​ ​of​ ​NCT​ ​Delhi Company.​ ​It​ ​is​ ​one​ ​of​ ​the​ ​largest​ ​manpower​ ​companies​ ​of​ ​the​ ​Government​ ​of NCT​ ​Delhi.​ ​Vskills​ ​certifications​ ​help​ ​candidates​ ​quantify​ ​and​ ​prove​ ​their​ ​skills​ ​in a​ ​particular​ ​domain​ ​-​ ​skills​ ​that​ ​are​ ​valued​ ​by​ ​the​ ​employer​ ​and​ ​are​ ​in​ ​great demand.

What are the advantages of your course over other online courses?

We have been delivering online trainings for the past 8 years and here are the key benefits of it:
You will save a lot of your time that will be wasted in traveling to any institute for a face to face classroom course, yet be able to retain the benefits of being in a classroom environment.
You will not miss any of the sessions even if you are traveling just with the help of an internet connection and a mobile/laptop.
You will receive recordings for all the sessions regardless of your attendance. You can go through these recordings as many times as you want to solidify your retention.

You will be among a community of learners and you will be able to share any doubts and confusions via LMS where both program leaders, teaching assistants and course aides will be available for support.

What will I do if I miss my class?

You will receive a recording of the class in case you miss any live class.

What kind of hands-on practice will I get in this course?

You will be regularly working on different assignments and quizzes while in the course. The Capstone project is the culminating assignment that will allow you to have an integrated experience of the program. The approach to this project is to think, define, design, and work your way to your solution, in such a way that you apply several aspects of your learning. This project will allow the learner to demonstrate

sound application of analytic techniques on a very interesting dataset.

Why is it the best online analytics course in India?

The comprehensive syllabus crafted by veterans in the field and 8+ years of experience in delivering online courses make it the best business analytics course in India.

What is the Salary that I can get after I do this course?

A fresher may get anything from Rs. 1.7 to 7.7 lakhs a year in India. The salary may rise to up to 50 lakhs per annum with a growth in profile.  People with exceptional educational backgrounds can easily get 1 crore salary as well.

How do you select your instructors?

We select our instructors through a rigorous selection procedure. We keep on reviewing the performance of the instructors based on regular student feedback. All our instructors apart from having a thorough knowledge of theory are people who have worked in the industry for a good duration of time.

Will I get Job Placement after this course?

Having conducted over 1900+ training programs for participants from 10,000+ brands across Asia, we are regularly approached by corporations for their hiring needs. Our Placement Cell provides Assistance to all participants who clear the Data Analytics Certification.

Our Awesome Corporate Customers

digital marketing course customers

Media Coverage

Register in FREE Webinar

Download the detailed course curriculum & Complimentary invite for Online Demo Session!

Limited Seats Available!
Date : 22nd Mar, 2018 (Thursday)
Time : 3 PM to 4 PM (IST/GMT +5:30)

  • This field is for validation purposes and should be left unchanged.