Please enable JavaScript.
Coggle requires JavaScript to display documents.
POWER BI - Coggle Diagram
POWER BI
SHAPE INITIAL DATA
POWER QUERY EDITOR
IDENTIFY COLUMN HEADERS AND NAMES
PROMOTE HEADERS
USE FIRST ROW AS HEADERS
RENAME/ REMOVE COLS
REMOVE TOP ROWS
REMOVE COLS
UNPIVOT COLS
MOST OFTEN USE W DATA FROM EXCEL
Transform -> Unpivot
wide to long data
PIVOT COLS
FLAT DATA -> TABLE OF AGGREATE VALUES
THEN SUMMARIZE DATA
MAX
MEDIAN
MIN
AVERAGE
COUNT
SUM
SIMPLIFY DATA STRUCT
RENAME QUERY
USER FRIENDLY NAMES
FactProductTable -> Products
import view of Products: vProduct -> confusing name
TargetSales --> with year (have this query annually)
REPLACE VALUES
TRANSFORM -> REPLACE VALUES
REPLACE NULL VALUES
NULL -> 0
REMOVE DUPLICATES
MIGHT NEED TO COPY THE TABLE BF REMOVING DUPLICATES
TIPS
USE LGG + ABBR. COMMONLY USED WITHIN ORG.
GIVE TABLES, COLS, MEASURES DESCRIPTIV. BIZ TERMS
"_" -> " "
CHANGE COLS DATA TYPES
EVALUATE DATA TYPES IN PQE BF LOADING
CHANGE DATA TYPES
COMBINE MULTIPLE TABLES INTO SINGLE TABLE