Get in Touch

Course Outline

Day 1

  1. Composition of a Data Science Team (including Data Scientists, Data Engineers, Data Visualizers, and Process Owners)
  2. Large Language Models
    1. Essential libraries for model deployment (Transformers, PyTorch, Ollama)
    2. Automating report generation using LLMs
    3. Generating reports automatically with LLMs
  3. Business Intelligence
    1. Categories of Business Intelligence
    2. Building Business Intelligence Solutions
    3. The intersection of Business Intelligence and Data Visualization
  4. Data Visualization
    1. The significance of Data Visualization
    2. Techniques for Presenting Data Visually
    3. Key Data Visualization Tools (infographics, gauges and dials, geographic maps, sparklines, heat maps, and detailed bar, pie, and trend charts)
    4. Crafting Visual Narratives through Color and Numerical Representation
  5. Practical Activity

Day 2

  1. Data Visualization in Python Programming
    1. Applying Python in Data Science
    2. Recap of Python Fundamentals
  2. Variables and Data Types (strings, numeric, sequence, mapping, set types, Boolean, binary, and type casting)
  3. Operators, Lists, Tuples, Sets, and Dictionaries
  4. Conditional Statements
  5. Functions, Lambda expressions, Arrays, Classes, Objects, Inheritance, and Iterators
  6. Scope, Modules, Date handling, JSON, Regular Expressions (RegEx), and PIP
  7. Exception Handling (Try / Except), Command Line Input, and String Formatting
  8. File Handling
  9. Practical Activity

Day 3

  1. Integrating Python with MySQL
  2. Creating Databases and Tables
  3. Database Manipulation (Insert, Select, Update, Delete, Where Clause, Order By)
  4. Dropping Tables
  5. Using Limit Clauses
  6. Joining Tables
  7. Removing Duplicate Entries from Lists
  8. Reversing Strings
  9. Data Visualization with Python and MySQL
    1. Introduction to Matplotlib (Basic Plotting)
    2. Utilizing Dictionaries and Pandas
    3. Logic, Control Flow, and Data Filtering
    4. Customizing Graph Properties (Font, Size, Color Schemes)
  10. Practical Activity

Day 4

  1. Plotting Data in Various Graph Formats
    • Histograms
    • Line Charts
    • Bar Charts
    • Box Plots
    • Pie Charts
    • Donut Charts
    • Scatter Plots
    • Radar Charts
    • Area Charts
    • 2D and 3D Density Plots
    • Dendrograms
    • Maps (Bubble, Heat)
    • Stacked Charts
    • Venn Diagrams
    • Seaborn Library
  2. Practical Activity

Day 5

  1. Data Visualization with Python and MySQL
    1. Group Project: Designing a Data Visualization Presentation for Top Management Using ITDI Local ULIMS Data
    2. Presentation of Final Output

Requirements

  • Familiarity with Data Structures.
  • Prior experience in programming.

Target Audience

  • Software Programmers
  • Data Scientists
  • Engineers
 35 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories