Five-day professional programmes in 14 citiesClassroom, online and in-house info@aractech.com +31 85 7444446

Professional training course

Business Intelligence: Data Analysis and Reporting Techniques

In this day and age it is no surprise for corporate staff to be overwhelmed by the abundance of unstructured data. The outline covers Data analysis tools and techniques, Mastering data reporting: the 20 must learn pivot-...

  • 5 daysClassroom or online
  • 13Upcoming dates
  • 5Cities
  • €2,175Fees from

Choose your format and date

  • 5 days
  • 09:00–14:00
  • Certificate of attendance

Classroom sessions

  1. 14–18 Dec 2026

    Barcelona

    Next date
    €2,275 + VAT
    Register
  2. 18–22 Jan 2027

    Paris

    €2,810 + VAT
    Register
  3. 15–19 Feb 2027

    Frankfurt

    Lowest fee
    €2,175 + VAT
    Register
  4. 15–19 Mar 2027

    Barcelona

    €2,275 + VAT
    Register
  5. 19–23 Apr 2027

    Frankfurt

    Lowest fee
    €2,175 + VAT
    Register
  6. 17–21 May 2027

    Rome

    €2,830 + VAT
    Register
  7. 21–25 Jun 2027

    Kuala Lumpur

    €2,425 + VAT
    Register
  8. 19–23 Jul 2027

    Barcelona

    €2,275 + VAT
    Register
  9. 16–20 Aug 2027

    Paris

    €2,810 + VAT
    Register
  10. 20–24 Sep 2027

    Frankfurt

    Lowest fee
    €2,175 + VAT
    Register
  11. 18–22 Oct 2027

    Barcelona

    €2,275 + VAT
    Register
  12. 15–19 Nov 2027

    Frankfurt

    Lowest fee
    €2,175 + VAT
    Register
  13. 20–24 Dec 2027

    Rome

    €2,830 + VAT
    Register

Online / Live sessions

  1. 14–18 Dec 2026

    Live virtual classroom

    Next date
    €1,625 + VAT
    Register
  2. 18–22 Jan 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  3. 15–19 Feb 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  4. 15–19 Mar 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  5. 19–23 Apr 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  6. 17–21 May 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  7. 21–25 Jun 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  8. 19–23 Jul 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  9. 16–20 Aug 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  10. 20–24 Sep 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  11. 18–22 Oct 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  12. 15–19 Nov 2027

    Live virtual classroom

    €1,625 + VAT
    Register
  13. 20–24 Dec 2027

    Live virtual classroom

    €1,625 + VAT
    Register

Introduction

Course overview

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.

View full course outline

What you will achieve

Learning objectives

  • 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

Who should attend

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.

Methodology

Learning approach

  • 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.

Complete course outline

Five focused days of learning and application

The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.

Day 1

Data analysis tools and techniques

  1. Consolidating data from separate files and sheets
  2. Advanced data validation using lists, dates and custom validation
  3. Powerful array functions
  4. Cell management tools: left, right, mid, concatenate, value
  5. Naming, editing, and managing cells and ranges
  6. Subtotal, sumif, sumifs, sumproduct, count, countif, countifs
  7. Coffee break
  8. Subtotal, sumif, sumifs, sumproduct, count, countif, countifs (continued)
  9. Looking-up data, texts, and values using vlookup
  10. The incredible table-tools technique
  11. Slicing dates into day names, weeks, week numbers, month names, years and quarters
  12. Text-to-columns and dynamic trimming using trim and len
  13. Managing texts and numbers using replace, find, and substitute
  14. Text change functions

Day 2

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

  1. Creating pivot tables
  2. Number formatting techniques
  3. Designing report layout
  4. Sorting in ascending, descending and more sort options
  5. Filtering labels and values
  6. Expanding and collapsing reports
  7. Drill down option
  8. Summarize values by sum, average, minimum, maximum, count
  9. Show values as % of total and % of
  10. Coffee break
  11. Show values as % of total and % of (continued)
  12. Pivot table options
  13. Inserting formulas
  14. Date analysis
  15. Copying pivot tables
  16. Creating pivot charts
  17. Dynamic chart labeling
  18. Mastering the slicer
  19. Showing report filter pages
  20. Linking pivot tables and pivot graphs with PowerPoint
  21. Conditional formatting with pivot tables
  22. Designing reports using the getpivotdata

Day 3

Data modeling and integration

  1. Spinner
  2. Check box data modeling with if function
  3. Option button data modeling with if function
  4. List box data modeling with choose function
  5. Scenario manager
  6. Coffee break
  7. Scenario manager (continued)
  8. Linking Excel with text files
  9. Linking Excel with databases (Access)
  10. Linking Excel with SQL
  11. Linking Excel with internet
  12. Linking Excel with Excel

Day 4

The look and feel: charting and visualization techniques

  1. Using the camera tool
  2. Working with formula-driven visualizations
  3. Using fancy fonts
  4. Coffee break
  5. Using fancy fonts (continued)
  6. Leveraging symbols in formulas
  7. Working with sparklines
  8. Creating unconventional style charts

Day 5

Tips and tricks

  1. Controlling and protecting your reports, worksheets and workbooks
  2. Data entry form
  3. Custom list
  4. Coffee break
  5. Custom list (continued)
  6. Text-to-speech
  7. Advanced conditional formatting
  8. Shortcuts for your daily work

Ready to book?

Business Intelligence: Data Analysis and Reporting Techniques

Next session: 14 - 18 December 2026, Barcelona

Course FAQs

Questions about this course

What participants and training managers usually ask before booking Business Intelligence: Data Analysis and Reporting Techniques. Can't find your answer?

WhatsApp
What does Business Intelligence: Data Analysis and Reporting Techniques cover?

This course covers Data Management and Business Intelligence through a structured five-day outline focused on practical application, discussion, and implementation planning.

When is the next available session?

The next scheduled session starts on 14 - 18 December 2026. See the course schedules section for the available dates and delivery formats.

Who should attend this course?

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.

Is bilingual course delivery available?

Yes. All course materials and presentations are provided in English, while bilingual explanation and discussion support may be available depending on the selected location and trainer availability. For example, when attending a course in Istanbul, you may request a Turkish-speaking trainer to explain the English course content in Turkish. Arabic explanation support may also be requested at this location. Other languages are available in selected cities. You can choose your preferred language support as an optional preference during registration.

How can I register for a session?

Use any Register button next to the available course dates to open the participant registration page and submit your booking request for the selected session.

Is this course available online as well as classroom-based?

Check the course schedules section for currently published classroom and Online / Live sessions.

Where are classroom sessions delivered?

Current classroom venues include Barcelona, Paris, Frankfurt, Rome, Kuala lumpur.

How long is the training programme?

The programme runs for five days from 09:00 to 14:00, which gives 25 contact hours, including a daily 30-minute break (22.5 hours of instruction).