Data Analytics Certificate Course

Download as pdf or txt
Download as pdf or txt
You are on page 1of 15

Data Analytics

Certificate Course
Take Practical Decisions Using Data Analytics Course

Hybrid- Live Online


Part Time 136 Hours
& Classroom

Certificates Awarded by
Course Highlights

136 Hours 100+ Hours


Blended - Online and Classroom Assignments and practicals

2+ Lifetime
Capstone projects Access to LMS

Prerequisites
Need basic computer skills

Basic mathematical concepts knowledge

Analytical mindset is recommended

Basic excel knowledge is mandatory

Course Objective
The Data Analytics course empowers you with all the needed skills and leverages the power of data to
make intelligent business decisions. This program covers the responsibilities of various roles in the
domain of Analytics, including Business Analysis, Data Analyst, Data Scientist, Data Engineer, AI Expert,
Project Managers for Data Analytics, Chief Data Officers, etc.The quizzes and exams will reinforce the
learning and help take corrective actions before the students face the job market with confidence.
Programming languages, tools and algorithms that one will learn will be most advanced starting right
from the basics.

2 | www.360DigiTMG.com
360DigiTMG Advantages

AI driven Learning Management System (LMS)

01 Students will be provided with LMS access for lifetime, which includes class
recordings, self-paced videos, assignment course works, reference materials,
datasets, algorithms, etc.

15+ years experience training faculties

02 Faculties with 15+ years of average experience and hail from top universities
including IIT, ISB, IIM. Our trainers trained a lot of corporate clients, which
includes many Fortune 500 companies.

Trained 20,000+ professionals

03 Carries a legacy of training 20,000+ professionals and 10,000+ students from


across the globe. Our program has been approved by 3 leading international
universities /accreditation bodies.

Curriculum

04 Curriculum has been meticulously designed by industry experts by considering


student communities as well as working professionals.

05
Career Mentorship & Placement Assistance
With 98% job placement success rate for the students who met the training
requirements, our success rate is the highest in the industry.
Learning Outcomes
Perform Data Visualization and Descriptive Statistical Analysis using Python

Perform load, retrieve, update, and delete the data in RDBMS

Analyse Structured and Unstructured data using different SQL and NoSQL queries

Develop an understanding of row-oriented and document-based database systems

Apply data-driven, visual insights for business decisions using Power BI and Tableau

Build Business Intelligence reports and dashboards and reports for day-to-day applicability

Develop live reports from streaming data to take proactive business decisions

Use Advanced Excel concepts to represent data for easy understanding

Form relationships in your data model and learn data visualization best practices

Who should attend


Business Analysts, Data Analyst, Employers planning to adopt a
Data Scientist, Data Engineer, digital-based business approach
Project Managers for Data Analytics leading to productivity and
or Data Stream projects sustainability of the business

Schools, Universities and Colleges Candidates aspiring to be Data


looking to upskill their faculties in Analyst, Analytics Manager /
Digital Courses Professional, Business Analyst,
Developer in Data Analytics

Industries applicable: Banking, Insurance, Finance Retail, E-commerce, Marketing,


Travel & Tourism, Agriculture, Consulting, Customer Service, Education, Engineering,
Finance, Government, Health, Mining Hospitality, Hospitals, Human Resources,
Information Systems, Information Technology, Law Enforcement, Manufacturing,
TeleCommunication, Oil and Gas, Public Relations, Purchasing, Quality Assurance,
Software Development, Training, etc.

4 | www.360DigiTMG.com
Course Modules
Python • Filtering - Dimension Filters, Measure Filters,
Date Filters, Tableau Context Filters
• Python Introduction
• Groups, Sets and Combined Sets
• Python Data Structures, Dictionaries & Sets
• Reference Lines, Bands and Distribution
• Python Packages for Analysing the Data
• Parameters - Dynamic Parameters,
• Advance Python Programming
Parameter Actions
• Advance Python Programming:
• Forecasting - Exponential Smoothing
Web Extraction and Serialization
Technique
• Descriptive Statistical Analytics / EDA
• Data Mining Unsupervised Learning -
• Data Visualization using Python Libraries Clustering
such as Matplotlib, Seaborn, Bokeh, Plotly
• Calculated fields in Tableau, Quick Table
Calculations, LOD Expressions
Tableau
• Tableau Mapping Features
• Data Visualization Introduction and • Tabeau-R and Tableau-Python Integration
Concepts
• Tableau-SQL integration
• Tableau Introduction and
• Tableau Interactive Dashboards, Dashboard
Tableau Architecture
Actions, Stories
• Exploring Data using Tableau
• Tableau Certification Orientation
• Working with Data using Tableau including
Data Extraction and Blending Power BI
• Various Charts in Tableau
(Basic to Advanced) • What is Power BI?

• Hierarchies - Tableau Drill Down and Roll • Transforming Data using Power BI Desktop
Up Features • Data Cardinality and Data Modeling in
• Sorting - Quick Sort, Sort from Headers, Power BI Desktop
Legends, Axis, Tool Bar; Sort by Fields, • Introduction to DAX
Nested Sort • Visualizing Your Data

The goal is to turn data into information


and information into insight.
Carly Fiorina,
former chief executive officer and chair
Hewlett-Packard Company

5 | www.360DigiTMG.com
• Power BI-R Integration, Power BI-Python • Automate Excel Formulas
Integration, Power BI-SQL Integration • Working with VBA Forms
• Advance Visualization Visualizations
• Power BI Dashboards SQL
• Organization Packs, Security - • What is Database
Working with Others
• Types of Databases
• DBMS vs RDBMS
Excel
• DBMS Architecture
• Statistical Analysis using Excel • Normalisation & Denormalization
• Business Moments • Install PostgreSQL
• Graphical Techniques using Excel • Install MySQL
• Inferential Statistics • Data Models
• Hypothesis Testing using Excel • DBMS Language
• Entering and Editing Text and Formulas • ACID Properties in DBMS
• Woking with Basic Excel Functions • What is SQL
• Formatting Data in an Excel Worksheet • SQL Data Types
• Creating Basic Charts in excel • SQL commands
• Excel Functions • SQL Operators
• Working with an Excel List • SQL Keys
• List Functions • SQL Joins
• Data Validation • GROUP BY, HAVING, ORDER BY
• Pivot Tables • Subqueries with select, insert, update,
• Conditional Functions delete statements?
• Lookup Functions • Views in SQL
• Text Based Functions • SQL Set Operations and Types
• What-IF Tools • SQL functions
• Understanding Why and • SQL Triggers
How behind Excel Macros • Introduction to NoSQL Concepts
• VBA Variables and Operators • SQL vs NoSQL
• Database connection SQL to Python

Search interest in “Business Intelligence”


has grown by 132% over the last five years.

6 | www.360DigiTMG.com
Tools Covered

Key Benefits
Integration between the tools is covered in detail.

Python Tableau Python Power BI R Tableau R Power BI


SQL Tableau SQL Power BI Python SQL R SQL

7 | www.360DigiTMG.com
Best Practical Learning Experience

e-Introduction to Program

Live or Classroom Sessions

Assignments

Weekly Clarification Sessions

Monthly Webinar sessions

Final Exam by 360DigiTMG

Post-Learning and advanced


course videos

Placement Assistance

Review and Re-attend sessions


Learning Journey continues
Next recommended courses for your career progression

Data Science Using Python Data Engineering Full Stack Data Science

Job Roles to Aim


Data Analyst BI Analyst Data Modeller Data Scientist

Panel of coaches

Sharat Kumar Bhargavi Kandukuri


VP - Data Science Senior Data Analyst
Research in Analytics, Business Intelligence, Power BI,
Big Data, Deep Learning Tableau, SQL, Python

Tarakeshwari Junge Sampath Bukya


Data Scientist Data Scientist

9 | www.360DigiTMG.com
Industry Career Services

100+ hours 3+ mock interviews


Interview preparation session with industry experts

Search

PROFILE
JOHN Lorem ipsum dolor sit amet, consectetuer

SMITH
adipiscing elit, sed diam nonummy nibh
euismod tincidunt ut laoreet.

Dolore magna aliquam erat volutpat. Ut wisi


TITLE POSITION enim ad minim veniam, quis nostrud exerci
Lorem ipsum dolor sit amet, adipiscing elit, sed
diam aliquip ex ea commodo consequat. tation ullamcorper.

JOHN SMITH
TITLE POSITION
PROFILE
Lorem ipsum dolor sit amet,
consectetuer adipiscing elit.
Lorem ipsum dolor sit amet, consectetuer
adipiscing elit, sed diam aliquip ex ea commodo. Dolore magna aliquam erat volutpat.
Lorem ipsum dolor sit amet,
Username sed diam nonummy.
Ut wisi enim ad minim veniam, quis
nostrud.
Lorem Ipsum Dolor Follow
Cdmx. MX · Contact Information Lorem ipsum dolor sit elit,
sed diam nonummy.

I am interested Add section More

Lorem ipsum dolor sit amet, consectetuer Lorem ipsum dolor sit amet, consectetuer
adipiscing elit, sed diam aliquip ex ea commodo. adipiscing elit, sed diam aliquip ex ea commodo.
Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet.
Username
Lorem Ipsum Dolor

Connect
Profile level: Advanced
Username
Lorem Ipsum Dolor

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, Connect


sed diam aliquip ex ea commodo consequat.

Username
Lorem Ipsum Dolor

Connect

Support on LinkedIn Support on


profile preparation resume preparation

Live projects in support with

Mobile App

Web App
Social Media
Data Visualisation
Web App

Raw
Data
Data Ingestion

IoT ML Code
Fat API docker
Pre Processed Model Building
Github
Data and Evaluation
Database

Code Container
repository
Web Sources
Model Ready
Data Mobile App

Web App

Monitoring and Maintenance Model Deployment


Flat Files Web App

10 | www.360DigiTMG.com
Get Certified! Get Recognized!
Upon successfully completing the programme with a minimum 50% score, you will be awarded with
Block chain enabled digital Certificate on Data Analytics from 360DigiTMG and IBM Certificate.

All samples shown are for illustration purposes only. Actually certificate
might vary based on course enhancements and awarding body

11 | www.360DigiTMG.com
A statement from the leader

CEO's message
We have upped the ante. We have pressed on the
gas pedal. We have transformed over years with our
AI capabilities-driven learning aids, which includes
our AiTutor for effective analysis based on the
learning behaviors of students. These insights will
make the learning actionable.

This goes back to our pledge of bringing the best in


you and with the killer objective of job placement for
our students, we filled "Job - The Ultimate Destiny" in
our DNA.

With the introduction of AI driven Soft Skills +


Industry Leader Talks + Alumni Connect we intend to
make the learning journey lucrative and enjoyable
like never before.

With our broad theme - "We don't just train, we


transform careers", I wish you success in your
upskilling, which is the only constant in life.

Bharani Kumar Depuru


Founder & Director
360DigiTMG and
Innodatatics Inc, USA

13 | www.360digitmg.com
Our Alumni Work at
Testimonials

I had great fun and a fabulous experience in this course. The


teaching was good but I really felt that the live project experience
was the best part of this course. Placement cell is very sincere
Nikhil Miriyala

The course was well structured and our trainer was very
thorough in the concepts. Placement training and interview
preparations helped me to switch my career to Data Science.
Thanks to 360DigiTMG.
Seshadri M

I felt very comfortable with teacher and the subjects taught.


They covered most of the concepts and gave us several
assignments. Teaching was interactive and lively. I got a
lovely job. I am so happy.
Sowjanya V

The faculty went to great depths to clarify our doubts.


They gave us a lot of assignments and one very
challenging live project. Great place to study.
Venu Panjarla

14 | www.360DigiTMG.com
Accreditation to international certification bodies

SUD

For further details, call us at

1800-212-654321

enquiry@360digitmg.com 360digitmg.com

Hyderabad: 2-56/2/19, 3rd Floor, Vijaya Towers, Ayyappa Society Road,


Madhapur, Hyderabad, Telangana 500081

Bengaluru: No 23, 2nd Floor, 9th Main Road, 22nd Cross Road,
7th Sector, HSR Layout, Bengaluru, Karnataka 560102

Chennai: C1, No.3, 3rd Floor, Alkasha Centre, Old Mahabalipuram Road,
NJK Avenue, Thoraipakkam, Tamil Nadu 600097

• 360DigiTMG does NOT promise or guarantee a job or progression in your current job if the conditions are not met
• Career Services is only offered as a complimentary service to manage your career proactively
• All product and company names in the alumni page are trademarks or registered trademarks of their respective holders.
Use of them does not imply any affiliation with or endorsement by them

You might also like