Analytic Techniques using Excel & Power BI

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

Limited Seats Available!
Date : 27th Sep, 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

Ravi Vijayaraghavan

Creating a talent pool in India with Practical hands-on experience in Analytics and Data Science is the need of the hour. Platforms like Digital Vidya are critical to filling this gap.

Ravi Vijayaraghavan
President and Head – Analytics and Decision Sciences

Lovekesh Vig

Digital Vidya has a very important role in getting the word out from the industry’s perspective. Initiatives like Digital Vidya will hopefully help to plug the gap between academia & practical skills.

Lovekesh Vig
Senior Scientist

Ambuj Kathuria

Digital Vidya is doing a great job of bringing people from diverse set of experiences to one platform for creating the best of Data Science skill pipeline.

Ambuj Kathuria
Head – Data & Analytics

Akshay Sehgal

Digital Vidya is doing a great job at bringing data analytics to the rest of the world!

Akshay Sehgal
General Manager

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


Digital Vidyarthis Speak

Faisal Hussain

Deputy Manager / Enzen Global Solutions Pvt Ltd

It was really an interactive Data Analytics training experience. It will surely help me in starting up my analytics career.

Utathya Ghosh

Data Analyst / Right Relevance

Really peaked my interest in Tableau. It is a fun tool and the presenter did a great job to help me learn. Presenter has good knowledge of subject and works well with students.

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!


UPCOMING DATES FOR DATA ANALYTICS EXCEL COURSE (Batch Details)

Dates Duration Days Course Fees
Oct 07, 2018 – Feb 06, 2019 15 weeks Sunt USD 459/- |Early Bird 25% off till 22nd Sep Register Now
Nov 03, 2018 – Mar 02, 2019 15 weeks Sat USD 459/- |Early Bird 25% off till 20th Oct 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

DATA ANALYTICS EXCEL COURSE SYLLABUS

    • 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 the 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 

      This module deals with the understanding of the 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

Capstone Project

It is not just hours of Theory! 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.
1. Risk Assessment of Credit Card Customers
As a Data Scientist, this Capstone project will help you understand how to analyse credit card customers’ data in
terms of Risk assessment. You will be able to identify what kind of customers are risky, what kind are not, which
one’s should be blacklisted, etc
2. IPL Data Analysis
As a Data Scientist, this Capstone project will help you analyze IPL data of several years. You will be able to identify
each player has been performing as a Batsman, Bowler, Fielder and also how each Team has been performing.
Your skills of Excel & Power BI will be put to test with the kind of analysis that you have to solve.

Note: It is mandatory to complete one project for your Course Completion and Certification. We encourage our
students to leverage all opportunities to sharpen their problem-solving skills as a Data Analyst.

Download Detailed Curriculum (.pdf)


Instructors

Rushabh Shah

Founder & CEO of DLTC.co

Dilnoor Singh

Tech Generalist

Jeet Shah

Trainer & Solopreneur

Course Advisors

Shweta Gupta

VP, Technology Vertical, Digital Vidya

Vishal Mishra

CEO & Co-Founder, Right Relevance

Manas Garg

Director of Engineering, PayPal 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

Data-Analytics-Excel-Tools

 

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

[/icon-box]


Data Analytics Excel Certification Process

How to get Data Analytics Certification?

  1. On registration, you will receive participation details for a 12 weeks live instructor-led online training program and 3 weeks of capstone project. 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 these 12 weeks of live instructor-led online training program and 3 weeks of capstone project 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

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

Limited Seats Available!
Date : 27th Sep, 2018 (Thursday)
Time : 3 PM to 4 PM (IST/GMT +5:30)


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