Start Your Career With an Associate Course
This Junior Analyst course provides the fundamental skills required to gather, clean, analyze, and visualize data using common industry tools like Excel, Google Sheets, and Power BI. It is designed to equip participants to perform tasks required in entry-level analyst roles, with a primary focus on setting up analyses and creating basic reports and dashboards.
By the end of the Junior Analyst course, participants will be able to:
Module 1: Data Analysis Fundamentals & Tool Setup
Module 2: Data Setup & Manipulation in Excel/Sheets
Module 3: Setting Up Data Connections & Basic Transformations in Power BI
Module 4: Building Basic Data Models & Reports in Power BI
Module 5: Creating Basic Calculations & Visualisations
Module 6: Basic Data Reporting & Interpretation
Module 1: Data Analysis Fundamentals & Tool Setup
Core Data Concepts: Data Types, Databases vs. Spreadsheets
The Data Analysis Lifecycle Stages
Introduction to Excel, Google Sheets, and Power BI Desktop Environments
Setting up Accounts and Navigating Interfaces
Data Privacy and Ethical Considerations Overview
Module 2: Data Setup & Manipulation in Excel/Sheets
Basic Data Entry, Formatting, Sorting, and Filtering
Fundamental Formulas: SUM, AVERAGE, COUNT, IF, Basic Arithmetic
Creating Basic Charts: Bar, Line, Pie Charts
Setting up Structured Data using Tables
Importing Data from CSV and Text Files
Module 3: Setting Up Data Connections & Basic Transformations in Power BI
Connecting Power BI Desktop to Excel, CSV, and other common sources
Introduction to the Power Query Editor Interface
Basic Data Cleaning: Changing Data Types, Removing Columns/Rows, Handling Basic Errors (Nulls), Filtering Data
Module 4: Building Basic Data Models & Reports in Power BI
Basic Data Modeling Concepts: Fact vs. Dimension Tables, Primary/Foreign Keys
Creating Simple Relationships between Tables
Building Reports with Standard Visuals: Tables, Matrices, Cards, Bar/Line/Pie Charts
Basic Formatting of Visuals and Report Pages
Module 5: Creating Basic Calculations & Visualizations
Creating Calculated Columns in Excel/Sheets/Power BI (Simple Formulas)
Introduction to DAX: Creating Basic Measures (SUM, COUNT, AVERAGE) in Power BI
Arranging Visuals to Create Basic Interactive Dashboards/Reports
Module 6: Basic Data Reporting & Interpretation
Reading Basic Charts and Tables Effectively
Simple Descriptive Analysis: Finding Minimums, Maximums, Averages, Counts
Formulating Basic Observations and Summaries from Data
Exporting Reports, Visuals, or Data from Tools (Excel, Power BI)
Participants enrolling for this programme will be required to have no prior data analysis experience, but strong computer literacy and familiarity with spreadsheet basics (like navigating cells) are beneficial. A logical mindset and interest in working with data.
Access to a computer capable of running Microsoft Excel/Google Sheets and Power BI Desktop, along with a reliable internet connection.
Requirements:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Piston and Fusion offer the Junior Data Analysis Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates for classroom and virtual online class.
Junior Data Analysis Course Schedule for Lagos, Abuja, & Online
8th Sep – 11th Sep, 2025
Mon – Thu
8:30am – 3:30pm
4 days
Contact Us
Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. This course focuses on the foundational steps and tools used in this process.
Microsoft Excel is widely available; Google Sheets is free. Power BI Desktop is a free download from Microsoft.
No, this course focuses on foundational analysis using Excel, Sheets, and Power BI's graphical interface. Programming languages are typically covered in more advanced courses.
This course provides strong foundational skills. Landing a job also depends on practice, portfolio building (using skills learned), and interview performance.
Piston and Fusion offer the Data Analysis Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See fees for classroom and virtual online class.
₦140,000
₦170,000
₦210,000
₦240,000
Virtual Only
-
-
-
-
-
-
₦140,000
₦170,000
₦210,000
₦240,000
Virtual Only
3 Months
-
-
-
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
₦140,000
₦170,000
₦210,000
₦240,000
Classroom & Virtual
Print & PDF
-
Teabreak & Lunch
Souvenir
Notepad & Pen
-
-
₦140,000
₦170,000
₦210,000
₦240,000
Classroom & Virtual
Print & PDF
Print & PDF
3 Months
Tea Break & Lunch
Souvenir
Notepad & Pen
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
Piston & Fusion Business Academy empowers individuals and businesses to achieve their professional goals through a variety of innovative courses, programs, and career services.
Talk to the Career Advisor and join the next schedule
Our Junior Business Analysis Training Location in Lagos, Abuja, PH & Online
Piston & Fusion Business Academy Lagos Training Centre is located at 122a Obadina Street, Omole Phase 1, Ikeja | Abuja Office is located at 22 Kumasi Cres, Wuse 2, Abuja 904101, Federal Capital Territory
You can join our classes from anywhere in Nigeria, Canada, the UK and the US via our Virtual Online Programs
We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.