注册

sign in 才能 publish，才能用到 powerbi service。
绑了银行卡，电话，最后会得到一个email，
注意⚠️ ：登录的时候是用这个新生成的微软链接，

比如我是这个 email：

xx@xxx.onmicrosoft.com

对了，一定要先去 app.powerbi.com 这个网站上注册@
又注册一次，这个 email 才有效，
最后才能在 power desktop 上面登录成功

记得，取消订阅，否则一个月两百多人民币。

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

也可以反过来，拆开，聚合

image.png

pivot

Append 和 Merge 合并表格

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

merge 像 sql 里面的各种 join

append 行数多，列不变，merge，列就根据 left ，right，变多变少

Column Quality

只看前1000行，也可以更改设置

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