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. Automatically Generating Reports with LLMs
  3. Business Intelligence
    1. Types of Business Intelligence for Government
    2. Developing Business Intelligence Tools for Government
    3. Business Intelligence and Data Visualization for Government
  4. Data Visualization
    1. Importance of Data Visualization for Government
    2. Visual Data Presentation Techniques
    3. Data Visualization Tools (infographics, dials and gauges, geographic maps, sparklines, heat maps, and detailed bar, pie, and fever charts)
    4. Effective Use of Colors and Numbers in Creating Visual Stories for Government
  5. Activity

Day 2

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

Day 3

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

Day 4

  1. Plotting Data in Different Graph Formats for Government
    • 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 Library for Government Data Visualization
  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 to Government Stakeholders

Requirements

  • A solid understanding of data structures.
  • Relevant experience in programming.

Audience for Government

  • Programmers
  • Data Scientists
  • Engineers
 35 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories