Timestamp: 00:00:00 Opening 00:02:50 Why Learn Data Analytics 00:07:03 BI Tools 00:10:00 Why Power BI 00:11:04 Disclaimer 00:12:38 Installation 00:13:10 Basic Principle 00:23:55 Get Data Excel 00:25:10 User First Row as Headers 00:26:10 Get Data CSV 00:27:00 Remove Top Rows 00:30:18 Remove Bottom Rows 00:31:46 Replace Values 00:32:33 Split Column 00:36:02 Split Column by Multi Delimiter 00:37:50 Remove Columns 00:40:28 Copying Steps 00:43:51 Get Data Excel 00:46:00 Get Data Folder 00:50:05 Get Data SQL 00:54:30 Get Data Google Sheets 00:55:50 Get Data Web 00:58:06 Fill Down 00:59:42 Enter Table Manually 01:12:50 Split Column 01:21:24 Load SQL Query as Table 01:25:07 Import vs DirectQuery 01:28:42 Change Data Source 01:29:14 Merge Columns 01:30:30 Search Column 01:31:14 Extract 01:34:12 Append Table 01:38:50 Merge Table 01:41:40 Join Table Concept 01:51:37 Conditional Column - IF THEN ELSE 01:54:27 Calculated Column - Custom Column 01:55:25 Extract Date and Time 01:58:00 Format Column Text 01:59:20 Group By 02:04:27 Pivot Column - Unpivot Column 02:10:40 Time Efficiency - Duplicate, Reference, Disable Load 02:14:46 Error Handling 02:16:56 Advanced Editor 02:19:23 Overview of Canvas, Table view, Model view 02:20:00 Insert Shape 02:22:00 Enter Table Manually 02:23:00 Add New Column 02:25:01 Join Table and RELATED/VLOOKUP 02:29:27 DAX Basic Concept 02:31:35 DAX Calculate SUM 02:38:20 DAX Calculate First Non Blank 02:45:23 DAX FILTER 02:48:14 DAX Studio 02:50:30 Add New Measure NUM DENUM 02:54:20 DAX Benchmark 02:57:40 Change Format of Column 02:58:37 DAX Calendar 02:59:23 DAX Cumulative 03:02:10 DAX Progress Tracker 03:04:46 Sorting Column for Canvas 03:05:46 Don't summarize 03:08:29 Frequent Used Visuals 03:08:36 Area Chart 03:10:45 Stacked Bar Chart 03:12:17 Treemap 03:13:45 Change Canvas Setting 03:14:17 Fit to Width 03:14:27 Line Chart 03:15:28 Change data type 03:17:34 Column Chart 03:19:10 Pie Chart 03:20:45 Scatter Chart 2D 03:23:56 Add Constant Line 03:28:12 Add Text 03:29:20 Gauge 03:30:05 KPI 03:37:42 Scatter Chart 3D 03:48:36 Matrix 03:50:26 Conditional Formatting Color 03:51:45 Ribbon Chart 03:52:10 Copy Visual 03:54:26 Formatting Visual
![[[ 3 HOURS ]] Data Warehouse Complete Tutorial - SQL + SSIS + SSAS + Power BI - { End to End }](http://i.ytimg.com/vi/eNxbMwUGl1g/mqdefault.jpg)
![Visual Calculations in Power BI - DAX Made Easy! [Full Course]](/img/1.gif)
Timestamp:
00:00:00 Opening
00:02:50 Why Learn Data Analytics
00:07:03 BI Tools
00:10:00 Why Power BI
00:11:04 Disclaimer
00:12:38 Installation
00:13:10 Basic Principle
00:23:55 Get Data Excel
00:25:10 User First Row as Headers
00:26:10 Get Data CSV
00:27:00 Remove Top Rows
00:30:18 Remove Bottom Rows
00:31:46 Replace Values
00:32:33 Split Column
00:36:02 Split Column by Multi Delimiter
00:37:50 Remove Columns
00:40:28 Copying Steps
00:43:51 Get Data Excel
00:46:00 Get Data Folder
00:50:05 Get Data SQL
00:54:30 Get Data Google Sheets
00:55:50 Get Data Web
00:58:06 Fill Down
00:59:42 Enter Table Manually
01:12:50 Split Column
01:21:24 Load SQL Query as Table
01:25:07 Import vs DirectQuery
01:28:42 Change Data Source
01:29:14 Merge Columns
01:30:30 Search Column
01:31:14 Extract
01:34:12 Append Table
01:38:50 Merge Table
01:41:40 Join Table Concept
01:51:37 Conditional Column - IF THEN ELSE
01:54:27 Calculated Column - Custom Column
01:55:25 Extract Date and Time
01:58:00 Format Column Text
01:59:20 Group By
02:04:27 Pivot Column - Unpivot Column
02:10:40 Time Efficiency - Duplicate, Reference, Disable Load
02:14:46 Error Handling
02:16:56 Advanced Editor
02:19:23 Overview of Canvas, Table view, Model view
02:20:00 Insert Shape
02:22:00 Enter Table Manually
02:23:00 Add New Column
02:25:01 Join Table and RELATED/VLOOKUP
02:29:27 DAX Basic Concept
02:31:35 DAX Calculate SUM
02:38:20 DAX Calculate First Non Blank
02:45:23 DAX FILTER
02:48:14 DAX Studio
02:50:30 Add New Measure NUM DENUM
02:54:20 DAX Benchmark
02:57:40 Change Format of Column
02:58:37 DAX Calendar
02:59:23 DAX Cumulative
03:02:10 DAX Progress Tracker
03:04:46 Sorting Column for Canvas
03:05:46 Don't summarize
03:08:29 Frequent Used Visuals
03:08:36 Area Chart
03:10:45 Stacked Bar Chart
03:12:17 Treemap
03:13:45 Change Canvas Setting
03:14:17 Fit to Width
03:14:27 Line Chart
03:15:28 Change data type
03:17:34 Column Chart
03:19:10 Pie Chart
03:20:45 Scatter Chart 2D
03:23:56 Add Constant Line
03:28:12 Add Text
03:29:20 Gauge
03:30:05 KPI
03:37:42 Scatter Chart 3D
03:48:36 Matrix
03:50:26 Conditional Formatting Color
03:51:45 Ribbon Chart
03:52:10 Copy Visual
03:54:26 Formatting Visual
Barokallah mas sharing knowledge dan waktunya, lanjutkan mas :)