Business Intelligence: Data Analysis and Reporting Techniques

Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • 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

  • Dec-30-2024

    London

  • Jan-06-2025

    Istanbul

  • Jan-06-2025

    Kuala Lumpur

  • Jan-13-2025

    Paris

  • Jan-13-2025

    Singapore

  • Jan-20-2025

    London

  • 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

    London

  • 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

    London

  • 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-21-2025

    London

  • 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

    London

  • 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

    London

  • 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

    London

  • 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

    London

  • 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

    London

  • 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-20-2025

    London

  • 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-17-2025

    London

  • 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

    London

  • Dec-15-2025

    Amsterdam

  • Dec-22-2025

    Barcelona

  • Dec-29-2025

    Dubai

  • Dec-29-2025

    Kuala Lumpur

  • Dec-29-2025

    Istanbul

Course Details

Course Outline

5 days course

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

Course Video