Certified Data Analysis and Dashboard Reporting in Excel Masterclass

Event Date:

Event Time:

Event Location:

Radisson Blu Hotel, Sandton

Certified Data Analysis and Dashboard Reporting in Excel Masterclass

OVERVIEW

Are you aware that Excel has introduced new features like built-in Python Integration bringing in versatile and well-supported Python data analysis functions and visualision(charts), new special Charts, AI Business Intelligent features, Database-like design and modelling in Power Pivot, Database and SQL-like language called DAX in Power Pivot. The combination of just the Power Query Feature and Power Pivot will enable you to connect to external databases of various kinds and build your own dynamic dashboards to analyse BIG DATA beyond the capabilities of what traditional EXCEL can do.  It is well known that many users of Excel working with financial data do not make optimal use of what the Excel package offers for BIG DATA ANALYSIS. The emphasis of this course is to transfer key knowledge areas in analysing data, developing reporting dashboards and in developing workable Excel models and the use of the advanced Excel 2021 functionality to enable delegates to develop financial models for decision making.

This masterclass is delivered using a combination of formal instruction and sample dashboards combined with practical and interactive exercises and case studies used to reinforce the concepts taught in each section of the course. Case studies include critique of conventional budgeting techniques and real-world examples of problems and latest dashboard techniques and best practice guidelines. This masterclass is demonstrated mostly using Microsoft Excel 2021. This masterclass is one of its kind, crash course, very practical and hands-on delivered by a facilitator with a rare skill-set in Data Science spanning across SQL, Python, Power BI, Excel, Programming, Risk Management, Budgeting and Forecasting. Above, the facilitator is a Chartered Accountant Accountant who has used Excel for many years and understands it's various applications to the specific situations and environment of the delegates.  The facilitator has joined the Microsoft Insider Programme and contributes the the continuous development of Excel to ensure it matches the developments in other competing Business Intelligence Tools. For that reason, the course will emphasise all the versatile BI Capabilities of Excel in Session 9.  In order to complete the exercises, delegates are required to use their own laptops with the recommended version of Excel.

REGISTRATION:

Investment:
R14 999 Excl VAT (Online)

R18 999 Excl VAT (Face to face)

To download the brochure or send an enquiry, Please complete the form below then a download link will be made available to you after you click submit.

Download Brochure and Send Enquiry

    I would like to receive email updates regarding future Masterclasses

    Sorry, this event is expired and no longer available.

    Event Location:

    • Radisson Blu Hotel, Sandton
    • Johannesburg
    • Gauteng
    • 2000
    • South Africa

    Event Schedule Details

      Share This Events:
      Add Calendar
      Subscribe To Our Newsletter
      So you can be the first to find out our latest classes and news

        I have read and agree to Dupleix Institute ’s Privacy Policy

        CANCEL
        The data you send is secure on our website.