Academy of Data Science

Request A Call Back
Apply For franchise
Menu
Menu

MicroDegree Program in Data Science with Tableau

Course Duration

  • 180 Hours
  • 5 sessions/week

Tools Covered

  • Tableau
  • MSSQL, ETL & SSIS
  • Python

Learning Mode

  • Online Live Classes
  • One on one Interactive session

We provide

  • Special sessions for doubt solving
  • Sessions recordings (on request)
  • Sessions documents (on request) 
  • Assignments Mock interview
  • Live Projects

Tableau Course Content

1. Introduction to Tableau

  1. Introduction to Tableau
  2. SSBI Tools
  3. Why Power Tableau?
  4. Building Blocks of Tableau
  5. Getting started with Tableau.
  6. Get Tableau Tools
  7. Introduction to Tools and Terminology
  8. Dashboard in Minutes
  9.  Interacting with your Dashboards

2. Tableau Basic

  1. Connecting Tableau to a Data File – CSV File
  2. Navigating Tableau
  3. Creating Calculated Fields
  4. Adding Colors, Adding Labels and Formatting
  5. Exporting Your Worksheet
  6. Get The Viz
  7. Working with Data Extracts in Tableau
  8.  Working with Time Series
  9. Understanding Aggregation, Granularity, and
    Level of Detail
  10. Creating an Area Chart & Learning About
    Highlighting
  11. Adding a Filter and Quick Filter
  12. Time series, Aggregation, and Filters

3. Joining and Charts in Tableau

  1. Relationships vs Joins (v. 2020.2 update)
  2.  Joining Data in Tableau
  3. Creating a Map, Working with Hierarchies
  4. Creating a Scatter Plot, Applying Filters to
    Multiple Worksheets
  5. Let’s Create our First Dashboard!
  6. Adding an Interactive Action – Filter &
    Highlighting
  7. Understanding how LEFT, RIGHT, INNER, and
    OUTER Joins Work
  8. Joins With Duplicate Values
  9. Joining on Multiple Fields
  10. The Showdown: Joining Data v.s. Blending
    Data in Tableau
  11. Data Blending in Tableau
  12. Dual Axis Chart
  13. Creating Calculated Fields in a Blend
    (Advanced Topic)
  14. The Data Model
  15. Working with Relationships in Tableau

4. Advance Data Transformation

  1. What Format Your Data Should Be In
  2.  Data Interpreter
  3. Pivot
  4. Splitting a Column into Multiple Columns
  5. MetaData Grid
  6. Fixing Geographical Data Errors in Tableau

5. Calculated Table And Advanced Dashboard

  1. Downloading the Dataset and Connecting
    to Tableau
  2. Mapping: how to Set Geographical Roles
  3. Creating Table Calculations for Gender
  4. Creating Bins and Distributions For Age
  5. Leveraging the Power of Parameters
  6. How to Create a Tree Map Chart
  7. Creating a Customer Segmentation
    Dashboard
  8. Advanced Dashboard Interactivity
  9. Analyzing the Customer Segmentation
    Dashboard

6.Clusters, Custom Territories, Design Features

  1. Custom Territories Via Groups
  2. Custom Territories Via Geographic Roles
  3. Adding a Highlighter
  4. Clustering In Tableau
  5. Cross-Database Joins
  6. Modelling With Clusters
  7. Saving Your Clusters
  8. New Design Features
  9. New Mobile Features

MSSQL Course Content

1. Databases – MySQL and SQL Queries

  1. Introduction to MySQL
  2. What is the MSSQL?
  3. How do I Install MSSQL?
  4. Connecting to the MSSQL
  5.  Creating and Selecting a database
  6.  Adding data to a table
  7. Executing multiple queries
  8. Exporting and Importing data tables.

2. Structural & Functional Database Management (DDL DML)

  1. SQL Syntax
  2. SQL Create Command
  3. SQL Alter Command
  4. SQL Truncate
  5. SQL Delete
  6. SQL Update
  7. SQL Set
  8. SQL Select
  9. SQL Distinct
  10. SQL Where Clause
  11. SQL And & Or
  12. SQL Order By
  13. SQL Insert 
  14.  

3. SQL Functions

  1. Single Row Functions
  2. String Functions, Aggregate Function, Round,
    Truncate, Max, Min, Date-Time Functions
  3. General Functions
  4. Count, Average, Sum etc.

4. Joining Tables

  1. Obtaining data from Multiple Tables
  2. Types of Joins (Inner Join, Left Join, Right Join &
    Full Join)
  3. Sub-Queries Vs. Joins

5. Operators (Data using Group Function)

  1. Distinct, Order by, Group by, Equal to etc. 

6. Database Objects (Constraints & Views)

  1. Not Null
  2. Unique
  3. Primary Key
  4. Foreign Key

7. SQL Advance

  1. SQL Like
  2. SQL Wildcards
  3. SQL In
  4. SQL Between
  5. SQL Alias
  6. SQL Union/Union All

9. SSIS SQL Server Data tool (SSDT)

  1. Data Import Export
  2. Transformations
  3. Variables
  4. Parameters
  5. Containers 

10. SQL Aggregate Functions

  1. SQL Avg()
  2. SQL Count()
  3. SQL Max()
  4. SQL Min()
  5. SQL Sum()
  6. SQL Group By clause
  7. SQL Having clause

11. Cloud Azure Data Factory

  1. resource group
  2. storage account
  3. Pipeline
  4. Data Factory supports two types of
    activities:
     a) data movement activities
     b) data transformation activities
  5.  activity like(copy activity ,lookup activity ) link service
  6. Integration Runtime
  7. dataset
  8. source
  9.  sink

Python Course Content

Introduction to Python

  1. What is Python?
  2. Why Python?

Variables in Python

  1. What is Variable?
  2. Variables and Constants in Python
  3. Variable, names and Value
  4. Values and Types
  5. What Does “Type” Mean?

String Handling

  1. What is string?
  2. String operations and indices
  3. Basic String Operations
  4. String Functions, Methods
  5. Delete a string
  6. String Multiplication and concatenation
  7. Python Keywords, Identifiers and Literals
  8. String Formatting Operator
  9. Structuring with indentation in Python
  10. Built-in String Methods
  11. Define Data Structure?
  12. Data Structures in PYTHON

Python Operators and Operands

  1. Arithmetic, Relational Operators and Comparison Operators
  2. Python Assignment Operators
  3. Short-hand Assignment Operators
  4. Logical Operators or Bitwise Operators

Python Conditional Statements

  1. How to use “if condition” in conditional structures
  2. if statement (One-Way Decisions)
  3. if .. else statement (Two-way Decisions) 
  4. How to use “else condition”
  5. Logical Operators or Bitwise Operators
  6. if .. elif .. else statement (Multi-way)
  7. How to use “elif” condition
    Nested IF Statement

Python LOOPS

  1. How to use “While Loop” and “For Loop”
  2. How to use For Loop for set of other things besides numbers
  3. Break statements, Continue statements, Enumerate
  4. function for For Loop
  5. Practical Example
  6. How to use for loop to repeat the same statement over and again
  7. Break, continue statements

Learning Python Strings

  1. Strings
  2. Lists
  3. Tuples

Python Lists

  1. Lists are mutable
  2. Getting to Lists
  3. List indices
  4. Traversing a list
  5. List operations, slices and methods
  6. Map, filter and reduce
  7. Deleting elements
  8. Lists and strings

Python TUPLE

  1. Advantages of Tuple over List
  2. Packing and Unpacking
  3. Comparing tuples
  4. Creating nested tuple
  5. Using tuples as keys in dictionaries
  6. Deleting Tuples
  7. Slicing of Tuple

Python Sets

  1. How to create a set?
  2. Iteration Over Sets
  3. Python Set Methods
  4. Python Set Operations
  5. Union of sets
  6. Built-in Functions with Set
  7. Python Frozenset

Variables in Python

  1. What is Variable?
  2. Variables and Constants in Python
  3. Variable, names and Value
  4. Values and Types
  5. What Does “Type” Mean?

Python Dictionary

  1. How to create a dictionary?
  2. Python Dictionary Methods
  3. Copying dictionary
  4. Updating Dictionary
  5. Delete Keys from the dictionary
  6. Dictionary items() Method
  7. Sorting the Dictionary
  8. Python Dictionary in-built Function
  9. Dictionary len() Method
  10. Variable Types
  11. Python List cmp() Method
  12. Dictionary Str(dict)

Python Functions

  1. What is a function?
  2. How to define and call a function in Python
  3.  Types of Functions
  4.  How Function Return Value?
  5. Types of Arguments in Functions
  6. Default Arguments and Non-Default
    Arguments
  7. Keyword Argument and Non-keyword
    Arguments
  8.  Rules to define a function in Python
  9. Scope and Lifetime of variables
  10.  Nested Functions
  11. Call By Value, Call by Reference
  12. Passing functions to function

Python Date and Time

  1. How to Use Date & DateTime Class
  2. How to Format Time Output
  3. How to use Timedelta Objects
  4. Calendar in Python
  5. datetime classes in Python
  6. How to Format Time Output?
  7. The Time Module
  8.  Python Calendar Module
  9. Python Text Calendar, HTML Calendar Class
  10. Unix Date and Time Commands

File Handling

  1. What is a data, Information File?
  2. File Objects
  3. File Different Modes and Object Attributes
  4. How to create a Text Fil and Append Data to a File and Read a File
  5. Closing a file
  6. Read, read line ,read lines, write, write
    lines…!!
  7. Renaming and Deleting Files
  8. Directories in Python
  9. Working with CSV files and CSV Module
  10. Handling IO Exceptions

Python Exception Handling

  1. Chain of importance Of Exception
  2. Exception Handling
  3. Try … Except
  4. Try .. Except .. else
  5. Try … finally
  6. Argument of an Exception
  7. Python Custom Exceptions
  8. Ignore Errors
  9. Assertions
  10. Using Assertions Effectively

More Advanced PYTHON

  1. Python Iterators, Generators, Closures,
    Decorators and Python @property

Python Class and Objects

  1. Introduction to OOPs Programming
  2. Object Oriented Programming System
  3. OOPS Principles
  4. Define Classes
  5. Creating Objects
  6. Class variables and Instance Variables
    Constructors
  7. Basic concept of Object and Classes