Tutorial

23 Oct 2023 PowerBi

PowerBi Tutorial Overview

1. DataImport

csv/excel
SQL DB
- (1) 서버 주소 기입
- (2) DB > Table 선택
- (+ )실시간 연동 : Direct Query
  - 실시간 설정 방법 : 시각화>서식>페이지 새로고침 활성화

2. Prep (=Transform)

(1) Filtering
(2) Change Data Type
(3) Rename / Delete / Insert Columns
(4) Merge
- select join keyes from each tables

3. Layout - “Context”

(1) Title
(2) Visualization
- Fields : (defalt : Bar chart)
- Graph type : select X,Y,etc
(3) Filtering (slicer)

4. Publish

Reference

[1] PowerBi Tutorial - Kevin Stratvert