请选择 进入手机版 | 继续访问电脑版
楼主: igs816
4792 33

[书籍介绍] Analyzing Data with Microsoft Power BI and Power Pivot for Excel [推广有奖]

泰斗

5%

还不是VIP/贵宾

-

威望
9
论坛币
2693869 个
通用积分
18515.7248
学术水平
2743 点
热心指数
3466 点
信用等级
2559 点
经验
484572 点
帖子
5413
精华
52
在线时间
3575 小时
注册时间
2007-8-6
最后登录
2024-3-28

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

igs816 在职认证  发表于 2018-1-14 23:18:35 |显示全部楼层 |坛友微信交流群
相似文件 换一批

+2 论坛币
k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群
赵安豆老师微信:zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

感谢您参与论坛问题回答

经管之家送您两个论坛币!

+2 论坛币
87vIiR0evCY3MmWWxJbdqhbyo2NSi51r.jpg


English | 2017 | ISBN: 150930276X | 250 Pages | True PDF | 12.6 MB


Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness.

How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It's meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you'll soon see, with the right data model, the correct answer is always a simple one!

By reading this book, you will:

• Gain an understanding of the basics of data modeling, including tables, relationships, and keys
• Familiarize yourself with star schemas, snowflakes, and common modeling techniques
• Learn the importance of granularity
• Discover how to use multiple fact tables, like sales and purchases, in a complex data model
• Manage calendar-related calculations by using date tables
• Track historical attributes, like previous addresses of customers or manager assignments
• Use snapshots to compute quantity on hand
• Work with multiple currencies in the most efficient way
• Analyze events that have durations, including overlapping durations
• Learn what data model you need to answer your specific business questions

About This Book

• For Excel and Power BI users who want to exploit the full power of their favorite tools
• For BI professionals seeking new ideas for modeling data

本帖隐藏的内容

Analyzing Data with Microsoft Power BI and Power Pivot for Excel.pdf (12.62 MB, 需要: 10 个论坛币)


二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

关键词:Microsoft Analyzing Power EXCEL Analy

已有 1 人评分经验 收起 理由
zl89 + 80 精彩帖子

总评分: 经验 + 80   查看全部评分

本帖被以下文库推荐

beijin2008 发表于 2018-1-14 23:24:51 |显示全部楼层 |坛友微信交流群
谢谢分享

使用道具

smartlife 在职认证  发表于 2018-1-15 00:52:34 |显示全部楼层 |坛友微信交流群
ljjjjjjjjjjjjj

使用道具

军旗飞扬 发表于 2018-1-15 05:28:21 |显示全部楼层 |坛友微信交流群
谢谢分享

使用道具

nkunku 发表于 2018-1-15 07:57:01 |显示全部楼层 |坛友微信交流群
Analyzing Data with Microsoft Power BI and Power Pivot for Excel

使用道具

allain 在职认证  发表于 2018-1-15 09:11:03 |显示全部楼层 |坛友微信交流群
kkkkkkkk

使用道具

xiaoyu王 发表于 2018-1-15 10:32:09 |显示全部楼层 |坛友微信交流群
好书,谢谢分享

使用道具

fdwang 发表于 2018-1-15 11:59:13 |显示全部楼层 |坛友微信交流群

使用道具

onlyflyttn 在职认证  发表于 2018-1-15 13:27:24 |显示全部楼层 |坛友微信交流群
好书,深入建模

使用道具

lhf8059 发表于 2018-1-15 13:39:45 |显示全部楼层 |坛友微信交流群
看看看

使用道具

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

本版微信群
加好友,备注cda
拉您进交流群

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

GMT+8, 2024-3-29 08:01