Business Inteligence

TRAINING COURSE

This course is currently not active. Feel free to submit an enquiry.

Details

Business intelligence (BI) is a collection of technologies, techniques and other tools that assist in business decision making. Especially by providing visual representations of important business metrics. This includes: extracting and collecting data from disparate sources (Data Warehousing), collating, aggregating and otherwise transforming the raw data into meaningful and useful information.

In this course you will learn an in depth understanding of:
  • The difference between data and information
  • Data extraction and cleaning
  • Data Warehousing
  • Data Presentation and visualisation
Popular products will be compared and discussed. Practical examples will be demonstrated using the free Microsoft Power BI tool.

Audience

Business Analysts. Advanced Excel users, Business unit leaders. Management Accountants.

Pre-Requisites

Power users on Excel. Some understanding of Databases.

Course Outline / Curriculum

  1. Data and Information
  2. Basic Database structures
  3. Data Extraction and cleaning
  4. Data Warehousing
  5. Data Modeling
  6. Schemas
  7. Reporting