剛好有個網友要之前上課的資料，我順便也要做教材給國外同事，所以先簡單整理起來。但比較抱歉的是，因為要給國外看，主要內容大多是英文的，有人需要看中文的，歡迎留言跟我說嚕！
歡迎大家回饋起步有哪些資源可以運用，我再整合到這，這樣就可以幫助初學者了。
針對中文的初學者, 我找到微軟很棒的資源, 請參考開始建置 Power BI
Power BI is a business analytics solution that lets you
−visualize your data
−share insights across your organization/ embed them in your app or website
−Connect to hundreds of data sources and bring your data to life with live dashboards and reports.
Power BI products - Power BI desktop
•Connect to hundreds of data sources on premises and in the cloud.
•Prepare and model your data with ease.
•Provide advanced analytics with the familiarity of Excel
•Create interactive reports customized for your business.
•Author for everyone, anywhere
Download and install Microsoft Power BI Desktop from the website or use Microsoft store to install it.
Microsoft store is a better solution due to the power BI software will be refreshed automatically once power BI desktop has new version released.
•Connect to hundreds of data sources, and visualize all your data with live dashboards and reports.
Then share insights across your organization to fuel intelligent action.
•Govern securely
•If you need to share the report with a group, need to ask Power BI Pro license from your company IT or buy the license via Microsoft.
•Access Power BI via office 365
−Need to use office365 account to login.
−If you are first time to use it, you need to register your account for Power BI.
•Power BI Premium gives you more consistent performance, support for large data
volumes, and the flexibility of a unified self-service and enterprise BI platform for
everyone in your organization.
− Need to apply it to setup the sharing workspace as Power BI Premium.
− Put the shared reports in Power BI Premium workspace and then distrube it via power BI app to share with others.
- After applying Power BI Premium workspace successfully, the diamond icon will be displayed for the workspace.
Data connection – Power BI data sources/ Connect to data in Power BI - documentation/ Create a report on a SharePoint List
•Get the data from Power BI datasets
−Datasets are under the workspace which belong to Power BI Premium.
| Get the data/ power BI dataset |  |
| In case link the data via Power BI datasets, only report/ model can be used in power BI desktop and "Transform data" cannot be used. |  |
Power BI data field/ format/ Analytics
•Field: which data would like to display in charts/ tables
•Format: chart/ table format setting
•Analytics: only available for some charts
Power BI data – Query overview
•Change data type
•Data disposition
Power BI visuals (Visualization – import from market)
•Visualization tables/ charts
 |
 |
 |
|
(need to publish to power BI workspace with Power BI Pro license)
•Publish the report to Pro Power BI at office 365 workspace.
−Only authorized workspace can be selected.
−Only publish to Power BI premium workspace can share to authorized people to read it.
•Click hyperlink to quickly access the report at Pro Power BI.
Share Power BI report – App
•Select which dashboard/ reports will be shared at App.
−Only Power BI premium workspace can use App to share.
Share Power BI report – authorized control for App
•Only authorized people can read the shared reports via App.
Schedule Power BI report auto refreshing time
•Use setting to set report auto refreshing time.
[News]
"Today we’re announcing that for the 14th consecutive year1 Microsoft has been positioned as a Leader in the 2021 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. For the third year, Microsoft is positioned furthest to the right for completeness of vision and furthest up in the ability to execute within the Leaders’ quadrant."
Source: Gartner (February 2020)
Top 10 reasons customers tell us why they chose Power BI
- Power BI Insights, Office 365 productivity—integrated into Excel and Microsoft Teams.
- Connect to data anywhere with hundreds of built-in connectors with Power Query.
- Quickly build systems of intelligence with Power BI + Microsoft Azure Synapse Analytics.
- Go from insight to action with Microsoft Power Platform.
- Only BI product with built in Data Loss Prevention through Microsoft Information Protection and Microsoft Cloud App security.
- Industry leading AI to help you find answers fast.
- Best in class mobile experiences with Power BI Mobile.
- Cloud maturity—rely on one of the largest and fastest growing BI clouds.
- Rapid, user driven innovation—new features released weekly based user feedback.
- Economics to drive a data culture with access for everyone.
Power BI的入門影片- It’s ALL About Relationship!!!
https://www.youtube.com/watch?v=qFYG2KKykCs
Dashboard in a Day - Power BI - Microsoft
Power BI 工程小組會每月更新所有 Dashboard in a Day 研討會的資產 (簡報者素材、示範用指令碼、學員逐步實作教室與資料集，外加如何順利進行活動的影片)，並 免費提供給所有 Microsoft 合作夥伴網路的合作夥伴。下載講師內容，包含簡報者素材、示範用指令碼，以及講師訓練素材。 需要將您的 Microsoft 帳戶綁定您的 Microsoft 合作夥伴網路識別碼，才可存取此內容。 英文 ， 其他語言
留言列表
好物分享 (1)
{{ article.title }}
