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 Introduction Course

By: McTimothy Associates  

Lagos State, Nigeria

12 - 14 Nov, 2020  3 days

Follow Event

  

NGN 145,000

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

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. Nov 12 - 14 Nov, 2020

Registration: 09:00:am - 09:45:am

Class Session: 10:00:am - 04:00:am

NGN 145,000.00
(Convert Currency)

Blessing Aguta 09080022449, 08058805333

Related Courses
The Balanced Scorecard: Achieving Performance Excellence Course The Balanced Scorecard: Achieving Performance Excellence Course

2 day, 25 - 26 Nov, 2020 

2020-11-25 12:11:00
Lagos State, Nigeria

McTimothy Associates

Aligning business activities to a company's vision and strategy is a must to ensure operational excellence. This is easier said than done, since this will require specific processes to ...

Finance for Non-Finance Managers Course Finance for Non-Finance Managers Course

3 days, 11 - 13 Nov, 2020 

2020-11-11 12:11:00
Lagos State, Nigeria

McTimothy Associates

Exposure of managers to important financial concepts in day-to-day business transactions. It will help them make better decisions based on financial implications on the business. It will also make ...

 Training on How to Conduct Effective Meetings Training on How to Conduct Effective Meetings

2 day, 19 - 20 Nov, 2020 

2020-11-19 12:11:00
Lagos State, Nigeria

McTimothy Associates

The purpose of this course is to answer the following question. "How can we have more productive meetings that are Goal focused, well designed, well managed, well prepared and held in the ...

Strategic Thinking and Planning Workshop Strategic Thinking and Planning Workshop

3 days, 28 - 30 Oct, 2020 

2020-10-28 12:10:00
Lagos State, Nigeria

McTimothy Associates

An organization without a strategy is like a ship without a rudder. How can organizations continue to provide exceptional value to stakeholders and customers if they are not clear on where they are ...