學習的長禾

 

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(5,240)

因為這篇文章(Power BI 101)的一些基本介紹都是寫英文的, 所以有些網友有需求要中文的, 所以才有產生了這篇文章.
但其實中文的有很多文章都有寫介紹也蠻詳細的, 我不想贅述, 所以用心智圖整理一下Power BI新手地圖在下面讓大家參考.

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(89,010)

開始學習自媒體後, 開始找些網路上相關的學習資源, 剛好看到Likecoin很棒的理念, 所以也申請了Liker land, 並將其設定在痞客邦.發現文章慢慢有人按讚了，還蠻開心的。

也隨手將找的資料及我的liker land資料附上. 有需要的話, 歡迎互相交流喔!

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(3,925)

《好康報報》
身為東森購物的消費者，花你本來要花的錢，免費送你500東森幣可以折抵，先省錢，再送你PV回饋，可以領現金回饋喔！

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(155,650)

學習的長禾 發表在 痞客邦 留言(0) 人氣(4,128)

學習的長禾 發表在 痞客邦 留言(0) 人氣(28)

Power Query - 概觀與學習- Excel - Microsoft Support
Power Query M 公式語言參考- PowerQuery M | Microsoft Docs

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(180)

剛好有個網友要之前上課的資料，我順便也要做教材給國外同事，所以先簡單整理起來。但比較抱歉的是，因為要給國外看，主要內容大多是英文的，有人需要看中文的，歡迎留言跟我說嚕！
歡迎大家回饋起步有哪些資源可以運用，我再整合到這，這樣就可以幫助初學者了。
針對中文的初學者, 我找到微軟很棒的資源, 請參考開始建置 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.
Power BI service
•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
•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

​	​
​	​

Share Power BI report
(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
Power BI 官方教學文件
Dashboard in a Day - Power BI - Microsoft
Power BI 工程小組會每月更新所有 Dashboard in a Day 研討會的資產 (簡報者素材、示範用指令碼、學員逐步實作教室與資料集，外加如何順利進行活動的影片)，並 免費提供給所有 Microsoft 合作夥伴網路的合作夥伴。下載講師內容，包含簡報者素材、示範用指令碼，以及講師訓練素材。 需要將您的 Microsoft 帳戶綁定您的 Microsoft 合作夥伴網路識別碼，才可存取此內容。  英文 ， 其他語言

 

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(32,465)

Power BI role level security Power BI 的資料列層級安全性 (RLS): 可用以限制指定使用者的資料存取。 篩選會限制資料列層級的資料存取，您可以在角色中定義篩選。
Microsoft Docs中其實已經說明的蠻清楚了, 但說明中是中文介面, 我的介面是英文版, 就順便截下來讓跟我一樣是英文介面的人參考 

(繼續閱讀...)

文章標籤

學習的長禾 發表在 痞客邦 留言(0) 人氣(5,488)

學習的長禾 發表在 痞客邦 留言(0) 人氣(4,178)