Have any question? +2348023037488, +2348062446972

Business Intelligence with Microsoft Excel

If you want to become good at creating Self Service Business Intelligence (BI) using the excellent and extensive Microsoft tool sets, you must learn how to become a data modeler using Power Pivot.

This course teaches the skills a business analyst needs to know in order to successfully use Power BI, Power Pivot for Excel and Power Query. The course starts out first using Powerful Advanced Excel functionality and then moves to Power BI tools.

Want to write basic Data Analysis eXpressions (DAX) formulas to extract business insights?

Want to write more advanced DAX formulas that use the power of DAX to extract additional business insights from the data that are not immediately obvious (yet are inherently available)?

Want to move from being a Power Pivot for Excel user to being a Power BI user, covering the differences between the tools and how to start using Power BI effectively?

Learning Objectives

The Main objective of this training is to make you understand Power Query, Power Pivot, Power View and Power Map to create powerful business intelligent reports and dashboards

Understand Power Query & Power Pivot and how to apply it to your job.

Produce valuable metrics for your business that never existed before.

Learn best tips & tricks to solve complex problems & create stunning work.

Target Audience

Intensive users of Excel, especially those responsible for reporting and analysis.

Business leaders who need to mine their data for actionable insight – using existing resources and on short deadlines.

Organizations looking to leverage Microsoft’s groundbreaking Power Pivot & BI offerings.

Business Intelligence and Database professionals looking to increase their professional agility and dramatically expand their capabilities.


Program Outline


Power Query

Cleaning up Data

Merging & Appending Data

Grouping Data

Loading data to PowerPivot

Power Pivot

Create relationships between Tables

Manage millions of rows of data

Custom Calculations, Key Metrics/KPIs

Analyzing Data with Pivot Tables

Power View

Creating Tables and Cards

Visualizing data with Graphs

Creating Interactive dashboards

Filter and Ask Questions of your Data

Powerful data analysis with Scatter Plots and Bubble Plots

Visualize Geographical data and maps

Power Map

Mapping Data with Power Map

Changing the Method of Aggregation

Mapping Data over Time

Creating Tours

Cost: N 100 000

Copyright © 2023 Jireh Computer Solution Ent. All right reserved.
Powered by:

Style Switcher

Select Layout
Chose Color
Chose Pattren
Chose Background