+234 907 500 0010

Register Now

Data Analysis & Decision Making

  • Home
  • Digital Skills Track
  • Data Analysis & Decision Making

About This Course

This applied course teaches statistical thinking and analytical frameworks without requiring advanced mathematical background. It will help you develop practical data analysis skills using accessible tools like Excel to collect, organize, analyze, and visualize information for improved decision-making.

You’ll learn to identify patterns, extract meaningful insights, and present findings persuasively to influence organizational decisions. The program emphasizes real-world business applications and provides templates and tools for immediate implementation in your workplace or business.

What You'll Get

  • Practical Excel skills for analyzing business data without advanced training
  • Ability to create compelling visualizations that communicate insights clearly
  • Frameworks for turning raw data into actionable business recommendations
  • Templates and formulas for common analytical challenges
  • Confidence to make data-driven decisions in your role

Who This is For?

  • Managers responsible for reporting and decision-making
  • Professionals working with numerical information regularly
  • Small business owners needing to analyze performance data
  • Team leaders wanting to make more informed decisions
  • Anyone who works with data but lacks formal analytical training

Requirements

  • Basic Excel or Google Sheets familiarity
  • Access to Microsoft Excel or Google Sheets software
  • Work-related data for practice exercises (or sample data provided)
  • Basic math skills for calculations and analysis
  • Willingness to learn analytical thinking approaches

Curriculum

8 Sessions

 

Learning Objectives:

  • Understand data types and their business applications
  • Learn data analysis process and methodologies
  • Develop analytical thinking and question formulation skills

Workshop Content:

  • Types of data and their characteristics
  • Data analysis process: question to insight
  • Analytical thinking development
  • Common business data analysis applications

 

Learning Objectives:

  • Master data import, cleaning, and organization
  • Learn data validation and quality control
  • Understand data structure for analysis

Workshop Content:

  • Data import from various sources
  • Data cleaning techniques and best practices
  • Data organization and structure principles
  • Data validation and error checking

 

Learning Objectives:

  • Calculate and interpret descriptive statistics
  • Understand measures of central tendency and variation
  • Learn data distribution and outlier analysis

Workshop Content:

  • Mean, median, mode applications and interpretation
  • Standard deviation and variance understanding
  • Data distribution analysis techniques
  • Outlier identification and treatment

 

Learning Objectives:

  • Understand effective data visualization principles
  • Master chart selection for different data types
  • Learn design principles for clear communication

Workshop Content:

  • Data visualization theory and best practices
  • Chart types and their appropriate uses
  • Color, layout, and design principles
  • Common visualization mistakes to avoid

 

Learning Objectives:

  • Master PivotTables for data summarization
  • Learn advanced formulas for business analysis
  • Understand conditional analysis and filtering

Workshop Content:

  • PivotTable creation and customization
  • Advanced Excel formulas (VLOOKUP, INDEX-MATCH, SUMIFS)
  • Conditional formatting for data insights
  • Advanced filtering and data manipulation

 

Learning Objectives:

  • Identify trends and patterns in business data
  • Learn simple forecasting techniques
  • Understand seasonality and cyclical patterns

Workshop Content:

  • Trend identification and analysis methods
  • Simple forecasting techniques in Excel
  • Seasonality analysis and adjustment
  • Forecast accuracy assessment

 

Learning Objectives:

  • Create business intelligence dashboards
  • Learn dashboard design principles
  • Understand automated reporting systems

Workshop Content:

  • Dashboard design principles and best practices
  • Excel dashboard creation techniques
  • Automated reporting and data refresh
  • Dashboard performance optimization

 

Learning Objectives:

  • Transform analysis into actionable insights
  • Learn to communicate findings effectively
  • Develop recommendation frameworks

Workshop Content:

  • From analysis to insight generation
  • Stakeholder communication strategies
  • Recommendation development and presentation
  • Action plan creation from analysis
data-analysis
Join Course

This Course Include

  • Live Interactive Workshops
  • Practical Implementation Projects
  • Comprehensive Resource Library
  • Peer Learning Community
  • Expert Instructor Support

Want personalized guidance?

Schedule a free 15-minute consultation with one of our program advisors to discuss your specific needs and goals.