Databyte Academy

About the Program

About The Certified Data Analyst Program

This course is designed for beginners or non-programmers who are interested in building their career in Data Analytics.

The field of data analysis, as the name implies, analyses data to discover trends. It has tremendous uses in the fields like Banks & Finance Industry, Telecommunication, Airlines, Oil and Gas, Manufacturing, Insurance, Retail, Healthcare, Government, Aerospace & Defense, Fast Moving Consumer Goods (FMCG), Hi-Tech, Pharmaceutical, Hotels & Hospitality, Travel and Tourism, Media, Real Estate, Engineering, Sports, E-commerce, Energy and Utility, Automotive, Non- Profit, Chemicals, Advertising and Public Relations etc.. who rely on quality data analysis to arrive at strategic business decisions.

Working professionals can definitely improve their resume and their job prospects by achieving a certificate in data analytics together with a Global Base SAS Certification.

Course Objective

This course will encompass all to help you emerge as an Industry ready professional in the field of analytics.

  1. This course is to help you to become a successful Data Analyst. It will teach you how to make powerful reports, creating dashboards, working with MS Access and SQL databases, along with a strong focus on case studies to ensure hands-on learning.
  2. In this program, you will also learn the powerful Data visualization tool, Tableau, one of the most popular data visualization and rapid BI tool to bring more interactive features to your analysis.
  3. This program is also power-packed with analytics training for beginners who wants to get globally recognized SAS certification to further to the next level. This SAS course explores the SAS tool and different techniques to help you access and manage data, create data structures, generate reports, and handle errors.

Who should do this course?

  1. Students from various quantitative backgrounds, like Engineering, Finance, Maths, Statistics, Economics, Business Management
  2. Professionals working with data in any industry
  3. Analytics consultants
  4. IT/Software Professionals
  5. Anyone who aspires to spearhead their career in Data Analytics.

Who are the trainers?

Our trainers are highly qualified industry experts and certified instructors with global analytical experience in delivering training.

Prerequisites

Computer literacy and knowledge of working with basic Microsoft Excel is necessary.

I would like to know more

""
1
Nameyour full name
Contact Number
Subject
Messagemore details
0 /
Previous
Next

Databyte Academy Instructors

Learn from practitioners, not from trainers.

SUMEET BANSAL

CEO & Co-Founder of Analytixlabs

Sumeet is a former Business Consultant and worked with prestigious companies like McKinsey & Company, ZS Associates and AbsolutData in the past 7 years. He has worked in more than 10 countries and is an expert in Market Research and Business Analytics. He co-founded AnalytixLabs in 2011, and has taken up the lead role from 2014 onward. He has worked extensively in domains such as Market Research, Brand positioning, Building Go-to-market strategies, Customer Lifecycle Management and Pricing for clients in various sectors like Automotive, Banking, Hi-tech, Pharma and Telecom.


CHANDRA MOULI

Chief Data Scientist

Chandra has got rich experience in the field of Marketing and Risk Analytics, which he has attained during his meticulous tenure with companies like McKinsey & Company, Genpact and erstwhile Citigroup Services. He has 8+ years of experience and has been working in the domain of Analytics since 2006 after completing his education from IIT-Madras. With his analytical rigour he has effectively helped various Banking & Financial Services, Media and Retail clients with Pre & Post campaign management, Credit risk, Attrition modelling, Cross sell and Up sell programs. He was also recently featured in the top 10 data scientists in India by the Analytics India Magazine.


Ankita Gupta

Principal Consultant

Ankita has more than 8 years of experience with McKinsey, where she focused on Market Research and Behavioural Analytics working with global clients in domains like Hi-Tech, Telecom, Banking and Retail. Post McKinsey, she joined Fidelity as Snr Specialist, to lead the NPS analytics effort for their various business apart from looking into possible B2C analytics. Ankita is an expert in quantitative marketing research such as conjoint, attitudinal segmentation, pricing and brand equity along with measuring consumer loyalty. She holds an MBA from ISB, Hyderabad.

Exam & Certification

The certification is provided by Databyte Academy

Upon successful completion of the program, students will be conferred with dual certification:

1) Certificate of Completion
2) CERTIFIED DATA ANALYST*

In order to be “Certified” as part of the course, students need to complete the assignments and examination. Once all your assignments are submitted and evaluated, the certificate shall be awarded.

New Intake – 21st August 2017


Certified Data Analyst

Course ID – CDA
Duration – 64 Hours
Classes – 8 Days
Learning Mode – Instructor Led-Classroom Training
Next Batch – Full Time (21st August 2017) & Weekend (19th  August 201t)

Course Outcome

You will have clear understanding of Data Analytics and how to manage & visualize the data. All the modules structured using real time, industry relevant data sets to enhance your analytics capabilities and problem solving abilities.

Course Content

The field of data analysis, as the name implies, analyses data to discover trends. It has tremendous uses not only in the economics and financial sector but fields like law, healthcare, public administration, politics, telecom, social media, manufacturing, banking & financial institutions etc. who rely on quality data analysis to arrive at strategic business decisions. Working professionals can definitely improve their resume and their job prospects by achieving a certificate in data analytics.

Exploratory Data Analysis Using Excel

  1. Introduction to Excel
  2. Working with Formulas and Functions
  3. Creating Charts and Graphics
  4. Analyzing Data with Excel
  5. Essentials, preparing data for the dashboard
  6. Data Prep & Reduction techniques
  7. Data Analytics Using Excel

Visusal Analytics Using Excel (Reporting & Dashboarding)

  1. Overview of Dash boarding
  2. Deciding On Dashboards
  3. Essentials, preparing data for the dashboard
  4. Understanding which Excel tools are essential for dashboards
  5. Charting (Pivot Charts & Normal Charts)
  6. Advanced Power Charting Techniques
  7. Adding ActiveX controls
  8. Trends & Scenarios
  9. Creating your Excel Dashboards
  10. Macros
  11. User Defined Functions
  12. Dashboard Macros
  13. Bullet-proofingyour Dashboards
  14. Practical Dashboard Creation: Hands – on Dashboard Creation

DBMS/RDBMS Using MS ACCESS (SQL)

  1. Introduction to MS Access
  2. What is SQL – A Quick Introduction
  3. Getting started
  4. Understanding basic RDBMS concepts
  5. Data manipulation – Reading & Manipulating a Single Table
  6. Data based objects creation (DDL Commands)
  7. Optimizing your work
  8. Data manipulation – CaseStudy-1
  9. Data manipulation – Case Study-2

Visual Analytics Using TABLEAU

  1. Getting started
  2. Data Manipulation
  3. Basic Data Analysis
  4. Maps
  5. Calculated Fields
  6. Parameters
  7. Building & customizing Dashboards
  8. Working with Data

Base SAS

  1. Introduction To Data Science
  2. Accessing Data
  3. Creating Data Structures
  4. Managing Data
  5. Handling Errors
  6. Generating Reports

Once armed with the analytics, you will also learn the powerful Data visualization tool Tableau to bring more interactive and slice and dice features to your analysis. Click Here To Download

I would like to know more

""
1
Nameyour full name
Contact Number
Subject
Messagemore details
0 /
Previous
Next

Get Ahead with Databyte’s Certificate

Earn your Certificate

Our Certified Data Analyst program is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Differentiate yourself with a Certificated Data Analyst

The knowledge and skills you’ve gained working on projects, simulations, case studies will set you ahead of competition.

Share your achievement

Talk about it on Linkedin, Twitter, Facebook, boost your resume or frame it – tell your friends and colleagues about it.

Learning Path

Login Form

Register Form