Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Business Intelligence: Data Modelling, Data Analysis and Reporting Techniques Training

By: LCL Coaches Consultants  

Lagos State, Nigeria

25 - 29 Oct, 2021  5 days

Follow Event

  

NGN 157,500

Venue: Lagos

This program is designed to help participants access business intelligence. You will be to able to clean, normalize, and interpret large data volumes. Also develop competence to establish historical relationships, analyze current situation and predict future strategies. The application of BI covers operational, tactical and strategic business decisions. It spans all departments and cascades down to all users who perform data reporting, analyses, modeling, integration and automation.

Course Objectives

By the end of the course, participants will be able to:

  • Boost Excel Business Intelligence (BI) expertise in data slicing and dicing, data massaging, and data aggregation and modeling
  • Perform data normalization, consolidation, report writing, analysis and reconciliation
  • Develop dynamic BI models, dashboards,scorecards and flash management reports by linking up Excel with  Access, web, text, SQL.Oracle and other databases
  • Advance and enhance your reports’ look and feel usinf dynamic visualization techniques 
  • Model and Forecast Financial Reports
  • Reference and Linking Business data in models
  • Massage and normalize data
  • Report, Interpret, analyze and reconcile date
  • Model and 'what-if' scenarios
  • Data integrate
  • Use Dynamic dashboards and scorecards
  • Create Key performance indicators
  • Build cash   and flexible budget models
  • use various breakeven techniques
  • Know how to value businesses
  • Make optimal decision regarding investment.
  • Add tremendous value to your report and the business

Course Contents

Day One

  • Business Performance Analysis
  • Cash flow Forecast Models
  • Excel Referencing and application
  • Linking and worksheet Consolidation
  • Forecasting Models
  • Historical Forecast (Point Forecast)
  • Trend Lines (Interval Forecast)
  • Cyclicality and Seasonality

Forecasting Financial Reports;

  • Key Drivers
  • Driving Financial Statements
  • Alternative Approaches

Day Two

Variance Analysis

Breakeven Analysis

  • Breakeven
  • Operating Leverage
  • Financial Leverage
  • Budget variance
  • Budgeting and Control
  • Example of Personal Budget
  • Example of Company Budget
  • Flexible budget model
  • Fixed budget model.

Day Three

  • Portfolio Analysis
  • Cost of Capital
  • Capital Asset Pricing Model
  • Dividend Growth Model
  • Cost of Preference Share
  • Cost of Debt
  • Weighted Average Cost of Capital (WACC)
  • Marginal WACC

Day Four

Investment Analysis

  • Payback Period
  • Accounting Rate of Returns
  • Internal Rate of Return
  • Net Present Value
  • Loan Management and Loan Determination Schedule
  • Benefit/Cost Ratio
  • Capital Rationing
  • Scenarios and Sensitivity Analysis and Charts

Risk and Return Analysis

  • Company Valuation
  • Adjusted Accounting Valuation
  • Dividends Valuation
  • Market Valuation
  • Free Cash flow Valuation

Day Five

Portfolio Analysis

  • Elements of Optimizing Models
  • Linear Programming
  • Margin Maximization
  • Bayes’ Theorem
  • Decision Tree Model
  • Building Sensitivity analysis and Scenarios into Models
  • Introduction and Application of Macro to enhance your Model.
Lagos Oct 25 - 29 Oct, 2021
NGN 157,500.00(Group Booking Discount Available)
(Convert Currency)

Olusina Lajorin 09026713101,08033241313

Group discount apply
Olusina Lajorin

Related Courses

Leading Strategic Human Resources Transformation Course Leading Strategic Human Resources Transformation Course

4 days, 02 - 05 Nov, 2021 

2021-11-02 12:11:00 2021-11-02 12:11:00
Abuja FCT, Nigeria

LCL Coaches Consultants

HR Transformation is about driving the achievement of business results. This training will help delegates deliver more than just basic administration but more on transformation efforts designed to ...

Winning Negotiation Skills Development Training Winning Negotiation Skills Development Training

3 days, 23 - 25 Nov, 2021 

2021-11-23 12:11:00 2021-11-23 12:11:00
Lagos State, Nigeria

LCL Coaches Consultants

In today Competitive world, the ability to negotiate effectively is highly appreciated. Business suffers a great loss due to poor negotiation skills while they can increase their profitability with ...

Life After Service/ Pre Retirement Workshop Life After Service/ Pre Retirement Workshop

5 days, 11 - 15 Apr, 2022 

2022-04-11 12:04:00 2022-04-11 12:04:00
Lagos State, Nigeria

LCL Coaches Consultants

An increasing number of people retire every year at different levels. Many retirees are not prepared for such a drastic change as they discover that the pension is inadequate. The employer, in ...

Effective Communication and Interpersonal Relations Course Effective Communication and Interpersonal Relations Course

5 days, 25 - 29 Oct, 2021 

2021-10-25 12:10:00 2021-10-25 12:10:00
Abuja FCT, Nigeria

LCL Coaches Consultants

Many organisations are characterised by strained relations and conflict which undermine operations and performance. Communication and interpersonal relations are complementary tools for reducing ...