Junior Data Analyst
overview
Course Overview
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.
Learning Outcomes
By the end of the Junior Analyst course, participants will be able to:
- Understand core data concepts, the analysis lifecycle, and navigate key tools (Excel, Sheets, Power BI).
- Perform essential data setup, cleaning, and manipulation tasks in Excel and Google Sheets using formulas and functions.
- Connect to data sources and perform basic data transformations using Power BI's Power Query Editor.
- Build simple data models and create reports with standard visuals in Power BI.
- Create basic calculated columns/measures and arrange visuals into interactive dashboards.
- Interpret basic charts/tables, perform simple descriptive analysis, and export findings from tools.
Curriculum
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)
who attends
Right For You
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.
Key Program Features
Training
The Junior Data Analyst training approach employs hands-on learning, which imparts the skills required for specific job roles.
Internship & Projects
The Junior Data Analyst course provides up to 4 months of internship while working on real work projects, which adds expertise and verifiable work references in the resident country.
Career Development
The Junior Data Analyst course assists participants in securing a job through the development of a professional profile and job prospecting.
teaching team
Meet Your Facilitator(s)
Olawande Akinmola
Trainer at Piston and Fusion Business Academy • Nigeria
B.Sc. in Microbiology; certifications in Data Analysis, Financial Analysis, and Financial Modelling (DAFM)
Olawande Akinmola is a Business Intelligence Analyst and facilitator skilled in transforming data into actionable insights. With a B.Sc. in Microbiology and certifications in Data and Financial Analysis, she specializes in SQL, Tableau, and Power BI. With three years of experience, she helps businesses make data-driven decisions through clear, strategic insights. As a facilitator at Piston and Fusion, she empowers professionals with data literacy, making complex information accessible and impactful.
course schedule
The Schedule For This Course
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
Classroom
Weekdays
Contact Us
Weekends
Contact Us
Virtual
Weekdays
Contact Us
Weekends
Contact Us
fees
What It Will Cost
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
apply now
Ready to Join the Course?
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
How to Apply:
- Check the website to select a course of choice and fee.
- Pay the registration fee and tuition to P&F account domiciled at First Bank
- DETAILS Account Name: Piston & Fusion Ltd Account Number: 2015242578 Bank: First Bank of Nigeria
- Send your name, phone no, email, training location, amount paid & proof of payment to fees@pistonandfusion.org
- Complete the enrollment form ONLY AFTER PAYMENT
- CASH PAYMENTS ARE NOT ALLOWED, ALL PAYMENTS MUST BE MADE TO THE COMPANY’S ACCOUNT.
https://www.pistonandfusion.org/enrol-now?type=individual&course=junior-data-analyst
Request a Proposal
Are you a corporate client looking to upskill your team?
To register multiple employees for our courses, please fill out this form to request a proposal.
We’ll provide you with a detailed quote, outlining the costs and benefits of your chosen courses. Once approved, we’ll generate an invoice for payment.
Let’s elevate your team's skills together!
https://www.pistonandfusion.org/enrol-now?type=corporate&course=junior-data-analystcontact us
Want to Get in Touch?
Individual
Get Free Career Counselling
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.
Corporate
Get Free L&D Plan
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.