Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

Microsoft Power BI is a business analytics service that allows you to visualize data and share insights. It transforms data from various sources to create interactive dashboards and Business Intelligence reports. Power BI, a Microsoft 365 program, will be covered in this course. 


For More Inquiries

Karim Shawki

Country Sales Manager

 966501148310

 k.shawki@beacon.com.eg

Karim Shawki

Country Sales Manager

 966501148310

 k.shawki@beacon.com.eg

Course Outcome

Analyze and visualizing any amount of data.

Apply how to handle and manage the format of any type of huge data.

Recognize the transforming data from Excel, CSV, any other source.

Determine how to clean up data and transform it to the best version in no time.

Identify Power query editor.

Course Outline

Module 1: DATA ANALYSIS USING EXCEL :Classic Excel Dashboard

Introducing Pivot Tables & PivotChart

Analyzing Data with PivotChart

Module 1: DATA ANALYSIS USING EXCEL :Connect, Transform, and Load Data Using Power Query

Introducing to Power Query

Connecting to Excel Workbook Files

Connecting to CSV & TEXT Files & Folders

Connecting to Access Files

Transforming Data Using Power Query

Loading Data to the Excel Data Model

Working with Multiple Queries

Module 1: DATA ANALYSIS USING EXCEL :Working with Data Model in Power Pivot

Power Pivot Capabilities

Understand Data Model Concept

Create Relationships in Data Model

Module 1: DATA ANALYSIS USING EXCEL :Working with DAX

Understand Data Analysis Expression - DAX

Create a Calculated Column

Create a Measure

Row Context

Filter Context

Time Intelligence in DAX

Module 2: Data Analysis Using Power BI :Introduction to Self-Service Business Intelligence

Introduction to business intelligence

Introduction to data analysis & data visualization


Who Should Attend

Anyone working with big data and need
to analyze and visualize it in professional report.

Anyone who wants to tell a story
using data by using visuals graphs and charts.

Any excel user who wants to improve
his knowledge and techniques by using better and smarter tools to do daily
tasks.

Share