Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿�
醿欋儯醿犪儭醿樶儭/醿炨儬醿濁儝醿犪儛醿涐儤醿� 醿♂儛醿償醿氠儸醿濁儞醿斸儜醿�: Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿�
醿欋儯醿犪儭醿樶儭/醿炨儬醿濁儝醿犪儛醿涐儤醿� 醿儛醿溼儝醿犪儷醿氠儤醿曖儩醿戓儛:
- 醿欋儯醿犪儭醿� 醿ㄡ償醿撫儝醿斸儜醿� 8 醿欋儠醿樶儬醿樶儭醿掅儛醿�. (醿♂儯醿�: 16 醿氠償醿メ儶醿樶儛, 32 醿♂儛醿愥儣醿�).
- 醿氠償醿メ儶醿樶償醿戓儤 醿┽儛醿⑨儛醿犪儞醿斸儜醿� 醿欋儠醿樶儬醿愥儴醿� 2-醿償醿� (醿濁儬醿ㄡ儛醿戓儛醿椺儭 醿抚儛 醿儯醿椺儴醿愥儜醿愥儣醿� 19:30 醿♂儣).
- 醿氠償醿メ儶醿樶儤醿� 醿儛醿溼儝醿犪儷醿氠儤醿曖儩醿戓儛醿� 2 醿♂儛醿愥儣醿�.
醿♂儛醿涐儤醿栣儨醿� 醿愥儯醿撫儤醿⑨儩醿犪儤醿�: 醿欋儯醿犪儭醿� 醿掅儛醿溼儥醿ａ儣醿曖儨醿樶儦醿樶儛 醿涐儩醿溼儛醿償醿涐償醿戓儤醿� 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿�, 醿愥儨醿愥儦醿樶儢醿樶儣 醿抚儛 醿栣儩醿掅儛醿抚儛醿� 醿涐儩醿溼儛醿償醿涐償醿戓儣醿愥儨 醿涐儯醿ㄡ儛醿濁儜醿樶儣 醿抚儛醿樶儨醿⑨償醿犪償醿♂償醿戓儯醿氠儤 醿溼償醿戓儤醿♂儧醿樶償醿犪儤 醿愥兏愥儧醿樶儛醿溼儤醿♂儣醿曖儤醿�.
醿欋儯醿犪儭醿� 醿♂儛醿♂儛醿犪儝醿斸儜醿氠儩 醿抚儛 醿♂儛醿樶儨醿⑨償醿犪償醿♂儩 醿樶儱醿溼償醿戓儛 醿犪儩醿掅儩醿犪儶 醿涐儛醿椺儣醿曖儤醿�, 醿曖儤醿溼儶 醿炨儤醿犪儠醿斸儦醿愥儞 醿樶儸醿п償醿戓儭 醿欋儛醿犪儤醿斸儬醿愥儭 醿涐儩醿溼儛醿償醿涐儣醿� 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿� 醿抚儛 醿愥儨醿愥儦醿樶儢醿樶儭 醿♂儰醿斸儬醿濁儴醿�, 醿愥儭醿斸儠醿� 醿涐儛醿椺儣醿曖儤醿�, 醿曖儤醿♂儛醿� 醿ａ儥醿曖償 醿愥儱醿曖儭 醿涐儩醿溼儛醿償醿涐償醿戓儣醿愥儨 醿涐儯醿ㄡ儛醿濁儜醿樶儭 醿掅儛醿犪儥醿曖償醿ａ儦醿� 醿掅儛醿涐儩醿儞醿樶儦醿斸儜醿� 醿抚儛 醿♂儯醿犪儭 醿掅儛醿愥儯醿涐儻醿濁儜醿斸儭醿濁儭 醿椺儛醿曖儤醿♂儤 醿儩醿撫儨醿� 醿抚儛 醿ａ儨醿愥儬醿斸儜醿�.
醿涐儭醿涐償醿溼償醿氠償醿戓儤 醿掅儛醿斸儶醿溼儩醿戓儤醿愥儨 Power BI 醿犪償醿炨儩醿犪儮 醿撫償醿曖償醿氠儩醿炨償醿犪儤醿� / 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儮醿樶儥醿濁儭醿樶儭 鈥溼儧醿濁儝醿栣儛醿ａ儬醿濁儜醿愥儭鈥� - 醿ａ儨醿愥儬醿斸儜醿�, 醿愥儧醿濁儶醿愥儨醿斸儜醿� 醿抚儛 醿炨儬醿濁儶醿斸儭醿斸儜醿�, 醿犪儩醿涐儦醿斸儜醿樶儭 醿掅儛醿曖儦醿愥儶 醿涐儛醿� 醿ａ儸醿斸儠醿� 醿涐儩醿溼儛醿償醿涐償醿戓儤醿� 醿樶儭醿⑨儩醿犪儤醿樶儭 醿涐儩醿п儩醿氠儤醿♂儣醿曖儤醿�.
醿欋儯醿犪儭醿�/醿炨儬醿濁儝醿犪儛醿涐儛 醿涐儩醿樶儶醿愥儠醿�:
醿ㄡ償醿♂儛醿曖儛醿氠儤: Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿�
- 醿犪儛 醿愥儬醿樶儭 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿�
- Power BI-醿樶儭 醿涐儤醿涐儩醿儤醿氠儠醿�; 醿涐儤醿♂儤 醿炨儩醿⑨償醿溼儶醿樶儛醿氠儤
- Power BI-醿樶儭 醿欋儩醿涐優醿濁儨醿斸儨醿⑨償醿戓儤醿� 醿抚儛 醿樶儨醿⑨償醿犪儰醿斸儤醿♂儤醿� 醿掅儛醿儨醿濁儜醿�
- 醿涐儩醿溼儛醿償醿涐償醿戓儣醿愥儨 醿欋儛醿曖儴醿樶儬醿樶儭 醿⑨儤醿炨償醿戓儤: Import vs DirectQuery
Power Query (醿涐儩醿溼儛醿償醿涐儣醿� 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿儤醿斸儜醿�)
- 醿涐儩醿溼儛醿償醿涐償醿戓儤醿� 醿樶儧醿炨儩醿犪儮醿� Power BI-醿ㄡ儤
- Power Query-醿ㄡ儤 醿涐儩醿溼儛醿償醿涐儣醿� 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿⑨儤醿炨儤醿� 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿儤醿斸儜醿� Custom Column / Conditional Column / Split Column
- 醿儺醿犪儤醿氠償醿戓儤醿� 醿斸儬醿椺儧醿愥儨醿斸儣醿栣償 醿抚儛醿涐儛醿⑨償醿戓儛 醿抚儛 醿ㄡ償醿犪儸醿п儧醿� (Merge Queries; Append Queries)
- Data Preview - Column quality; Column distribution; Column profile
醿涐儩醿溼儛醿償醿涐儣醿� 醿涐儩醿撫償醿氠儤 (Data Model)
- Dimension & Fact 醿儺醿犪儤醿氠償醿戓儤
- 醿涐儩醿溼儛醿償醿涐儣醿� 醿涐儩醿撫償醿氠儤醿� 醿⑨儤醿炨償醿戓儤; Star vs Snowflake schema
- Normalization; Denormalization; Junk dimensions
- Implicit vs Explicit Measures
Power BI-醿樶儭 醿曖儤醿栣儯醿愥儦醿斸儜醿�&苍产蝉辫;(Charts) 醿抚儛 醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤 (Elements)
- 醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿掅儛醿溼儺醿樶儦醿曖儛 醿抚儛 醿掅儛醿儨醿濁儜醿�
- 醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤醿� 醿掅儛醿溼儺醿樶儦醿曖儛 醿抚儛 醿掅儛醿儨醿濁儜醿�
- 醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿抚儛 醿斸儦醿斸儧醿斸儨醿⑨償醿戓儤醿� 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛; 醿め儩醿犪儧醿愥儮醿樶儬醿斸儜醿�
- 醿炨儤醿犪儩醿戓儤醿椺儤 醿め儩醿犪儧醿愥儮醿樶儬醿斸儜醿� (Conditional formatting)
- Custom visuals
醿め儤醿氠儮醿犪償醿戓儤醿� 醿⑨儤醿炨償醿戓儤 醿抚儛 醿濁優醿儤醿斸儜醿�; 醿樶償醿犪儛醿犪儱醿樶償醿戓儤
- 醿め儤醿氠儮醿犪償醿戓儤醿� 醿⑨儤醿炨償醿戓儤 醿抚儛 醿涐儛醿椺儤 醿濁優醿儤醿斸儜醿�
- RLS (row-level security) - 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛 醿抚儛 醿抚儛醿⑨償醿♂儮醿曖儛
- Drill mode (Drill up; Drill down)
- 醿樶償醿犪儛醿犪儱醿樶償醿戓儤醿� 醿ㄡ償醿メ儧醿溼儛
DAX (Data Analysis Expressions)
- DAX 醿め儯醿溼儱醿儤醿斸儜醿� (Aggregation, Time intelligence, Information functions鈥�)
- DAX 醿濁優醿斸儬醿愥儮醿濁儬醿斸儜醿�
- DAX 醿儠醿氠儛醿撫償醿戓儤
- 醿儺醿犪儤醿氠償醿戓儤醿� 醿ㄡ償醿メ儧醿溼儛 DAX-醿樶儭 醿掅儛醿涐儩醿п償醿溼償醿戓儤醿�
醿涐儩醿溼儛醿償醿涐償醿戓儤醿� 醿抚儛醿儝醿ａ儰醿斸儜醿�; 醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿樶儨醿⑨償醿犪儛醿メ儶醿樶償醿戓儤
- Data Groups
- Data Bins
- 醿曖儤醿栣儯醿愥儦醿斸儜醿樶儭 醿樶儨醿⑨償醿犪儛醿メ儶醿樶償醿戓儤
- Bookmarks; Slicers synchronization
Power BI Service 醿炨儦醿愥儮醿め儩醿犪儧醿�
- 醿犪償醿炨儩醿犪儮醿斸儜醿樶儭 醿掅儛醿涐儩醿メ儠醿斸儳醿溼償醿戓儛 Power BI Service-醿ㄡ儤 醿抚儛 醿涐儛醿椺儤 醿掅儛醿栣儤醿愥儬醿斸儜醿�
- Workspace-醿斸儜醿樶儭 醿ㄡ償醿メ儧醿溼儛, 醿涐儛醿椺儤 醿濁優醿儤醿斸儜醿� 醿抚儛 醿犪儩醿氠償醿戓儤 (Admin vs Member vs Contributor vs Viewer)
- 醿涐儩醿溼儛醿償醿涐償醿戓儤醿� 醿掅儛醿溼儛醿儦醿斸儜醿樶儭 醿欋儩醿溼儰醿樶儝醿ａ儬醿愥儶醿樶儛 (Data refresh)
- Power BI-醿樶儭 醿氠儤醿償醿溼儢醿樶償醿戓儤醿� 醿⑨儤醿炨償醿戓儤
- Microsoft Fabric; External tools - 醿栣儩醿掅儛醿撫儤 醿涐儤醿涐儩醿儤醿氠儠醿�
醿欋儯醿犪儭醿樶儭 醿掅儛醿曖儦醿樶儭 醿ㄡ償醿涐儞醿斸儝:
- 醿掅偿醿儩醿抚儤醿溼偿醿戓儛: 醿欋儯醿犪儭醿樶儭 醿掅儛醿曖儦醿樶儭 醿ㄡ償醿涐儞醿斸儝 醿涐儭醿涐償醿溼償醿氠償醿戓儭 醿斸儱醿溼償醿戓儛醿� Power BI-醿樶儭 醿♂儬醿ａ儦醿� 醿ㄡ償醿♂儛醿儦醿斸儜醿氠儩醿戓償醿戓儤醿� 醿♂儛醿戓儛醿栣儤醿♂儩 醿儩醿撫儨醿� 醿抚儛 醿ａ儨醿愥儬醿斸儜醿�, 醿犪儩醿� 醿涐儤醿♂儤 醿掅儛醿涐儩醿п償醿溼償醿戓儤醿� 醿抚儛醿涐儩醿ａ儥醿樶儞醿斸儜醿氠儛醿� 醿抚儛醿ａ儥醿愥儠醿ㄡ儤醿犪儞醿溼償醿� 醿涐儩醿溼儛醿償醿涐儣醿� 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿儳醿愥儬醿濁償醿戓儭, 醿掅儛醿愥儥醿斸儣醿濁儨 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿⑨儤醿炨儤醿� 醿⑨儬醿愥儨醿♂儰醿濁儬醿涐儛醿儤醿斸儜醿�, 醿ㄡ償醿メ儧醿溼儛醿� 醿涐儩醿撫償醿氠償醿戓儤 醿抚儛 醿掅儛醿愥儥醿斸儣醿濁儨 醿涐儩醿溼儛醿償醿涐儣醿� 醿曖儤醿栣儯醿愥儦醿樶儢醿愥儶醿樶儛 - 醿樶儨醿⑨償醿犪儛醿メ儶醿樶儯醿氠儤 醿犪償醿炨儩醿犪儮醿斸儜醿�. 醿愥儭醿斸儠醿�, 醿斸儱醿溼償醿戓儛醿� 醿п儠醿斸儦醿愥儨醿愥儤醿犪儤 醿儩醿撫儨醿� 醿椺儯 醿犪儩醿掅儩醿� 醿抚儛 醿犪儛 醿掅儢醿樶儣 醿掅儛醿樶儲醿犪儧醿愥儠醿濁儨 醿儩醿撫儨醿� Power BI-醿ㄡ儤 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤醿� / 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿樶儭 醿涐儤醿涐儛醿犪儣醿ａ儦醿斸儜醿樶儣.
- 醿涐儤醿樶储醿斸儜:&苍产蝉辫;醿欋儯醿犪儭醿樶儭 醿戓儩醿氠儩 醿氠償醿メ儶醿樶儛醿栣償 醿┽儛醿⑨儛醿犪儞醿斸儜醿� 醿⑨償醿♂儮醿樶儬醿斸儜醿�, 醿犪儩醿涐儦醿樶儭 醿♂儛醿め儯醿儠醿斸儦醿栣償醿� 醿欋儯醿犪儭醿抚儛醿涐儣醿愥儠醿犪偿醿戓儯醿氠偿醿戓儤 醿涐儤醿樶儲醿斸儜醿斸儨 醿メ儛醿犪儣醿ａ儦-醿愥儧醿斸儬醿樶儥醿ａ儦醿� 醿ａ儨醿樶儠醿斸儬醿♂儤醿⑨償醿⑨儤醿� (亚色影库) 醿♂償醿犪儮醿樶儰醿樶儥醿愥儮醿�.
- 醿犪償醿掅儤醿♂儮醿犪儛醿儤醿樶儭 醿戓儧醿ａ儦醿�:
醿欋儯醿犪儭醿栣償 醿♂儸醿愥儠醿氠儛 醿抚儛醿樶儸醿п償醿戓儛 4 醿溼儩醿斸儧醿戓償醿犪儭!
醿犪偿醿欋儩醿涐偿醿溼兏愥儶醿樶偿醿戓儤
醿♂儸醿愥儠醿氠儤醿� 醿♂儛醿め儛醿♂儯醿犪儤
"Microsoft Power BI - 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 醿抚儛 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿�" - 醿♂儛醿♂償醿犪儮醿樶儰醿樶儥醿愥儮醿� 醿欋儯醿犪儭醿樶儭 醿︶儤醿犪償醿戓儯醿氠償醿戓儛醿� 750 醿氠儛醿犪儤. 醿斸儬醿椺儤 醿濁儬醿掅儛醿溼儤醿栣儛醿儤醿樶兏愥儨 醿濁儬醿� 醿愥儨 醿涐償醿⑨儤 醿愥優醿氠儤醿欋儛醿溼儮醿樶儭 醿ㄡ償醿涐儣醿儠醿斸儠醿愥儴醿� 醿涐儩醿メ儧醿斸儞醿斸儜醿� 10%-醿樶儛醿溼儤 醿め儛醿♂兏愥儥醿氠偿醿戓儛.
20%-醿樶儛醿溼儤 醿め儛醿♂兏愥儥醿氠償醿戓儛 醿斸儥醿ａ儣醿曖儨醿樶儭:
- 亚色影库-醿� 醿愥儱醿⑨儤醿ａ儬 醿♂儮醿ａ儞醿斸儨醿⑨儭!
- 亚色影库-醿� 醿欋儯醿犪儭醿抚儛醿涐儣醿愥儠醿犪償醿戓儯醿氠儭!
- 醿溼償醿戓儤醿♂儧醿樶償醿� 醿愥兏愥儧醿樶儛醿溼儭, 醿曖儤醿♂儛醿� 亚色影库-醿� 醿斸儬醿椺儤 醿♂儛醿♂償醿犪儮醿樶儰醿樶儥醿愥儮醿� 醿欋儯醿犪儭醿� 醿ａ儥醿曖償 醿掅儛醿曖儦醿樶儦醿� 醿愥儱醿曖儭.
醿♂儛醿欋儩醿溼儮醿愥儱醿⑨儩 醿樶儨醿め儩醿犪儧醿愥儶醿樶儛
醿椺儛醿涐儣醿� 醿溼儤醿ㄡ儨醿樶儛醿溼儤醿償
醿ａ儸醿п儠醿斸儮醿� 醿掅儛醿溼儛醿椺儦醿斸儜醿樶儭醿� 醿抚儛 醿♂償醿犪儮醿樶儰醿樶儶醿樶儬醿斸儜醿樶儭 醿償醿溼儮醿犪儤醿� 醿償醿氠儧醿儲醿曖儛醿溼償醿氠儤
(+995) 591 112 200
(+995 32) 220 65 20 (313)
tamtanishnianidze@gau.edu.ge
醿掅儢醿愥儠醿溼儤醿氠偿醿戓儤
醿掅儛醿氠偿醿犪偿醿�
醿⑨儬醿斸儨醿斸儬醿斸儜醿�
醿曖儛醿♂儤醿� 醿♂儤醿涐儩醿溼儤醿ㄡ儠醿樶儦醿�
醿曖儛醿♂儤醿� 醿♂儤醿涐儩醿溼儤醿ㄡ儠醿樶儦醿� 醿愥儬醿樶儭 醿涐儛醿樶儥醿犪儩醿♂儩醿め儮醿樶儭 醿涐儤醿斸儬 醿♂償醿犪儮醿樶儰醿樶儶醿樶儬醿斸儜醿ａ儦醿� , 醿愥儭醿斸儠醿� 醿涐儛醿樶儥醿犪儩醿♂儩醿め儮醿樶儭 醿涐儤醿斸儬 醿♂償醿犪儮醿樶儰醿樶儶醿樶儬醿斸儜醿ａ儦醿� 醿抚儛 . 醿涐儛醿� 醿愥儱醿曖儭 15 醿償醿氠儢醿� 醿涐償醿⑨儤 醿涐儯醿ㄡ儛醿濁儜醿樶儭 醿掅儛醿涐儩醿儞醿樶儦醿斸儜醿� 醿樶儨醿め儩醿犪儧醿愥儶醿樶儯醿氠儤 醿⑨償醿メ儨醿濁儦醿濁儝醿樶償醿戓儤醿� 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿♂儰醿斸儬醿濁償醿戓儴醿�, 醿犪儩醿掅儩醿犪儶 醿欋償醿犪儷醿�, 醿愥儭醿斸儠醿� 醿♂儛醿償醿氠儧醿儤醿め儩 醿♂償醿メ儮醿濁儬醿斸儜醿ㄡ儤 (IT 醿樶儨醿め儬醿愥儭醿⑨儬醿ａ儱醿⑨儯醿犪儤醿� 醿♂儺醿曖儛醿抚儛醿♂儺醿曖儛 醿愥儭醿炨償醿メ儮醿斸儜醿樶儭 醿涐儛醿犪儣醿曖儛 | 醿涐儩醿溼儛醿償醿涐儣醿� 醿愥儨醿愥儦醿樶儢醿� 醿抚儛 醿犪償醿炨儩醿犪儮醿樶儨醿掅儤 | 醿犪償醿氠儛醿儤醿ａ儬醿� 醿涐儩醿溼儛醿償醿涐儣醿� 醿戓儛醿栣償醿戓儤 (SQL Server) | 醿炨儬醿濁儝醿犪儛醿涐儤醿犪償醿戓儛 (Visual Basic .NET) | Microsoft Office 365-醿� & G Suite-醿� 醿愥儞醿涐儤醿溼儤醿♂儮醿犪儤醿犪償醿戓儛鈥� )
醿樶儝醿� 2021 醿儦醿樶兏愥儨 醿涐儯醿ㄡ儛醿濁儜醿� 醿め儬醿愥儨醿掅儯醿� 醿欋儩醿涐優醿愥儨醿樶儛醿ㄡ儤 醿ａ儶醿儩醿ａ儬 醿炨儬醿濁償醿メ儮醿斸儜醿栣償, BI 醿欋儩醿溼儭醿ａ儦醿⑨儛醿溼儮醿樶儭 醿炨儩醿栣儤醿儤醿愥儢醿�.
