This comprehensive course on Understanding Data Governance arrives at a pivotal moment, a time when data is a company’s most valuable asset. Designed to equip participants with essential knowledge and tools, the course aims to enable your team to implement and oversee data governance practices within your organisation.

Duration:

1 day

Outline:

Module 1: Introduction to Data Governance

Module 2: Foundations of a Data-Centric Organization

Module 3: Advantages and Challenges of Data Governance

Module 4: Best Practices and Objectives of Data Governance

Module 5: Practical Implications of Data Governance

Module 6: Making a Difference in Data Governance

Data Quality for Beginners is designed to provide a comprehensive understanding of the concepts and practices surrounding data quality. You will learn about the attributes of good data and the dimensions that define data quality.

This course is designed for non-IT professionals who want to contribute to improving data quality within their organisation.

Participants will also examine key techniques that can be used to improve data quality, including profiling, standardisation, and cleansing, as well as a complete six-step process for managing and improving data quality.

By the end of this course, you will have a thorough understanding of how to ensure that your data is of the highest quality and is able to support your business goals and objectives.

Duration:

1 day

Outline:

Module 1: Basics of Data Quality

Module 2: Your Role In Improving Data Quality

Module 3: Data Quality Dimensions

Module 4: Data Quality Techniques

Module 5: The Five-Step Process to Improve Data Quality

Module 6: Six Data Quality Practices

Implementing Chat GPT on Azure for Beginners and Non-Data Scientists
Dive into this specialised one-day workshop crafted for professionals looking to understand and utilise Azure’s integration with OpenAI’s leading language models: GPT-4 and GPT-3. Unlock the potential of these AI models and explore how Azure’s infrastructure can elevate their functionalities across different sectors.

In this beginner-friendly OpenAI GPT workshop, participants will:
• Initiate and configure essential Azure services for optimal integration with OpenAI models.
• Gain insights into the unique capabilities and features of both GPT-4 and GPT-3 when implemented on Azure.
• Engage in hands-on tasks using their own dataset (or our provided test data) to witness the real-world impact and applications of these models.
• Understand the intricacies of data storage and management when harnessing the power of GPT models on Azure.
• Learn and apply deployment strategies to ensure the efficient use of the models in real-time scenarios.
• Dive into image generation capabilities, particularly with DALL-E.
• Master a range of applications, from content creation and summarization to advanced semantic search techniques.

By the end of this course, you will:
• Understand the integration and synergy between Azure and OpenAI’s GPT-4 and GPT-3 models.
• Be familiar with setting up and configuring essential Azure services for OpenAI model deployment.
• Recognize the unique functionalities of GPT-4, GPT-3, and the image generation capabilities of DALL-E.
• Apply hands-on knowledge by using your own or provided data with these models, witnessing their real-world applications.
• Understand the data storage and management processes in the context of Azure and OpenAI models.
• Explore diverse AI tasks such as content generation, summarization, semantic search, and image generation.

Duration:

1 day

Outline

Module 1: Getting Started with Azure Open AI

Module 2: Exploring Azure OpenAI Models

Module 3: Introduction to Prompt Engineering

Module 4: Bringing Your Own Data

Module 5: Data Handling and Storage on Azure

This is an official Microsoft course delivered under the Microsoft Certified Trainer program. It covers the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Power BI.

You’ll learn how to access and process data from a range of data sources including both relational and non-relational. Additionally, this course discusses how to manage and deploy reports and dashboards for sharing and content distribution.

Duration:

3 days

Outline:

Module 1: Get Started with Microsoft Data Analytics

Module 2: Getting Data in Power BI

Module 3: Cleaning, Transforming, and Loading Data in Power BI

Module 4: Design a Data Model in Power BI

Module 5: Create Model Calculations using DAX in Power BI

Module 6: Optimize Model Performance in Power BI

Module 7: Create Reports in Power BI

Module 8: Create Dashboards in Power BI

Module 9: Identify Patterns and Trends in Power BI

Module 10: Create and Manage Workspaces in Power BI

Module 11: Manage Files and Datasets in Power BI

Module 12: Row-level Security in Power BI

This one-day workshop offers participants an introduction to the world of data analytics using Power BI. Designed specifically for beginners, attendees will walk through an end-to-end analytics process – from sourcing and cleaning data to visualisation and insights derivation.

By harnessing the powerful features of Power BI, participants will understand how to transform raw data into meaningful insights using sample HR data.

Duration:

1 day

Outline:

Module 1: Introduction to Data Analytics 

Module 2: The basics and importance of Data Modelling 

Module 3: Ingestion and Transformations of Data in Power Query 

Module 4: Creating Simple Power BI Reports 

Module 5: Common Errors/Troubleshooting Steps  

Module 6: The future of Microsoft Fabric and Power BI 

This hands-on course aims to provide students with a comprehensive understanding of Data Lakehouse using Databricks, a modern data architecture that merges the capabilities of data lakes and data warehouses.

By the end of the course, students will be well-equipped to design, implement, manage, and optimize a Data Lakehouse for various data storage and analytical needs.

Duration:

2 days

Outline:

Module 1: Introduction to Data Lakehouse

Module 2: Understanding the Underlying Technologies

Module 3: Data Ingestion Strategies

Module 4: Data Storage and Organisation

Module 5: Data Governance and Security

Module 6: Querying and Data Modeling

Module 7: Performance Tuning and Optimisation

This 2-day intensive course provides business leaders, IT managers, and data professionals with a hands-on approach to create a comprehensive data strategy for their organisation.

Utilising a 4-step method, participants will learn how to initiate, develop, implement, and sustain a data strategy that aligns with organisational objectives.

Duration:

2 days

Outline:

Module 1: Introduction to Data Strategy

Module 2: Data Strategy Charter Scope Statement

Module 3: Develop Data Strategy

Module 4: Workshop – Create Your Data Strategy Charter and Strategy Document

Module 5: Define Programs of Works

Module 6: Initiate and Sustain Programs of Work

Module 7: Workshop – Defining and Initiating Programs of Work

Module 8: Q&A and Course Recap