楼主: jerker
14808 483

[讨论交流] [红包]红五月,感谢有你,PowerPivot for Advanced Reporting and Dashboards   [推广有奖]

学术权威

82%

还不是VIP/贵宾

-

TA的文库  其他...

数据科学(Data Science)

威望
6
论坛币
151465 个
通用积分
20802.6052
学术水平
3255 点
热心指数
3493 点
信用等级
3011 点
经验
5252 点
帖子
6106
精华
28
在线时间
3368 小时
注册时间
2009-11-19
最后登录
2019-6-26

初级学术勋章 中级热心勋章 初级热心勋章 初级信用勋章 中级学术勋章 高级学术勋章 特级学术勋章 高级热心勋章 特级热心勋章 中级信用勋章 高级信用勋章 特级信用勋章

jerker 发表于 2015-5-2 01:53:25 |显示全部楼层
本帖最后由 jerker 于 2015-5-3 15:08 编辑

谨以本帖,献给我温柔善良,豪气大方的山东妹子,我的导师Asa(421073390,情感交友版主,很任性的那位);
我的搭档小友,风流倜傥,英俊潇洒,即将步入社会的量化投资版主fantuanxiaot。
特别鸣谢免费大师,管理科学版主感谢kychan一直以来的无私奉献。
祝大家红五月,一切只有顺。
https://bbs.pinggu.org/thread-3694090-1-1.html

QQ截图20150502014040.png

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

本帖隐藏的内容

Robert Bosco J-PowerPivot for Advanced Reporting and Dashboards-Packt Publishing.rar (32.39 MB)


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.
QQ截图20150502014151.png

QQ截图20150502014213.png

QQ截图20150502014236.png

QQ截图20150502014319.png

QQ截图20150502014252.png

QQ截图20150502014244.png




已有 5 人评分经验 论坛币 学术水平 热心指数 信用等级 收起 理由
xddlovejiao1314 + 20 + 1 + 1 + 1 精彩帖子
kychan + 100 + 1 + 1 + 1 精彩帖子
fantuanxiaot + 50 + 50 精彩帖子
xujingtang + 60 + 1 奖励积极上传好的资料
inankai + 50 + 1 + 1 + 1 精彩帖子

总评分: 经验 + 280  论坛币 + 50  学术水平 + 3  热心指数 + 4  信用等级 + 3   查看全部评分

本帖被以下文库推荐

stata SPSS
auirzxp 学生认证  发表于 2015-5-2 02:19:51 |显示全部楼层
已有 1 人评分经验 论坛币 收起 理由
jerker + 5 + 5 夜猫子也要注意休息哦

总评分: 经验 + 5  论坛币 + 5   查看全部评分

回复

使用道具 举报

GGOD 发表于 2015-5-2 02:32:20 |显示全部楼层
已有 1 人评分经验 论坛币 收起 理由
jerker + 5 + 5 又是一位夜猫子,注意休息哦

总评分: 经验 + 5  论坛币 + 5   查看全部评分

回复

使用道具 举报

Elena3 发表于 2015-5-2 07:00:48 |显示全部楼层
PowerPivot for Advanced Reporting and Dashboards
已有 1 人评分论坛币 收起 理由
jerker + 5 精彩帖子

总评分: 论坛币 + 5   查看全部评分

回复

使用道具 举报

rrjj101022 发表于 2015-5-2 08:45:35 |显示全部楼层
谢谢分享~~~
已有 1 人评分论坛币 收起 理由
jerker + 5 精彩帖子

总评分: 论坛币 + 5   查看全部评分

回复

使用道具 举报

kzpan 发表于 2015-5-2 08:58:43 |显示全部楼层
已有 1 人评分论坛币 收起 理由
jerker + 5 精彩帖子

总评分: 论坛币 + 5   查看全部评分

回复

使用道具 举报

jerker 发表于 2015-5-2 09:30:59 |显示全部楼层
感谢各位一直以来对量化投资的支持。五一节快乐。
回复

使用道具 举报

fin-qq 发表于 2015-5-2 09:33:46 |显示全部楼层

回帖奖励 +5

jerker 发表于 2015-5-2 09:30
感谢各位一直以来对量化投资的支持。五一节快乐。
五一快乐! 你有没有去版主群发红包?
已有 1 人评分经验 论坛币 收起 理由
jerker + 12 + 12 精彩帖子

总评分: 经验 + 12  论坛币 + 12   查看全部评分

回复

使用道具 举报

wsuper007 发表于 2015-5-2 09:42:03 |显示全部楼层

回帖奖励 +5

What you will learn from this book
回复

使用道具 举报

SMACKDOWN 发表于 2015-5-2 09:44:58 |显示全部楼层

回帖奖励 +5

回复

使用道具 举报

您需要登录后才可以回帖 登录 | 我要注册

京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2019-6-26 22:53