تجاوز إلى المحتوى الرئيسي
Data Analysis Using Microsoft Excel and Power Business Intelligence (BI)
Data Analysis Using Microsoft Excel and Power Business Intelligence (BI)
التقييم
المدرب/ون
حسن منصور
عدد الساعات
14
فترة الانعقاد
-
أيام النشاط التدريبي
الاثنين
الثلاثاء
الاربعاء
الخميس
التوقيت
16:30 - 20:00
تصنيفات النشاط التدريبي
المهارات الأساسية
لغة النشاط التدريبي
انجليزي
المنهجية
وجاهي
المدينة
عمان
نوع التدريب
دورات قصيرة
اخر موعد للتسجيل
السعر للأردني
112 JOD
السعر لغير الأردني
280 US$
المخرجات

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.

الفئة المستهدفة

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

المحتويات

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

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.