Day #2: Data Modelling and Data Mining Masterly

KShs15,000.00 KShs10,000.00

Industry Expert Topic

  • Data Mining
  • Data Modelling

Share the product and get 10% discount!

Remaining characters: 160



Day #2: Data Modelling and Data Mining Masterly

A poorly designed data model is a costly waste in any organization and limits extraction of value from that data for decision making. A good data model enables faster analysis, smarter decision, meaningful client relationships and finally a healthier bottom-line (Profits). This module equips you with skills in data modelling and data mining techniques with key emphasis on Powerpivot toolkit which provides a foundation for embedding analytics.


  1. Build prowess in designing and developing agile data models that allows easy analysis and manipulation
  2. Build prowess in Data mining techniques in Excel ecosystem

Target Groups

  1. Professionals who are in charge of collecting data from raw sources
  2. Professionals who consolidates data from other systems.
  3. All Analysts

Topical Outline

  • Data Types
  • Data modelling techniques in Ms. Excel (Extract, Transform Load (ETL)).
  • Using the Powerpivot in data modelling
  • Data Mining, data consolidation and data cleansing techniques
  • DAX Functions for Dynamic aggregations, calculated columns and fields
  • Data model smoothing before analysis.

Key Remarks

  • This module will expound and get to deep dive excursion on some advanced skills introduced in Day 1.
  • Pre-work will be emailed prior to the Bootcamp for practice

Further Details

This program is part of of our ICT Productivity Competency Programs (Read More).

For more details, kindly contact Anne ( or Office Cell +254 726 611805

Your transformation & growth partner.


There are no reviews yet.

Be the first to review “Day #2: Data Modelling and Data Mining Masterly”

Your email address will not be published. Required fields are marked *