delivery
Classroom & Virtual
duration
Contact Us
enrolled students
9,999
Related Courses
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
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 & Visualizations
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)
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
Internship & Projects
Career Development
teaching team
Meet Your Facilitator(s)
Loading...
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
Loading...
Loading...
Loading...
FAQs
Frequently Asked Questions
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.
