Website: https://dataplus.rw/

Call for registration: Professional training in Advanced Excel and Power BI

Date: January 2025
Duration: 3 weeks (Weekend Program)
Venue: University of Rwanda, College of Science & Technology (UR-CST), Nyarugenge Campus
Mode: Physical and Virtual Participation Available
Fee: 40,000 RWF

Dates: 18th January 2025 – 2nd February 2025

Time: 09:00 AM – 17:00 PM

Certification: Certificates of Merit Awarded after successful completion of the program

Registration link:  https://forms.gle/qj6nQrZFeANhpLpQA

Introduction

In an era dominated by digital transformation, the ability to analyze and visualize data is a cornerstone of career success across industries. Microsoft Excel, with its powerful data management and analytical tools, has long been a trusted companion for professionals worldwide. Meanwhile, Power BI elevates data processing to a new level, enabling users to craft dynamic, interactive dashboards and generate actionable insights from complex datasets. Together, these tools empower individuals to navigate and harness the ever-growing volume of data for strategic decision-making and impactful reporting.

This hands-on training aims to provide participants with the essential tools and techniques required to excel in data analysis and visualization. By mastering advanced Excel functionalities and Power BI’s dynamic features, participants will gain the capability to efficiently organize, analyze, and present data. Whether you are a beginner eager to build a strong foundation or an experienced user looking to deepen your expertise, this comprehensive training is tailored to ensure a transformative learning experience. The sessions will emphasize practical application, empowering participants to translate their learning into impactful solutions for real-world challenges.

Training Objectives

  • Enhance participants’ proficiency in advanced Excel functionalities, including data cleaning, pivot tables, advanced formulas, and macros.
  • Introduce participants to Power BI’s interface and tools for data modeling, visualization, and reporting.
  • Enable participants to create interactive dashboards that provide actionable insights.
  • Bridge the knowledge gap for professionals from diverse institutions and backgrounds.

Key Features

  • Practical Focus:A hands-on approach with real-world datasets and scenarios.
  • Expert Trainer:Delivered by a seasoned trainer and consultant with double master’s degrees in Data Science and Public Health.
  • Blended Participation:Options for both physical attendance at UR-CBE Gikondo Campus and virtual participation for those outside Rwanda.
  • Certification:Participants who successfully complete the training will be awarded a Certificate of Merit, adding value to their professional portfolio.

Training Methodology: This training adopts a practical, hands-on approach focusing on Interactive sessions with real-world datasets, guided practice with advanced Excel functions and tools, Step-by-step development of Power BI dashboards, Case studies and group exercises, as well as Q&A sessions to address participants’ specific needs.

Target Audience

This training is ideal for:

  • Professionals in the public and private sectors seeking to enhance their data analysis and visualization skills.
  • Academic staff, researchers, and students interested in data-driven insights.
  • Business analysts, data managers, and consultants looking to improve reporting capabilities.
  • Anyone with a passion for leveraging data for decision-making.

Training Outline

Advanced Excel Skills

  • Data cleaning and preparation.
  • Advanced formulas and functions.
  • Pivot tables and charts.
  • Automation using macros.

Data Visualization Using Power BI

  • Introduction to Power BI interface and tools.
  • Connecting and transforming data sources.
  • Creating dynamic and interactive dashboards.
  • Sharing and publishing visualizations.

Registration Details

  • Fee:40,000 RWF
  • Payment mode:  Equity Bank: 4002200779105
  • DATA+ Consultant ltd. MOMO pay code *182*8*1*92570
  • Deadline for Registration:15th January 2025
  • Contact for Inquiries:0784857317
  • Email:21@gmail.com

Registration link: https://forms.gle/qj6nQrZFeANhpLpQA

Apply