Business Intelligence for Finance, Accounting and Management bootcamp

To equip professionals with the skills to build dynamic risk analytics models to identify, measure and mitigate risk before they affect your business operations

Greetings & Welcome

About The Event

Develop robust financial analytics models connected to your core systems to analyse financial performance, operational bottlenecks, and forecast to stay ahead of your competition.

December 9-13, 2019 @ 08 - 00 am

A FIVE days boot camp

What to Expect

Event Schedule

Professionals will acquire the skills to connect to any core system (s) in their organization leveraging from Advanced features in Business Intelligence and analyse hundreds of millions of data.

Download Full Schedule

  • 9th DAY 1
  • 10th DAY 2
  • 11th DAY 3
  • 12th DAY 4
  • 13th DAY 5

Day One

Introduction to 360 Audit Analytics with PivotTables

Professionals will be introduced to 360-degree analytics in Microsoft Excel leveraging the power of advanced features like PivotTables, Conditional formatting, styles, slicers, implicit measures and timelines.

Coverage:
i. Analyse large datasets in matter of seconds with robust PivotTable features.
ii. Develop customized risk identification tools for reporting
iii. Perform level of detail analytics to unearth the finest detail of risk in their models
iv. Generate risk interactive exposing heatmaps
v. Manipulating data with implicit measures for quick analysis.
vi. Preparing analytical reports for printing.
vii. Implementing dynamic charts for risk analysis and exposure of high-risk areas.
viii. Building interactive reports for presentation and sharing online

Coverage:

  • Building dynamic risk registers and logs
  • Generating 360-degree risk analytics reports
  • Highlighting red flags and areas of underperformance in your organization
  • Generate year on year comparisons, lead and lag segments in your business
  • Developing volume risk assessment tools
  • Build interactive risk management presentations
  • Level of detail analytics

Day Two

1. Connecting to systems to automate your reporting

This module introduces risk professionals to Advanced Excel’s features in connecting to business systems like databases (finance systems, HR, ERPs, etc), cloud technologies (amazon, azure, etc), big data platforms (Hadoop, etc), flat files (.csv, text files, folders, etc). Also, they will acquire the techniques to automate their cleaning and structuring of big data in a matter of seconds while maintaining an Audit Trail to trace back previous instructions. By the end of this module;

Coverage:
a. Concepts of ETL and Data Connections
b. Structuring, cleaning, and transformation of big data
c. Introduction to the M Language.
d. Data destinations and consolidations

2. Data Modeling, Storage and Normalization

In this training module, professionals will be introduced to the MS Excel Data Model that can handle analysis and modeling of billions of data.  Auditors will be able to join different systems to  perform cross platform audits (make comprehensive
comparisons and deductions).

Coverage:
a. Advanced-Data Modeling and Cross-Platform Analytics
b. Entity Relationship Diagrams
c. Buckets and stratification

Day Three

Audit Command Language: Data Analysis Expressions (DAX)

This module introduces professionals to advanced audit analytics with the business intelligence language of Data Analysis Expressions. Auditors will learn how to deploy explicit measures to perform robust analysis on their datasets and conduct sophisticated audits of their datasets.

Coverage:
a. KPI Measures and Benchmarking
b. Harvesters and Banding
c. The Language of Data Analysis Expressions

Day Four

1. Audit Command Language: Data Analysis Expressions (DAX)

This module introduces professionals to advanced audit analytics with the business intelligence language of Data Analysis Expressions. Auditors will learn how to deploy explicit measures to perform robust analysis on their datasets and conduct sophisticated audits of their datasets.

Coverage:
a. KPI Measures and Benchmarking
b. Harvesters and Banding
c. The Language of Data Analysis Expressions

2. Building Real-Time Audit Reports

This module will equip professionals with the skills to develop dynamic audit reports and dashboards for presentation and sharing with relevant stakeholders. They will be introduced to the tools to build automated solutions from trial balancing to outlier detection.

Coverage:
a. Cube Formulas and Data Model Extraction techniques
b. Real-time Audit Reporting systems
c. Building fully-fledged audit intelligence
d. Developing an automated corporate dashboard for audit and finance reports.

Day Five

Documenting Data Analytics Findings

In this final module, professionals will learn the skills generate tidy, well-formatted and best practice audit report by applying advanced techniques in Word Processing so as to make comprehensive audit reports.

Coverage:
a. Producing audit reports
b. The DPP-Model
c. Packaging an audit report.

Who should attend?

  1. Finance and Audit professionals analyzing risk intheir financial, investment and banking models.
  2. Managers and Executives who monitor and arerequired to produce reports and dashboards topresent to their teams and board members.
  3. Risk Management Professionals looking to develop robust risk assessment models, looking for areas to mitigate risk and potential grounds to leverage.
  4. Entrepreneurs looking to assess investment decisions, prepare financial proposals and projectfuture returns based on historical data.
Speakers

Event Speakers

Never hesitate to ask

Frequent Asked Questions

How do I register for the Bootcamp?

You can register now. Alternatively call +256 414 231 136 or contact Cathie on 0784270519.

What is the cost to attend?

Book early for the lowest prices

  • Early-bird registration (expires 15th September 2019): UGX 1,000,000 per person full access.

  • Standard registration: UGX 1,200,000 per person full access.

What is included in the full registration price?

Registration fee includes the attendance, documentation, breakfast and lunch.

What are the Business Intelligence for Finance, Accounting and Management bootcamp hours?

The Credit, Investiment & Risk Analytics Bootcamp will begin Monday, 23rd September at 8:30 a.m. (registration opens at 7:30 a.m.) and will end on Friday, 27th September at 4:30 p.m.

Never hesitate to ask

Didn't find yet?
Ask your question

Recommend a Friend

Share on whatsapp
Share on facebook
Share on skype
Share on twitter
Share on linkedin
Share on telegram

Share this to invite
your friends too!

Before its too late. Register early

Scroll to Top
Chat with us
Chat with us
Questions, doubts, issues? We're here to help you!
Connecting...
None of our operators are available at the moment. Please, try again later.
Our operators are busy. Please try again later
:
:
:

The data collected by this form is used to get in touch with you. For more information, please check out our privacy policy
Have you got question? Write to us!
:
:

The data collected by the chat form is used to get in touch with you. For more information, please check out our privacy policy
This chat session has ended
Was this conversation useful? Vote this chat session.
Good Bad