Data AnalyticsMaster Course

We Proudly Partner:

59,000+Participants

4,500+Batches

10+Years

55+Countries

Data Analytics using Excel, SQL & PowerBI

In-depth Coverage

Data AnalyticsMaster Course

By 2020, it’ll be one of the most in-demand jobs across the world

In the USA, professionals earn an average salary of about $20,990 as a Data Analyst

Initial salary of $7,000 to $8,387 (USA)

97,000+ jobs currently open in Data Analytics

6% job increase predicted year on year

Why Learn Data Analytics?Stay Ahead of the Change

What Will You Get?Learning That’s Not Confined

16Number of Modules

15+Hours of Self-paced

Videos

30+Assignment Hours

3Projects

15+Assignments

24*7Forum

Support

Monthly LiveQ&A Sessions

2

SalientFeatures

Fortnightly Live Instructor-LedDoubt Clearing Sessions

Active Q/A Forum2 Weeks ofProject Work

Class Labs/Home Assignment(05 hrs/Week Learning Time)

Individual Attention toEach Learner

24*7 Support Lifetime Access toUpdated Content and Videos

Govt. of India(Vskills Certified Course)

Internal Competitionswith Prizes

Multiple ToolsCovered

Top RatedAdvisors

Industry andAcademia Faculty

Hands-on ApproachCareer Mentoring &Resume Sessions

Money BackGuarantee

Industry RelevantCurriculum

Who Should do this Course?Get Ready to Transform

Freshers interested in starting their career in the Data Analytics Industry

People from finance, sales, supply chain, customer satisfaction who work with Data

Professionals from logistics, accounting, marketing, trading, administration,manufacturing, research and development

Anyone who wants to get started in the industry of Data Visualization,Data Science or Analytics

Job Role Expected*

Data Analyst

Bussiness Analyst

*No Placement Support Available

Introduction to Data Science &Analytics Techniques

Introduction to Data Science

Introduction to Python

Data Analysis Pipeline

What is Data Extraction

Types of Data

Raw and Processed Data

Data Wrangling

CourseCurriculum

Overview of the Analytics Techniques

Analytics

Business Analytics

Business Intelligence

Industry Examples

Introduction to Data Visualization

What is Visualization

Importance of data visualization

Data Visual Analytic pipeline

Intro to DV tools that are ruling the industry - Tableau - Power BI - Qlik View

Data Cleaning & Working withConditions using Excel

Fundamentals of Excel

GUI

Cell Referencing

Freeze panes

Sum function

Introduction

Counting functions

Summing functions

Averaging functions

Rounding functions

Useful functions

Multi-level sort

Custom filter

Sorting and filtering

Remove duplicates

Duplicates

Concatenate

Left, right, upper, lower

Working with text

Conditional Formatting

Logical Operations

IF, AND, OR, Nested IF

Working with conditions

Splitting

Creating dates

Data functions

Data Manipulation using Advanced Excel

$ Referencing

Vlookup and Hlookup

Match and Index

Fetching and comparing data sets

Name Box

Named ranges

Data Analysis & Visualization using Advanced Excel

Goal Seek

Data Table

Scenario Manager

What-if-Analysis

Solver plug-in

Solver Plug-in

Dimensions & Measures

Multi-layer Pivot Table

Summarize Values by

Show Values as Grouping

Pivot tables

Various Charts

Pivot Charts

Combo Charts

Sparklines

Charts

Introduction to Statistics & Application in Excel

Descriptive Statistics

Inferential Statistics

Regression

Anova

Correlation

Covariance

Histogram

Introduction to MS SQL & MS Access

Relational Database Concepts

Data types

Tables

Core Database Concepts

SQL Queries & Views

Select, Insert, Update, Delete

Queries

Creating and Updating

Views

Power BI - Introduction

Calculated Columns

Measures

Calculated Columns & Measures

Why use Tables

Referencing Syntax

Formulas

Named Ranges

Excel Tables

Dashboard using Pivot Tables, Slicers, Timeline

Dashboard

Old v/s new Technologies

Power BI Desktop

Power BI Service

Power BI Mobile

Power BI Components

From Excel

From Access, Folder, other sources

Importing Data

Query Editor

Advanced Methods

Pivoted data / Unpivoted Data

Clean & Transform Data

Relationships

Calculated Columns & Measures

Calculated Tables

Time-based Data

Modeling

Power BI - Building Dashboards, Manipulating datausing DAX, Importing Data from multiple sources

Introduction to DAX

Data types

Calculated Columns & Measures

DAX Functions

Relating Excel functions with DAX functions

Variables

Tables Referencing

Filtering

DAX Functions

Create simple visualizations

Combination charts

Slicers

Map Visualizations

Tables & Matrix

Scatter Charts

Waterfall & Funnel Charts

Gauges & Single Number

Cards

Styling the visualizations

Categories with no data

Visualizations

Sign up for Power BI Service

Parts of the Power BI Service

Datasets

Reports

Dashboards"

Introduction to Power BI Service

Publish from Power BI desktopto Service

Publishing

Import an Excel table in Power BIService directly

Power BI and Excel

Mailchimp

Google Analytics

QuickBooks

Import from data other Services

Pinning the required reportfrom across reports

Ask questions on your data

Focus mode

Edit tile details

Dashboards

Installing the App

Viewing Dashboards

Viewing Reports

Sharing

Power BI Mobile

Assignments

Introduction to Analytics Techniques & Fundamentals of Excel

Working on Sorting & Filtering

Working with Dates & Starting out with Other Conditions

Getting Started with Data Manipulation

Working with Tables & Drop-down Functions

Getting Deep with Analytical Applications

Working with Pivot Tables

Getting Friendly with the Basics of SQL

Working with Intermediate SQL Capabilities

Assignments are important to engage students deeply with the course objectives. In our data analyst course training program, we provide you with industry-relevant assignments to allow you to nurture your practical and analytical skills. Our aim is to broaden your view to discover new possibilities with data analytics.

Certifications

Digital Vidya’s DataAnalytics Certification

Vskills CertificationA nominal fee of Rs. 1770/- is involved

CapstoneProject

Risk Assessment of Credit Card Customers

Project Description:

Capstone Projects help you to gain real-time exposure and are seen as the best form of learning in Data Analytics. At Digital Vidya, we provide you with an integrated learning experience of data analytics using robust capstone projects. After the Advanced Excel Course, and introduction to SQL & Data Science landscape, your learning will be strong enough to work on these projects.

As a Data Analyst, this Capstone project will help you understand the process to analyse the data of credit card customers in terms of Risk Assessment. You will be able to identify what kind of customers are risky, what kind are not, which one should be blacklisted, etc

IPL Data Analysis

As a Data Analyst, this Capstone project will help you analyze IPL data of several years. You will be able to identify how each player has been performing as a Batsman, Bowler, and a Fielder. You will also understand how each Team has been performing. Your skills of Excel will be put to test with the kind of analysis that you have to solve.

Analyzing the Business of Computer Rentals

Large Corporations, Small Business & Freelancers are in need of computers/laptops for short amounts of time due to various reasons. It’s better for them to rent it rather than buying such costly equipment. You will be given some data of transactions related to computer rentals and would be asked to work on it holistically in order to make it digestible and relevant. That's where you'll be challenged and your knowledge tested.

Tools You Will Learn

Course Advisors &Instructors

SHWETA GUPTAVice President, Tech.

Shweta Gupta has 19+ years of Technology Leadership

experience. She holds a patent and number of publications in

ACM, IEEE and IBM journals like Redbook and developer Works.

MANAS GARGArchitect

Manas Garg heads the Analytics for Marketing at

Paypal. He takes Data Driven Decisions for Marketing

Success.

VISHAL MISHRACEO & Co-Founder

Vishal is a Technology Influencer and CEO of Right

Relevance. (A platform used by millions for content & influencer discovery)

Course Advisors

DILNOOR SINGH MANDAR MULAYMandar Mulay is a Corporate

Software Trainer and Consultant in Databases and Business

Intelligence area. He has 19 years of training experience and is passionate about executing

training in Excel and VBA. Within Databases, he executes training

in Oracle, DB2, SQL Server & Teradata.

RUSHABH SHAH

Trainer Profiles

Rushabh Shah is the Founder & CEO of DLTC.co and Blogger at

ExcelRush.com. His strengths are data & business analysis. To

share his knowledge and experience of working with

various businesses areas, he has trained 1300+ working

professionals and students in Excel Advanced & others.

Dilnoor Singh is SAS Base and SAS Advanced Certified

Professional having a total of 6 years of IT industry experience.

The first 3 years were with pharmaceutical and Insurance

Consulting firms and in the later 3, he has built 2 startups in web

and mobile domains.

RightRelevance

ManagementTeam

ANUJ BATRACEO

Anuj Batra has spent more than 15 years in senior leadership roles at organizations such as Genpact, CPA Global, Electronic Data Systems (EDS) and COLT Telecommunications. He strongly feels that industry interface in professional education makes learning more accessible and students more equipped to take on new roles and jobs.

An astute commercial leader, Anuj has been responsible for the design and implementation of commercial and business strategy as well as key financial roles including leading Corporate Training Programs across several companies. He envisions professional education as a key enabler for enhancing employability.

PRADEEP CHOPRACo-Founder

Among the pioneers of Digital Marketing in India, Pradeep has been part of the Internet Industry since 1999.

Pradeep is an international speaker & an author on Digital Marketing & Entrepreneurship. He is one of the most sought after speakers in Digital Marketing and his speaking assignments include ad-tech, Search Engine Strategies (USA, India), World Social Media Summit at Kuala Lumpur, Social Media Workshops

in Singapore, Click Asia Summit, TiEcon, Global Youth Marketing Forum and NASSCOM India Leadership Forum in India. He writes on Entrepreneurship and Digital Marketing for Wall Street Journal, Inc & Entrepreneur Magazines.

A graduate from IIT Delhi, Pradeep is a core member of the Global Committee at SEMPO (Search Engine Marketing Professional Organization), a non-profit that nurtures the growth of Digital Marketing globally. He also sits on the advisory board of Social Media Chambers Malaysia. His obsession for the digital medium has led him to believe that Internet connectivity is more important than the water supply.

KAPIL NAKRACo-Founder

Kapil Nakra, a graduate from IIT Delhi, is a first-generation Serial Entrepreneur. As a pioneer of Digital Marketing in India, Kapil has grown along with the Internet Industry as a User, a Service Provider and now as an Educator.

He started his entrepreneurial journey in 2000 when he started his 1st venture, Whizlabs Software. At Whizlabs, he pioneered the efforts in building an online market for Whizlabs’

assessment solutions for enterprises and helped Whizlabs acquire over 100 Enterprise Customers including blue-chip accounts such as Cisco purely using Digital Marketing. Whizlabs won the ‘Most Innovative Indian IT Company’ award from NASSCOM in 2004. Kapil is known for his simplistic and inquisitive leading style, which motivates people to think out-of-the-box. It goes without that saying that Kapil has a deep passion for Entrepreneurship and Digital Marketing. He is a regular speaker at various Digital Marketing conferences and his previous speaking engagements include speaking at SearchCamp and OMCAR.

Industry Experts Speak

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.

I can see a good course structure and well-designed syllabus for those who are passionate enough to enter into the analytics world. The platform helps people grow professionally and in very less time.

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.

Naresh MehtaAVP – Data Science & Analytics

Ajay OhriData Scientist

Madhu VadlamaniLead Analytics

Participant Reviews

This course helped me in understanding Python from the basics & got me ready to implement machine learning models successfully.

Shubham ParabSoftware Developer

The course Data science using python at Digital Vidya provided me with a turning track for my career which was fruitful in curving my role as a Data Scientist.

Priytosh SahooData analyst

LifetimeContent Access

FeeRs. 12,500 +GST

Interested? Contact Us!

+91-84680-02880

www.digitalvidya.com

info@digitalvidya.com