Webinar on

Power BI in Excel

On

23rd May 2025

11:00 AM to 05:00 PM

By

Microsoft Certified Professional & Data Analyst

Program Objectives

To introduce participants to the basics of Power BI, help them understand data visualization concepts, and enable them to create interactive reports with filters, Top N, and calculated metrics.

ROI on Training: -

Understand the Power BI interface and data visualization concepts.

Create basic and advanced visualizations with filters and interactions.

Learn to use Top N filters and apply conditional formatting.

Create calculated metrics using simple DAX formulas.

Publish and share Power BI reports.

How to customize colors, fonts, and layout for professional-looking reports

Useful Power BI keyboard shortcuts and productivity tips

Course Contents

Ø Introduction to Power BI

ü  What is Power BI?

ü  Importance of Data Visualization

ü  Power BI components (Power BI Desktop, Service, and Mobile

 

Ø Basic Data Visualizations        

ü  Creating basic visualizations:

ü  Bar Chart, Line Chart, Pie Chart

ü  Table and Matrix

ü  Formatting visualizations

 

Ø Advanced Visualizations       

ü  Stacked and Clustered Charts

ü  Combo Chart (Line + Column)

ü  Map Visualizations

 

Ø Adding Calculated Metrics    

ü  Creating calculated columns

ü  Using simple DAX formulas:

ü  SUM(), AVERAGE(), COUNT()

ü  Adding measures for key insights

Ø Q&A and Wrap-up      

ü  Recap of key concepts & queries

ü  Tips for further learning

Ø Getting Started with Power BI      

ü  Connecting to Data (Excel, CSV)

ü  Data Transformation Basics (Power Query)

ü  Loading Clean Data into Power BI

 

Ø Data Filtering & Slicing         

ü  Using Filters and Slicers

ü  Adding interaction between visuals

ü  Visual level vs. Page level filters

 

Ø Top N Analysis & Conditional Formatting 

ü  Creating Top N filters

ü  Adding data labels and percentages

ü  Applying conditional formatting based on values

 

Ø Power BI Report Publishing & Sharing         

ü  Overview of Power BI Service

ü  Publishing reports

ü  Sharing and collaborating with Power BI Service

Pre-requisites

You should have good internet connection and good quality headphone/speaker set with Laptop.

You should have notepad/pen to note down important points.

How to Register:

Fees: Per person

Rs. 4500 /-

USD 81

18% GST is applicable

> Mode of Payment: NEFT /Paytm / Credit Card/ GPAY

> Fees include certificate of participation & Course Material.

*Terms & Conditions apply

 

Best regards

For GFORD Institute of Management Pvt Ltd

Piyush Verma

For Booking seats Email us : gfordseminar@outlook.com 

Mob. : 9711114779 / 9315556407

For Query and nominations – 9540012349 only Whatsapp

 

For unsubscribe from the mailing list, please mail us on deletemailgford@gmail.com