Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Microsoft Excel Business Intelligence Course

By: McTimothy Associates Consulting LLC  

Lagos State, Nigeria

14 - 16 Apr, 2025  3 days

Follow Event

  

NGN 218,750

Get 10.00% off

Venue: The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos.

Other Dates

Venue Date Fee  
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos., Lagos State, Nigeria 05 - 07 Jun, 2025 NGN218750
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos., Lagos State, Nigeria 17 - 19 Jul, 2025 NGN218750

Business Intelligence in a business is to help corporate executives, business managers and other operational workers make better and more informed business decisions. Companies also use BI to cut costs, identify new business opportunities, and spot inefficient business processes ripe for re-engineering. BI as a discipline and as a technology-driven process is made up of several related activities which include, Data mining, analytical processing, Querying and Reporting. The potential benefits of business intelligence include Accelerating and improving decision making, optimizing internal business processes, increasing operational efficiency, driving new revenues, gaining competitive advantages over business rivals, identifying market trends and Spotting business problems that need to be addressed

This course makes use of Microsoft Excel which is the universal language of business and accountants, and most decision-makers in small to mid-sized businesses use the king of spreadsheets in some way for reporting. In fact, research analyst Gartner has conceded that “Excel is still the number one reporting tool”.

This course covers the Excel Dashboard and Reports, pivot table, Power BI publisher for Excel and Excel Power BI tools (power query, PowerPivot, power view, power Map) which will help in providing faster data insights, data analysis, data mining, data modelling, financial reporting, improving day-to-day decision-making capacities and business performance.

This course is very hands-on with Excel and offers all the advice and software practice utilizing these advanced tools which include building queries to extract, transform, and load data, and to create elegant data models with PowerPivot. This involves analyzing multiple data sets, working with cross-sectional data, merging different sets to create a data model.

Learning Objectives

By the end of this course, you will be able to:

  • Extract and transform data
  • Import data into Power Pivot from different sources
  • Set up and manipulate Pivot Tables and Pivot Charts with Power Pivot
  • Describe, set up and work with Tables, Table Relationships, Calculated Columns and Measures
  • Understand the complex DAX functions and use them in your data analysis
  • Work with relational data and perform dynamic aggregation.
  • Create a report with real-world data: PowerPivot, Power Query, power view and Power Map
  • Calculated items and KPIs
  • Extract meaningful insight from a data model
  • Dynamic filters with slicers and timelines
  • Automate reoccurring tasks
  • Work with the ‘M’ language
  • Localizing data and geographic plots across the globe
  • Make a killer map

Course Content

  • Module 1: Introducing Power BI for Excel You Will Learn:
  • Module 2: BI Data Query Course Content
  • Module 3: Creating Data Models
  • Module 4: PowerPivot for Excel
  • Module 5: Creating PowerPivot Functions
  • Module 6: Power View for Excel
  • Module 7: Power Map for Excel
  • Module 8: Power BI publisher for Excel

Who Should Attend?

This course is suited to those with an interest in Excel, data analysis, data science, business intelligence, market analytics, reporting sales, analytics, Fraud and Audit and is well suited for Accountants, statisticians, Auditors, Internal Auditors, Economists, enterprise managers, data analysts, Business Analysts, Finance staff, Banking staff, financial market staffs, consultants, Management and those involved with Compliance and Risk assessment and BI

Prerequisites:

Each participate is expected to have access to a system during the training as this is a practical class and this would aid active participation and understanding.

Prior knowledge of excel is a compulsory as this is not a beginner non- intermediate excel class.

The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos. Apr 14 - 16 Apr, 2025
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos., Lagos State, Nigeria 05 - 07 Jun, 2025
The Professional Place: 12b, Olumoroti Street, Gbagada Phase 2, Lagos., Lagos State, Nigeria 17 - 19 Jul, 2025
NGN 218,750.00(5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants)
NGN 218,750.00(5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants)
NGN 218,750.00(5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants)
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

5% Group Discount for 3-5 participants, or 10% Group Discount for 6 and above participants

Related Courses

IOSH Managing Safely Course IOSH Managing Safely Course

3 days, 17 - 19 Apr, 2025 

2025-04-17 12:04:00 2025-04-17 12:04:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

IOSH Managing Safely is an ideal course for any individual in a supervisory or management position to understand why and how to manage safety within their organization effectively. IOSH Managing ...

Document Control and Records Management Document Control and Records Management

3 days, 27 - 29 Mar, 2025 

2025-03-27 12:03:00 2025-03-27 12:03:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

This Document Control and Records Management course will discuss the principles of managing information. The organization: How your information is managed today Definitions: Understanding what the ...

Installation and Configuring Windows Server 2016 Course Installation and Configuring Windows Server 2016 Course

3 days, 28 - 30 Aug, 2025 

2025-08-28 12:08:00 2025-08-28 12:08:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

Upon Completion of this Course, you will accomplish following: - Plan and prepare a strategy for server upgrade or migration Prepare and install Server Core installation, Nano Server Understand the ...

Corporate Strategies and Value Innovation Masterclass Corporate Strategies and Value Innovation Masterclass

3 days, 20 - 22 Mar, 2025 

2025-03-20 12:03:00 2025-03-20 12:03:00
Lagos State, Nigeria

McTimothy Associates Consulting LLC

This course introduces key concepts, tools, and principles of strategic management allowing managers to create their organization's unique sustainable competitive advantage using differentiation, ...