Data Analysis & Dashboard Reporting in Excel is part of the Knowledge & Networking Division of Informa PLC
This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 3099067.
Data Analysis & Dashboard Reporting in Excel
تحليل البيانات وتقارير لوحة القيادة من خلال برنامج إكسل
Learn to synthesise and summarise information into a logical framework to create powerful business dashboard reporting
15 – 18 October 2017
The Address Hotel, Dubai Marina, Dubai, UAE

The VisiCalc row-and-column-based layout introduced in 1978 is what we know as spreadsheets today. These have evolved to become powerful business tools that are widely used across business functions. Step into any of the various departments in a business and you will find some business processes that are supported using Excel. Excel’s current advanced functionality together with its formatting and visual design capabilities creates a basis for its extensive use as a data analysis and business reporting tool.

سوف تتعلمون من خلال هذه الدورة كيفية تحديد البيانات المختلفة وتصنيفها في عرض مفيد للأعمال. ستفهمون ما هي البيانات و أهميتها وستدركون قيمتها باستخدام التطبيقات التحليلية. سوف تحسنون من خلال إلتحاقكم بهذه الدورة عمليات صنع القرارات عن طريق التحليل وستتعلمون كيفية العرض البصري للبيانات والدمج بين صور البيانات والرسوم البيانية والهياكل والوظائف وأمثلة حقيقية عن لوحات قيادة ديناميكية جيدة وأخرى سيئة.

تتوج الدورة بتقييم نهائي يطلب من خلاله من الحاضرين الخضوع لتقييم إنشاء لوحة القيادة الديناميكية باستخدام البيانات الخاصة بهم والأمثلة التي تم تقديمها خلال الدورة ومن خلال الجمع بين كافة المبادئ والتقنيات التي تم عرضها خلال الأيام الأربعة.

Course Content

Module One

  • Introducing dashboards
  • Defining a dashboard
  • Defining a report
  • User requirements
  • Dashboard dimensions and filters
  • Dashboard design principles
  • Best practice in data modelling
  • Excel functions and dashboards
  • Ranges and tables

Module Two

  • Table design principles
  • Custom number formatting
  • Adding and customising sparklines
  • Using conditional formatting
  • Pivot tables

Module Three

  • Charting and visualisation techniques
  • Top and bottom displays
  • Variance displays
  • Progress bars
  • Bullet graphs

Module Four

  • Leverage macros to automate reporting
  • Utilising form controls in dashboards
  • Check boxes
  • List boxes
  • Option buttons
  • تحليل البيانات
  • نظرية تحليل البيانات والعلاقات فيما بينها
  • أدوات تحليل البيانات
  • استخدام برنامج اكسل Excel  كأداة لتحليل البيانات
  • الرسم البياني وتصميم الجدول
  • تقارير لوحة القيادة
  • الأخطاء الشائعة في تصميم لوحات القيادة
  • مراجعة الرسوم البيانية
  • إضافة الرموز والصور على لوحات القيادة
  • استخدام الألوان والشعارات بفعالية
  • تصميم لوحات قيادة ديناميكية
  • التقنيات والأدوات الأساسية
  • الرسم البياني للوحات القيادة
  • لوحة القيادة الصلبة
  • الأدوات الأساسية المتقدمة
Who Should Attend
  • Finance Managers
  • Financial Controllers
  • Management Accountants
  • Financial Analysts
  • Business Analysts
  • Professionals involved in data analysis and dashboard reporting using Excel

محللو الأعمال                      المدراء التجاريون
المدراء الماليون                    المراقبون الماليون
محللو التقارير                      محللو استخبارات  الأعمال
المحللون الماليون                 أي موظف يشارك في تحليل البيانات أو إنشاء لوحات القيادة
المحاسبون الإداريون

Benefits Of Attending
  • Understand the principles of data analysis
  • Discover the tools to analyse data and build reports using your existing Excel skills
  • Know how to use visual effects to improve reports and presentations
  • Explore how to summarise, present and communicate data clearly and concisely
  • Improve the efficiency of performing routine tasks through recording, writing and editing powerful macros
  • Learn the principles of good dashboard design and how to present data graphically
  • فهم مبادئ تحليل البيانات
  • تعلم كيفية تحليل وتلخيص البيانات في إطار عمل منطقي
  • التمييز بين الحاجة إلى رسم بياني أو جدول
  • معرفة كيفية استخدام المؤثرات البصرية لتحسين التقارير والعروض
  • تعلم  كيفية تلخيص وتقديم البيانات بشكل واضح وموجز من خلال الرسوم والصور
  • استكشاف أدوات تحليل البيانات وإعداد التقارير باستخدام أدوات برنامج اكسل Excel والمهارات ذات الصلة

    Peter Hofmann
    Executive Director
    MFX Options and Solutions (Pty) Ltd, South Africa

    Peter Hofmann is an Executive Director of MFX Options and Solutions (Pty) Ltd, specialising in business management and corporate strategic and operational management consulting. The platform for his current business focus was established through his exposure to the holistic corporate business environment where he built a successful career over two decades, having established and built up successful departments focused on operational and executive management and board liaison.

    His integral involvement with a range of international clients includes projects undertaken by MFX such as:

    • Strategic business plans, functional plans and processes, supply chain management, strategic planning and process analysis for implementation of ERP systems
    • The assessment of economic, social and environmental impacts and development of systems and processes to drive performance management and reporting
    • The assessment of business intelligence frameworks to support the development of integrated graphical dashboard reporting mechanisms within business entities
    • The analysis of key ESG issues to develop reporting objectives and frameworks
    • The development and implementation of performance strategies for business units
    • The development of five-year strategies on an annual basis, customer surveys anad measurement, business unit strategies and electronic customer focused marketing campaigns

    The Address, Dubai Marina


    The Address Dubai Marina
    Dubai Marina
    P.O. Box 32923, Dubai, UAE
    T: +971 4 4367777
    F: +971 4 4367788

    click here for directions

    Standing tall in the heart of one of Dubai's most vibrant neighbourhoods, where crystal waters shimmer against modern architecture and luxury yachts moor alongside trendsetting restaurants, The Address Dubai Marina is a haven for the discerning traveller.

    With 200 luxurious rooms, five superb restaurants and lounges, a relaxing spa, spectacular infinity pool and state of the art meeting and event facilities, The Address Dubai Marina will keep you refreshed and inspired.

    Perfectly situated for your business needs, The Address Dubai Marina is just a short ride away from Dubai Media and Internet Cities, Knowledge Village, Jebel Ali Free Zone, and within walking distance from the metro station.

    And what is business without a little fun? With the white sand beaches of the Arabian Gulf just a stroll away, and the hotel's direct link to the stylish Dubai Marina Mall, The Address Dubai Marina gives you every reason to extend your stay and unwind.


    Special delegate rates have been negotiated at selected hotels and we highly recommend you secure your room reservation at the earliest to avoid last minute inconvenience. You can contact the Hospitality Desk for required assistance on:

    T:+971-4-407 2693
    F:+971-4-407 2517


    Delegates requiring visas should contact the hotel they wish to stay at directly, as soon as possible. Visas for non-GCC nationals may take several weeks to process.

Date Course Fee Before
6 August 2017
Course Fee Before
10 September 2017
Final Fee
15 – 18 October 2017
US$ 3,995 US$ 4,495 US$ 4,995
Course fees include documentation, luncheon and refreshments. Delegates who attend all sessions and successfully complete the course assessment will receive an Informa Certificate of Completion.

Pricing excludes 5% VAT, where applicable


Book and pay full fee for two colleagues and the third attends for FREE

  • Not applicable in conjunction with corporate discounts
  • Payment to be settled before start of the course to avail the offer
  • This offer is not applicable on Early Bird Prices

For more information, email Andy Watts on

You Might Want To Check These Related Events
Copyright © 2016. KNect365, All rights reserved