Our upcoming sessions...


One-on-one training | Group Training
..join us by registering

Upcoming Classes


...
General Python Programming

We will take you from basics through advance programming. You have the choice to become a full stack developer or a data scientist or both.

Learn More!
...
Data Analytics and Visualization

This covers data wrangling of various data types. It includes text analytics, various visualisations, ML and DL, and capstone projects.

Learn More!
...
Power BI for Business Analytics

It captures data loading from different sources, transformation including use of DAX and M formula, creating insight through dashboard presentations.

Learn More!
...
SQL and Database Design

This covers different structured query syntaxes, database design, handling of different relationships in database, connecting with python for analytics.

Learn More!

Categories

At Zippadiva, you will be engaged on a live section with real tutor virtually. The training has two main categories:



...

One-on-one training

This covers the entire module and at the same time involves direct contact with tutor(s) but on an individual basis. Here there is no waiting time for the date of commencement as it depends on the trainee's availability.

Register  here.


...

Group training

This involves training in a group. Generally, there is waiting time after registration of a course. The commencement date will usually be communicated to all trainees in the group.

Register  here.


Our courses include examples, exercises and real-life application projects. With us, you will build competency that could help you land a job. Our partners recruit most of our trainees. We are also strengthening our partnership and seeking new partners for job placement and collaboration. We educate our current partners while building brand awareness among prospective partners. Zippadiva provides custom Virtual Training that centers around your needs and help you capture more mindshare at all stages. Our tutors are well grounded in their subject areas to give world class experience you deserve.



Our tutors

Coaching | Mentorship

Contact our tutors

General Python Programming

Python is an interpreted high-level general-purpose programming language. Its design philosophy emphasizes code readability with its use of significant indentation. Its language constructs as well as its object-oriented approach aim to help programmers write clear, logical code for small and large-scale projects. Wikipedia. Register  here.

Introduction

- Getting Started
- Keywords and Identifiers
- Statements and Comments
- Variables
- Datatypes
- Datatype Conversion
- Input, Output and Import
- Operators and Types
- Namespace and Types
- Exercises

Flow Control

- if, elif, else Statements
- Loops (for Loop, while Loop, etc.)
- break and continue
- Pass

Functions

- Functions
- Function and Argument
- Recursion in Python
- Anonymous Function
- Global, Local and Nonlocal Variables
- Global Keyword
- Modules
- Package
- Exercises

Datatypes (in details)

- Numbers
- List
- Tuple
- String
- Set
- Dictionary
- Exercises

Files

- File Operation
- Directory
- Exception
- Exception Handling
- User-defined Exception
- Exercises

Object and Class

- OOP
- Class
- Inheritance
- Multiple Inheritance
- Operator Overloading
- Exercises

Advanced Topics

- Iterator
- Generator
- Closure
- Decorators
- Property
- RegEx
- Exercises

Date & Time

- Datetime Module
- Datetime and Strftime
- Datetime and Strptime
- Current Date and Time
- Get Current time
- Timestamp to Datetime Conversion
- Time Module
- Time and Sleep
- Exercises

Projects

- Build a BMI calclator using Tkinter
- Build a Calculator using Tkinter
- Build a car diagnostic scanner
- Sentence Maker Program
- Data analytics and visualisation


Python Data Analytics and Visualisation

Data analytics is the process of analyzing data sets in order to make the decision about the information they have, increasingly with specialized software and system. Data analytics technologies are used in commercial industries that allow organizations to make business decisions. Data can help businesses better understand their customers, improve their advertising campaigns, personalize their content, and improve their bottom lines. The techniques and processes of data analytics have been automated into mechanical processes and algorithms that work over raw data for human consumption. Data analytics help a business optimize its performance. Data Analytics.

Data visualization is the practice of translating information into a visual context, such as a map or graph, to make data easier for the human brain to understand and pull insights from. The main goal of data visualization is to make it easier to identify patterns, trends and outliers in large data sets. The term is often used interchangeably with others, including information graphics, information visualization and statistical graphics.
Data visualization is one of the steps of the data science process, which states that after data has been collected, processed and modeled, it must be visualized for conclusions to be made. Data visualization is also an element of the broader data presentation architecture (DPA) discipline, which aims to identify, locate, manipulate, format and deliver data in the most efficient way possible.
Data visualization is important for almost every career. It can be used by teachers to display student test results, by computer scientists exploring advancements in artificial intelligence (AI) or by executives looking to share information with stakeholders. It also plays an important role in big data projects. As businesses accumulated massive collections of data during the early years of the big data trend, they needed a way to quickly and easily get an overview of their data. Visualization tools were a natural fit.
Visualization is central to advanced analytics for similar reasons. When a data scientist is writing advanced predictive analytics or machine learning (ML) algorithms, it becomes important to visualize the outputs to monitor results and ensure that models are performing as intended. This is because visualizations of complex algorithms are generally easier to interpret than numerical outputs. Data Visualisation. Register  here.

Introduction

- Definition
- List
- Set
- Dictionary
- List Comprehension
- Data Types and Sources (csv, json, excel, online, text, etc.)
- Exercises

Text Analytics

- Using Tokenization
- Anagrams
- Exercises

Numbers Analytics

- Numpy
- Generating and Plotting Arbitrary Data
- Exercises

Data Analytics with Series and DataFrame

- Python Series
- Python DataFrame
- Exercises

Connecting to Data from Different File Sources

- Data from Zip file
- Data from Excel
- Data from CSV
- Data from Text
- Data from JSON
- Data from Other Sources
- Exercises

Data Analytics and Visualisation with Matplotlib

- Charts and Chart Attributes
- 3D Charts with Matplotlib
- Chart Animation with Matplotlib
- Exercises

Data Analytics and Visualisation with Seaborn

- Charts and Chart Attributes
- Exercises

Time Analytics

- Datetime
- Datetime Conversion
- Exercises

Data Analytics and Visualisation with Online Resources

- Charts and Chart Attributes
- Exercises

Advance Data Analytics: Image Analytics

- Creating a numpy array from Image
- Indexing, Slicing, and Iterating numpy array
- Concatenating and splitting
- Batch Image Resizing
- Detecting Faces in Images
- Capturing Video from webcam

Advance Data Analytics: Video Analytics

- Capturing Video from webcam
- Detecting Moving object from a webcam and record time of entrance and exit
- Storing Object Detection Timestamps in a CSV File and Visualisation

Advance Data Analytics: Visualisation

- Interactive Data Visualisation with Python and Bokeh
- Data Visualisation with Justpy

Advance Data Analytics: Machine Learning

- Importing Basic Libraries and Packages
- Link to Source Data
- Familiarizing with the Data
- Checking if there are Missing Data
- Data Exploration using Histogram
- Data Exploration using Correlation Matrix
- Creating a Condition for Classification
- Examining Proportion of Data from Classification
- Data for Modelling: Preparation (Standardizing Feature Variables and Data Split)
- Creating Machine Learning (ML) Model and Selection
- Result Presentation and Conclusion

Projects: Advance Optional Project

- Project 1: Building a web map with python: Interactive mapping with folium
- Project 2: Detecting Moving object from a webcam and record time of entrance and exit, and making a real-time Visualisation
- Project 3: From Data to Information: E.g. What Day of the Week are People the Happiest?
- Project 4: Interactive Visualisation with Quasar, Highchart and Justpy: Combining Javascript and Python
- Project 5: Interactive Visualisation with Javascript D3.js
- Project 6: Machine Learning Project
- Project 7: Deep Learning Project


Power BI for Business Analytics

Power BI is an interactive data visualization software developed by Microsoft with primary focus on business intelligence.It is part of the Microsoft Power Platform.
Power BI provides cloud-based BI (business intelligence) services, known as "Power BI Services", along with a desktop based interface, called "Power BI Desktop". It offers data warehouse capabilities including data preparation, data discovery and interactive dashboards.In March 2016, Microsoft released an additional service called Power BI Embedded on its Azure cloud platform. One main differentiator of the product is the ability to load custom visualizations. Wikipedia. Register  here.

Introduction

- Getting started and Set-up
- Introduction (Power BI)
- Overview of Power BI
- Connecting to 3rd party software (software as services)
- Power BI community.
- Power BI desktop - Changing Locale

Data Transformation

- Connecting to database
- Data Transformation
- Splitting Columns
- Managing query groups
- Changing data types
- Working with dates
- Removing and Reordering Columns
- Conditional Columns
- Connecting to files in a folder
- Merge queries
- Query dependency view
- Transforming less structured data
- Entering data
- Query Parameters
- Summary

Relationships, DAX and M formula

- Managing Relationships
- Creating calculated columns
- Optimising Models for reporting
- Creating calculated measures
- Creating and managing hierarchies
- Using Calculated Tables
- Time intelligence
- Manually typing in a data table
- Include and exclude
- Grouping Binning

Data Visualisation and Formatting

- Pie and Treemap
- Hierarchical Axis and Concatenation
- Filter (including TopN)
- Bar Chart with line
- Analytics pane
- Clustering (machine learning)
- Slicer
- Focus mode and see data
- Date slicer
- Map and filled map
- ESRI Map
- Table and Matrix
- Table Styles
- Scatter Chart
- Water fall chart
- Gauge, Card and KPI
- Colouring Charts
- Shapes, Textboxes and Images
- Gridlines and Snap grids
- Page layout and formatting
- Visual Relationship
- Duplicate Page
- Category with no data
- Default Summarisation and Categorisation
- Positioning, Aligning and Sorting Visuals

Creating Dashboard and Publishing

- Create Dashboard
- Publish Dashboard

Project

- Project 1
- Project 2
- Project 3
- Project 4


SQL and Database Design

SQL, Structured Query Language, is a programming language used by Relational Database Management Systems (RDBMS) to trigger communication or interaction with the data stored in the database. It aids analytics by retrieving useful information that promotes informed decision making.
A relational database consists of multiple tables, with rows and columns, that relate to each other. The relationship between tables is made possible by the addition of a shared columns through a foreign key.
Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly. Database design involves classifying data and identifying interrelationships. This theoretical representation of the data is called an ontology. The ontology is the theory behind the database's design. Wikipedia. Register  here.

Introduction

- Setup and Installations
- About Data and Database
- Types of Database
- Popular Databases
- Database Selection Criteria
- Database Maintenance
- Database Management
- About SQL and its Subsets
- Database Management System
- Database Terms
- Difference Between SQL and MySQL
- Difference Between MSSQL Server and MySQL
- Differences in Syntax Between SQL Server, MySQL, PostgreSQL and SQLit

Database Overview

- Familiarizing with DBMS
- Creating a Database using DBMS
- Importing tables into Database
- Exporting Data

Implementing SQL and T-SQL Queries

- Intro to: DDL and DML
- SELECT
- T-SQL Demo
- DISTINCT
- TOP (rows)
- TOP (rows) PERCENT
- AS
- FROM
- WHERE
- AND
- OR
- NOT
- BETWEEN
- LIKE
- IN
- IS NULL
- IS NOT NULL
- CREATE
- DROP
- UPDATE
- DELETE
- AGGREGATE FUNCTIONS (COUNT, SUM, AVG, MIN, MAX, ETC.)
- GROUP BY
- HAVING
- ORDER BY
- DESC
- ASC
- OFFSET
- FETCH
- JOINS (INNER, LEFT, RIGHT, FULL)
- EXISTS
- GRANT
- REVOKE
- SAVEPOINT
- TRUNCATE
- UNION (UNION, UNION ALL)

Operators in SQL

- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Bitwise Operators
- Compound Operators

SQL and Python Interaction

- Introduction - Downloads and Installation
- Importing Basic Libraries And Connecting to MSSQL Server
- Implementing Query - Visualising SQL Data
- Partway to Analytics and Visualisation - Data Exploration
- Partway to Data Visualisation - Aggregating Data
- Partway to Data Visualisation - Visualising
- Exercises and Assignments

Electives

- Introduction to Database Design
- Introduction to Data Pipeline (fall)
- Introduction to Data Warehouse (summer)


Python for Web Development - Flask, HTML, CSS, BOOTSTRAP

This course covers a crash course on html, css, and bootstrap. It teaches how to implement flask frame work in web development. Here flask will be used for backend. Since python is a scripting language, it will also be used for the frontend. HTML (Hypertext Markup Language) provides the front end architecture while css and bootstrap provided styling and beautifying of the web application.
. Register  here.

Overview

- HTML crash course
- CSS crash course
- Bootstrap crash course
- Flask overview
- Templates
- Flask forms
- Flask with SQL database
- A web development project
- Project deployment
- Project


Python for Web Development - Django, HTML, CSS, BOOTSTRAP

This course covers a crash course on html, css, and bootstrap. It teaches how to implement django frame work in web development. Here django will be used for backend. Since python is a scripting language, it will also be used for the frontend. HTML (Hypertext Markup Language) provides the front end architecture while css and bootstrap provided styling and beautifying of the web application.
. Register  here.

Overview

- HTML crash course
- CSS crash course
- Bootstrap crash course
- Django overview
- Templates
- Django forms
- Django with SQL database
- A web development project
- Project deployment
- Project




Our students are top in class

Basic | Advance | Expert

... Knowledge is power ...



Join Us Today!


. . . . . . join us to land your dream job