Subtopi
Topic Session No. Planned Session Date
cs
Data Exploration
Characteristics of Data Exploration
Exploration And Explanation The art of Data-Driven Storytelling
In Data- 1
Driven Storytelling(A) Data Storytelling
Dimensions of data- driven visual stories
What is Data Interpretation?
Exploration And Explanation Qualitative Data Interpretation
In Data- 2 Why data interpretation is important
Driven Storytelling(B) Data Interpretation Methods, Summary,
List & Tips
Analysis Method and Process
Data-driven Storytelling Visualization-Driven Storytelling
Techniques & Techniques
3
Communicating Data To An What Does the Audience Know?
Audience What Does the Audience want?
Specific Design Contexts
Intro to Tableau
Tableau Public
Data Visualiz
Tableau- Intro to Tableau & Tableau Ushered-in Era of Visual Analytics
ation using 4
Connect various
Tableu Tableau Pricing
Connect various data files using tableau
Tableau various graphs Tableau- various graphs
5
Dimensions and measures Dimensions and measures
Draw charts in tableau & Draw charts in Tableau
Superstore example to draw 6
basic charts Superstore example to draw basic charts
Example of Calculated Fields
Why Use Calculated Fields?
Example of calculated fields 7
Create a Calculated Field
Create a Simple Calculated Field
Examples of filters and various chart
enhancement in tableau
Examples of filters and Tableau Tips, Tricks and Hacks to Enhance
various chart enhancement Dashboards
8
in tableau & Publish tableau Publish tableau dashboards
dashboards
Publish tableau dashboards/Workbooks
various chart enhancement
8
in tableau & Publish tableau
dashboards
Publish your workbook
Python Introduction- Anaconda IDE,
Spyder and Jupyter Notebook. Explain the
Python - Anaconda IDE 37 nuts and bolts
and Conditionals and Variable declaration and defining functions
Iterations in Python
If and else if statement
38
Python vs R
Functions, Data Types, Loops in python
Advanced Functions 39
String manupulation
Python data types and Different data types in python
exception handling 40
Exception handling in python
read write files in python
41
DATA Pandas various functions
Pandas and numpy
SCIENCE Numpy functions
42
WITH PYTH Loops practicals
ON data types hands-on
43
Practicals on Pandas
Practicals on Pandas
44
creating functions in python
Simple programming
Plot histogram, bar chart using matplotlib
45
Plot pie chart, heat map, line graphs using
matplotlib
Handson on reading and writing files.
46
Change the type of data.
Hands on and Case 47 Hands on and Case Study
Study 48 Hands on and Case Study
49 Hands on and Case Study
Topics Nee Date
1. Introduction to Database Systems
Concept & Overview of DBMS, Data
Models, Database Languages, Database Administrator, Database Us
ers, Three Schema architecture of DBMS
2. Entity-Relationship Model
Basic concepts, Design Issues, Mapping Constraints, Keys, Entity-
Relationship Diagram, Weak Entity Sets, Extended E-R features.
3. SQL and Integrity Constraints
Concept of DDL, DML, DCL. Basic Structure, Set operations,
Aggregate Functions, Null Values, Domain Constraints, Referential
Integrity Constraints, assertions, views, Nested
Subqueries, Database security application development using SQL,
Stored procedures and triggers.
ATABASES MANAGEMENT SYSTEM Database Design
4. Relational
Functional Dependency, Different anamolies in designing
a Database., Normalization using funtional dependencies,
Decomposition, Boyce-Codd Normal Form, 3NF, Nomalization using
multi-valued depedencies, 4NF, 5NF
5. Structure Query Language and Advance SQL Programming
Data Manipulation Language on SQL programming to feed and
query relation database objects.
