Data Analysis - Advanced Excel & Power BI: Analysis for Business Decisions

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

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)

Nosakhare Obaseki

Nosakhare Obaseki

IT ManagerNigeria

Master of Business Administration (MBA);

Nosakhare Obaseki is a seasoned professional with an MBA and expertise in business intelligence, IT support, and cybersecurity. As the IT Manager at Divcon Engineering, he drives digital transformation and enhances operational efficiency by leveraging business intelligence tools, enabling data-driven decisions. Nosakhare excels in IT support, cybersecurity, and ISO 9001 implementation, and is proficient in technical skills like SQL, Excel, PowerBI, and cloud platforms. With a proven track record of successful projects, including the SPDC Manpower Project and NIBSS mCash Storm, he is recognized as a visionary leader in the IT industry, committed to driving innovation and business success.

Ezra Manuel

Ezra Manuel

Graduate Research AssistantNigeria

M.Sc. in Synthetic Chemistry; B.Sc. in Chemistry; OND in Electrical/Electronics.

Ezra Manuel is a data enthusiast with a diverse background, holding an M.Sc. in Synthetic Chemistry, a B.Sc. in Chemistry, and an OND in Electrical/Electronics. His journey from research in chemistry to data science has made him proficient in Python, SQL, PowerBI, Excel, Microsoft PowerApps, KNIME Analytics, and SPSS. As a Graduate Research Assistant at Elizade University, he pushes the boundaries of data science, and previously as a Remote Data Science Facilitator at Piston & Fusion, he honed his ability to make complex concepts accessible. Passionate about helping businesses leverage data for informed decisions, Ezra teaches students to use data analysis tools to solve real-world problems, combining his research experience with practical skills to empower learners and professionals.

Christian Ozoemene

Christian Ozoemene

Data ScientistNigeria

M.Sc. in Data Science Management; AWS Certified Solutions Architect (in view); AWS Data Engineer Associate (in view).

Christian Ozoemene is a Data Scientist at Piston & Fusion Business Academy with an M.Sc. in Data Science Management, specializing in Data Analytics, Machine Learning, and AI. He is dedicated to staying at the forefront of the field, pursuing industry-recognized certifications like AWS Certified Solutions Architect and AWS Data Engineer Associate. With proficiency in tools like Python, SQL, Excel, and Power BI, Christian empowers students to confidently tackle data challenges. His real-world experience, including work on credit scoring projects at mdoc, enriches his lessons, bridging theory with practical application. Christian is passionate about nurturing the next generation of data-driven leaders, equipping them with the skills to transform data into actionable business strategies.

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:

10th Feb – 14th Feb, 2025

As of Wed Feb 05 2025

Days:

Mon – Fri

Time:

8:30am – 4pm

Duration:

5 days

Weekends

Dates:

5th Apr – 27th Apr, 2025

As of Wed Feb 05 2025

Days:

No days selected

Time:

8:30am – 4pm

Duration:

4 weeks

Virtual

Weekdays

Dates:

10th Feb – 14th Feb, 2025

As of Wed Feb 05 2025

Days:

Mon – Fri

Time:

8:30am – 4pm

Duration:

5 days

Weekends

Dates:

5th Apr – 27th Apr, 2025

As of Wed Feb 05 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.

Standard

₦150,000

Virtual Only

Course Materials

PDF

Certificate

PDF

Manual, Cases & Templates

PDF

Mentorship

-

Refreshment

-

Perks

-

-

Additional Services

-

-

Standard Plus

₦180,000

Virtual Only

Course Materials

PDF

Certificate

PDF

Manual, Cases & Templates

PDF

Mentorship

3 Months

Refreshment

-

Perks

-

-

Additional Services

CV & LinkedIn Profile Development

Exam Application (Only for Certification courses)

Professional

₦230,000

Classroom & Virtual

Course Materials

Print & PDF

Certificate

Print

Manual, Cases & Templates

Print

Mentorship

-

Refreshment

Teabreak & Lunch

Perks

Souvenir

Notepad & Pen

Additional Services

-

-

Professional Plus

₦260,000

Classroom & Virtual

Course Materials

Print & PDF

Certificate

Print

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
  • 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=data-analysis-advanced-excel-and-power-bi-analysis-for-business-decisions

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=data-analysis-advanced-excel-and-power-bi-analysis-for-business-decisions
contact 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.