책 이미지
책 정보
· 분류 : 외국도서 > 컴퓨터 > 데스크탑 애플리케이션 > 스프레드시트
· ISBN : 9781119210641
· 쪽수 : 288쪽
· 출판일 : 2016-04-04
목차
Introduction 1
Part I: Supercharged Reporting with Power Pivot 7
Chapter 1: Thinking Like a Database 9
Chapter 2: Introducing Power Pivot 19
Chapter 3: The Pivotal Pivot Table 33
Chapter 4: Using External Data with Power Pivot 67
Chapter 5: Working Directly with the Internal Data Model 93
Chapter 6: Adding Formulas to Power Pivot 107
Chapter 7: Publishing Power Pivot to SharePoint 125
Part II: Wrangling Data with Power Query 135
Chapter 8: Introducing Power Query 137
Chapter 9: Power Query Connection Types 155
Chapter 10: Transforming Your Way to Better Data 171
Chapter 11: Making Queries Work Together 201
Chapter 12: Extending Power Query with Custom Functions 215
Part III: The Part of Tens 233
Chapter 13: Ten Ways to Improve Power Pivot Performance 235
Chapter 14: Ten Tips for Working with Power Query 243
Index 255
