Interactive Dashboards Using Power BI
Interactive Dashboards Using Power BI
0
Description
Interactive Dashboards Using Power BI
Requirements
Nothing
What You Learn
Interactive Dashboards Using Power BI
Who This Course Is For
Any One Intersted in Data Analysis and Project Control Engineers
- 01 Introduction
- 1.01 Project Overview 00:08:30
- 1.02 Importing Data from Excel 00:07:46
- Quiz 0 Questions
- 02 Table in Power BI
- 2.01 Creating Tables preview 00:05:41
- 2.02 Formatting and Sorting 00:10:01
- 2.03 Cross Filtering for Tables 00:05:57
- 2.04 Methods of Aggregations 00:06:12
- 2.05 Percentage Calculations 00:01:47
- Quiz 0 Questions
- 03 Matrix and Cards
- 3.01 Creating Matrix Visualization 00:05:37
- 3.02 Method of aggregations in matrix 00:04:06
- 3.03 Conditional Formatting 00:07:20
- 3.04 Card Visualization 00:08:26
- Quiz 0 Questions
- 04 Filter and Slicer
- 4.01 Text Slicers 00:05:07
- 4.02 Numeric Slicer 00:04:11
- 4.03 Date Slicers 00:03:55
- 4.04 Text Filter Visual Level 00:04:55
- 4.05 Numeric Filter Visual Level 00:04:57
- 4.06 Date Filter Visual Level 00:02:42
- 4.07 Page and Report Level Filter 00:01:54
- 4.08 Drill Through Filter preview 00:03:45
- Quiz 0 Questions
- 05 Column Visualization
- 5.01 Column Visualization 00:11:41
- 5.02 Analytics Features 00:05:21
- 5.03 Graph Options 00:05:19
- 5.04 Stacked Column Chart 00:03:08
- 5.05 Cross Filter and Slicer 00:02:00
- Quiz 0 Questions
- 06 Trend Analysis
- 6.01 Line Chart preview 00:12:11
- 6.02 Graph Chart 00:04:02
- 6.03 Ribbon Chart 00:02:37
- 6.04 Other Graphs 00:04:52
- Quiz 0 Questions
- 07 Interactive Report
- 7.01 Interactive dashboard Project 00:13:10
- 7.02 Report Features 00:03:47
- 7.03 Grouping option 00:06:22
- 7.04 Advanced Tooltips 00:08:12
- 7.05 Bookmarks 00:06:08
- 7.06 Action Buttons 00:07:37
- 7.07 Publish Report 00:04:03
- Quiz 0 Questions
- 08 Custom Visualization
- 8.01 More Visuals (Gant Chart & Slicer) 00:08:24
- 8.02 Themes 00:04:11
- Quiz 0 Questions
- 09 Excel & PowerPoint
- 9.01 Export to Excel 00:04:46
- 9.02 Export to Power Point 00:04:30
- Quiz 0 Questions
- 10 Over view Query Editor & Perform Transformation
- 10.01 Overview Query Editor 00:06:57
- 10.02 Transformation Part 1 00:06:48
- 10.03 Transformation Part 2 00:06:24
- 10.04 Transformation Part 3 00:04:08
- 10.05 Conditional If Statement 00:05:45
- 10.06 Merge Function 00:08:44
- 10.07 Append Function 00:07:04
- 10.08 Column Calculations 00:07:31
- 10.09 Diagnostics 00:07:57
- 10.10 Summery Table 00:07:08
- 10.11 Clean & Prepare Data for Analysis 00:06:03
- 10.12 Parameters 00:09:40
- Quiz 0 Questions
- 11 Relationships
- 11.01 Creating and Manage Relationships 00:08:19
- 11.02 Relationship Calculations 00:04:39
- Quiz 0 Questions
- 12 DAX Calculations
- 12.01 Calculated Columns 00:06:30
- 12.02 Date Functions 00:05:37
- 12.03 Formatting Dates 00:06:21
- 12.04 Date Master Table 00:10:57
- 12.05 Introduction to Measure 00:07:11
- 12.06 Measure Formulas 00:06:48
- 12.07 Calculate Formula 00:11:10
- 12.08 New Table Using Filter 00:07:11
- 12.09 SUMX 00:05:43
- 12.10 IF Function 00:07:26
- 12.11 And & Or Functions 00:07:22
- 12.12 Cumulative Values 00:13:36
- Quiz 0 Questions
- 13 Case Study with P6
- 13.01 Preparing Data in P6 00:10:26
- 13.02 Exporting Data to Excel (PV) 00:05:48
- 13.03 Exporting EV Cost Values 00:12:20
- 13.04 Activity Codes 00:13:53
- 13.05 Transforming Data in power BI 00:08:59
- 13.06 Cards (Delay Days) 00:10:02
- 13.07 PV & EV Interval 00:06:41
- 13.08 Cum PV 00:08:13
- 13.09 Cum EV & Line Chart 00:09:39
- 13.10 Percent Complete % 00:17:15
- 13.11 Formatting 00:06:23
- 13.12 Manpower Data from P6 00:12:30
- 13.13 Transforming data for manpower 00:10:36
- 13.14 Productivity Performance Index 00:11:23
- 13.15 Summery Manpower Analysis Report 00:14:06
- 13.16 Detailed Manpower Analysis Report 00:11:52
- 13.17 Construction Staff Efficiency 00:06:52
- 13.18 Efficiency & Deployment Schedule 00:09:15
- 13.19 Comprehensive Report by Building 00:11:38
- 13.20 SPI Indicator by building preview 00:08:07
- Quiz 0 Questions
- 14 Connect Power BI with Data Base
- 14.01 Connect Power BI with SQLite 00:05:18
- 14.02 Connect Power BI with XML 00:03:03
- 14.03 Connect Power BI with Web 00:03:43
- Quiz 0 Questions
- Exams
Write Review
Latest Courses
Copyright | Planning Force All Rights Reserved . Made with MiskIts
Reviews
Joe LiTrenta
2024-09-09 14:09:27Priyadarshini K
2024-08-30 06:35:59Balaji Venkatesan
2024-08-29 10:55:26AHMED ADEL ABDELHAMID ABDELAAL AYOUB
2024-08-24 11:56:32Ahmedmoheb256
2024-08-20 08:18:42Ahmed Maher
2024-08-12 06:51:18Mahmoud Saber
2024-08-11 07:10:54Avadhut Kashikar
2024-07-24 10:53:06Mohamed kamal
2024-07-23 19:10:01Saranya S
2024-07-22 09:57:37Ali Ibrahim
2024-07-19 13:54:55Jad Darazi
2024-07-09 11:50:46Allen J.
2024-07-02 18:04:57Ahmed Abdelrasol Hamza
2024-06-24 21:02:55Mohamed Attia Abass
2024-06-24 10:52:56Ali Ahmed
2024-06-13 16:48:25Mohamed Bayoumi Afifi Ali Abdin
2024-06-03 06:07:44Abdelrahman Fawzy Ibrahim
2024-05-27 08:11:09Mohammad Elhefnawy
2024-05-22 09:45:46Jimmie Box
2024-05-16 12:24:00Shehab Salah El-Dein
2024-05-09 19:32:02samira Albesher
2024-05-03 06:21:15thank you
Nesreen Refaat
2024-05-03 05:14:10Ahmed Elsayed Amin Moustafa
2024-04-18 05:29:34Yousra
2024-04-13 12:57:58Ahmed Afifi
2024-04-12 12:46:38Ibrahim Ali Ibrahim
2024-04-11 14:26:27Mohammed sluieman ABUALHAJ
2024-04-08 01:00:34GOOD
Hadeer Elarosy
2024-04-02 20:40:39Mahmoud Samak
2024-03-31 09:31:54