Data Analytics Using Excel & Power BI

Uncategorized
Wishlist

About Course

Data Analytics Using Excel & Power BI Course in Port Harcourt, Lagos and Abuja and Worldwide

Course Overview

The Data Analytics Using Excel & Power BI course is designed to equip you with practical skills to analyze, visualize, and interpret data for business decision-making.

You will learn how to clean data, perform analysis, build dashboards, and generate insights using Microsoft Excel and Power BI, two of the most widely used data tools in the industry.

Course Objectives

By the end of this course, you will:

  • Understand the fundamentals of data analytics
  • Clean and prepare raw data for analysis
  • Use Excel for data analysis and reporting
  • Build interactive dashboards in Power BI
  • Interpret data and make data-driven decisions
  • Work with real-world datasets across industries

Course Modules

1. Introduction to Data Analytics

  • What is Data Analytics
  • Types of Data Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
  • Role of a Data Analyst
  • Data Analytics Workflow
  • Real-world applications of data analytics

2. Microsoft Excel for Data Analysis (Beginner to Advanced)

2.1 Excel Fundamentals

  • Excel Interface and Navigation
  • Data Entry and Formatting
  • Working with Worksheets and Workbooks

2.2 Data Cleaning in Excel

  • Removing duplicates
  • Handling missing data
  • Text to Columns
  • Data validation

2.3 Excel Formulas and Functions

  • Basic formulas (SUM, AVERAGE, COUNT)
  • Logical functions (IF, AND, OR)
  • Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Text and Date functions

2.4 Data Analysis Tools

  • Sorting and Filtering
  • Conditional Formatting
  • Pivot Tables
  • Pivot Charts

2.5 Excel Dashboards

  • Creating charts (Bar, Line, Pie, etc.)
  • Building interactive dashboards
  • Using slicers and timelines

3. Introduction to Power BI

3.1 Power BI Basics

  • What is Power BI
  • Power BI Interface
  • Installing and setting up Power BI Desktop

3.2 Data Import and Transformation

  • Connecting to data sources (Excel, CSV, etc.)
  • Power Query Editor
  • Data cleaning and transformation
  • Data modeling basics

4. Data Modeling in Power BI

  • Creating relationships between tables
  • Star schema vs flat data
  • Calculated columns and measures
  • Introduction to DAX (Data Analysis Expressions)

5. Data Visualization in Power BI

  • Creating charts and visuals
  • Tables and matrices
  • Cards and KPIs
  • Maps and geographic data

 

6. Building Interactive Dashboards

  • Designing dashboards
  • Adding filters and slicers
  • Drill-down and drill-through features
  • Creating user-friendly reports

7. Advanced Power BI Features

  • DAX functions (CALCULATE, SUMX, etc.)
  • Time intelligence functions
  • Performance optimization
  • Data refresh and scheduling

8. Real-World Data Projects

  • Sales data analysis
  • Customer behavior analysis
  • Financial performance dashboards
  • Inventory and logistics analysis

9. Data Storytelling & Reporting

  • Interpreting data insights
  • Presenting findings effectively
  • Creating professional reports
  • Business decision-making with data

Tools Covered

  • Microsoft Excel
  • Power BI Desktop

Career Opportunities

After completing this course, you can work as:

  • Data Analyst
  • Business Analyst
  • Reporting Analyst
  • Operations Analyst
  • Data Assistant

Course Duration

  • 8 Weeks (Flexible depending on schedule)

Who Should Enroll

  • Beginners with no prior experience
  • Students and graduates
  • Business owners and entrepreneurs
  • Professionals looking to upgrade their skills

Certification

Participants will receive a Certificate of Completion after successfully finishing the course and projects.

Bonus

  • Real-world datasets
  • Hands-on projects
  • CV/Portfolio guidance
  • Job and freelance tips
FEES: N180,000
DISCOUNT FEES: N130,000
Show More