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

Enrolled: 2650 students

Working hours

Monday 8:00 am - 5.00 pm
Tuesday 8:00 am - 5.00 pm
Wednesday 8:00 am - 5.00 pm
Thursday 8:00 am - 5.00 pm
Friday 8:00 am - 5.00 pm
Saturday 8:00 am - 5.00 pm
Sunday Closed

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

Data Analysis – Advanced Excel & Power BI 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 advance 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 visualizations 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 visualizations. 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 Analyst in Nigeria.

Who Should Attend

  • 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

Handling Data with Advanced Excel Functions

  • Introduction to Excel Statistical Functions
  • Learn how to search user information in a table using VLOOKUP & HLOOKUP
  • Increase readability and efficiency of a function by naming arrays
  • Group records and make logical comparisons with nested if statements
  • Find errors in data using multiple errors find functions
  • Enhance search robustness using Index and match

Data Reporting and Visualization in Excel

  • How charts visual perception for impactful story telling
  • Summarize and analyze data using PIVOT table
  • Sort, Filter & Slicer business data for analyzing impactful insights
  • Create dashboards for visualizing business data and storytelling with data

Introduction to Power BI, Creating Relationships & Data Models in Power BI

  • Exploring Power BI Interface & Ribbons
  • Review the project source data
  • Types of Data Connectors in Power BI
  • Query Editor
  • Configuring Power BI Data Source Settings
  • Defining Hierarchies
  • Introduction to Data Model
  • Principles of Database Normalization
  • Managing & Editing Table Relationships in Power BI
  • Understanding Filter Flow

Data Reporting and Visualization with Power BI

  • Visualizing Data with Power BI Reports
  • Introduction to Reports in Power BI
  • Inserting Basic Charts & Visuals
  • Managing & Viewing Roles

Deborah Osilade

I am Deborah Osilade, I am a Data Analyst and an Instructor at Piston and Fusion Business Academy. I love leveraging data to create high quality data intelligent solutions. I enjoy working on building Predictive Models, Financial models and designing Dashboards solutions. My specialization and core skills are in Finance, Data Science & Machine Learning. I have a Post Graduate Diploma in Data Science and Business Analysis from the University of Texas at Ausin and a B.A. Accounting and Finance degree from Middlesex University. My proficiency with data science tools span across Programming Language for Data Science, Data visualisation tools and Data management tools.

Adeola Badmus

I am Adeola, my 15-year professional career has spanned several roles, organizations, and sectors. I served as a project manager in IntroIT Consulting, Head of Institute / Chief Operating Officer for the Institute for Advance e-Studies, I currently hold the position as the senior project consultant & marketing director for Piston & Fusion. My qualification includes MSc. In Marketing, BSc. In Business Administration, Digital Marketing, Data Analytics, PMP, PRINCE 2, NEBOSH, Level 3 Award in Education & Training. I have been privileged to attend some of the best institutions globally, University of Lagos, Lagos Business School, and University of Liverpool (UK). I am a member of AMA, PMI & IOSH. I have trained over 4000+ professionals in marketing, branding, project management, data analytics and other business related programmes.

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.

Prospective applicants who do not meet the programme requirement but wants to join the programme should should follow the process detailed below.

Application Process

  1. Start a chat with the online course adviser or complete the application form
  2. Application will be reviewed by programme committee
  3. Application acceptance will be communicated by programme committee
  4. Pay the programme fee after receiving acceptance from the committee
  5. Check your mail for programme schedule and payment confirmation


    Participant’s Experience

    Preview Course

    What is included in the Course Programme Pack

    • Practice Manual & Textbook
    • Participants workbook & Exercises
    • Templates for professional practice
    • Local & international case studies
    • Recognized Certification of Completion
    • Branded Personalized programme pack & stationaries
    • Breakfast & Lunch – Buffet Menu
    • 3 Star Accommodation (Optional – Available on Request)

    Kindly note all training materials for the Virtual Online classes will be in electronic formats (PDF & MS Word)

    Data Analysis – Avanced Excel Course Fees & Dates for  Upcoming Classroom Classes In 2022

    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.

    Programme Information

    Course Objective: The Programme focus is to impart the skills to manage data analysis processes and the use of data analytics tools
    Classroom Fee: ₦130,000
    Weekday Date: 4th Oct – 7th Oct 2022 | 4 Days: Tue – Fri | 8:30am – 4pm
    Weekend Date: 5th Nov – 26th Nov 2022 | 4 Weeks: Saturdays | 8:30am – 4pm
    Location: 122a Obadina Street, Omole Phase 1 Ikeja Lagos
    Virtual Class Fee: ₦100,000 | $160
    Weekday Date: 4th Oct – 7th Oct 2022 | 4 Days: Tue – Fri | 8:30am – 3pm
    Weekend Date: 5th Nov – 26th Nov 2022 | 4 Weeks: Saturdays | 8:30am – 3pm
    Location: Microsoft Teams | Zoom

    Why Piston & Fusion Ranked Amongst the Best Business Institute In Nigeria?

    • We have trained 6000+ professionals
    • We have over 10 years industry experience
    • Our facilitators are experienced and certified
    • We offer post training career advice and support