《Supercharge Power BI》读书笔记

       今年元旦，B站UP Ms_Excel 老师推荐了《DAX Supercharge Power BI... by Allington  Matt》并邀请了几位网友一起来读，能和Ms_Excel 老师共读一本书，也是一件快乐的事儿。今天是2023年元月5号了，就像很多立了FLAG然后感觉到累，感觉到不想继续了的小伙伴一样，我也确实觉得能够踏踏实实坐下来读书，确实不是一件容易的事。回想自去年2月14号以来复习PowerQuery的过程，跟现在的体会也很相似。既然已经坚持了一年，那就再走远一点吧。

     今天开始，把自己的读书笔记分享一下，一来可以梳理知识点，二来让自己坚持下去有个抓手。说是笔记，自己觉得更像是书中内容的概括，整体路线跟着书的目录一样，有些内容添加了自己的理解和补充，还有些我觉得是重点的内容没有翻译，是原文搬过来的。有的地方可能写的不正确，也请大家指正！

Part I 序(Introduction)

1、BI分为企业版和self-service BI，对个人用户来说，POWER BI DESKTOP是很好的数据智能处理软件。

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的四个主要模块

数据获取：Data acquisition

数据建模：Data modelling

视觉对象：Data visualisation

报告分发：Report distribution

4、为什么要学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.

很大程度上来讲，如果不学DAX语言只学习基础的Power BI和了解SSAS Tabular是如何工作的，那这个软件工具的价值就大大受限了。传统的EXCEL用户需要大量练习，本书也设计提供了大量练习，教你如何书写DAX。如果不能自如地书写DAX公式，那就不能很好的掌握Power BI 或EXCEL中的 Power Pivot.

5、渐进式学习 Incremental Learning

系统的学习了一门课程以后，新知识点可以随时学习，前提是基础已经比较好，渐进式学习是补充。

     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、主动学还是被动学 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、学习就像打高尔夫

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

书买来是用的，要善于写标注、写理解。

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.