Training Course in System Analytics Using Microsoft 365

Training Course in System Analytics Using Microsoft 365

This course is designed to help individuals and organizations unlock the data management, usage analytics, reporting, and administrative insights provided by Microsoft 365.

Foundation
01

Course Overview

Course Summary
Course Title Training Course in System Analytics Using Microsoft 365
Organization Tech For Development (T4D)
Venue Tech For Development (T4D) Training Center along Tala Road, Runda, Nairobi
Duration 5 Days
Target Industries
  • Banking
  • Retail
  • Financial services
  • Logistics and supply chain
Target Job Roles
  • Business Analysts
  • Data Analysts
  • CRM Managers
  • Sales Managers
  • Marketing Managers
  • Report Writers
Course Fees (Face-to-Face) USD 1100/KES 75,000 (Exclusive of VAT)
Course Fees (Virtual) USD 500/KES 55,000 (Exclusive of VAT)
Training Modes Virtual and face-to-face training
Payment Payment should be made to the Tech For Development (T4D) bank account on or before the start of the course
Accreditation Tech For Development Certificate of Course Completion

This course is designed to help individuals and organizations unlock the data management, usage analytics, reporting, and administrative insights provided by Microsoft 365.

 

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

 

  • Leverage Microsoft 365’s built-in cloud analytics and reporting tools, including usage tracking, collaboration, and productivity metrics, to monitor, analyze, and optimize organizational operations
  • Extract and visualize usage, collaboration, communication, and license data (e.g., adoption rates and storage usage)
  • Transform that raw usage data into actionable reports, and define key performance metrics (KPIs)
  • Use live dashboards/analytics to support decision-making, compliance, governance, and resource optimization

 

 

Duration

 

5 days

 


What are the Key Skills from This Course?

 

  • Analyzing Microsoft 365 usage data across Teams, SharePoint, MS Excel, and Power BI to identify adoption trends and activity patterns
  • Creating and customizing dashboards and visualizations using Microsoft 365 admin tools and Power BI
  • Structuring system data for effective reporting and analytics
  • Generating, interpreting, and monitoring reports on productivity, usage, security, and compliance
  • Automating recurring reporting tasks and streamlining analytics workflows
  • Presenting data insights effectively to non-technical stakeholders to inform actionable decisions

 

 

What You Can Do With Microsoft 365?

 

  • Streamline work with a suite of productivity tools like MS Word, MS Excel, MS PowerPoint, Teams, and OneDrive
  • Organize emails, manage calendars, and schedule meetings with Outlook
  • Share documents and collaborate in real time using SharePoint and Teams
  • Visualize data in Power BI, integrated with Microsoft 365 tools

 

 

Who Should Attend This Course?

 

 

  • Sales managers
  • Business analysts
  • Data analysts
  • Sales representatives
  • Marketing professionals

 

 

Course Objectives

 

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

 

  • Understand the importance of system analytics in optimizing business processes and decision-making
  • Use Microsoft Excel for advanced data analysis, including data cleaning, manipulation, and visualization
  • Create interactive dashboards, reports, and visualizations using Power BI to communicate data insights effectively
  • Develop skills in collaboration and data management using SharePoint, including creating sites, managing document libraries, and sharing data securely
  • Explore automation and custom application development using Power Automate and Power Apps to streamline workflows and enhance system analytics capabilities
  • Apply the acquired knowledge and skills to real-world scenarios, enabling participants to make data-driven decisions and optimize business performance
  • Foster a collaborative learning environment where participants can engage in hands-on exercises, discussions, and practical projects to reinforce their understanding of system analytics using Microsoft 365 tools

 

 

Course Requirements

 

  • Proficiency in English
  • Basic computer literacy
  • Familiarity with Microsoft tools

 

 

 

Training Approaches

 

  • Interactive lectures
  • Live demonstrations
  • Hands-on exercises
  • Group discussions
  • Real-world case studies
  • Knowledge checks and quizzes
  • Collaborative group work
02

Course Modules

Course Outline

 

Module I: Introduction to System Analytics

  • Understanding the importance of system analytics in business optimization
  • Key concepts and methodologies in system analytics
  • Data-driven decision-making and its impact on business performance
  • Case Study/Practical Exercise: Analyzing a real-world business scenario where system analytics improved operational efficiency

 

 

Module II: Data Analysis with Microsoft Excel

 

  • Exploring advanced Excel functions and formulas for data analysis
  • Data cleaning and manipulation techniques in Excel
  • Creating pivot tables and charts for data visualization
  • Case Study/Hands-on Exercise: Performing a complete data analysis on a sample dataset using Excel, including cleaning, analysis, and visualization

 

 

Module III: Data Visualization with Power BI

 

  • Introduction to Power BI and its features for data visualization
  • Creating interactive dashboards and reports in Power BI
  • Utilizing Power BI visuals and customizing visualizations
  • Case Study/Practical Session: Building a Power BI dashboard to visualize key metrics for a sample company

 

 

Module IV: Collaboration and Data Management with SharePoint

 

  • Overview of SharePoint and its role in data management
  • Creating SharePoint sites and document libraries for collaboration
  • Version control, access permissions, and document sharing in SharePoint
  • Case Study/Hands-on Exercise: Setting up a SharePoint site for a department to manage documents and collaboration

 

 

Module V: Automation and Custom Applications with Power Automate and Power Apps

 

  • Introduction to Power Automate and its capabilities for workflow automation
  • Creating automated data workflows using Power Automate
  • Developing custom applications with Power Apps for system analytics
  • Case Study/Practical Component: Designing and implementing an automated workflow using Power Automate and a custom app with Power Apps for a specific business process
03

Course Administration

Methodology

This instructor-led training course is delivered using a blended learning approach comprising presentations, guided practical sessions, web-based tutorials, and group work.

Accreditation

Participants will receive a Tech For Development Certificate of Course Completion.

Training Venue

Held at the Tech For Development Training Centre.

Accommodation & Airport Transfer

Arranged upon request.
Email: letstalk@techfordevelopment.com
Phone: (+254) 790 824 179

Tailor-Made

Customised training available.

Payment

Send proof of payment to letstalk@techfordevelopment.com.

2026 Schedules

Date & Location Cost
09 Mar - 13 Mar
Nairobi
KES 75,000 |
$1,100
Enroll
13 Apr - 17 Apr
Nairobi
KES 75,000 |
$1,100
Enroll
11 May - 15 May
Nairobi
KES 75,000 |
$1,100
Enroll
08 Jun - 12 Jun
Nairobi
KES 75,000 |
$1,100
Enroll
13 Jul - 17 Jul
Nairobi
KES 75,000 |
$1,100
Enroll
10 Aug - 14 Aug
Nairobi
KES 75,000 |
$1,100
Enroll
14 Sep - 18 Sep
Nairobi
KES 75,000 |
$1,100
Enroll
12 Oct - 16 Oct
Nairobi
KES 75,000 |
$1,100
Enroll
09 Nov - 13 Nov
Nairobi
KES 75,000 |
$1,100
Enroll
14 Dec - 18 Dec
Nairobi
KES 75,000 |
$1,100
Enroll
11 Jan - 15 Jan
Nairobi
KES 75,000 |
$1,100
Enroll
08 Feb - 12 Feb
Nairobi
KES 75,000 |
$1,100
Enroll
08 Mar - 12 Mar
Nairobi
KES 75,000 |
$1,100
Enroll
12 Apr - 16 Apr
Nairobi
KES 75,000 |
$1,100
Enroll
10 May - 14 May
Nairobi
KES 75,000 |
$1,100
Enroll
14 Jun - 18 Jun
Nairobi
KES 75,000 |
$1,100
Enroll
12 Jul - 16 Jul
Nairobi
KES 75,000 |
$1,100
Enroll
09 Aug - 13 Aug
Nairobi
KES 75,000 |
$1,100
Enroll
13 Sep - 17 Sep
Nairobi
KES 75,000 |
$1,100
Enroll
11 Oct - 15 Oct
Nairobi
KES 75,000 |
$1,100
Enroll
08 Nov - 12 Nov
Nairobi
KES 75,000 |
$1,100
Enroll
13 Dec - 17 Dec
Nairobi
KES 75,000 |
$1,100
Enroll

Quick Links