Data Analysis - Advanced Excel & Power BI: Analysis for Business Decisions
- Description
- Curriculum
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
Introduction to Data Analytics
- Highlights of Data Analytics
- Data Strategy using the Convo Model
- Data Quality Framework
- Overview of Data Analytics Workflow
Introdution 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 visualizing 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 Visualize KPIS and Metircs to enhance business decisions
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
- Start a chat with the online course adviser or complete the application form
- Application will be reviewed by programme committee
- Application acceptance will be communicated by programme committee
- Pay the programme fee after receiving acceptance from the committee
- Check your mail for programme schedule and payment confirmation
Participant’s Experience
Data Analysis Course Fees
| Standard |
| ₦100,000 |
| Standard Plus |
| ₦120,000 |
| Professional |
| ₦160,000 |
| Professional Plus |
| ₦200,000 |
| Standard |
| ₦100,000 |
| Training Delivery Virtual |
| Duration Weekday: 5 Days Weekday: 5 Days |
| Manual & Cases (PDF) |
| Templates & Exam Guide (PDF) |
| Training Certificate (PDF) |
| Project with final grading |
| Refreshment |
| x |
| x |
| Perks |
| x |
| x |
| Additional Services |
| – |
| – |
| CV Development | LinkedIn Optimization Available at N5000 |
| Standard Plus |
| ₦120,000 |
| Training Delivery Virtual |
| Duration Weekday: 5 Days Weekday: 5 Days |
| Manual & Cases (PDF) |
| Templates & Exam Guide (PDF) |
| Training Certificate (PDF) |
| Project with final grading |
| Refreshment |
| x |
| x |
| Perks |
| x |
| x |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization 1 Package Included |
| Professional |
| ₦160,000 |
| Training Delivery Classroom |
| Duration Weekday: 5 Days Weekday: 5 Days |
| Manual & Cases Flash Drive (PDF) |
| Templates & Exam Guide Flash Drive (PDF) |
| Training Certificate Hard Copy |
| Project with final grading |
| Refreshment |
| Tea Break |
| Lite Lunch |
| Perks |
| x |
| Notepad & Pen |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization 1 Package Included |
| Professional Plus |
| ₦200,000 |
| Training Delivery Classroom |
| Duration Weekday: 5 Days Weekday: 5 Days |
| Manual & Cases Hard copy & PDF |
| Templates & Exam Guide Flash Drive (PDF) |
| Training Certificate Hard copy & PDF |
| Project Review & grading |
| Refreshment |
| Maxi Breakfast |
| Maxi Lunch |
| Perks |
| Back Pack |
| Notepad & Pen |
| Additional Services |
| Exam Application |
| Job Alerts |
| CV Development | LinkedIn Optimization Both Package Included |
Data Analysis – Avanced Excel Course Dates for Upcoming Classroom Classes In 2024
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 | |
| Weekday Date: | 9th Dec – 13th Dec 2024| 5 Days: Mon – Fri | 8:30am – 4pm |
| Weekend Date: | 7th Dec – 21st Dec 2024 | 5 Weeks: Saturdays | 8:30am – 4pm |
| Location: | 122a Obadina Street, Omole Phase 1 Ikeja Lagos |
| Virtual Class | |
| Weekday Date: | 9th Dec – 13th Dec 2024| 5 Days: Mon – Fri | 8:30am – 3pm |
| Weekend Date: | 7th Dec – 21st Dec 2024| 5 Weeks: Saturdays | 8:30am – 3pm |
| Location: | Microsoft Teams | Zoom |
Anthony Ani
“Relocating to Canada was the most challenging decision I and my family had to make, the uncertainties of a new country. I was determined that I won't risk everything to start earning minimum wage. I took my PMP training with Piston & Fusion, earned my certification at the first attempt, and to be honest it has elevated my career trajectory”
Gabriel Eluke (Human Resources/Admin) | Netcom Africa Limited
"I became a professional Human Resource personnel after my training with piston and Fusion. It brought a great turn around to my career and remains one of the best decisions I ever took. "
Okhueleigbe Usifo (Construction safety officer/ OFA) | Beedie Construction Canada
"The firm I worked with in Abuja had not paid salaries for 5 months, I decided to leave the country, and left for Dubai. I applied for a safety officer vacancy, out of 15 applicants I was the only person that was selected with HSE level 1, 2 and 3 certificate. I thought getting a job here would be difficult but my certificate helped me."
Uju Edinbus | Perform Group (Goal.com)
"I wanted to change my job, I needed something to give me the advantage to switch jobs. My friend advised I take a digital marketing course, after the training I started prospecting jobs, I got a call for my first interview, at the interview I was grilled extensively on my credentials, thanks to my digital marketing knowledge I got what I will describe as my dream job."
Mojisola Mosuro PMP | ExxonMobil
“As a fresh graduate I knew getting a good job would be a challenge. I researched online for a professional course to boost my CV, and I found P&F Project Management course. I completed the course. I have since changed jobs 3 times. Project Management. was the best Decision I made.”
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
People who enrolled for this course, also enrolled for the following courses
| Microsoft Power BI for Business Intelligence & Data Analytics | Data Analysis Using SPSS |
| Data Science Using Python | Business Analysis |
Course details
Duration
5 Days
Popular courses
-
Logistics and Supply Chain Management
Members onlyBy piston -
Financial Modeling & Forecast...
Members onlyBy piston
-
Procurement and Contract Management
Members onlyBy piston
-
Project Management Professional (PMP)
Members onlyBy admin
-
Digital Marketing Strategy & ...
Members onlyBy admin
-
Data Analysis Using SPSS
Members onlyBy admin
-
Business Leadership for Managers &...
Members onlyBy admin
-
Tax Planning & Corporate Comp...
Members onlyBy admin
-
Business Analysis
Members onlyBy piston