Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate&#039;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.

Aya MohamedFinancial Learning Advisor TL

Customized Corporate Training

We are the 'go-to' experts when it comes to customizing financial training programs. While adhering to the set rules and regulations, we do not interrupt your day-to-day business activities and work with cooperative flexibility to fit the immersing workflow.

Learning 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.

Classify merging, appending and Combing data.

Creating data models.

Explain normalization concept.

Categorize different relationship types.

Distinguish measures Using DAX (Data Analysis Expressions).

Creating Calculated Columns Using DAX (Data Analysis Expressions).

Construct dynamic Reports and Dashboards.

Prepare different Power BI visuals for a professional report.

Organize data using different filter levels.

Course Outline

Introducing Pivot Tables & PivotChart

Analyzing Data with PivotChart

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

Power Pivot Capabilities

Understand Data Model Concept

Create Relationships in Data Model

Understand Data Analysis Expression - DAX

Create a Calculated Column

Create a Measure

Row Context

Filter Context

Time Intelligence in DAX

Introduction to business intelligence

Introduction to data analysis & data visualization

Introduction Power BI

Create Report & Dashboard

Loading Data to Power BI

Uploading & Updating PBIX Reports

Transforming Data Using Power Query in Power BI

Create Calculated Column

Create Measure

Mange Data Model in Power BI

Create Relationships

Create Hierarchies

Creating Reports & Dashboard

Report Filtering

Drill-down & Drill-Through

Formatting Visualizations

Apply conditional formatting

Slicers and Advance Card Visuals

Bookmarks & Buttons & Q & A

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.

Karim Shawki

Country Sales Manager