Skip to main content
Data Analysis Using Microsoft Excel and Power Business Intelligence (BI)
Data Analysis Using Microsoft Excel and Power Business Intelligence (BI)
Training Activity Rate
Trainer/s
حسن منصور
Training activity Hours
17.50
Training activity Date
-
Training Activity Days
Sunday
Monday
Tuesday
Wednesday
Thursday
Start and End Time
16:30 - 20:00
Training Activity Classification
Basic Skills
Course Language
English
Methodology
In class
City
Amman
Type of Training
short courses
Deadline for registration
Price For Jordanian
140 JOD
Price For Non Jordanian
262.5 US$
Outcomes

By the end of this course, trainees will be able to :-

- Deploy Power Business Intelligence (BI).

- Build reports.

- Make merging, summarizing, and calculating data .

- Work with CSV, TXT, and Excel Worksheets.

Target Group

- Analysts, business seniors and financial employees who are interested in preparing financial and managerial reports, building dash boards, and cleaning and transforming data.

Contents

- LOOKUP, VLOOKUP & HLOOKUP.

- XLOOKUP & XMATCH .

- PIVOT TABLES .

- PIVOT POWER – DATA ANAYSIS EXPRESSIONS (DAX).

- RELATIONSHIPS .

- What is Power BI?

- Examining Power BI Suite of Products.

- Identifying Differences Between Products.

- Understanding Power BI Updates.

- Installing Power BI Desktop.

- Exploring the Power BI Desktop Interface.

- Utilizing File Types; PBIX vs PBIT.

- Examining Data Sources.

- Discussing Data Refresh.

- Understanding Data Types.

- Importing, Transforming, and Loading Data.

- Appending Operations.

- Working with Folders and Files.

- Using Pivot Tables.

- Working with Relational Data.

- Understanding Relationships.

- Importing from SQL Server Analysis Services Multidimensional and Tabular.

- Understanding the Issues with Merges.

- Performing Merges.

- Grouping Options.

- Summarizing.

- Calculating.

- Creating Reports.

- Utilizing the Matrix Visualization.

- Utilizing the Map Visualization.

- Utilizing the Card Visualization.

- Utilizing the Chart Visualization.

- Utilizing Slicers.

- Publishing to Power BI Online.

- Introduction to Power BI Online.

- Importing Data.

- Sharing Reports and Dashboards.

- Creating Reports.

- Configuring Dashboards.

- Exploring Power BI Mobile.