? ? ? ?今年元旦，B站UP Ms_Excel 老師推薦了《DAX Supercharge Power BI... by Allington? Matt》并邀請(qǐng)了幾位網(wǎng)友一起來讀，能和Ms_Excel 老師共讀一本書，也是一件快樂的事兒。今天是2023年元月5號(hào)了，就像很多立了FLAG然后感覺到累，感覺到不想繼續(xù)了的小伙伴一樣，我也確實(shí)覺得能夠踏踏實(shí)實(shí)坐下來讀書，確實(shí)不是一件容易的事?；叵胱匀ツ?月14號(hào)以來復(fù)習(xí)PowerQuery的過程，跟現(xiàn)在的體會(huì)也很相似。既然已經(jīng)堅(jiān)持了一年，那就再走遠(yuǎn)一點(diǎn)吧。

? ? ?今天開始，把自己的讀書筆記分享一下，一來可以梳理知識(shí)點(diǎn)，二來讓自己堅(jiān)持下去有個(gè)抓手。說是筆記，自己覺得更像是書中內(nèi)容的概括，整體路線跟著書的目錄一樣，有些內(nèi)容添加了自己的理解和補(bǔ)充，還有些我覺得是重點(diǎn)的內(nèi)容沒有翻譯，是原文搬過來的。有的地方可能寫的不正確，也請(qǐng)大家指正！

Part I 序(Introduction)

1、BI分為企業(yè)版和self-service BI，對(duì)個(gè)人用戶來說，POWER BI DESKTOP是很好的數(shù)據(jù)智能處理軟件。

2、Perhaps one of the most important things to note about Power BI is that it is designed with business analysts and Excel users in mind.?

3、POWER BI DESKTOP的四個(gè)主要模塊

數(shù)據(jù)獲?。篋ata acquisition

數(shù)據(jù)建模：Data modelling

視覺對(duì)象：Data visualisation

報(bào)告分發(fā)：Report distribution

4、為什么要學(xué)DAX

? ? ?In much the same way, if you learn Power BI basics but don't learn the DAX language and how SSAS Tabular works, you will be limited to simplistic capabilities that restrict the value you can get from the tool.you definitely need some structured learning if you want to be good at using this tool. I have learnt that Excel users need practice, practice, practice. This book is designed to give you practice and to teach you how to write DAX. If you can’t write DAX, you will never be good at Power BI or Power Pivot for Excel.

很大程度上來講，如果不學(xué)DAX語言只學(xué)習(xí)基礎(chǔ)的Power BI和了解SSAS Tabular是如何工作的，那這個(gè)軟件工具的價(jià)值就大大受限了。傳統(tǒng)的EXCEL用戶需要大量練習(xí)，本書也設(shè)計(jì)提供了大量練習(xí)，教你如何書寫DAX。如果不能自如地書寫DAX公式，那就不能很好的掌握Power BI 或EXCEL中的?Power Pivot.

5、漸進(jìn)式學(xué)習(xí) Incremental Learning

系統(tǒng)的學(xué)習(xí)了一門課程以后，新知識(shí)點(diǎn)可以隨時(shí)學(xué)習(xí)，前提是基礎(chǔ)已經(jīng)比較好，漸進(jìn)式學(xué)習(xí)是補(bǔ)充。

? ? ?I'm not the kind of guy who can sit down and read a novel, but I love to buy Excel reference books and read them cover to cover. And I have learnt a lot about Excel over the years by using this approach. When I find some new concept that I love and want to try, most of the time I just remember it.

? ? ?Even if you don`t remember the details, the next time you face a similar problem, you’ll remember that you read something about it once, and you’ll be able to go find your book to look it up.

? ? ?About DAX,at that point, you will be able to incrementally learn all you want, but until then, you need to read, learn, and, most importantly, practice, practice, practice.

6、主動(dòng)學(xué)還是被動(dòng)學(xué) Passive vs. Active Learning

What I really needed to do was change from a passive learning approach to an active approach, where I was participating in the learning process rather than being a spectator.

7、學(xué)習(xí)就像打高爾夫

You can read all the Power BI books you like, but you will not be any good at DAX or data modelling until you actually do it yourself.

8、如何收效好

Practice, practice,practice until you have the knowledge committed to memory and you can do it without looking.

9、做好筆記和注釋 Don’t Treat This Like a Library Book

書買來是用的，要善于寫標(biāo)注、寫理解。

In fact, I would go so far as to say you should write in the reference books you own. You bought them for a reason: to learn. If you are reading this book and want to make some notes to yourself for future reference, then you should definitely do that.