Business Intelligence: Data Analysis and Reporting Techniques

Course Info

Length:

5 Days

Type:

In Classroom

City:

Dubai
Available DatesVenue
2025-05-05Dubai
2025-07-07Dubai
2025-09-15Dubai
2025-11-03Dubai
Available DatesOther Venue
2025-06-16London
2025-07-07Kuala Lumpur
2025-07-07Amsterdam
2025-07-07Barcelona
2025-07-07Paris
2025-07-07Istanbul
2025-07-07Singapore
2025-08-04London
2025-10-06Singapore
2025-10-06Kuala Lumpur
2025-10-06London
2025-10-06Istanbul
2025-10-06Paris
2025-10-06Barcelona
2025-10-06Amsterdam
2025-12-15London

Course Details

  • Introduction

  • Objective

  • Who should attend

  • Course Location

This program will introduce Business Intelligence (BI), hands-on, to allow you to clean, normalize, and interpret large volumes of data. You will be able to establish historical relationships, analyse the current situation and predict future strategies.

 

The application of BI is borderless, covering operational, tactical, and strategic business decisions. It spans all departments and cascades down to all users who perform data cleansing, reporting, analysis, modelling, integration, and automation.

 

In this course we use MS Excel exclusively as an ultimate and readily available BI tool allowing you to develop an exclusive level of expertise and add immediate value to your job and company.

Course Outline

5 days course
  • Day 1
  • Day 2
  • Day 3
  • Day 4
  • Day 5

Data analysis tools and techniques

 

  • Consolidating data from separate files and sheets
  • Advanced data validation using lists, dates and custom validation
  • Powerful array functions
  • Cell management tools: left, right, mid, concatenate, value
  • Naming, editing, and managing cells and ranges
  • Subtotal, sumif, sumifs, sumproduct, count, countif, countifs
  • Looking-up data, texts, and values using vlookup
  • The incredible table-tools technique
  • Slicing dates into day names, weeks, week numbers, month names, years and quarters
  • Text-to-columns and dynamic trimming using trim and len
  • Managing texts and numbers using replace, find, and substitute
  • Text change functions

Search Course

Related Courses

Course Video

Logo

Subscribe to our newsletter

LONDON HEAD OFFICE

+44 20 80 900 464

[email protected]

DUBAI OFFICE

+971 43 88 00 94

[email protected]

PARIS OFFICE

+33 1 42 68 50 22

[email protected]

SINGAPORE OFFICE

+65 9690 4313

[email protected]

KUALA LUMPUR OFFICE

+60 19-305 5694

[email protected]

BARCELONA OFFICE

+34 934 925 700

[email protected]

Copyright © 2025 lpcentre.com All Rights Reserved. London Premier Centre For Training Ltd Registered in England and Wales, Company Number: 13694538
Contact - Terms and Conditions - Privacy Policy - Quality Policy - Become an instructor - Vacancies - Sitemap
DMCA.com Protection Status