Course Outline

Day 1

  1. Data Science
  2. Data Science Team Composition (Data Scientist, Data Engineer, Data Visualizer, Process Owner)
  3. Business Intelligence
    1. Types of Business Intelligence
    2. Developing Business Intelligence Tools
    3. Business Intelligence and the Data Visualization
  4. Data Visualization
    1. Importance of Data Visualization
    2. The Visual Data Presentation
    3. The Data Visualization Tools (infographics, dials and gauges, geographic maps, sparklines, heat maps, and detailed bar, pie and fever charts)
    4. Painting by Numbers and Playing with Colors in Making Visual Stories
  5. Activity

 

Day 2

  1. Data Visualization in Python Programming
    1. Data Science with Python
    2. Review on Python Fundamentals
  1. Variables and Data Types (str, numeric, sequence, mapping, set types, Boolean, binary, casting)
  2. Operators, Lists, Tuples. Sets, Dictionaries
  3. Conditional Statements
  4. Functions, Lambda, Arrays, Classes, Objects, Inheritance, Iterators
  5. Scope, Modules, Dates, JSON, RegEx, PIP
  6. Try / Except, Command Input, String Formatting
  7. File Handling
  1. Activity

 

Day 3

  1. Python and MySQL
  1. Creating Database and Table
  2. Manipulating Database (Insert, Select, Update, Delete, Where Statement, Order by)
  3. Drop Table
  4. Limit
  5. Joining Tables
  6. Removing List Duplicates
  7. Reverse a String
  1. Data Visualization with Python and MySQL
    1. Using Matplotlib (Basic Plotting)
    2. Dictionaries and Pandas
    3. Logic, Control Flow and Filtering
    4. Manipulating Graphs Properties (Font, Size, Color Scheme)
  2. Activity

 

Day 4

  1. Plotting Data in Different Graph Format
    • Histogram
    • Line
    • Bar
    • Box Plot
    • Pie Chart
    • Donut
    • Scatter Plot
    • Radar
    • Area
    • 2D / 3D Density Plot
    • Dendogram
    • Map (Bubble, Heat)
    • Stacked Chart
    • Venn Diagram
    • Seaborn
  2. Activity

Day 5

  1. Data Visualization with Python and MySQL
    1. Group Work: Create a Top Management Data Visualization Presentation Using ITDI Local ULIMS Data
    2. Presentation of Output

Requirements

  • An understanding of Data Structure.
  • Experience with Programming.

Audience

  • Programmers
  • Data Scientist
  • Engineers
 35 Hours

Number of participants



Price per participant

Open Training Courses require 5+ participants.

Testimonials (1)

Trainer was accommodative. And actually quite encouraging for me to take up the course.

Grace Goh - DBS Bank Ltd
Course - Python in Data Science

Related Courses

Kaggle

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists and developers who wish to learn and build their careers in Data Science using Kaggle.

By the end of this training, participants will be able to:

  • Learn about data science and machine learning.
  • Explore data analytics.
  • Learn about Kaggle and how it works.
Read more...

Accelerating Python Pandas Workflows with Modin

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists and developers who wish to use Modin to build and implement parallel computations with Pandas for faster data analysis.

By the end of this training, participants will be able to:

  • Set up the necessary environment to start developing Pandas workflows at scale with Modin.
  • Understand the features, architecture, and advantages of Modin.
  • Know the differences between Modin, Dask, and Ray.
  • Perform Pandas operations faster with Modin.
  • Implement the entire Pandas API and functions.
Read more...

GPU Data Science with NVIDIA RAPIDS

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists and developers who wish to use RAPIDS to build GPU-accelerated data pipelines, workflows, and visualizations, applying machine learning algorithms, such as XGBoost, cuML, etc.

By the end of this training, participants will be able to:

  • Set up the necessary development environment to build data models with NVIDIA RAPIDS.
  • Understand the features, components, and advantages of RAPIDS.
  • Leverage GPUs to accelerate end-to-end data and analytics pipelines.
  • Implement GPU-accelerated data preparation and ETL with cuDF and Apache Arrow.
  • Learn how to perform machine learning tasks with XGBoost and cuML algorithms.
  • Build data visualizations and execute graph analysis with cuXfilter and cuGraph.
Read more...

Anaconda Ecosystem for Data Scientists

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists who wish to use the Anaconda ecosystem to capture, manage, and deploy packages and data analysis workflows in a single platform.

By the end of this training, participants will be able to:

  • Install and configure Anaconda components and libraries.
  • Understand the core concepts, features, and benefits of Anaconda.
  • Manage packages, environments, and channels using Anaconda Navigator.
  • Use Conda, R, and Python packages for data science and machine learning.
  • Get to know some practical use cases and techniques for managing multiple data environments.
Read more...

Data Analysis with Python, Pandas and Numpy

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at intermediate-level Python developers and data analysts who wish to enhance their skills in data analysis and manipulation using Pandas and NumPy.

By the end of this training, participants will be able to:

  • Set up a development environment that includes Python, Pandas, and NumPy.
  • Create a data analysis application using Pandas and NumPy.
  • Perform advanced data wrangling, sorting, and filtering operations.
  • Conduct aggregate operations and analyze time series data.
  • Visualize data using Matplotlib and other visualization libraries.
  • Debug and optimize their data analysis code.
Read more...

Machine Learning with Python and Pandas

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists who wish to use Pandas to preform predictive analysis with machine learning.

By the end of this training, participants will be able to:

  • Perform data wrangling in Python.
  • Conduct ETL operations for machine learning.
  • Create data visualizations with Pandas
Read more...

Scaling Data Analysis with Python and Dask

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at data scientists and software engineers who wish to use Dask with the Python ecosystem to build, scale, and analyze large datasets.

By the end of this training, participants will be able to:

  • Set up the environment to start building big data processing with Dask and Python.
  • Explore the features, libraries, tools, and APIs available in Dask.
  • Understand how Dask accelerates parallel computing in Python.
  • Learn how to scale the Python ecosystem (Numpy, SciPy, and Pandas) using Dask.
  • Optimize the Dask environment to maintain high performance in handling large datasets.
Read more...

FARM (FastAPI, React, and MongoDB) Full Stack Development

 14 Hours

This instructor-led, live training in (online or onsite) is aimed at developers who wish to use the FARM (FastAPI, React, and MongoDB) stack to build dynamic, high-performance, and scalable web applications.

By the end of this training, participants will be able to:

  • Set up the necessary development environment that integrates FastAPI, React, and MongoDB.
  • Understand the key concepts, features, and benefits of the FARM stack.
  • Learn how to build REST APIs with FastAPI.
  • Learn how to design interactive applications with React.
  • Develop, test, and deploy applications (front end and back end) using the FARM stack.
Read more...

Developing APIs with Python and FastAPI

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at developers who wish to use FastAPI with Python to build, test, and deploy RESTful APIs easier and faster.

By the end of this training, participants will be able to:

  • Set up the necessary development environment to develop APIs with Python and FastAPI.
  • Create APIs quicker and easier using the FastAPI library.
  • Learn how to create data models and schemas based on Pydantic and OpenAPI.
  • Connect APIs to a database using SQLAlchemy.
  • Implement security and authentication in APIs using the FastAPI tools.
  • Build container images and deploy web APIs to a cloud server.
Read more...

Scientific Computing with Python SciPy

 7 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at developers who wish to use SciPy to create advanced scientific computing functions with Python.

By the end of this training, participants will be able to:

  • Set up the necessary development environment to start creating scientific computing functions.
  • Get the full benefit of SciPy features by performing practical examples of complex operations.
  • Implement and optimize mathematical algorithms and functions to solve scientific problems.
  • Design data structures and interpolation methods for visualization, processing, and analysis.
Read more...

Game Development with PyGame

 7 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at developers who wish to use PyGame to create and build games using Python programming.

By the end of this training, participants will be able to:

  • Set up the necessary development environment to start creating game applications with PyGame and Python.
  • Learn how to create interactive PyGame applications integrated with animations and multimedia features.
  • Run and test game programs with PyGame test suite and convert them into executable files.
Read more...

Web application development with Flask

 14 Hours

This practical course is addressed to Python developers that want to create and maintain their first web applications. It is also addressed to people who are already familiar with other web frameworks such as Django or Web2py, and want to learn how using a microframework (i.e. a framework which glues together third-party libraries instead of providing a self-contained universal solution) changes the process.

A significant part of the course is devoted not to Flask itself (it's tiny), but to third-party libraries and tools often used in Flask projects.

Read more...

Advanced Flask

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at developers who wish to use the advanced features of Flask to build scalable web applications on top of MongoDB.

By the end of this training, participants will be able to:

  • Set up the necessary development environment to start developing web applications with Flask.
  • Get to know the advanced concepts and techniques for real-world Flask projects.
  • Build a RESTful API server on top of MongoDB.
  • Learn how to containerize, test, and deploy microservices with Flask, Docker, and Amazon EC2.
  • Gain some insights on the advanced Flask integrations for scaling web applications.
Read more...

Build REST APIs with Python and Flask

 14 Hours

This instructor-led, live training in Peru (online or onsite) is aimed at backend developers who wish to build REST APIs with Python and Flask.

By the end of this training, participants will be able to:

  • Implement a REST API to allow a Flask web application to read and write to a database in the backend.
  • Develop advanced authentication features like refresh tokens.
  • Build a reusable backend for future Python projects.
  • Simplify storage of data with SQLAlchemy.
  • Deploy REST APIs onto a cloud based server.
Read more...

Related Categories

Image for MySQL category
MySQL
Image for Python category
Python
Image for Data Science category
Data Science
1