Microsoft Excel BI Tool

This course introduces the use of the BI Tool available in Microsoft Excel, which is a tool that helps in data management, data analysis, and summarizing results in a way that is clearly meaningful, beautiful, and easy to understand. It can present information in various formats such as charts, images, maps, or in the form of a dynamic report known as a dashboard.

Introduction to BI Tool and Basic Usage

• Getting to know the BI Tool
• Familiarizing with various tools of the BI Tool
• Power Query
• Power Pivot
• Power View
• Power Map
• Installing necessary Add-ins for usage

Using Power Query

• Understanding the basics of Power Query
• Creating a new query from various data sources such as Text File, Excel File, Access File, etc.
• Using Query Editor to edit and customize queries
• Using Group and Combine to aggregate and transform data imported from multiple files

Using Power Pivot

• Understanding the basics of Power Pivot
• Importing and adding data
• To the Data Model
• Creating relationships between tables
• Creating calculated fields

Using Power View

• Understanding the basics of Power View
• Creating and customizing Power View

Using Power Map

• Understanding the basics of Power Map
• Creating Power Map