DATA COLLECTION AND INTERPRETATION FOR BUSINESS ANALYSTS

Live-Online Training: N175,000
Classroom Training: N 215,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

(PARTICIPANTS SHOULD BRING THEIR LAPTOP)

Course Contents

DAY ONE

Data Collection, Manipulation & Analysis

• Definition and Uses of Data, Models and Functions
• Key Steps in the Collection and Analysis Process
• How Quantitative Models Are Used in Practice
• Pivot Table
• • Default Pivot Table
  • Tabular Pivot Table
  • Pivot Table Filtering
  • Making a very 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 as many as 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 is PowerView
  • Simple practical 
• 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.