{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}
free FREE

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

{{email ? __('Got it!') : __('Restock Alert')}}

We will notify you by email when the item back in stock.

Cancel
Yami

Jingdong book

微软Excel 2013:用PowerPivot 建立数据模型

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

微软Excel 2013:用PowerPivot 建立数据模型

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}
Ends in
{{ itemCurrency }}{{ item.valid_price }}
{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}
{{ itemDiscount }}
{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}
{{ itemCurrency }}{{ item.valid_price }}
Sale ends in
Sale will starts after Sale ends in
{{ getSeckillDesc(item.seckill_data) }}
{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details
Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.
Sold Out

Details

Full product details
Editer Recommend

扩展Excel的威力,用敏捷、有效的新方法来实现商务智能,开展数据分析,成为Excel高级用户。

Content Description

Microsoft Excel是进行数据分析的世界标准,其易用性和强大功能使得Excel电子表格成为人人使用的工具,无论分析何种信息。
《微软Excel 2013:用PowerPivot 建立数据模型》面向Excel用户、项目经理和决策者,本书能满足他们学习PowerPivot for Excel 2013基础知识、掌握用于PowerPivot的新的DAX语言以及学习PowerPivot高级数据建模和编程技术的愿望。
《微软Excel 2013:用PowerPivot 建立数据模型》,不是一步一步指导PowerPivot for Excel 2013的书。如果你正在寻找PowerPivot傻瓜书,那么只能说这不是你的菜。但是如果你需要一本书伴随你在这漫长而令人愉悦的旅行中,从第1个简单的Excel工作簿开始,不久将很快创建复杂的模拟,那么这本书就是你的资源。
在写《微软Excel 2013:用PowerPivot 建立数据模型》时,我们决定把重点放在概念和实例上,从零开始带你掌握DAX语言。
《微软Excel 2013:用PowerPivot 建立数据模型》不涵盖每个功能,也不用“单击A,然后B”的方式解释每个操作。相反,本书承载了大量信息,这样一旦学完本书,你在Excel新的建模选项中将有足够的背景知识。
用最后一句话来强调这本书的主要特点: 它是用来学习的书,而不只是阅读。做好长途旅行的准备——但我们向你保证这将是非常值得的。
Author Description

阿尔贝托·法拉利(Alberto Ferrari),微软SQL Server分析服务(SSAS)大师,是专注于建立微软商务智能解决方案的顾问和培训师。他是《微软Excel 2010 PowerPivot》的合著者。
Catalogue

第1章 PowerPivot简介
1.1 在Excel表中使用数据透视表
1.2 在Microsoft Office 2013环境中使用PowerPivot
1.2.1 将信息添加到Excel表格当中
1.2.2 创建一个包含多个表格的数据模型
1.2.3 了解关系
1.3 了解数据模型
1.3.1 查询数据模型
1.4 PowerPivot加载项
1.5 使用OLAP工具并转换为公式
1.6 理解PowerPirot for Excel 2013
1.7 创建一个Power VJew报告
第2章 使用PowerPivot的独特功能
2.1 加载外部数据源
2.1.1 创建PowerPivot数据透视表
...
12.2 随时间推移的聚合和比较
12.2.1 年初至今(YTD)、季度初至今(QTD)和月初至今(MTD)
12.2.2 带有CALCULATE的时间智能函数
12.2.3 计算上一年的期间(PY)
12.2.4 计算移动年度合计
12.2.5 使用其他聚合函数
12.2.6 计算上一年的差额
12.3 随时间推移的期末余额
12.3.1 半累加度量
12.3.2 OPENINGBALANCE和CLOSINGBALANCE函数
12.3.3 通过使用事务(交易)更新余额
12.4 计算移动平均
第13章 使用高级DAX
13.1 分区间
13.2 排名
13.3 使用多对多关系
13.4 计算新客户和回头客
13.5 了解KEEPFILFERS
13.6 实施购物篮分析
13.7 理解计算列的威力:ABC分析
13.8 处理货币兑换
...
16.8 PowerPivot作为一个原型系统
Introduction

原书序
Microsoft Excel是进行数据分析的世界标准,其易用性和强大功能使得Excel电子表格成为人人使用的工具,无论分析何种信息。
...
本书为谁而作
这本书面向Excel用户、项目经理和决策者,本书能满足他们学习PowerPivot for Excel 2013基础知识、掌握用于PowerPivot的新的DAX语言以及学习PowerPivot高级数据建模和编程技术的愿望。
对读者的假定
这本书假定你对Excel 2010或Excel 2013有一个基本了解。你不需要成为一个Excel高手,只是一个普通用户就好。将介绍从Excel过渡到PowerPivot需要什么,但不以任何方式涵盖Excel基础知识,例如输入公式、写VLOOKUP函数或其他基本功能。不需要PowerPivot的预备知识。如果你已经尝试过自己建立一个数据模型,那更好;但我们假设在阅读这本书之前,你从来没有打开过PowerPivot。
这本书如何组织
从头到尾读这本书。任何试图直接跳转到某个特定问题的解决方案,跳过一些内容,可能会是错误的选择,在每个章节都会介绍需要在后续章节进一步理解的概念和功能。
此外,你将需要不止一次地阅读本书的一些章节,因为其中的理论背景是很难在第一次阅读时掌握的。
全书共分为16章。
...
关于配套内容
配套内容包括:
■微软的Access版本AdventureWorksDW数据库,你可以用它来建立自己的例子。
■本文中使用的所有Excel工作簿(也就是说,所有工作簿是用来说明书中的概念的)。注意,你需要用Excel 2013,打开工作簿。
致谢
这本书要感谢的人很多,以至于不可能列出一个完整的列表来一一感谢。所以,感谢所有对本书有贡献的朋友,甚至那些没有意识到为本书做出了贡献的朋友。博客评论、论坛帖子、电子邮件讨论、技术会议的与会者和演讲者的聊天,这些一直对我们非常有帮助,而且很多人都为本书的创作做出了重大贡献,也就是说,我们需要提及一些有特殊贡献的朋友。
首先要感谢Edward Melomed,他鼓舞了我们,没有几年前与他的那场充满激情的讨论,我们可能尚未开启我们的PowerPivot之旅。
还要感谢微软出版社、O’Reilly传媒和对本项目有贡献的人: Kenyon Brown、Christopher Hearse以及其他许多幕后工作人员。
唯一比写一本书更花费时间的工作,是必须为准备写书所做的研究。有一群人,我们(友好地)称为“SSAS业内人士”帮我们为写这本书铺平了道路。来自微软的几个人特别值得一提,因为他们花了宝贵时间教导我们有关PowerPivot和DAX函数的重要概念。他们是Marius Dumitru、Jeffrey Wang和Akshai Mirchandani。伙计们,你们的帮助是无价的!
也要感谢Amir Netz, Ashvini Sharma和T.K.Anand,他们对有关如何定位PowerPivot的讨论做出了贡献,他们帮助我们对本书做出了一些战略选择。
在互联网时代编撰成书是具有挑战性的,因为新的资料和想法层出不穷。有几个博客对本书的完成尤为重要,在这里要提到的博主是: Chris Webb、Kasper de Jonge、Rob Collie、Denny Lee和Dave Wickert。
最后,要特别提及本书的技术评审Javier Guillen。他两次检查了我们原始文本中的所有内容,寻找错误,给我们提供了关于如何提高本书质量的宝贵建议。如果这本书包含比我们的原稿更少的错误,这归功于Javier。如果仍然有错误,这当然要由我们负责。
太谢谢你们了,伙计们!
支持与反馈
以下部分提供了勘误表、电子书支持、反馈和联系人信息。
勘误表
我们已经尽力,以确保本书和配套内容的准确性。
这本书出版后的任何已报道的错误会在oreilly.com的微软出版社网站中的本书主页上列出:
https://aka.ms/Excel2013DataModelsPP/errata
如果你发现一个尚未列出的错误,可以通过上述网页报告给我们。
如果你需要额外支持,请发送电子邮件至mspinput@microsoft.com获取微软出版社的图书支持。
需要注意的是,这些地址不提供微软公司软件产品的支持。
我们希望获取你的反馈
在微软出版社,你的满意是我们的首要任务,您的反馈是我们最宝贵的资产。请告诉我们你对本书的想法。
以上网页中的调查是简短的,我们会阅读你的每个意见和想法,提前感谢你的反馈!
保持联系
译者序
...
统计人员应当学习本书,通过对复杂的数据开展挖掘,从而发现其中隐含的模式和趋势。
...
刘凯
美国注册管理会计师(CMA)
国际信息系统审计师(CISA)
国际数据管理协会(DAMA)中国分会项目主管
2014年5月

Specifications

Brand Jingdong book
Brand Origin China

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use
Add to favorites
{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}
{{__("Buy Directly")}} {{ itemCurrency }}{{ item.directly_price }}
Quantity
{{ quantity }}
{{ instockMsg }}
{{ limitText }}
{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}
Sold by JD@CHINA
Ship to
{{ __("Ship to United States only") }}
Free shipping over 69
Genuine guarantee

Added to Cart

Keep Shopping

More to Consider

{{ item.brand_name }}

{{ item.item_name }}

{{ item.currency }}{{ item.market_price }}

{{ item.currency }}{{ item.unit_price }}

{{ item.currency }}{{ item.unit_price }}

Coupons

{{ coupon.coupon_name_new | formatCurrency }}
Clip Clipped Over
{{ getCouponDescStr(coupon) }}
{{ coupon.use_time_desc }}
Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

All rights reserved by Yami.

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by JD@CHINA

Service Guarantee

Yami Free Shipping over $49
Yami Easy Returns
Yami Ships from United States

Shipping

  • United States

    Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

    Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

    2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by JD@CHINA

Service Guarantee

Yami Cross-store Free Shipping over $69
Yami 30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by JD@CHINA

Service Guarantee

Free shipping over 69
Genuine guarantee

Shipping

Yami Consolidated Shipping $9.99(Free shipping over $69)


Seller will ship the orders within 1-2 business days. The logistics time limit is expected to be 7-15 working days. In case of customs clearance, the delivery time will be extended by 3-7 days. The final receipt date is subject to the information of the postal company.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Yami

Download the Yami App

Back Top

Recommended for You

About the brand

Jingdong book

为您推荐

Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折
Yami
欣葉
2种选择
欣叶 御大福 芋头麻薯 180g

周销量 600+

$1.66 $1.99 83折

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review
{{ totalRating }} Write a review
  • {{i}} star

    {{i}} stars

    {{ parseInt(commentRatingList[i]) }}%

Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}
Yami Yami
{{ comment.user_name }}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

{{ comment.content }}

Yami
Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Review

Yami Yami

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

{{ commentDetails.content }}

Yami
Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ commentDetails.likes_count }} {{ commentDetails.likes_count }} {{ commentDetails.reply_count }} {{commentDetails.in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}

Yami Yami

{{ showTranslate(reply) }}Show Less

{{ strLimit(reply,800) }}Show more

Show Original

{{ reply.reply_content }}

{{ formatTime(reply.reply_in_dtm) }}

{{ reply.reply_likes_count }} {{ reply.reply_likes_count }} {{ reply.reply_reply_count }} {{reply.reply_in_user==uid ? __('Delete') : __('Report')}}

Please write at least one word

Cancel

That’s all the comments so far!

Write a review
How would you rate this item?

Please add your comment.

  • A nice nickname will make your comments more popular!
  • The nickname in your account will be changed to the same as here.
Thanks for your review
Our community rely on great reviews like yours to find the best of Asia.

Report

If you find this content inappropriate and think it should be removed from the Yami.com site, let us know please.

Cancel

Are you sure to delete your review?

Cancel

You’ve Recently Viewed

About the brand

Jingdong book