Algorithmic Trading with Python and R Training Course

This instructor-led, live training in [location] (online or onsite) is aimed at intermediate-level participants who wish to master advanced data integration and visualization techniques in Looker Studio, and learn how to connect diverse data sources, design compelling dashboards, and automate reporting workflows for government and other public sector organizations to drive better decision-making. By the end of this training, participants will be able to: - Connect and integrate multiple data sources into Looker Studio. - Create custom metrics and calculated fields for tailored analysis. - Design advanced visualizations, including interactive filters and charts. - Automate reporting workflows for real-time data updates. - Apply best practices for visual storytelling and report customization.

This instructor-led, live training in US (online or onsite) is designed for data scientists and software engineers who wish to utilize Dask within the Python ecosystem to build, scale, and analyze large datasets for government. By the end of this training, participants will be able to: - Set up the necessary environment to begin building big data processing systems using Dask and Python. - Explore the features, libraries, tools, and APIs available in Dask. - Understand how Dask enhances parallel computing capabilities in Python. - Learn techniques for scaling the Python ecosystem (including Numpy, SciPy, and Pandas) using Dask. - Optimize the Dask environment to ensure high performance when handling large datasets.

This instructor-led, live training in US (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 for government applications.

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 for government workflows.
• 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 to ensure compliance with public sector governance standards.

This instructor-led, live training in US (online or onsite) is designed for intermediate-level data professionals who aim to implement a lakehouse solution using Microsoft Fabric for government. By the end of this training, participants will be able to: - Comprehend the architecture and components of Microsoft Fabric. - Configure and manage a Lakehouse using Microsoft Fabric. - Ingest and transform data utilizing Apache Spark. - Use Delta Lake tables for versioning and managing data. - Implement data ingestion pipelines with Dataflows Gen2. - Orchestrate data pipelines using Data Factory.

This instructor-led, live training in US (online or onsite) is designed for government professionals at the beginner to intermediate level who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration. By the end of this training, participants will be able to: - Navigate and utilize the core features of Excel and Google Sheets. - Perform data analysis and generate actionable insights using advanced spreadsheet techniques. - Collaborate in real-time using Google Sheets to facilitate seamless teamwork. - Create reusable templates for reporting, tracking, and project management for government use.

This instructor-led, live training (available online or on-site) is designed for developers who aim to utilize the FARM (FastAPI, React, and MongoDB) stack to create dynamic, high-performance, and scalable web applications for government use. By the end of this training, participants will be able to: - Set up a development environment that seamlessly integrates FastAPI, React, and MongoDB. - Understand the fundamental concepts, features, and benefits of the FARM stack. - Learn how to develop REST APIs using FastAPI. - Gain proficiency in designing interactive applications with React. - Develop, test, and deploy both front-end and back-end components of applications using the FARM stack.

This instructor-led, live training (online or onsite) is aimed at developers who wish to use FastAPI with Python to build, test, and deploy RESTful APIs more efficiently and rapidly for government projects. By the end of this training, participants will be able to: - Set up the necessary development environment to create APIs using Python and FastAPI. - Develop APIs more quickly and easily leveraging the FastAPI library. - Understand how to create data models and schemas based on Pydantic and OpenAPI standards. - Integrate APIs with a database using SQLAlchemy. - Implement security and authentication in APIs utilizing FastAPI tools. - Build container images and deploy web APIs to a cloud server for government use.

This instructor-led, live training (online or onsite) is designed for government data analysts who wish to utilize Google Sheets for data analysis. By the end of this training, participants will be able to: - Construct spreadsheets using Google Sheets. - Apply formulas that are compatible with both Google Sheets and Excel. - Format and analyze any dataset. - Develop data visualizations through charts and graphs.

Google Sheets is a robust cloud-based spreadsheet tool designed to support real-time collaboration, data organization, and analysis.

This instructor-led, live training (available online or on-site) is tailored for professionals at beginner to intermediate levels who seek to enhance their efficiency and collaborative capabilities using Google Sheets’ advanced features.

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

• Navigate and utilize the key functionalities of Google Sheets effectively.
• Manage and organize data with precision using filters, sorting, and formatting tools.
• Apply essential and advanced formulas for various business scenarios.
• Create charts, dashboards, and reusable templates to facilitate reporting and collaboration.

Format of the Course

• Interactive lectures and discussions.
• Practical exercises and hands-on practice in Google Sheets.
• Real-world examples and collaborative activities tailored to enhance learning.

Course Customization Options

• To request a customized training for government or other specific needs, please contact us to arrange.

This course is tailored for individuals who have prior experience with Google Sheets. It delves into advanced data analysis tools such as pivot tables and charts, along with interactive features like slicers. Participants will gain skills in organizing data within tables, constructing intuitive dashboards, and employing presentation techniques that facilitate dynamic filtering and the clear communication of findings. This training is designed to enhance data management capabilities for government professionals, ensuring they can effectively leverage these tools in their workflows.

This instructor-led, live training in [location] (online or onsite) is designed for government participants at beginner to intermediate levels who wish to develop foundational skills in data visualization and reporting using Looker Studio. The course will cover how to connect data sources, visualize information effectively, and gain actionable insights. By the end of this training, participants will be able to: - Understand the core features of Looker Studio and its applications for government. - Set up Looker Studio and integrate it with various data sources. - Create engaging dashboards using charts, graphs, and filters. - Customize reports to meet specific audience and business needs. - Collaborate on and share dashboards effectively within their organization.

This instructor-led, live training in US (online or onsite) is aimed at data analysts and data scientists who wish to use Metabase for government to collect, query, and visualize data for business intelligence analysis and reporting. By the end of this training, participants will be able to: - Install and configure Metabase to begin building data visualizations and dashboards. - Learn how to query, aggregate, and visualize data using Metabase. - Utilize the features and tools in Metabase to write SQL queries. - Create analytics charts and dashboards to derive business insights. - Understand best practices and tips for using Metabase effectively, including strategies for resolving common issues.

This instructor-led, live training in US (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 for government applications. - Differentiate between Modin, Dask, and Ray in terms of their suitability for various data processing tasks. - Perform Pandas operations more efficiently using Modin. - Implement the entire Pandas API and functions to enhance data analysis capabilities.

Microsoft Fabric is a comprehensive analytics platform that consolidates data engineering, data integration, data warehousing, data science, real-time analytics, and business intelligence into a single solution. This instructor-led, live training (online or onsite) is designed for intermediate-level data professionals who aim to leverage Microsoft Fabric to develop modern data solutions with integrated analytics, governance, and visualization tools for government. By the end of this training, participants will be able to: - Understand the components of Microsoft Fabric and their integration within the Microsoft ecosystem. - Create and manage Fabric Workspaces with appropriate access control measures. - Build and manage Lakehouses to centralize and analyze data efficiently. - Utilize notebooks for exploratory analysis and transformation using Python and SQL. - Design and automate data flows using visual pipelines. - Model and manage data using the Data Warehouse and Semantic Model layers. - Design and publish interactive dashboards with Power BI in Fabric. **Format of the Course** - Interactive lectures and discussions - Extensive exercises and practice sessions - Hands-on implementation in a live-lab environment **Course Customization Options** - To request a customized training for government, please contact us to arrange.

**Audience** **Format of the Course** By the end of this training, participants will be able to: In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse. The Tidyverse is a collection of versatile R packages designed for cleaning, processing, modeling, and visualizing data. Key packages include ggplot2, dplyr, tidyr, readr, purrr, and tibble. - **Target Audience:** - Beginners to the R language - Beginners to data analysis and data visualization - **Course Format:** - Part lecture, part discussion, exercises, and extensive hands-on practice - **Learning Objectives:** - Perform data analysis and create compelling visualizations - Draw meaningful conclusions from various datasets of sample data - Filter, sort, and summarize data to answer exploratory questions - Transform processed data into informative line plots, bar plots, and histograms - Import and filter data from a variety of sources, including Excel, CSV, and SPSS files This training is designed to equip participants with the skills necessary for effective data manipulation and visualization, aligning with the needs and standards required for government data analysis.