Data Analytics with Excel and Power BI

An introductory course for complete beginners & professionals looking to learn data analysis and business intelligence complete with a Microsoft certification

Welcome to Moringa School

2025 Intake is Ongoing

Part-time Remote

Start Date:
3rd March, 2025
Course Duration:
14 Weeks
Mode of Learning:
Part Time & Online, Evening Classes | Mon - Fri 6 pm - 9 pm E.A.T
Tuition Fee:
Ksh 55,000

Master Data Analytics & get Microsoft Associate-certification

This foundational course equips you with essential Data Analytics skills using Power BI, MS Excel, and SQL. Learners will master skills in data manipulation, analysis, and visualization with Excel. You will also learn how to build interactive dashboards and reports in Power BI & SQL.

Through practical exercises and case studies, learners will gain the ability to extract insights, make data-driven decisions, and communicate findings effectively. By the end of the course, you will be prepared for Data Analyst roles and a Microsoft Associate certification

Course Details

Data analytics is the process of examining raw data to uncover patterns, trends, and insights that inform decision-making. For professionals, mastering data analytics is crucial as it enhances the ability to make data-driven decisions. Furthermore, proficiency in data analytics increases employability and potential for career advancement, making it an essential skill in today’s data-driven industry landscape.

This course is designed for complete beginners with no prior programming experience interested in Data Analytics.

  1. Have basic math skills and computer skills.
  2. Proficiency in English – both spoken and written.
  3. Must have a computer or laptop with the following specs ( core i5 – i7, 8GB RAM, 500GB memory).
  4. Must have a desire and curiosity to learn.

No prior experience in programming is required.

Mastering data analytics equips professionals with the skills needed to leverage data for strategic advantage in any industry.

  1. Informed Decision-Making: Enhance the ability to make data-driven decisions that can improve business strategies and outcomes.
  2. Competitive Advantage: Gain insights that can help your organization stay ahead of the competition.
  3. Efficiency Improvement: Identify areas for cost reduction and process optimization.
  4. Market Trends: Understand and predict market trends to better meet customer needs and preferences.
  5. Career Growth: Increase your employability and potential for advancement in the growing field of data analytics.

If you are in search of a unique learning experience this is the place for you. We guarantee you will learn market-aligned skills through our practical and comprehensive curriculum.

  1. Project-based learning with access to large data sets & real-world business case studies
  2. Technical Mentor Support
  3. Live instructor classes
  4. Career Readiness Support
  5. Dual certification – certificate of completion from Moringa + Microsoft Data Associate certification

Qualify for in-demand jobs like BI Analyst, Data Analyst or Power BI Analyst

Get Started Now - Apply Here

Curriculum Overview

  • Introduction to Data Analytics
  • Excel Basics and Navigation

  • Data Quality 
  • Data Privacy
  • Removing Duplicated data
  • Dealing with inconsistent data
  • Pivot tables and Slicers

  • Introduction to Statistics
  • Probability basics in Excel
  • Hypothesis Testing in Excel
  • Sampling in Excel
  • Random Variables

  • Charts
  • Interactive Dashboards

  • Introduction to SQL
  • Selecting Data with SQL
  • Filtering Data with SQL
  • Ordering and Limiting Data with SQL

  • Grouping Data with SQL
  • SQL Table Relations
    • Join Statements
    • One-to-Many and Many-to-Many Joins
  • SQL Subqueries

  • What is Power BI
  • Power BI components
  • Power BI Desktop
  • Preparing Data Sources
    • Connect to a data source
    • SQL data sources
    • Shared dataset vs local dataset
  • Data cleaning

    • Model view in Power BI
    • Introduction to Schemas
    • Introduction to cardinality and cross-filtering
    • Transforming Data with Power BI

  • Deep Dive into DAX [ Working with calculations, Measures And Calculated Columns,Working with DAX Parameters and Naming Conventions]
  • Using Formulas and Functions
  • Creating Visualizations

  • Creating & Configuring Dashboards
  • Working With Reports & Distribution
  • Creating workspaces
  • Monitoring workspaces
  • Deploying assets

 

  • Apply learned concepts and tools to practical projects and case studies, reinforcing understanding and skill application.

Take your career to the next level and become a data-driven decision-maker with Microsoft Data Analyst Associate Certification

Career Opportunities

Ready to launch your Data Analyst Career?