This is a past event. Registration is closed. View other ISACA Kenya Chapter events.

Event Details

This training aims to provide participants with a comprehensive understanding of enterprise analytics principles and value drivers. Through a series of modules, attendees will acquire key skills in data management, data cleanup, wrangling, aggregation techniques, data visualization principles, and dashboard development.

  • Member: - Ksh. 76,000
  • Non-member - Ksh. 82,000
  • 35 CPE hrs
  • 5 days

May 13 - 17, 2024 GMT+3

Add to Calendar

Merica Hotel
Nakuru, Nakuru County, Kenya
Show on map

Agenda

  • Day 1 (May 13, 2024)
    8:00 AM - 8:25 AMRegistration
    8:30 AM - 4:30 PMEnterprise Analytics(MS01)
    Key concepts in analytics
    Day 2 (May 14, 2024)
    8:30 AM - 4:30 PMExcel & Power Query (MS02)
    Importing
    Profiling imported data for preliminary accuracy checks
    Day 3 (May 15, 2024)
    8:30 AM - 4:30 PMExcel & Power Query (MS02 Cont’d)
    Explore data transformation prior to loading for analysis
    Day 4 (May 16, 2024)
    8:30 AM - 4:30 PMPower BI (MS03)
    Introduction to data visualization principles

    Building analytics insights into dashboards

    Sample large file: https://techriskcoke-my.sharepoint.com/:u:/g/personal/ngotho_techrisk_co_ke/ESamtLfYXwlKntc6h9zdcecB5PV02I0eoI6Y2bAZjAfR8w
    Day 5 (May 17, 2024)
    8:30 AM - 12:30 PMCase Study (MS04)
    Practice exercises to enhance skills of delegates

Documents

Day 1: Income Statements.zip
Day 2: ForLearning.zip
Day 2- Lab 2 - The Excel Data Model.xlsx
Module 1- classic analysis.xlsx
ED-CustomerComments-Complete.pdf
ED-Inventory and Complaints.xlsx
ED-Inventory and Complaints 2nd.xlsx
Day 3 - EDs and Industry income statements.zip
customer complaints data.xlsx
Day 3- Additional Data.zip
Day 4 ED-Sales-2010-11 Daily Sales by Product.zip
Final Presentation .xlsx

Community

Discover and connect with other attendees.

Menu