Business Intelligence: Data Analysis and Reporting Techniques


Course Calendar

DateLocationFees
31 Dec 2018 - 4 Jan 2019Dublin3,800 €
7 Jan - 11 Jan 2019Munich2,800 €
21 Jan - 25 Jan 2019Barcelona2,800 €
4 Feb - 8 Feb 2019Munich2,800 €
11 Feb - 15 Feb 2019Stockholm2,800 €
25 Feb - 1 Mar 2019London3,800 €
4 Mar - 8 Mar 2019Munich3,800 €
11 Mar - 15 Mar 2019Istanbul1,500 €
25 Mar - 29 Mar 2019Munich2,800 €
1 Apr - 5 Apr 2019London3,800 €
15 Apr - 19 Apr 2019Stockholm2,800 €
22 Apr - 26 Apr 2019Munich2,800 €
6 May - 10 May 2019London3,800 €
20 May - 24 May 2019Stockholm2,800 €
27 May - 31 May 2019Istanbul1,500 €
10 Jun - 14 Jun 2019London3,800 €
17 Jun - 14 Jun 2019Dublin3,800 €
1 Jul - 5 Jul 2019Munich2,800 €
15 Jul - 19 Jul 2019Barcelona2,800 €
22 Jul - 26 Jul 2019Munich2,800 €
5 Aug - 9 Aug 2019Stockholm2,800 €
19 Aug - 23 Aug 2019London3,800 €
26 Aug - 30 Aug 2019London3,800 €
9 Sep - 13 Sep 2019Stockholm2,800 €
23 Sep - 27 Sep 2019Istanbul1,500 €
30 Sep - 4 Oct 2019London3,800 €
7 Oct - 11 Oct 2019Dublin3,800 €
21 Oct - 25 Oct 2019Munich2,800 €
28 Oct - 1 Nov 2019Stockholm2,800 €
11 Nov - 15 Nov 2019Munich3,800 €
25 Nov - 29 Nov 2019Istanbul1,500 €
2 Dec - 6 Dec 2019Munich2,800 €
16 Dec - 20 Dec 2019Prague2,800 €
23 Dec - 27 Dec 2019Manchester3,100 €
6 Jan - 10 Jan 2020Berlin3,800 €
20 Jan - 24 Jan 2020London3,800 €
27 Jan - 31 Jan 2020Munich3,800 €

* Price excluding VAT


Outline PDF



  • Planning and Strategy Management

Course Description

 
Course Objectives
 
By the end of the Program, Participants will be able to:
  • Boost Excel Business Intelligence (BI) expertise in business and management reporting.
  • Perform automated report writing, analysis and reconciliation.
  • Link their Excel with PowerPoint for dynamic data update.
  • Develop dynamic BI dashboards, scorecards and flash management reports to assist professionals in measuring performance and enhancing decision making.
  • Use advanced report development techniques by linking-up Excel with Access, Web, Text, SQL, Oracle and other databases.
  • Design, prepare and run reports using PowerPivots as a BI tool.
  • Perform data analysis techniques to produce timely and accurate reports.
 
Who Should Attend
 
Business professionals, business analysts, research professionals, marketing and sales, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations and analysis. 
 
Course Outline
 
Tools and Techniques
 
Consolidating Data from Separate Files and Sheets
Advanced Data Validation Using Lists, Dates and Custom Validation
Array Functions
Cell Management Tools: Left, Right, Mid, Concatenate, Value
Naming Cells and Ranges
Subtotal, Sumif, Sumifs, Sumproduct
Looking-Up Data, Texts, and Values Using Vlookup
The Incredible Table Tools Techniques
Slicing Dates into Day Names, Month Names, Years and Quarters
Text to Columns and Dynamic Trimming Using Trim, Len,
Find and Substitute
Text Change Functions
 
 
The 19 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
Summarize Data By Sum, Average, Minimum, Maximum, Count
Show Values as % of Total & % 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
 
 
Report Design and Modeling Techniques Spinner
 
Check Box Data Modeling with IF function
Option Box Data Modeling with IF function
List Box Data Modeling with CHOOSE function
Linking Excel with Text Files
Linking Excel with Databases (Access)
Linking Excel with SQL
Linking Excel with Internet
Scenario Manager
 
 
Charting and Visualization Techniques
 
Creating Dynamic Labels
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 in Excel
 
Controlling and Protecting Your Reports, Analysis and
Reconciliations
Data Entry Form
Custom List
Text to Speech
Protecting Worksheets and Workbooks

Download PDF Enroll Now


Latest Tweets

Contact Us

  • Address:27 Old Gloucester Street , Monomark House , WC1N 3AX , London , United Kingdom

  • Phone: +44(203)2399994

  • Email: info@informatech.co.uk

  • Company Registered in U.K No. 10532767

Follow Us