Python Training

Python uses dynamic typing, and a combination of reference counting and a cycle-detecting garbage collector for memory management. It also features dynamic name resolution (late binding), which binds method and variable names during program execution. Register Today

Python Training Plans

  PLAN A PLAN B PLAN C
Description Python PL-SQL &
Python
PL-SQL,
Tableau & Python
Total Duration 4 Weeks 8 Weeks 12 Weeks
Completely Real-time, Practical
Mock Interviews, Case Studies
Python: Modules
Python: Detailed Design of Interactive
Python: Python Dictionary
Python: Introduction to Web
Python: GUI Programming-Tkinter
SQL : Basic SQL, SQL Server Concepts
PL-SQL : Queries, Joins, Group By
PL-SQL : Queries, SProcs, Lock Hints
PL-SQL: Queries, Normal Forms, Excel
Working with Tableau Online
Tableau Desktop & Reports
Groups, Sets, Hierarchies
Filters, LOD Expressions
Actions, Bookmarks, Calc
Tableau Prep and ETL
Tableau Server, Online
Table Admin & Security
Dashboards & Worksheets - Security
Tableau : Real-time Project
Total Course Fee * INR 6,000
USD 81
INR 11,000
USD 149
INR 19,000
USD 257

Python Training Schedules :

S No Timings (IST) Start Date Register
Schedules for Oracle SQL & PL-SQL
1 6:30 AM - 7:30 AM May 6th Register
2 10:30 AM - 11:30 AM May 19th Register
3 5:30 PM - 6:30 PM May 12th Register
4 8:30 PM - 9:30 PM June 1st Register
Schedules for Python Training
1 7:30 AM - 8:30 AM May 12th Register
2 6:30 PM - 7:30 PM June 2nd Register
3 8:30 AM - 10:30 AM (w) May 22nd Register
Schedules for Tableau Training
1 9:30 AM - 10:30 AM May 6th Register
2 7:30 PM - 8:30 PM June 3rd Register
3 6:30 AM - 8:30 AM (w) May 15th Register

Oracle SQL & PL-SQL Training Highlights :

Real-Time Training Practical Training
DDL, DML, DCL, TCL Commands Queries, Joins
Query Tuning CTEs, TVPs
Excel Imports PIn-Memory Tables
Cloud (Service) with Reports Dashboards & Apps
Tableau Server Configuration Data Refresh Options
Project for your Resume Excel, Database Sources

If above schedule does not work, opt for Tableau Training Videos

 

Python Training Course Contents:

Part 1: Tableau Report Design - 1

Part 2: Tableau Report Design - 2

Part 3: Tableau Prep, Server, Online

Ch 1 : TABLEAU INTRO, INSTALLATION

  • Introduction to Tableau, Reporting Tools
  • Report Types in Real-time: Interactive
  • Paginated, Analytical and Mobile Reports
  • Data Sources for Report Design Process
  • Tableau as a Self Service BI Tool
  • Tableau Features, Technical Advantages
  • Data Sources Types in Tableau
  • Tableau Training : Course Plan, Lab
  • Tableau Public Desktop : Installation
  • Tableau Prep Tools - Data Modelling
  • Power BI Licensing Plans - Types
  • Worksheets, Marks, Shelves, Axis
  • Basic Report Design Terminology
  • Data Sources, Connectors, Clients
  • Study Material, Certifications, FAQs

Ch 7 : TABLEAU VIZ - LEVEL 3

  • Tableau Treemaps & Nested Rectangles
  • Marks Type, Color, Size and Label
  • Comparing Treemaps with Bars & Tables
  • Circle View Vizualization and Usage
  • Side By Side Circle View, Usage
  • Scatter Plot - Labels, Axis Items
  • Packed Bubbles and Circles - Lables
  • Tableau Symbol Maps - Examples
  • Tableau Filled Maps - Examples
  • Using Quick Table Calculations
  • Histogram Charts and Properties
  • Measures and Value Comparisions
  • Tableau Motion Charts and Axis
  • Bullet Graphs and Limitations
  • Dimension - Measure Considerations

Ch 13 : DASHBOARDS & STORIES

  • Creating and Using Tableau Dashboards
  • Worksheet - Dashboard Differences, Use
  • Bulding Dashboards - Views and Sheets
  • Dashboard Size, Views and Objects
  • dashboards - Implementation Steps
  • Working with Local and Global Filters
  • Tiles, Floating Layouts in Tableau
  • Layout Containers and Images
  • Tableau URLs, Worksheets, Tiles
  • Dashboard Extensions & Management
  • Device Designer - Layout Options
  • Adding and Customizing Layouts
  • Story Points - Creation and Use
  • Adding Worksheets and Dashboards
  • Tableau Publish Options (PROD)

Ch 2: BASIC REPORTS, ARCHITECTURE

  • Tableau Workbook Creation, Data Sources
  • Data View, Preview Settings, Row Count
  • Tableau Worksheets : Creation, Options
  • Row Shelf & Column Shelf, Details View
  • Dimensions, Measures Identification
  • Basic Tableau Report Design
  • Marks : Text, Detail, Tooltip, Colors
  • VizQL : Vizualization Query Language
  • Tableau Architecture - Components
  • Data Connectors and LIVE Connections
  • Tableau In-Memory Database Usage
  • Tableau Server Components and Use
  • Application Server and Data Engine
  • Backgrounder, Data Server, Search
  • Fast Data Engine, Gateway Components
  • Tableau File Types and Workbooks
  • Level of Detail, Sets, Marks, Workbooks

Ch 8 : TABLEAU CALCULATIONS - 1

  • Tableau Operators and Types
  • Tableau Functions and Real-time Use
  • Tableau Calculations and Formats
  • Numerical Calculatins & Examples
  • Aggregated Calculations in Tableau
  • Creating Calculations From Shelfs
  • Using Calculations in Reports
  • Calculation Edits, Identifications
  • String and Logic Functions
  • ASCII, CHAR, LEN, ENDSWITH
  • FIND, FINDNTH, LEFT, CONTAINS
  • LOWER, UPPER, LTRIM, RTRIM
  • MID, MIN, REPLACE, RIGHT
  • SPACE, SPLIT, UPPER, MAX
  • ELSE, ELSEIF, END, IF, IIF
  • IFNULL, ISDATE, ISNULL, MAX
  • MIN, NOT, OR, THEN, WHEN, ZN

Ch 14 : TABLEAU ONLINE (CLOUD)

  • Tableau SDLC - Dev to Prod
  • Tableau Online - SaaS Platform
  • Tableau Cloud - Projects Arch
  • Create/Register Tableau Account
  • Tableau Workbooks Publish Options
  • Tableau Data Sources - Publish
  • Tableau Workbook Uploads, Shares
  • Verify / Access Workbooks, URLs
  • Creating Reports in Tableau Online
  • Published Data Sources - Online
  • Project Share and Workbook Share
  • SheetShare, Dashboard Share Options
  • Story Share and User Acces Control
  • Favorite and Tableau Online Objects
  • Subscriptions and Email Share Options
  • Ask Data ( Q & A) Options, Report Design
  • Security Advantages @ Tableau Online

Ch 3 : GROUPS, BINS, UNION

  • Grouping : Data Categorization
  • Creating Groups on Static Data
  • Dynamic Data Grouping, Binnig
  • Static & Dynamic Ranges - Bins
  • Hierarchies: Creation, Real-time Use
  • Drilldown Reports in Tableau
  • Drill-Down and Drill-Up Reports
  • Working with "Show Me" Button
  • Union - Combining Multiple Inputs
  • Data Filters & File / Table Union
  • Considerations For Union in Tableau
  • Using Union Tables in Tableau Viz
  • Filters & Expressions in Data Source
  • Data View Operations in Tableau
  • Table Operations - Report Design
  • DataView Operations - Report Design

Ch 9 : TABLEAU CALCULATIONS - 2

  • Date and Time Calculations
  • DATEADD, DATEDIFF, DATENAME
  • DATEPART, DATETRUNC, DAY
  • ISDATE, MAKEDATE, MONTH
  • NOW, QUARTER, TODAY, YEAR
  • Calculations - Year, Quarter, Month
  • Custom Calculations, Data Appending
  • Custom Date and Time Formatting
  • Date and Time Conversions To INT
  • Calculations Reuse and Edits
  • Two Digit Conversions with Date
  • Table Functions with Tableau
  • Running Total and Row Number
  • Case Statements, FIRST, LOOKUP
  • Dynamic Row Numbers & Functions
  • Custom Date / Month Formatting

Ch 15 : TABLEAU SERVER

  • Tableau Server - Architecture
  • Tableau Server - Installation Process
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Server
  • Adding Custom Layouts in Tableau Server
  • Adding Content to Custom Layouts
  • Java Script API in Table Server
  • Tableau Online Versus Table Server
  • Security Advantages @ Tableau Server
  • Tableau Online - Architecture
  • Publish Tableau Workbook, Verify
  • Sharing Options and Layouts
  • Adding Device Layouts in Tableu Online
  • Adding Custom Layouts in Tableau Online
  • Adding Content to Custom Layouts

Ch 4 : JOINS, BIG DATA ACCESS

  • Using Joins with Tableau Sources
  • Inner Joins with Tables, Reports
  • Outer Joins with Tables, Reports
  • Using Joins to Report Matching Data
  • Using Joins to Report Missing Data
  • Tableau Reports with SQL Queries
  • Joining More than 2 Tables, SQL
  • Joining Multiple Data Sheets
  • Working with Big Data Access
  • Azure SQL Databases in Tableau
  • Remote Data Sources and Joins
  • Using SQL Queries in Tableau
  • Data Blending Options in Tableau
  • Working with Multiple Data Sources
  • Data Combinations & Aggregations
  • Show Data & Data Grouping Options

Ch 10 : TABLEAU CALCULATIONS - 3

  • Table Calculations in Tableau
  • Using Table Calc, Scope Options
  • Partitioning, Addressing Benefits
  • Addressing Options with Table Calc
  • YTD Calculation Examples, Reports
  • QTD Calculation Examples, Reports
  • MTD Calculation Examples, Reports
  • Running Totals, Quick Calculations
  • LOD : Types of Level Of Detail
  • Level of Details (LOD), Usage
  • Table Calc Vs LOD Expressions
  • FIXED LOD Expression Examples
  • INCLUDE LOD Expression Examples
  • EXCLUDE LOD Expression Examples
  • Using LOD Expressions in Tableau
  • Using Quick Calculations with LOD

Ch 16: TABLEAU PREP - 1

  • Tableau Prep - ETL & Data Cleansing
  • Tableau Prep - WorkFlow, DEV & PROD
  • Comparing Tableau Prep and Desktop
  • Hyper / TDE Files with Tableau Prep
  • Creating, Using TDE with Prep Tool
  • Flow Pane, Input and Output Panes
  • Run Flow and TDE File Generation
  • Saving Flows, Reusability Options
  • Data Source and Data Sampling
  • Multiple Sources: Union Operation
  • Performing Data Extraction Options
  • Adding Steps and Flows to Prep
  • Adding Output to Flow in Prep
  • Run Flow Options and Destinations
  • Using Prep Output for Reports
  • Prep Output to Desktop & Server

Ch 5 : TABLEAU VIZ - LEVEL 1

  • Tableau Visualizations - Types
  • Visualization Categories, Usage
  • Tableau Bar Charts and Types
  • Simple Bar Charts and Usage
  • Horizontal & Colored Bar Charts
  • Stacked Bar Charts, Measures
  • Side By Side Bar Charts and Use
  • Interactive Bar Charts & Filters
  • Line Charts and Data Points
  • Continous Line Charts and Usage
  • Discrete Line Charts and Usage
  • Dual Line Chart and Types
  • Area Charts : Discrete, Continous
  • Stacked Area Charts, Reports
  • Combine Area Charts & Line Charts

Ch 11 : TABLEAU FILTERS

  • Tableau Filters - Creation, Use
  • Extract Filters and TDE (hyper)
  • Data Source Filters & twb Files
  • String, Numeric & Date Fields
  • Context Filters & Real-time Use
  • Filter Dependancy with Context
  • Row Filters : All, Top & Bottom
  • Aggregated Extracts and History
  • Visual Filters, Worksheet Filters
  • Report Level Filters and Usage
  • Dimension Filters and Examples
  • Measure Filters and Examples
  • MeasureName Filters and Examples
  • Custom Filters and Real-time Use
  • Quick Filters, Types For Reports

Ch 17 : TABLEAU PREP - 2

  • Working with Multiple Data Sources
  • Data Cleansing, Clean Step Options
  • UNION Transformation, Aggregations
  • Missing Column Detections & Merge
  • Column Rename, Adding New Columns
  • Changes and Step Audits in Prep
  • Creating Calculated Fields, Replace
  • Grouping and Manual Selections
  • Aggregate Steps : Precautions, Types
  • Data Type Conversions, Filed Options
  • Custom Calculations, String Functions
  • Field Formatting, Data Flow Options
  • Adding Output Steps to the Flow
  • Generating and Using TDE (hyper)
  • Reusing the Flows with Flow Files

Ch 6 : TABLEAU VIZ - LEVEL 2

  • Tableau Pie Charts, Real-time Use
  • Simple Pie Charts - Examples
  • Stacked Pie Charts - Examples
  • Side By Side Pie Charts
  • Reverse Rows and Row Count
  • Donut Charts and Agle Properties
  • Inner / Outer Pie Charts, Stacking
  • Drill-down Pie Charts and Usage
  • CrossTab Charts and Text Properties
  • Rows, Columns and Marks : Text
  • Conditional Formatting, Divergence
  • Using Quick Claculations in Tableau
  • Highlight Tables and Color Palettes
  • Box & Wishker Plots - Text Tables
  • Heat Maps and Real-time Usage
  • Size Controls and Color Options

Ch 12 : PARAMETERS, ACTIONS

  • Tableau Parameters - Working
  • Creating Parameters, Conditions
  • Linking Parameters to Calculations
  • Using Calculations in Fields/View
  • Dynamic Filters using Parameters
  • Dynamic Dimension using Parameters
  • Dynamic Measures using Parameters
  • Sets and Set Parameters, Usage
  • Tableau Action Types, Limitations
  • Filter Actions: Static/Dynamic
  • Highlight Actions, Dynamic Types
  • URL and Parameter Action Types
  • Worksheet Actions, Usage Options
  • Set Actions, Runtime Actions
  • Tableau Actions & Dashboards
  • Use Field and Filter Actions

Ch 18 : REAL-TIME PROJECT
  • Project Requirement Analysis
  • Implementing SDLC Phases
  • Requirement Gathering, FSA
Phase 1:
  • TABLEAU Report Design
  • Visualizations, Properties
  • Analytics and Formating
Phase 2:
  • Data Modeling, Tableau Prep
  • Dynamic Connections, Azure DB
  • Parameters and VizQL Scripts
Phase 3:
  • Tableau Online Analysis
  • Cloud and Tableau Server
  • Project FAQs and Solutions
 
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 LIVE Server.
 

Python Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Python Modes and new IDEs
  • Variables, Strings, Operations, Functions
  • Sequence, Lists, Tuple, Sets
  • Date & Time, Dictionary, Python Modes
  • File Handling and Exception Handling
  • Unit Testing, Python Web, Data Analytics
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T