Two days Webinar on

Microsoft Power BI for Excel Users

On

23^rd – 24^th February 2024

11:00 AM to 04:30 PM

Introduction    

This course is designed for anyone who works with large set of data facing problem in excel and want to create a dashboard and share with your team member – regardless of technical or analytical background. Get trained in data visualization techniques, work with interactive dashboards, and generate reports, charts and graphs. 

Program Objectives

The course is provided with a basic understanding and concept of using Power BI, and hands-on exercises covering most of course content and some will be an overview, and providing the opportunity to visually analyze data, build Interactive Dashboards and share them with others.

ROI on Training: -

Various BI tools and understanding how they can be used together for greater effect

The decision-making process in an enterprise and steps involved

Understand options for connecting to data

Build and format visualizations

Understand basic parameters

Create calculated fields

Build interactive dashboards

Publish the reports and dashboard

Prerequisites

Business Analysts / Excel users or those working on big data and wants to create reports and dashboard.

Course Outline / Contents

Ø Getting started ü Introducing Power BI ü A quick look at Power BI Desktop ü A quick look at the Power BI service Ø Power BI and Excel ü Introduction - using Excel data in Power BI ü Upload Excel data to Power BI ü OneDrive for Business with Excel ü Import Power View and Power Pivot to Power BI Ø Shaping and Transforming Data ü Introduction to the Query Editor ü Clean and transform your data with the Query Editor ü Cleaning irregularly formatted data Ø Modeling ü Introduction to modeling your data ü How to manage your data relationships ü Optimizing data models ü Introduction to DAX ü DAX calculation types ü DAX functions ü Create calculated columns ü Create calculated measures ü Create calculated tables Explore your time-based data

Ø Visualizations ü Introduction to visuals in Power BI ü Create and customize simple visualizations ü Modify colors in charts and visuals ü Shapes, text boxes, and images ü Page layout and formatting ü Interactions among visualizations ü Visual hierarchies and drill-down ü Using custom visualizations ü R integration in Power BI Desktop Ø Publishing and Sharing ü Introduction to the Power BI service ü Publish Power BI Desktop reports ü Create and configure a dashboard ü Share dashboards with your organization ü Quick insights in Power BI ü Introduction to security, and workspaces ü Create workspaces in Power BI ü Manually republish and refresh your data ü Install and configure a personal gateway ü Print and export dashboards and reports ü Publish to web Ø Getting Data ü Available data sources in Power BI Desktop ü Connecting to data sources ü Connecting to a database ü Connecting to a CSV file

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. 10,000/-

USD 161

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 – 9560940218 only Whatsapp

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