Data Analytics using Python with Tableau Online Live Classroom Training

The Data Analytics using Python with Tableau Online live Classroom Training by GingerBoard Academy is 4 weeks, 1.5 hours per day, 5 Days a week covering the basic concepts of Python, covering important libraries used for Data analysis like Pandas, Numpy, Matplotlib, Regex, etc. and Visualization & building dashboard using Tableau. Student will also be doing a project during the training which needs to be submitted one week after the completion of the course.

You will learn through online live classroom and get great hands on experience. This program is packed with assignments, class tests, weekly quiz, coding exercises and final exam.

For doubt clearing you can post query on forum and get answers within 48 hours. Also, a student counceller to connect with on queries and support.

Please Note:

This will be regorous 4 week long program, there will be timed class test before each class of what you have learned a day before. Every week Quiz and aptitude test along with assignment and Final Exam after each module. (Module 1: Data Analysis & Python, Module 2: Tableau & Dashboard). You will also be expected to do a project as final submission for certificate.

Online Live Classroom Course


Course Structure

Unit 1 - Python
  • Introduction to Python Language
  • The advantages of Python over other programming languages
  • Python installation (Windows & Linux distribution for Anaconda Python)
  • Deploying Python IDE
  • Basic Python commands
  • Data types
  • Variables
  • Keywords
  • Built-in data types in Python
  • Tabs and spaces indentation
  • Code comment Pound # character
  • Variables and names
  • Python built-in data types(Numeric, int float, complex, list, tuple, set, dict)
  • Containers
  • Text sequence
  • Exceptions
  • Instances
  • Classes
  • Modules
  • Str(String)
  • Ellipsis Object
  • Null Object
  • Ellipsis
  • Debug
  • Basic operators(comparision, arithmetic, slicing and slice operator, logical, bitwise)
  • Loop and control statements(while, for, if, break, else, continue)
  • How to write OOP concepts in Python
  • Connecting to a database
  • Classes and objects in Python
  • OOPs paradigm
  • Important concepts in OOP(polymorphism, inheritance, encapsulation)
  • Python functions, return types
  • Lambda expressions
  • Connectnig to databse and pulling data
  • The xrange() function
  • List Comprehensions
  • Generator Expressions
  • Dictonaries and Sets
  • Reading data from CSV, Excel, JSON
  • Writing data to CSV, Excel, JSON, HTML
  • Reading data from database and storing in data frame
  • Writing data frame to database
  • Handling PDF files - tabula-py
Unit 2 - Python important libraries
  • Introduction to arrays and matrices
  • Indexing of array
  • Data types
  • Broadcasting of array math
  • Standard deviation
  • Conditional probability
  • Correlation and covariance
  • Pandas
  • Series
  • Constructing from dictionaries
  • Custom index
  • Data Frames
  • Constructing from a dictionary
  • With values as lists
  • Custom indexing
  • Rearranging the columns
  • Accessing values loc(), iloc(), at() & iat()
  • Setting values
  • Sum
  • Cumulative sum
  • Assigning a column to the data frame
  • Adding a new column
  • Deleting a column
  • Slicing
  • Indexing and advanced indexing
  • Boolean indexing
  • Transposing
  • Sort by
  • Concatenate
  • Merge
  • Inner join
  • Outer join
  • left outer join
  • Right outer join
  • Merge on columns
  • Join
  • Group By-Aggregation
  • Data munging
  • Introduction to SciPy and its function
  • Building on top of NumPy
  • Cluster
  • Linalg
  • Signal
  • Optimize
  • Integrate
  • Subpackages
  • SciPy with Bayes Theorem
  • How to plot graph and chart with Python
  • Various aspects of line
  • Scatter
  • Bar
  • Histogram
  • Subplots
  • Math function
  • Scraping using BS4
  • Exploratory data analysis using Python
Unit 3 - Visualisation and Dashboards
  • Scenario
  • Objetives
  • Application Terminology and Definitions
  • Opening and closing tableau
  • Data source page
  • Tableau Workspace
  • Files and folders
  • Gettign started with Tableau
  • View terminoogy and definitions
  • View sections
  • Data Terminology and Definitions
  • View Sections
  • Data Terminology and Definitions
  • Data Types
  • Data Roles: Dimension vs. Measure
  • Data Roles: Continous vs Descrete
  • Changing Data Roles
  • Connecting to Tableau Data Server
  • What is a Join
  • Types of Joins
  • When to Use Joining
  • Enabling Right Outer Join
  • Right Outer Join and Custom SQL Enabled
  • What is Data Blending
  • When to Use Data Blending
  • Data Blending in Tableau
  • Differences Between Joining and Blending
  • Joining vs. Blending
  • Writing Custom SQL
  • Prepare your Data for Analysis
  • Organizing and Simplifying Data
  • Objectives
  • Filtering Data
  • What is a Filter
  • Applying a Filter to a View
  • Filtering on Dimensions
  • Filtering on Dimensions Functions
  • Aggregating Measures
  • Filtering on Measures
  • Filtering on Dates
  • Quick Filters
  • Sorting of Data
  • What is Sorting
  • Sorting Data in Tableau
  • Types of Sorting
  • Creating Combined Fields
  • Combined Fields
  • Creating Groups and Defining Aliases
  • What is a Group
  • What are Aliases
  • Defining an Alias
  • Working with Sets and Combined Sets
  • Sets
  • Combined Sets
  • Working with Groups and Sets
  • Drill to Other Levels in a Hierarchy
  • Grand totals and Subtotals
  • Adding Totals
  • How to Define Aggregations
  • Changing Aggregation Function
  • Tableau Bins
  • Bins
  • Fixed Sized Bins
  • Variable Sized Bins
  • Formatting and Annotations
  • Adding Caption to Views
  • Click Interaction Adding Title to View
  • Click Interaction2 Adding Captions to View
  • Using Titles Captions and Tool tips
  • Adding Tooltips to Views
  • Using Title Caption and Tooltip
  • Formatting the Axes
  • Edit Axis Option
  • Formatting Views with Labels and Annotations
  • Format Window
  • Format Mark Labels
  • Date Hierarchies
  • Drilling in the Time Hierarchy
  • Pivoting Date Parts on Shelves
  • Differentiate Between Discrete and Continuous Dates
  • Using Continuous Dates
  • Using Discrete Dates
  • Working with Discrete and Continuous dates
  • What are Custom Dates
  • Creating and Using Custom Dates
  • Fiscal Year
  • Define a Date Field on a Fiscal Year
  • Relative Date Filters
  • Importing Date Dimensions in Tableau from a Cube
  • Work with Date Hierarchies on Cubes
  • Chart Types
  • Working with Combined Axis
  • Working with Combination Charts
  • Understanding geocoding and geographic mapping in tableau
  • Combined Axis Graph and Scatter Plot
  • Describe text and highlight tables
  • Work with Pages Shelf and Create Motion Charts
  • Heat Maps
  • Using Bins and Histograms
  • Using Histograms
  • Using Pie Charts
  • Compare Measures Using Bullet Charts
  • Using Bar in Bar Charts
  • Using Pareto Charts
  • Creating Pareto Charts
  • Using Waterfall Charts
  • Using Gantt Charts
  • Working with box plots
  • Using Sparkline Charts
  • Calculations
  • Objectives
  • Strings Date Logical and Arithmetic Calculation
  • Working with Strings Date Logical and Arithmetic Calculations
  • Using Strings Date Logical and Arithmetic Calculations
  • Working with Arithmetic Calculations
  • Aggregation Options
  • Working with Aggregation Options
  • Grand Totals and Sub-Totals
  • Quick Table Calculations
  • Creating Quick Table Calculations
  • Working with Quick Table Calculations
  • Automatic and Custom Split
  • Ad-hoc Analytics
  • LOD Calculations
  • Creating and using Parameters
  • Objectives
  • What is a Parameter
  • Creating a Parameter
  • Exploring Parameter Controls
  • Work with Parameters
  • Click Interaction Working with Parameters
  • Dashboards
  • Objectives
  • Build Interactive Dashboards
  • What is a Dashboard
  • Building Dashboards
  • Best practices for creating effective dashboards
  • Comprehending Best Practices
  • Creating a Dashboard and Importing Sheets
  • Interaction Exploring Dashboard Actions
  • Use of Running Actions
  • Using Dashboard Actions
  • Sharing your Work
  • How to Share your Reports
  • Exporting your Work

Reasons to Join this Course

Live Training Classes

Live Training Classes

Project

Project

Councellor and Forum Support

Councellor and Forum Support


Certificate

Certificate

Hands on Practice

Hands on Practice

Technical Interview Preparation during the course

Technical Interview Preparation during the course

Pursue your Dream Career with our Best Courses and expert trainers! Register Today!

Connect with us