| 所在主题： | |
| 文件名: Robert Bosco J-PowerPivot for Advanced Reporting and Dashboards-Packt Publishing.rar | |
| 资料下载链接地址: https://bbs.pinggu.org/a-1783942.html | |
本附件包括：
|
|
| 附件大小: | |
|
谨以本帖，献给我温柔善良，豪气大方的山东妹子，我的导师Asa（421073390，情感交友版主，很任性的那位）；
我的搭档小友，风流倜傥，英俊潇洒，即将步入社会的量化投资版主fantuanxiaot。 特别鸣谢免费大师，管理科学版主感谢kychan一直以来的无私奉献。 祝大家红五月，一切只有顺。 https://bbs.pinggu.org/thread-3694090-1-1.html Leverage the capabilities of the Microsoft Excel PowerPivot add-on to create advanced BI solutions Overview Learn how to create advanced BI solutions quickly and efficiently using easy-to-follow, step-by-step examples Understand the key principles of PowerPivot with the help of real-time examples Discover more about some interesting DAX functions with examples of how they work [hide][/hide] In Detail Business intelligence technology gives an organization the power to make decisions using large volumes of data. By obtaining an adequate amount of data and integrating data from a variety of sources, a user can get a comprehensive knowledge of their business and business strategies. PowerPivot is a free add-in to the 2010 version of the spreadsheet application MS Excel. It extends the capabilities of the PivotTable data summarization and cross-tabulation feature with new features such as expanded data capacity, advanced calculations, the ability to import data from multiple sources, and the ability to publish workbooks as interactive web applications. PowerPivot for Advanced Reporting and Dashboards will teach you the fundamentals of PowerPivot as well as how to use the different data types available. This book also discusses useful tips and tricks for handling and resolving errors that might pop up while creating your report. With this book, you will be able to create relevant BI reports quickly and efficiently. Moving on from the basics, this book will explain the types of data sources that can be imported into PowerPivot. You will then delve into relationships, hierarchies, and data model creation using imported data. You will also learn how to employ DAX functions to transform unstructured data into structured data. Finally, this book will teach you how to create reports such as Pivot Tables, Pivot Charts, Slicers, KPIs, and Perspective reports using PowerPivot and how to publish them using the SharePoint server. What you will learn from this book Install PowerPivot and discover how to use it Learn about the data memory constraints for the 32-bit and 64-bit versions Explore the list of data sources that can be imported into PowerPivot workbooks Understand the purpose of importing data Publish reports using the SharePoint server Learn about the data refresh method based on the data source Approach A step-by-step tutorial with focused examples that builds progressively from basic to advanced topics and helps you create business intelligence reports and dashboards quickly and efficiently using the PowerPivot add-in. Who this book is written for This book is ideal for data analysts, reporting and MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals, self-service business intelligence personnel, and students. It is assumed that you have basic data analysis skills and intermediate level Excel skills. Familiarity with Pivot Tables as well as basic knowledge of VBA scripting and SharePoint will be useful but not necessary. |
|
熟悉论坛请点击新手指南
|
|
| 下载说明 | |
|
1、论坛支持迅雷和网际快车等p2p多线程软件下载，请在上面选择下载通道单击右健下载即可。 2、论坛会定期自动批量更新下载地址,所以请不要浪费时间盗链论坛资源,盗链地址会很快失效。 3、本站为非盈利性质的学术交流网站,鼓励和保护原创作品，拒绝未经版权人许可的上传行为。本站如接到版权人发出的合格侵权通知，将积极的采取必要措施；同时，本站也将在技术手段和能力范围内，履行版权保护的注意义务。 (如有侵权，欢迎举报) |
|
京ICP备16021002号-2 京B2-20170662号
京公网安备 11010802022788号
论坛法律顾问：王进律师
知识产权保护声明
免责及隐私声明
