亚色影库

醿欋儯醿犪儭醿樶儭/醿炨儬醿濁儝醿犪儛醿涐儤醿� 醿♂儛醿�醿斸儦醿�醿濁儞醿斸儜醿�: Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿愥儨醿愥儦醿樶儢醿�

醿欋儯醿犪儭醿樶儭/醿炨儬醿濁儝醿犪儛醿涐儤醿� 醿�醿愥儨醿掅儬醿�醿氠儤醿曖儩醿戓儛:

• 醿欋儯醿犪儭醿� 醿ㄡ償醿撫儝醿斸儜醿� 8 醿欋儠醿樶儬醿樶儭醿掅儛醿�. (醿♂儯醿�: 16 醿氠償醿メ儶醿樶儛, 32 醿♂儛醿愥儣醿�).
• 醿氠償醿メ儶醿樶償醿戓儤 醿┽儛醿⑨儛醿犪儞醿斸儜醿� 醿欋儠醿樶儬醿愥儴醿� 2-醿�醿斸儬 (醿♂儛醿涐儴醿愥儜醿愥儣醿� 醿抚儛 醿�醿ａ儣醿ㄡ儛醿戓儛醿椺儭 19:00醿♂儣-21:00醿♂儣)
• 醿氠償醿メ儶醿樶儤醿� 醿�醿愥儨醿掅儬醿�醿氠儤醿曖儩醿戓儛醿� 2 醿♂儛醿愥儣醿�.

醿♂儛醿涐儤醿栣儨醿� 醿愥儯醿撫儤醿⑨儩醿犪儤醿�: 醿欋儯醿犪儭醿� 醿掅儛醿溼儥醿ａ儣醿曖儨醿樶儦醿樶儛 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿樶儭 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿�, 醿愥儨醿愥儦醿樶儢醿樶儣 醿抚儛 醿栣儩醿掅儛醿抚儛醿� 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿椺儛醿� 醿涐儯醿ㄡ儛醿濁儜醿樶儣 醿抚儛醿樶儨醿⑨償醿犪償醿♂償醿戓儯醿氠儤 醿溼償醿戓儤醿♂儧醿樶償醿犪儤 醿愥兏�儛醿涐儤醿愥儨醿樶儭醿椺儠醿樶儭.

醿欋儯醿犪儭醿� 醿♂儛醿♂儛醿犪儝醿斸儜醿氠儩 醿抚儛 醿♂儛醿樶儨醿⑨償醿犪償醿♂儩 醿樶儱醿溼償醿戓儛 醿犪儩醿掅儩醿犪儶 醿涐儛醿椺儣醿曖儤醿�, 醿曖儤醿溼儶 醿炨儤醿犪儠醿斸儦醿愥儞 醿樶儸醿п償醿戓儭 醿欋儛醿犪儤醿斸儬醿愥儭 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿� 醿抚儛 醿愥儨醿愥儦醿樶儢醿樶儭 醿♂儰醿斸儬醿濁儴醿�, 醿愥儭醿斸儠醿� 醿涐儛醿椺儣醿曖儤醿�, 醿曖儤醿♂儛醿� 醿ａ儥醿曖償 醿愥儱醿曖儭 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿椺儛醿� 醿涐儯醿ㄡ儛醿濁儜醿樶儭 醿掅儛醿犪儥醿曖償醿ａ儦醿� 醿掅儛醿涐儩醿�醿撫儤醿氠償醿戓儛 醿抚儛 醿♂儯醿犪儭 醿掅儛醿愥儯醿涐儻醿濁儜醿斸儭醿濁儭 醿椺儛醿曖儤醿♂儤 醿�醿濁儞醿溼儛 醿抚儛 醿ａ儨醿愥儬醿斸儜醿�.

醿涐儭醿涐償醿溼償醿氠償醿戓儤 醿掅儛醿斸儶醿溼儩醿戓儤醿愥儨 Power BI 醿犪償醿炨儩醿犪儮 醿撫償醿曖償醿氠儩醿炨償醿犪儤醿� / 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿愥儨醿愥儦醿樶儮醿樶儥醿濁儭醿樶儭 鈥溼儧醿濁儝醿栣儛醿ａ儬醿濁儜醿愥儭鈥� - 醿ａ儨醿愥儬醿斸儜醿�, 醿愥儧醿濁儶醿愥儨醿斸儜醿� 醿抚儛 醿炨儬醿濁儶醿斸儭醿斸儜醿�, 醿犪儩醿涐儦醿斸儜醿樶儭 醿掅儛醿曖儦醿愥儶 醿涐儛醿� 醿ａ儸醿斸儠醿� 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿樶儣 醿樶儭醿⑨儩醿犪儤醿樶儭 醿涐儩醿п儩醿氠儤醿♂儣醿曖儤醿�.

醿欋儯醿犪儭醿�/醿炨儬醿濁儝醿犪儛醿涐儛 醿涐儩醿樶儶醿愥儠醿�: 

醿ㄡ償醿♂儛醿曖儛醿氠儤: Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿愥儨醿愥儦醿樶儢醿�

• 醿犪儛 醿愥儬醿樶儭 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿愥儨醿愥儦醿樶儢醿�
• Power BI-醿樶儭 醿涐儤醿涐儩醿�醿樶儦醿曖儛; 醿涐儤醿♂儤 醿炨儩醿⑨償醿溼儶醿樶儛醿氠儤
• Power BI-醿樶儭 醿欋儩醿涐優醿濁儨醿斸儨醿⑨償醿戓儤醿� 醿抚儛 醿樶儨醿⑨償醿犪儰醿斸儤醿♂儤醿� 醿掅儛醿�醿溼儩醿戓儛
• 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿樶儭 醿樶儧醿炨儩醿犪儮醿� Power Bi-醿ㄡ儤
• 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿椺儛醿� 醿欋儛醿曖儴醿樶儬醿樶儭 醿⑨儤醿炨償醿戓儤: Import vs DirectQuery

Power Query (醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿�醿樶償醿戓儤)

• Power Query-醿ㄡ儤 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿⑨儤醿炨儤醿� 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿�醿樶償醿戓儤 Custom Column / Conditional Column / Split Column
• 醿�醿�醿犪儤醿氠償醿戓儤醿� 醿斸儬醿椺儧醿愥儨醿斸儣醿栣償 醿抚儛醿涐儛醿⑨償醿戓儛 醿抚儛 醿ㄡ償醿犪儸醿п儧醿� (Merge Queries; Append Queries)
• 醿め儛醿樶儦醿斸儜醿樶儭 醿掅儛醿斸儬醿椺儤醿愥儨醿斸儜醿� (Combine Files)
• 醿炨儛醿犪儛醿涐償醿⑨儬醿斸儜醿� (Parameters) 醿抚儛 醿涐儛醿椺儤 醿掅儛醿涐儩醿п償醿溼償醿戓儛
• Data Preview - Column quality; Column distribution; Column profile

醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿涐儩醿撫償醿氠儤 (Semantic Model)

• Semantic Model; Dimension & Fact 醿�醿�醿犪儤醿氠償醿戓儤
• 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿涐儩醿撫償醿氠儤醿� 醿⑨儤醿炨償醿戓儤; Star vs Snowflake schema
• Relationships; Cardinality; Cross-filter direction
• 醿愥儱醿⑨儤醿ａ儬醿� 醿抚儛 醿愥儬醿愥儛醿メ儮醿樶儯醿犪儤 (Active&Inactive) 醿犪償醿氠儛醿�醿樶償醿戓儤
• Normalization; Denormalization; 
• Implicit vs Explicit Measures

Power BI-醿樶儭 醿曖儤醿栣儯醿愥儦醿斸儜醿�&苍产蝉辫;(Charts) 醿抚儛 醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤 (Elements)

•  醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿掅儛醿溼儺醿樶儦醿曖儛 醿抚儛 醿掅儛醿�醿溼儩醿戓儛
•  醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤醿� 醿掅儛醿溼儺醿樶儦醿曖儛 醿抚儛 醿掅儛醿�醿溼儩醿戓儛
•  醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿抚儛 醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤醿� 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛; 醿め儩醿犪儧醿愥儮醿樶儬醿斸儜醿�
•  醿炨儤醿犪儩醿戓儤醿椺儤 醿め儩醿犪儧醿愥儮醿樶儬醿斸儜醿� (Conditional formatting)
•  Custom visuals

醿め儤醿氠儮醿犪償醿戓儤醿� 醿⑨儤醿炨償醿戓儤 醿抚儛 醿濁優醿�醿樶償醿戓儤; 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿ａ儭醿愥儰醿犪儣醿�醿濁償醿戓儛 (RLS)

•  醿め儤醿氠儮醿犪償醿戓儤醿� 醿⑨儤醿炨償醿戓儤 醿抚儛 醿涐儛醿椺儤 醿濁優醿�醿樶償醿戓儤
•  RLS (row-level security) - 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛 醿抚儛 醿抚儛醿⑨償醿♂儮醿曖儛
•   醿樶償醿犪儛醿犪儱醿樶償醿戓儤醿� 醿ㄡ償醿メ儧醿溼儛
• Drill mode (Drill up; Drill down)
• 醿︶儤醿氠儛醿欋償醿戓儤 醿抚儛 醿溼儛醿曖儤醿掅儛醿�醿樶儛 (Buttons & Navigation)

DAX (Data Analysis Expressions)

• DAX 醿め儯醿溼儱醿�醿樶償醿戓儤 (Aggregation, Time intelligence, Information functions鈥�)
• DAX 醿濁優醿斸儬醿愥儮醿濁儬醿斸儜醿�
• DAX 醿�醿曖儦醿愥儞醿斸儜醿�
• Data Table-醿樶儭 醿ㄡ償醿メ儧醿溼儛
• 醿�醿�醿犪儤醿氠償醿戓儤醿� 醿ㄡ償醿メ儧醿溼儛 DAX-醿樶儭 醿掅儛醿涐儩醿п償醿溼償醿戓儤醿�

醿涐儩醿溼儛醿�醿斸儧醿斸儜醿樶儭 醿抚儛醿�醿掅儯醿め償醿戓儛; 醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿樶儨醿⑨償醿犪儛醿メ儶醿樶償醿戓儤

•   Data Groups
•   Data Bins
•   醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿樶儨醿⑨償醿犪儛醿メ儶醿樶償醿戓儤
•   Custom Tooltips
•   Bookmarks; Slicers synchronization

Power BI Service 醿炨儦醿愥儮醿め儩醿犪儧醿�

• 醿犪償醿炨儩醿犪儮醿斸儜醿樶儭 醿掅儛醿涐儩醿メ儠醿斸儳醿溼償醿戓儛 Power BI Service-醿ㄡ儤 醿抚儛 醿涐儛醿椺儤 醿掅儛醿栣儤醿愥儬醿斸儜醿�
• Workspace-醿斸儜醿樶儭 醿ㄡ償醿メ儧醿溼儛, 醿涐儛醿椺儤 醿濁優醿�醿樶償醿戓儤 醿抚儛 醿犪儩醿氠償醿戓儤 (Admin vs Member vs Contributor vs Viewer)
• 醿涐儩醿溼儛醿�醿斸儧醿斸儜醿樶儭 醿掅儛醿溼儛醿�醿氠償醿戓儤醿� 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛 (Data refresh)
• Power BI-醿樶儭 醿氠儤醿�醿斸儨醿栣儤醿斸儜醿樶儭 醿⑨儤醿炨償醿戓儤
• Copilot-醿樶儭 醿掅儛醿涐儩醿п償醿溼償醿戓儛 Power Bi-醿ㄡ儤
• Microsoft Fabric-醿樶儭 醿涐儤醿涐儩醿�醿樶儦醿曖儛

醿欋儯醿犪儭醿樶儭 醿掅儛醿曖儦醿樶儭 醿ㄡ償醿涐儞醿斸儝:

• 醿掅偿醿�醿濁兏�儤醿溼偿醿戓儛: 醿欋儯醿犪儭醿樶儭 醿掅儛醿曖儦醿樶儭 醿ㄡ償醿涐儞醿斸儝 醿涐儭醿涐償醿溼償醿氠償醿戓儭 醿斸儱醿溼償醿戓儛醿� Power BI-醿樶儭 醿♂儬醿ａ儦醿� 醿ㄡ償醿♂儛醿�醿氠償醿戓儦醿濁儜醿斸儜醿樶儭 醿♂儛醿戓儛醿栣儤醿♂儩 醿�醿濁儞醿溼儛 醿抚儛 醿ａ儨醿愥儬醿斸儜醿�, 醿犪儩醿� 醿涐儤醿♂儤 醿掅儛醿涐儩醿п償醿溼償醿戓儤醿� 醿抚儛醿涐儩醿ａ儥醿樶儞醿斸儜醿氠儛醿� 醿抚儛醿ａ儥醿愥儠醿ㄡ儤醿犪儞醿溼償醿� 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿�醿п儛醿犪儩醿斸儜醿�, 醿掅儛醿愥儥醿斸儣醿濁儨 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿⑨儤醿炨儤醿� 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿�醿樶償醿戓儤, 醿ㄡ償醿メ儧醿溼儛醿� 醿涐儩醿撫償醿氠償醿戓儤 醿抚儛 醿掅儛醿愥儥醿斸儣醿濁儨 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿曖儤醿栣儯醿愥儦醿樶儢醿愥儶醿樶儛 - 醿樶儨醿⑨償醿犪儛醿メ儶醿樶儯醿氠儤 醿犪償醿炨儩醿犪儮醿斸儜醿�. 醿愥儭醿斸儠醿�, 醿斸儱醿溼償醿戓儛醿� 醿п儠醿斸儦醿愥儨醿愥儤醿犪儤 醿�醿濁儞醿溼儛 醿椺儯 醿犪儩醿掅儩醿� 醿抚儛 醿犪儛 醿掅儢醿樶儣 醿掅儛醿樶儲醿犪儧醿愥儠醿濁儨 醿�醿濁儞醿溼儛 Power BI-醿ㄡ儤 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿� / 醿涐儩醿溼儛醿�醿斸儧醿椺儛 醿愥儨醿愥儦醿樶儢醿樶儭 醿涐儤醿涐儛醿犪儣醿ａ儦醿斸儜醿樶儣.
  
• 醿涐儤醿樶储醿斸儜:&苍产蝉辫;醿欋儯醿犪儭醿樶儭 醿戓儩醿氠儩 醿氠償醿メ儶醿樶儛醿栣償 醿┽儛醿⑨儛醿犪儞醿斸儜醿� 醿⑨償醿♂儮醿樶儬醿斸儜醿�, 醿犪儩醿涐儦醿樶儭 醿♂儛醿め儯醿�醿曖償醿氠儢醿斸儶 醿欋儯醿犪儭醿抚儛醿涐儣醿愥儠醿犪偿醿戓儯醿氠偿醿戓儤 醿涐儤醿樶儲醿斸儜醿斸儨 醿メ儛醿犪儣醿ａ儦-醿愥儧醿斸儬醿樶儥醿ａ儦醿� 醿ａ儨醿樶儠醿斸儬醿♂儤醿⑨償醿⑨儤醿� (亚色影库) 醿♂償醿犪儮醿樶儰醿樶儥醿愥儮醿�.
  
• 醿犪償醿掅儤醿♂儮醿犪儛醿�醿樶儤醿� 醿戓儧醿ａ儦醿�:  

醿欋儯醿犪儭醿栣償 醿♂儸醿愥儠醿氠儛 醿抚儛醿樶儸醿п償醿戓儛 29 醿♂偿醿メ儮醿斸儧醿戓偿醿犪儭!