文件名称：微软excel2013用powerpivot建立数据模型-【配套内容示例文件】
文件大小：179.78MB
文件格式：RAR
更新时间：2024-02-11 10:53:48
excel power pivot bi
微软excel2013用powerpivot建立数据模型-【配套内容示例文件】 Microsoft Excel 2013 Building Data Models with PowerPivot] 注意！只有示例文件，没有电子书！ 内含一个access数据库文件；1-16章Excel的.xlsx配套文件
【文件预览】：
Chapter15
----CH15-02-Dynamic ABC.xlsm(5.71MB)
----CH15-04-Connections.xlsm(4.41MB)
----CH15-01-RecordingMacro.xlsm(5.53MB)
----CH15-03-Loading Data.xlsm(4.41MB)
Chapter09
----CH09-01-Hierarchies.xlsx(5.37MB)
----CH09-02-Parent Child.xlsx(258KB)
Chapter13
----CH13-09-Basket Analysis.xlsx(1.74MB)
----CH13-01-Banding.xlsx(1.61MB)
----CH13-11-Currency Conversion.xlsx(2.6MB)
----CH13-02-Banding Wrong Config.xlsx(1.61MB)
----CH13-08-KEEPFILTERS 2.xlsx(4.1MB)
----CH13-03-Ranking.xlsx(154KB)
----CH13-07-KEEPFILTERS.xlsx(4.1MB)
----CH13-10-ABC Analysis.xlsx(1.02MB)
----CH13-05-Many-to-many.xlsx(5.33MB)
----CH13-04-Ranking - 2.xlsx(176KB)
----CH13-06-NewCustomers.xlsx(5.65MB)
Chapter10
----CH10-03-Card.xlsx(2.75MB)
----CH10-02-Matrix.xlsx(2.75MB)
----CH10-01-01-Power View.xlsx(7.26MB)
----CH10-06-Power View Map.xlsx(4.13MB)
----CH10-01-Power View.xlsx(7.26MB)
----CH10-04-Bubbles.xlsx(2.75MB)
----CH10-07-Power View Tiles.xlsx(4.15MB)
Chapter11
----CH11-04-Power View Metadata - Map.xlsx(4.32MB)
----CH11-02-Power View.xlsx(2.75MB)
----CH11-06-Perspectives.xlsx(9.69MB)
----CH11-07-DrillThrough.xlsx(9.73MB)
----CH11-05-Sets.xlsx(2.69MB)
----CH11-03-Power View Metadata.xlsx(4.07MB)
----CH11-01-KPI.xlsx(2.71MB)
AdventureWorks DW 2012.accdb
Chapter16
----No demo files for this chapter.txt(0B)
Chapter06
----CH06-03-2005_Plans.txt(292B)
----CH06-02-2005Plans.xlsx(38KB)
----CH06-05-SharePoint list.xlsx(252KB)
----CH06-01-Linked Tables.xlsx(219KB)
----CH06-04-Word table.docx(13KB)
Chapter08
----CH08-03-CALCULATE - OR Conditions.xlsx(4.3MB)
----CH08-04-CALCULATE - Context Transition.xlsx(2.02MB)
----CH08-05-CALCULATE - Circular Dependency.xlsx(185KB)
----CH08-01-Why CALCULATE.xlsx(5.32MB)
----CH08-02-CALCULATE - Single Column.xlsx(4.3MB)
----CH08-06-ALLSELECTED.xlsx(4.29MB)
Chapter14
----CH14-07-CROSSJOIN.xlsx(5.52MB)
----CH14-06-ABC in Excel.xlsx(5.69MB)
----CH14-02-FILTER.xlsx(5.55MB)
----CH14-04-SUMMARIZE.xlsx(5.52MB)
----CH14-01-SimpleQuery.xlsx(5.58MB)
----CH14-08-GENERATE.xlsx(5.53MB)
----CH14-05-Link Back.xlsx(5.6MB)
----CH14-03-ADDCOLUMNS.xlsx(5.51MB)
Chapter12
----CH12-10-SemiAdditive.xlsx(349KB)
----CH12-06-Working Days - Holidays in DAX.xlsx(5.68MB)
----CH12-04-Working Days.xlsx(5.61MB)
----CH12-01-Calendar Table.xlsx(5.36MB)
----CH12-13-Stocks Moving Average.xlsx(1.59MB)
----CH12-05-Working Days - Holidays.xlsx(5.63MB)
----CH12-09-Previous Year.xlsx(5.65MB)
----CH12-11-ClosingBalance.xlsx(395KB)
----CH12-08-YTD.xlsx(5.65MB)
----CH12-03-Multiple Calendar Tables - Renamed.xlsx(5.59MB)
----CH12-02-Multiple Calendar Tables.xlsx(5.59MB)
----CH12-07-Working Days Delay.xlsx(6.04MB)
----CH12-12-ClosingTransaction.xlsx(446KB)
Chapter03
----CH03-05-Final Exercise.xlsx(3.36MB)
----CH03-01-SalesExample.xlsx(468KB)
----CH03-03-DaxFunctions.xlsx(499KB)
----CH03-04-Relational Functions.xlsx(3.03MB)
----CH03-02-Aggregation Functions.xlsx(540KB)
Chapter05
----No demo files for this chapter.txt(0B)
Chapter02
----CH02-02-Distinct Count.xlsx(5.47MB)
----CH02-01-PowerPivot Data Model.xlsx(5.46MB)
Chapter01
----CH01-01-Classical Excel PivotTable.xlsx(10.06MB)
----CH01-02-Dashboard.xlsx(3.53MB)
----CH01-03-Power View Report.xlsx(10.11MB)
Chapter04
----CH04-01-Understanding Relationships.xlsx(57KB)
----CH04-02-Data Model.xlsx(398KB)
----CH04-05-Star Schemas.xlsx(8.93MB)
----CH04-06-Advanced Relationships.xlsx(5.46MB)
----CH04-03-Understanding Normalization.xlsx(108KB)
----CH04-04-Querying OLTP.xlsx(15.93MB)
Chapter07
----CH07-02-Context Interactions.xlsx(185KB)
----CH07-04-Parameter Table.xlsx(5.34MB)
----CH07-01-Evaluation Contexts.xlsx(2.09MB)
----CH07-03-Contexts and Relationships.xlsx(5.36MB)