delivery
Classroom & Virtual
duration
5 days / 4 weeks
enrolled students
9,999
overview
Course Overview
As the business world becomes more competitive, advancing your data analysis skills set is a decision that will keep you at the top of your career. The data analysis advanced excel course covers advanced Excel techniques for collecting, presenting, describing and making inferences from sets of data. The course is suitable for individuals with good Excel skills.
Microsoft Power BI course for Business & Data Analytics course teaches you the skills you need to interact with, author, and maintain robust visualisations and custom data models. Hands-on exercises based on real-life business scenarios clearly demonstrate each technique. In this Power BI course, you will explore, create, and manage highly interactive data visualisations. Extract meaningful business insights from your disparate enterprise data using the detailed information contained in this practical guide. You will learn Microsoft Power BI from Nigeria best Data Analyst. The Power BI course is for professional Business & Data Analysts in Nigeria.
Learning Outcomes
By the end of the Data Analysis - Advanced Excel course, participants will be able to:
- Master advanced Excel functions and formulas for data analysis.
- Create advanced charts and graphs to visualize data effectively.
- Build PivotTables and PivotCharts for data summarization and analysis.
- Automate tasks using macros and VBA in Excel.
- Learn best practices for data analysis and reporting in Excel.
Curriculum
Introduction to Data Analytics
Introduction to Excel
Handling Data with Excel
Data Reporting and Data Visualisation with Excel
Introduction to Power BI Desktop, Handling data & Modelling data with Power Bi
Introduction to Data Analytic Expressions
Data Reporting and Data Visualisation with Power BI
Introduction to Data Analytics
Highlights of Data Analytics
Data Strategy using the Convo Model
Data Quality Framework
Overview of Data Analytics Workflow
Introduction to Excel
Introduction to Excel functions, Sum if, Count if, Sum-ifs, concat etc.
Working with Table calculation & Naming Arrays in Excel
Learn how to search user information in a table using Lookup functions
Group records and make logical comparisons with nested if statements
Handling Data with Excel
Load, Data Cleaning and Data Transformation with Power Query Editor
Debugging Connection Errors in Power Query Editor
Creating Relationships and Modelling multiple tables with Power Pivot
Descriptive Analysis using the Data Analytics tool Pak
Exploratory Data Analysis with Power Pivot
Creating Calculated fields using DAX in Power pivot
Data Reporting and Data Visualisation with Excel
Use Charts and visual aids for Impactful visual perception & visual storytelling
Create dashboards for visualising business data and storytelling with data
Use dashboard actions to create interactions within storyboards
Introduction to Power BI Desktop, Handling data & Modelling data with Power Bi
Working and designing Power BI Canvas
Load, Data Cleaning and Data Transformation with Power Query Editor
Building a Comprehensive Data Model, Date Tables and Bridge tables in Power Bi
Connecting Multiple tables and creating Relationships in PowerBI desktop
Introduction to Data Analytic Expressions
Introduction to measures & tables using DAX
Creating KPIs and metrics for Business decision-making
Data Reporting and Data Visualisation with Power BI
Introduction to Data Visualization in Power Bi
Creating Dashboards to Visualise KPIS and Metrics to enhance business decisions.
who attends
Right For You
Participants enrolling for this programme will be required to have basic computing skills. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.
Requirements:
- Experienced individuals who manage data analysis activities in diverse fields
- Working professionals seeking to change career, job or industry to data analysis related field
- Individuals who meets the requirements and intend on starting a career in data analysis
- Mid to senior-level executives in any sector
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
Key Program Features
Training
The Data Analysis - Advanced Excel & Power BI: Analysis for Business Decisions training approach employs hands-on learning, which imparts the skills required for specific job roles.
Internship & Projects
The Data Analysis - Advanced Excel & Power BI: Analysis for Business Decisions 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 Data Analysis - Advanced Excel & Power BI: Analysis for Business Decisions course assists participants in securing a job through the development of a professional profile and job prospecting.
teaching team
Meet Your Facilitator(s)
testimonials
What Participants Said
The P&F Experience
Piston & Fusion Business Academy empowers individuals and businesses to achieve their professional goals through a variety of innovative courses, programs, and career services.
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
Dates:
7th Apr – 11th Apr, 2025
Days:
Mon – Fri
Time:
8:30am – 4pm
Duration:
5 days
Weekends
Dates:
5th Apr – 27th Apr, 2025
Days:
No days selected
Time:
8:30am – 4pm
Duration:
4 weeks
Virtual
Weekdays
Dates:
7th Apr – 11th Apr, 2025
Days:
Mon – Fri
Time:
8:30am – 4pm
Duration:
5 days
Weekends
Dates:
5th Apr – 27th Apr, 2025
Days:
No days selected
Time:
8:30am – 4pm
Duration:
4 weeks
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.
₦150,000
₦180,000
₦230,000
₦260,000
Standard
₦150,000
Virtual Only
Course Materials
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
-
Perks
-
-
Additional Services
-
-
₦150,000
₦180,000
₦230,000
₦260,000
Standard Plus
₦180,000
Virtual Only
Course Materials
Certificate
Manual, Cases & Templates
Mentorship
3 Months
Refreshment
-
Perks
-
-
Additional Services
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
₦150,000
₦180,000
₦230,000
₦260,000
Professional
₦230,000
Classroom & Virtual
Course Materials
Print & PDF
Certificate
Manual, Cases & Templates
Mentorship
-
Refreshment
Teabreak & Lunch
Perks
Souvenir
Notepad & Pen
Additional Services
-
-
₦150,000
₦180,000
₦230,000
₦260,000
Professional Plus
₦260,000
Classroom & Virtual
Course Materials
Print & PDF
Certificate
Manual, Cases & Templates
Print & PDF
Mentorship
3 Months
Refreshment
Tea Break & Lunch
Perks
Souvenir
Notepad & Pen
Additional Services
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
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.
Reserve a slot
FAQs
Frequently Asked Questions
Yes, we may be able to reschedule your course. Please contact our customer support team for more information and to discuss your specific request.
Upon successful completion of the course, you will receive a certificate showing that you completed the course.