Course Level:
| 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 |
|
| Target Job Roles |
|
| Course Fees (face-to-face training) |
USD 1100/KES 75,000 (Exclusive of VAT) |
| Course Fees (virtual training) | 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 | Upon successful completion of the training, participants will receive a Tech For Development Certificate of Course Completion |
Course Summary
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
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
Related Courses
Course Administration Details:
Methodology
This instructor-led training course is delivered using a blended learning approach and comprises presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
Accreditation
Upon successful completion of this training, participants will be issued a Tech For Development Certificate of Course Completion.
Training Venue
The training will be held at the Tech For Development Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.
Accommodation and Airport Transfer
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.
- Email: letstalk@techfordevelopment.com
- Phone: (+254) 790 824 179
Tailor-Made
This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our Training Centre or at a convenient location. For further inquiries, please contact us on:
- Email: letstalk@techfordevelopment.com
- Phone: (+254) 790 824 179
Payment
Payment should be transferred to our bank account on or before the start of the course. Send proof of payment to letstalk@techfordevelopment.com
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Want more details about our courses? Get in touch with us.
