注冊(cè)

sign in 才能 publish，才能用到 powerbi service。
綁了銀行卡，電話，最后會(huì)得到一個(gè)email，
注意?? ：登錄的時(shí)候是用這個(gè)新生成的微軟鏈接，

比如我是這個(gè) email：

xx@xxx.onmicrosoft.com

對(duì)了，一定要先去 app.powerbi.com 這個(gè)網(wǎng)站上注冊(cè)@
又注冊(cè)一次，這個(gè) email 才有效，
最后才能在 power desktop 上面登錄成功

記得，取消訂閱，否則一個(gè)月兩百多人民幣。

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your data into interactive insights.

That action could involve reallocating resources within the business to accommodate a need

You need to be able to look at the data and facilitate trusted business decisions

the concept of data analysis and its importance to business should not be understated

Descriptive：Descriptive analytics help answer questions about what has happened based on historical data
Diagnostic：why events happened；to discover the cause of these events
Predictive：what will happen in the future；use historical data to identify trends and determine if they're likely to recur
Prescriptive：which actions should be taken to achieve a goal or target；Prescriptive analytics techniques rely on machine learning as one of the strategies to find patterns in large datasets. By analyzing past decisions and events, organizations can estimate the likelihood of different outcomes
Cognitive：attempt to draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferences,

facet
distill
intricate
prevalent
narrative

The process of preparing data and modeling data is an iterative process

data analysts can build powerful reports, without writing any code, that enable users to get insights and answers and find actionable objectives

crunchingFor others, the value of Power BI will be in using real-time Azure SQL Data Warehouse tables that combine with other databases and real-time sources to build a moment-by-moment dataset.

https://powerbi.microsoft.com/en-au/

header 不正常

https://learn.microsoft.com/en-us/training/modules/clean-data-power-bi/2-shape-data

image.png

Unpivot Columns Power BI

image.png

https://www.youtube.com/watch?v=GINbx-gOwNE&t=58s

image.png

image.png

也可以反過(guò)來(lái)，拆開(kāi)，聚合

image.png

pivot

Append 和 Merge 合并表格

https://learn.microsoft.com/en-us/training/modules/clean-data-power-bi/5-combine-tables

merge 像 sql 里面的各種 join

append 行數(shù)多，列不變，merge，列就根據(jù) left ，right，變多變少

Column Quality

只看前1000行，也可以更改設(shè)置

https://learn.microsoft.com/en-us/training/modules/clean-data-power-bi/6-profile-data

M code

For instance, if you need to 【change the name of a database】, you could do it right in the code and then select Done.

Star schemas

image.png