Course Outline

Day 1

  1. Composition of the Data Science Team (Data Scientist, Data Engineer, Data Visualizer, Process Owner)
  2. Large Language Models
    1. Common Libraries for Deploying Models (Transformers, PyTorch, Ollama)
    2. Automating Report Generation with LLMs
    3. Generating Reports Automatically with LLMs
  3. Business Intelligence
    1. Types of Business Intelligence for Government
    2. Developing Business Intelligence Tools
    3. Business Intelligence and Data Visualization
  4. Data Visualization
    1. Importance of Data Visualization for Government
    2. Visual Data Presentation
    3. Data Visualization Tools (infographics, dials and gauges, geographic maps, sparklines, heat maps, detailed bar, pie, and fever charts)
    4. Using Numbers and Colors to Create Effective Visual Stories
  5. Activity

Day 2

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

Day 3

  1. Python and MySQL for Government
  2. Creating a Database and Table
  3. Manipulating the Database (Insert, Select, Update, Delete, Where Statement, Order By)
  4. Dropping a Table
  5. Limiting Results
  6. Joining Tables
  7. Removing List Duplicates
  8. Reversing a String
  9. Data Visualization with Python and MySQL
    1. Using Matplotlib for Basic Plotting
    2. Working with Dictionaries and Pandas
    3. Logic, Control Flow, and Filtering
    4. Customizing Graph Properties (Font, Size, Color Scheme)
  10. Activity

Day 4

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

Day 5

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

Requirements

  • A comprehensive understanding of data structures.
  • Practical experience with programming.

Audience

  • Programmers for government
  • Data Scientists
  • Engineers
 35 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories