Advanced Data Analysis and Report with PowerQuery and PowerBI

2 พฤศจิกายน 2562

9.00 – 12.00

• Tool BI (PowerQuery, BI , Pivot , View, Map)

• Introduction to Microsoft Excel

• Advanced Microsoft Excel

• Overview

• Conditional Formatting

• Calculator in Excel

• Basic Calculator

• Date Calculator

• Calculator in Excel

• Formula Calculator

• Work with Data (Sort, Filter, Subtotal)

• Analyzing Data (Trend, Scenarios)

• Work with Multiple Workbooks

13.00 - 16.00

• Overview Power Query

• Install Power Query

• Get Data

• Data Transformation

• Pivot Column

• Unpivot Column

• fill

• Pivot Table

• Append Query

• Merge Query

• Calculator in Power Query

• Function in Power Query

3 พฤศจิกายน 2562

9.00 – 12.00

• Overview Pivot Table & Pivot Chart

• Prepare Data

• Get Data

• Management Data

• Calculator in Pivot Table

• Slicer and Timeline

• Filter Data

• Power Pivot

• Overview Power Pivot

• Install Power Pivot

• Relationship

• DAX Expression

• DAX Function

13.00 - 16.00

• Power BI

• Overview Power BI

• Install Power BI

• Get Data

• Relationship

• Create Visual

• Pin Dashboard

• Power BI Service

• Workshop 1: Retail Analysis

• Workshop 2: Human Resources