Business Intelligence: Data Analysis and Reporting Techniques

Available Dates

Dec-30-2024

London
Jan-20-2025

London
Feb-17-2025

London
Mar-17-2025

London
Apr-21-2025

London
May-19-2025

London
June-16-2025

London
July-21-2025

London
Aug-18-2025

London
Sep-15-2025

London
Oct-20-2025

London
Nov-17-2025

London
Dec-15-2025

London

Dates in Other Venues

Dec-09-2024

Kuala Lumpur
Dec-09-2024

Istanbul
Dec-16-2024

Paris
Dec-16-2024

Singapore
Dec-23-2024

Dubai
Dec-23-2024

Amsterdam
Dec-30-2024

Barcelona
Jan-06-2025

Istanbul
Jan-06-2025

Kuala Lumpur
Jan-13-2025

Paris
Jan-13-2025

Singapore
Jan-20-2025

Amsterdam
Jan-27-2025

Dubai
Jan-27-2025

Barcelona
Feb-03-2025

Istanbul
Feb-03-2025

Kuala Lumpur
Feb-10-2025

Paris
Feb-10-2025

Singapore
Feb-17-2025

Amsterdam
Feb-24-2025

Barcelona
Feb-24-2025

Dubai
Mar-03-2025

Kuala Lumpur
Mar-03-2025

Istanbul
Mar-10-2025

Singapore
Mar-10-2025

Paris
Mar-17-2025

Amsterdam
Mar-24-2025

Barcelona
Mar-24-2025

Dubai
Apr-07-2025

Kuala Lumpur
Apr-07-2025

Istanbul
Apr-14-2025

Paris
Apr-14-2025

Singapore
Apr-21-2025

Amsterdam
Apr-28-2025

Dubai
Apr-28-2025

Barcelona
May-05-2025

Kuala Lumpur
May-05-2025

Istanbul
May-12-2025

Singapore
May-12-2025

Paris
May-19-2025

Amsterdam
May-26-2025

Dubai
May-26-2025

Barcelona
June-02-2025

Istanbul
June-02-2025

Kuala Lumpur
June-09-2025

Paris
June-09-2025

Singapore
June-16-2025

Amsterdam
June-23-2025

Barcelona
June-30-2025

Dubai
June-30-2025

Istanbul
June-30-2025

Kuala Lumpur
July-07-2025

Istanbul
July-07-2025

Kuala Lumpur
July-14-2025

Singapore
July-14-2025

Paris
July-21-2025

Amsterdam
July-28-2025

Dubai
July-28-2025

Barcelona
Aug-04-2025

Kuala Lumpur
Aug-04-2025

Istanbul
Aug-11-2025

Paris
Aug-11-2025

Singapore
Aug-18-2025

Amsterdam
Aug-25-2025

Barcelona
Aug-25-2025

Dubai
Sep-01-2025

Kuala Lumpur
Sep-01-2025

Istanbul
Sep-08-2025

Singapore
Sep-08-2025

Paris
Sep-15-2025

Amsterdam
Sep-22-2025

Barcelona
Sep-29-2025

Dubai
Sep-29-2025

Kuala Lumpur
Sep-29-2025

Istanbul
Oct-06-2025

Kuala Lumpur
Oct-06-2025

Istanbul
Oct-13-2025

Paris
Oct-13-2025

Singapore
Oct-20-2025

Amsterdam
Oct-27-2025

Barcelona
Oct-27-2025

Dubai
Nov-03-2025

Kuala Lumpur
Nov-03-2025

Istanbul
Nov-10-2025

Singapore
Nov-10-2025

Paris
Nov-17-2025

Amsterdam
Nov-24-2025

Dubai
Nov-24-2025

Barcelona
Dec-01-2025

Istanbul
Dec-01-2025

Kuala Lumpur
Dec-08-2025

Singapore
Dec-08-2025

Paris
Dec-15-2025

Amsterdam
Dec-22-2025

Barcelona
Dec-29-2025

Dubai
Dec-29-2025

Kuala Lumpur
Dec-29-2025

Istanbul

Course Details

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.

By the end of the course, participants will be able to:

Boost Excel Business Intelligence (BI) expertise in data slicing and dicing, data massaging, and data aggregation and modelling
Perform data normalization, consolidation, report writing, analysis and reconciliation
Develop dynamic BI models, dashboards, scorecards and flash management reports by linking-up Excel with Access, Web, Text, Internet, SQL, ERPs and other databases.
Advance and enhance the look and feel of reports using dynamic visualization technique
Acquire numerous tips and tricks that enable them to work efficiently

Business Intelligence: Data Analysis and Reporting Techniques is ideal for:

Business professionals, business analysts, data analysts, research analysts, finance professionals,
Marketing and sales professionals,
HR professionals, IT professionals, administrative staff, supervisors, general business professionals
Staff from any function who need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision making.

Our courses in London are held at the LPC office located at:

LPC Oxford Street Offices: 25 N Row, London W1K 6DJ

London Head Office: 47 - 49 Park Royal Road, London NW10 7LQ

Once you register, we will subsequently send you the course details, including the location, trainer, and other logistical information.

Pay Attention, Please! The course location at our offices is subject to availability. Should our office be unavailable, we will secure an alternative nearby venue and promptly inform you of the change. The exact time and location will be confirmed one week prior to the course commencement.

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

Mastering data reporting: the 20 must learn pivot-tables tools

Creating pivot tables
Number formatting techniques
Designing report layout
Sorting in ascending, descending and more sort options
Filtering labels and values
Expanding and collapsing reports
Drill down option
Summarize values by sum, average, minimum, maximum, count

Data modeling and integration

Spinner
Check box data modeling with if function
Option button data modeling with if function
List box data modeling with choose function
Scenario manager
Linking Excel with text files
Linking Excel with databases (Access)
Linking Excel with SQL
Linking Excel with internet
Linking Excel with Excel

The look and feel: charting and visualization techniques

Using the camera tool
Working with formula-driven visualizations
Using fancy fonts
Leveraging symbols in formulas
Working with sparklines
Creating unconventional style charts

Tips and tricks

Controlling and protecting your reports, worksheets and workbooks
Data entry form
Custom list
Text-to-speech
Advanced conditional formatting
Shortcuts for your daily work

Business Intelligence: Data Analysis and Reporting Techniques

Course Info

Course Details

Course Outline

Course Video

Business Intelligence: Data Analysis and Reporting Techniques

Course Info

Course Details

Course Outline

Search Course

Related Courses

Course Video