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

19 - 22 Nov, 2019  4 days

Follow Event

  

NGN 125,500

Venue: No 2 Oyefeso Avenue (road between Consolidated Hallmark Insurance and Fidson Ltd), Off Ikorodu road, Savoil Bus stop, Obanikoro, 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.

In this program we extensively use MS Excel as an important and readily available BI tool allowing you to develop an exclusive level of expertise and adding immediate value to your job and company.

Target Audience

Business professionals, business analysts, research analysts, marketing and sales professionals, Finance and Admin professionals,  HR professionals, IT professionals, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision making.

Course Methodology

20% of the program is designed and structure focused. 80% uses MS Excel as a BI tool. Groups and individuals will be required to complete exercises, case studies, and projects on daily basis. Required to bring your Laptop

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

Variance Analysi

Breakeven Analysis

  • Breakeven
  • Operating Leverage
  • Financial Leverage

Day Two

  • 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

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

Day Four

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

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.
No 2 Oyefeso Avenue (road between Consolidated Hallmark Insurance and Fidson Ltd), Off Ikorodu road, Savoil Bus stop, Obanikoro, Lagos Nov 19 - 22 Nov, 2019

Registration: 09:30:am - 04:30:am

NGN 125,500.00
(Convert Currency)

Olusina Lajorin 09026713101,08033241313

Discount of 5% for 2 to 4 booking, 10% for 5 plus booking
Olusina Lajorin
NST PPC Advert
Related Courses
Performance Appraisal and  Management System Training Performance Appraisal and Management System Training

3 days, 27 - 29 Aug, 2019 

2019-08-27 12:08:00
Lagos State, Nigeria

LCL Coaches Consultants

Performance management is an opportunity to re-engage managers to the corporate goals through the process of setting objectives, assessing progress, providing on-going coaching and feedback to ensure ...

Consultative Selling Approaches that Create Long Term Business Relationships  Course Consultative Selling Approaches that Create Long Term Business Relationships Course

3 days, 07 - 09 Aug, 2019 

2019-08-07 12:08:00
Lagos State, Nigeria

LCL Coaches Consultants

Consultative Selling Approach provides the sales personal and team with a toolbox of effective business to business selling techniques. The course is designed to provide approaches to build long term ...

Effective Business Continuity Planning and Management Approaches Course Effective Business Continuity Planning and Management Approaches Course

4 days, 19 - 22 Nov, 2019 

2019-11-19 12:11:00
Lagos State, Nigeria

LCL Coaches Consultants

This Effective Business Continuity Planning and Management Approaches training is designed to develop and implement a powerful Business Continuity Management Plan. Created with the diligent manager ...

Train The Trainer Workshop Train The Trainer Workshop

3 days, 24 - 26 Sep, 2019 

2019-09-24 12:09:00
Lagos State, Nigeria

LCL Coaches Consultants

This Three-day programme provides practical help to enable participants to grasp the mindset of an expert trainer and appreciate the ‘inner game’ of beliefs and values as they apply to ...