Business Intelligence: Data Analysis and Reporting Techniques

Course Info

Length: 1 Week

Type: In Classroom

Available Dates

Venue

  • Apr-01-2024

    London

  • Apr-01-2024

    Amsterdam

  • Apr-08-2024

    Istanbul

  • Apr-08-2024

    Kuala Lumpur

  • Apr-15-2024

    Paris

  • Apr-15-2024

    Dubai

  • Apr-15-2024

    Singapore

  • Apr-22-2024

    Amsterdam

  • Apr-22-2024

    Dubai

  • Apr-29-2024

    London

  • Apr-29-2024

    Barcelona

  • May-06-2024

    Amsterdam

  • May-06-2024

    London

  • May-13-2024

    Kuala Lumpur

  • May-13-2024

    Istanbul

  • May-20-2024

    Paris

  • May-20-2024

    Singapore

  • May-27-2024

    Barcelona

  • May-27-2024

    Dubai

  • June-03-2024

    Amsterdam

  • June-03-2024

    London

  • June-10-2024

    Kuala Lumpur

  • June-10-2024

    Istanbul

  • June-17-2024

    Singapore

  • June-17-2024

    Paris

  • June-24-2024

    Dubai

  • June-24-2024

    Barcelona

  • July-01-2024

    Amsterdam

  • July-01-2024

    London

  • July-08-2024

    Kuala Lumpur

  • July-08-2024

    Istanbul

  • July-15-2024

    Paris

  • July-15-2024

    Singapore

  • July-22-2024

    Amsterdam

  • July-22-2024

    Dubai

  • July-29-2024

    London

  • July-29-2024

    Barcelona

  • Aug-05-2024

    London

  • Aug-05-2024

    Amsterdam

  • Aug-12-2024

    Istanbul

  • Aug-12-2024

    Kuala Lumpur

  • Aug-19-2024

    Paris

  • Aug-19-2024

    Singapore

  • Aug-26-2024

    Dubai

  • Aug-26-2024

    Barcelona

  • Sep-02-2024

    Amsterdam

  • Sep-02-2024

    London

  • Sep-09-2024

    Istanbul

  • Sep-09-2024

    Kuala Lumpur

  • Sep-16-2024

    Singapore

  • Sep-16-2024

    Paris

  • Sep-23-2024

    Dubai

  • Sep-23-2024

    Amsterdam

  • Sep-30-2024

    London

  • Sep-30-2024

    Barcelona

  • Oct-07-2024

    London

  • Oct-07-2024

    Amsterdam

  • Oct-14-2024

    Kuala Lumpur

  • Oct-14-2024

    Istanbul

  • Oct-21-2024

    Paris

  • Oct-21-2024

    Singapore

  • Oct-28-2024

    Barcelona

  • Oct-28-2024

    Dubai

  • Nov-04-2024

    Amsterdam

  • Nov-04-2024

    London

  • Nov-11-2024

    Istanbul

  • Nov-11-2024

    Kuala Lumpur

  • Nov-18-2024

    Singapore

  • Nov-18-2024

    Paris

  • Nov-25-2024

    Barcelona

  • Nov-25-2024

    Dubai

  • Dec-02-2024

    Amsterdam

  • Dec-02-2024

    London

  • 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

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