文件名称：微软Excel 2013:用PowerPivot 建立数据模型
文件大小：205.64MB
文件格式：RAR
更新时间：2021-04-08 18:39:14
PBI, 数据模型,PP
Microsoft Excel是进行数据分析的世界标准，其易用性和强大功能使得Excel电子表格成为人人使用的工具，无论分析何种信息。在写这本书时，我们决定把重点放在概念和实例上，从零开始带你掌握DAX语言。《微软Excel 2013:用PowerPivot 建立数据模型》不涵盖每个功能，也不用“单击A，然后B”的方式解释每个操作。相反，《微软Excel 2013:用PowerPivot 建立数据模型》承载了大量信息，这样一旦学完《微软Excel 2013:用PowerPivot 建立数据模型》 你在Excel新的建模选项中将有足够的背景知识。用最后一句话来强调这本书的主要特点：它是用来学习的书，而不只是阅读。我们向你保证这将是非常值得的。。这个是数据模型
【文件预览】：
9780735676343_files
----Chapter07()
--------CH07-01-Evaluation Contexts.xlsx(2.09MB)
--------CH07-02-Context Interactions.xlsx(185KB)
--------CH07-03-Contexts and Relationships.xlsx(5.36MB)
--------CH07-04-Parameter Table.xlsx(5.34MB)
----Chapter03()
--------CH03-03-DaxFunctions.xlsx(499KB)
--------CH03-01-SalesExample.xlsx(468KB)
--------CH03-05-Final Exercise.xlsx(3.36MB)
--------CH03-02-Aggregation Functions.xlsx(540KB)
--------CH03-04-Relational Functions.xlsx(3.03MB)
----Chapter08()
--------CH08-03-CALCULATE - OR Conditions.xlsx(4.3MB)
--------CH08-01-Why CALCULATE.xlsx(5.32MB)
--------CH08-06-ALLSELECTED.xlsx(4.29MB)
--------CH08-02-CALCULATE - Single Column.xlsx(4.3MB)
--------CH08-05-CALCULATE - Circular Dependency.xlsx(185KB)
--------CH08-04-CALCULATE - Context Transition.xlsx(2.02MB)
----Chapter06()
--------CH06-05-SharePoint list.xlsx(252KB)
--------CH06-04-Word table.docx(13KB)
--------CH06-01-Linked Tables.xlsx(219KB)
--------CH06-02-2005Plans.xlsx(38KB)
--------CH06-03-2005_Plans.txt(292B)
----Chapter14()
--------CH14-08-GENERATE.xlsx(5.53MB)
--------CH14-04-SUMMARIZE.xlsx(5.52MB)
--------CH14-01-SimpleQuery.xlsx(5.58MB)
--------CH14-07-CROSSJOIN.xlsx(5.52MB)
--------CH14-05-Link Back.xlsx(5.6MB)
--------CH14-03-ADDCOLUMNS.xlsx(5.51MB)
--------CH14-02-FILTER.xlsx(5.55MB)
--------CH14-06-ABC in Excel.xlsx(5.69MB)
----Chapter01()
--------CH01-01-Classical Excel PivotTable.xlsx(10.06MB)
--------CH01-03-Power View Report.xlsx(10.11MB)
--------CH01-02-Dashboard.xlsx(3.53MB)
----Chapter05()
--------No demo files for this chapter.txt(0B)
----Chapter15()
--------CH15-01-RecordingMacro.xlsm(5.53MB)
--------CH15-02-Dynamic ABC.xlsm(5.71MB)
--------CH15-03-Loading Data.xlsm(4.41MB)
--------CH15-04-Connections.xlsm(4.41MB)
----Chapter09()
--------CH09-02-Parent Child.xlsx(258KB)
--------CH09-01-Hierarchies.xlsx(5.37MB)
----Chapter04()
--------CH04-05-Star Schemas.xlsx(8.93MB)
--------CH04-02-Data Model.xlsx(366KB)
--------CH04-01-Understanding Relationships.xlsx(57KB)
--------CH04-06-Advanced Relationships.xlsx(5.46MB)
--------CH04-03-Understanding Normalization.xlsx(108KB)
--------CH04-04-Querying OLTP.xlsx(15.93MB)
----Chapter11()
--------CH11-05-Sets.xlsx(2.69MB)
--------CH11-03-Power View Metadata.xlsx(4.07MB)
--------CH11-07-DrillThrough.xlsx(9.73MB)
--------CH11-02-Power View.xlsx(2.75MB)
--------CH11-01-KPI.xlsx(2.71MB)
--------CH11-04-Power View Metadata - Map.xlsx(4.32MB)
--------CH11-06-Perspectives.xlsx(9.69MB)
----AdventureWorks DW 2012.accdb(102.65MB)
----Chapter12()
--------CH12-08-YTD.xlsx(5.65MB)
--------CH12-03-Multiple Calendar Tables - Renamed.xlsx(5.59MB)
--------CH12-06-Working Days - Holidays in DAX.xlsx(5.68MB)
--------CH12-11-ClosingBalance.xlsx(395KB)
--------CH12-13-Stocks Moving Average.xlsx(1.59MB)
--------CH12-07-Working Days Delay.xlsx(6.04MB)
--------CH12-01-Calendar Table.xlsx(5.36MB)
--------CH12-12-ClosingTransaction.xlsx(446KB)
--------~$CH12-08-YTD.xlsx(165B)
--------CH12-05-Working Days - Holidays.xlsx(5.63MB)
--------CH12-10-SemiAdditive.xlsx(349KB)
--------CH12-02-Multiple Calendar Tables.xlsx(5.58MB)
--------CH12-09-Previous Year.xlsx(5.65MB)
--------CH12-04-Working Days.xlsx(5.61MB)
----Chapter10()
--------CH10-06-Power View Map.xlsx(4.13MB)
--------CH10-01-Power View.xlsx(7.26MB)
--------CH10-04-Bubbles.xlsx(2.75MB)
--------CH10-03-Card.xlsx(2.75MB)
--------CH10-07-Power View Tiles.xlsx(4.15MB)
--------CH10-02-Matrix.xlsx(2.75MB)
--------CH10-01-01-Power View.xlsx(7.26MB)
----Chapter16()
--------No demo files for this chapter.txt(0B)
----Chapter02()
--------CH02-01-PowerPivot Data Model.xlsx(5.48MB)
--------~$CH02-01-PowerPivot Data Model.xlsx(165B)
--------CH02-02-Distinct Count.xlsx(5.47MB)
----AdventureWorksDW2012_Data.mdf(201.25MB)
----Chapter13()
--------CH13-06-NewCustomers.xlsx(5.65MB)
--------CH13-10-ABC Analysis.xlsx(1.02MB)
--------CH13-01-Banding.xlsx(1.61MB)
--------CH13-04-Ranking - 2.xlsx(176KB)
--------CH13-02-Banding Wrong Config.xlsx(1.61MB)
--------CH13-11-Currency Conversion.xlsx(2.6MB)
--------CH13-05-Many-to-many.xlsx(5.33MB)
--------CH13-03-Ranking.xlsx(154KB)
--------CH13-08-KEEPFILTERS 2.xlsx(4.1MB)
--------CH13-09-Basket Analysis.xlsx(1.74MB)
--------~$CH13-02-Banding Wrong Config.xlsx(165B)
--------CH13-07-KEEPFILTERS.xlsx(4.1MB)