Nigerian Seminars and Trainings

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

business logo

Business Analytics and Data Management

By: Tom Associates Training  

Lagos State, Nigeria

04 - 08 Jul, 2022  5 days

Follow Event

  

NGN 194,999

Venue: 5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos

Other Dates

Venue Date Fee  
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos, Lagos State, Nigeria 12 - 16 Dec, 2022 NGN194999

How can you put data to work for your organization? 

How can numbers be used to tell you about present and future of your business activities and potentials?

This course answers these questions with quantitative models. Candidates who take part in it will understand the fundamentals of this critical data management skill. 

Through a series of short lectures, demonstrations, candidates will learn the key ideas with which they can begin to create their own standard models. Next, candidates will equally handle a variety of building blocks that will allow them to start structuring own models.

Course Contents

Day One

Data Manipulation and Analysis

• Definition and Uses of Data, Models and Common Functions

• How Models are Used in Practice

• Key Steps in the Modeling Process

• Pivot Table 

  • Default Pivot Table
  • Tabular Pivot Table
  • Pivot Table Filtering
  • Making a dynamic regular table from Pivot Table
  • Calculations and Formula use with Pivot Table
  • Advanced Pivot Table tricks.

• PowerPivot for Data Mining (Excel 2013 or 2010 with PowerPivot Addin)

  • Working with data of over 2 million rows
  • Connecting with multiple sources of data
  • DAX formulas
  • Most popular PowerPivot Analysis.

• PowerQuery

  • Understanding what PowerQuery is
  • Simple practical uses
  • Using it to connect to third party data sources (your ERP or Database).

• PowerView

  • Understanding what PowerView is
  • Simple practical uses.

• Power Map 

  • Plotting your data on a live map that can be zoomed and rotated
  • Special amazing use of the Power Map.

 

DAY TWO

• Charting Large Data

  • Understanding the principles that guide visualizing large data
  • Making charts that bring insights to a large data
  • Building a large data dashboard.

• Making Professional Reports in Excel and Dashboards

  • Linking sheets 
  • Duplicating sheets (better than copy and paste)
  • Inserting sheets, labeling, and coloring the professional way
  • Freezing Panes and splitting windows
  • Conditional formatting 
  • To identify patterns
  • Using formulae
  • To make extremely intelligent reports

• Making Professional Reports in Excel and Dashboards

• Absolute and Relative Cell addressing to make effective formulas

• Dashboards

• Having the audience/recipient in mind.

 

Day Three

Linear Models and Optimization

• Introduction to Linear Models and Optimization

• Growth in Discrete Time

• Constant Proportionate Growth

• Present and Future Value

• Optimization.

Building Blocks of Probability Models

• Introduction to Probabilistic Models

• Examples of Probabilistic Models

• Probability Trees

• Monte Carlo Simulations

• Markov Chain Models

• The Bernoulli Distribution

• The Binomial Distribution

• The Normal Distribution

• The Empirical Rule.

Day Four

Regression Models

• Introduction to Regression Model

• Use of Regression Models

• Interpretation of Regression Coefficients

• R-squared and Root Mean Squared Error (RMSE)

• Fitting Curves to Data

• Multiple Regression

• Logistic Regression.

Day Five

Preparing and Presenting the Reports

• Excel spreadsheet reports

• Excel to PowerPoint 

  • Linking PowerPoint Charts to Excel
  • Embedding Excel sheets in PowerPoint
  • Making a Powerful PowerPoint Presentation.

• Excel to Word

  • Mail Merge: Sending a personalized mail to a list of people
  • Linking PowerPoint Charts to Excel
  • Embedding Excel sheets in Word
  • Copying tables and content from Excel to Word, the right way.

• E-mails reports.

5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos Jul 04 - 08 Jul, 2022
5/7 Alade Lawal Street, Off Ikorodu Road, Anthony Village, Lagos, Lagos State, Nigeria 12 - 16 Dec, 2022

Registration: 08:30:am - 03:30:am

NGN 194,999.00(VAT Inclusive)
(Convert Currency)

Mr Abiodun Toki 08033019120

LIVE-ONLINE: N175,000 CLASSROOM: N195,000 3 – 4 participants: 5% discount 5 or more participants: 10% discount

Related Courses

Advancing Performance By S.M.A.R.T. Targets Setting and Appraisal Processes: Employee Performance Assurance Training Advancing Performance By S.M.A.R.T. Targets Setting and Appraisal Processes: Employee Performance Assurance Training

4 days, 23 - 26 Aug, 2022 

2022-08-23 12:08:00 2022-08-23 12:08:00
Lagos State, Nigeria

Tom Associates Training

By the time the programme ends, participants would become conversant with the procedure of:   • Determining performance measures at the Corporate, Business Unit and Individual levels. ...

How to Turn Around an Underperforming Business - (Breathing New Life into a Business in Difficulty) How to Turn Around an Underperforming Business - (Breathing New Life into a Business in Difficulty)

3 days, 03 - 05 Aug, 2022 

2022-08-03 12:08:00 2022-08-03 12:08:00
Lagos State, Nigeria

Tom Associates Training

When an enterprise is in crisis, all kinds of devastating things start to happen to the customers, to the suppliers, to its finances, to the workers, the managers, and their families. But in a ...

Marketing that Creates Results Marketing that Creates Results

5 days, 22 - 26 Aug, 2022 

2022-08-22 12:08:00 2022-08-22 12:08:00
Lagos State, Nigeria

Tom Associates Training

The learning objectives of Marketing that Creates Results training are as follows Day One Acquisition Marketing Customer acquisition process Acquisition campaign Digital channels acquisitions: ...

Complete Salesperson Course: The Seven Traits Complete Salesperson Course: The Seven Traits

5 days, 15 - 19 Aug, 2022 

2022-08-15 12:08:00 2022-08-15 12:08:00
Lagos State, Nigeria

Tom Associates Training

The Traits Sales Competence Commercial Knowledge Business Development Capabilities Bidding and Tendering Application of Excel and PowerPoint in Sales Use of Digital Media Presentation Skills. ...