Where is this course held?

Upcoming sessions run in Barcelona, Paris, Frankfurt, Rome, Kuala Lumpur.

How much does the course cost?

Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Business Intelligence: Data Analysis and Reporting Techniques Training Course

Q: How long is the Business Intelligence: Data Analysis and Reporting Techniques course?

The course runs over 5 days of classroom training, usually Monday to Friday.

Q: When is the next Business Intelligence: Data Analysis and Reporting Techniques course?

The next public date is 14 - 18 Dec 2026 in Barcelona. There are 13 upcoming dates in total.

Q: Can I take Business Intelligence: Data Analysis and Reporting Techniques online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

Course overview

Why Attend

In this day and age it is no surprise for corporate staff to be overwhelmed by the abundance of unstructured data. ERPs and databases have evolved to a point where they can house amazingly large amounts of data. The question now is, what do you do with this data to add value? 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, analyze 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, modeling, integration and automation.

Course Methodology

20% of the course is design and structure focused while 80% uses MS Excel as a BI tool. Groups and individuals will be required to complete exercises, case studies, and projects on a daily basis.

Course Objectives

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 modeling
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 techniques
Acquire numerous tips and tricks that enable them to work efficiently

Target Audience

Business professionals, business analysts, data analysts, research analysts, finance professionals, marketing and sales professionals, HR professionals, IT professionals, administrative staff, supervisors, general business professionals and 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.

Target Competencies

Massaging and normalizing data
Reporting, analysis and reconciliation
Interpretation of large data sets
Modeling and 'what-if' scenarios
Establishing data integration
Developing dynamic dashboards and scorecards
Designing key performance indicators

Course outline

1Day 1: 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
2Day 2: 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
- Show values as % of total and % of
- Pivot table options
- Inserting formulas
- Date analysis
- Copying pivot tables
- Creating pivot charts
- Dynamic chart labeling
- Mastering the slicer
- Showing report filter pages
- Linking pivot tables and pivot graphs with PowerPoint
- Conditional formatting with pivot tables
- Designing reports using the getpivotdata
3Day 3: 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
4Day 4: 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
5Day 5: 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

Schedule

Dates and fees

13 upcoming dates in 5 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF

December 2026

14DEC 14 - 18 Dec 2026Mon to Fri · 5 daysNext session

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

January 2027

18JAN 18 - 22 Jan 2027Mon to Fri · 5 days

ParisFrance · Classroom

£3,250per delegate2+ people: £2,600 each

February 2027

15FEB 15 - 19 Feb 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

March 2027

15MAR 15 - 19 Mar 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

April 2027

19APR 19 - 23 Apr 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

May 2027

17MAY 17 - 21 May 2027Mon to Fri · 5 days

RomeItaly · Classroom

£4,250per delegate2+ people: £3,400 each

June 2027

21JUN 21 - 25 Jun 2027Mon to Fri · 5 days

Kuala LumpurMalaysia · Classroom

£2,250per delegate2+ people: £1,800 each

July 2027

19JUL 19 - 23 Jul 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

August 2027

16AUG 16 - 20 Aug 2027Mon to Fri · 5 days

ParisFrance · Classroom

£3,250per delegate2+ people: £2,600 each

September 2027

20SEP 20 - 24 Sep 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

October 2027

18OCT 18 - 22 Oct 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

November 2027

15NOV 15 - 19 Nov 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

December 2027

20DEC 20 - 24 Dec 2027Mon to Fri · 5 days

RomeItaly · Classroom

£4,250per delegate2+ people: £3,400 each

Live online, on the same dates

Join the class in real time from your office or home: live sessions with the trainer, group discussion, course materials and a certificate of completion. Joining details are emailed before the course starts.

December 2026

14DEC 14 - 18 Dec 2026Mon to Fri · 5 daysNext session

Live onlineVirtual classroom · join from anywhere