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.
By the end of the Data Analysis - Advanced Excel course, participants will be able to:
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.
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:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
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.
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.
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.
IT Manager • Nigeria
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.
Graduate Research Assistant • Nigeria
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.
Data Scientist • Nigeria
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.
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.
10th Feb – 14th Feb, 2025
As of Wed Feb 05 2025
Mon – Fri
8:30am – 4pm
5 days
5th Apr – 27th Apr, 2025
As of Wed Feb 05 2025
No days selected
8:30am – 4pm
4 weeks
10th Feb – 14th Feb, 2025
As of Wed Feb 05 2025
Mon – Fri
8:30am – 4pm
5 days
5th Apr – 27th Apr, 2025
As of Wed Feb 05 2025
No days selected
8:30am – 4pm
4 weeks
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.
Virtual Only
-
-
-
-
-
-
Virtual Only
3 Months
-
-
-
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
Classroom & Virtual
Print & PDF
-
Teabreak & Lunch
Souvenir
Notepad & Pen
-
-
Classroom & Virtual
Print & PDF
Print & PDF
3 Months
Tea Break & Lunch
Souvenir
Notepad & Pen
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
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-decisionsWe help you decide if this course is a good match for your career. We can also help you plan and develop a career path.
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.