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

[{"title":"（ 90 个子文件 205.64MB ） 微软Excel 2013:用PowerPivot 建立数据模型","children":[{"title":"9780735676343_files","children":[{"title":"Chapter07","children":[{"title":"CH07-01-Evaluation Contexts.xlsx <span style='color:#111;'> 2.09MB </span>","children":null,"spread":false},{"title":"CH07-02-Context Interactions.xlsx <span style='color:#111;'> 185.38KB </span>","children":null,"spread":false},{"title":"CH07-03-Contexts and Relationships.xlsx <span style='color:#111;'> 5.36MB </span>","children":null,"spread":false},{"title":"CH07-04-Parameter Table.xlsx <span style='color:#111;'> 5.34MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter03","children":[{"title":"CH03-03-DaxFunctions.xlsx <span style='color:#111;'> 499.49KB </span>","children":null,"spread":false},{"title":"CH03-01-SalesExample.xlsx <span style='color:#111;'> 468.18KB </span>","children":null,"spread":false},{"title":"CH03-05-Final Exercise.xlsx <span style='color:#111;'> 3.36MB </span>","children":null,"spread":false},{"title":"CH03-02-Aggregation Functions.xlsx <span style='color:#111;'> 539.86KB </span>","children":null,"spread":false},{"title":"CH03-04-Relational Functions.xlsx <span style='color:#111;'> 3.03MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter08","children":[{"title":"CH08-03-CALCULATE - OR Conditions.xlsx <span style='color:#111;'> 4.30MB </span>","children":null,"spread":false},{"title":"CH08-01-Why CALCULATE.xlsx <span style='color:#111;'> 5.32MB </span>","children":null,"spread":false},{"title":"CH08-06-ALLSELECTED.xlsx <span style='color:#111;'> 4.29MB </span>","children":null,"spread":false},{"title":"CH08-02-CALCULATE - Single Column.xlsx <span style='color:#111;'> 4.30MB </span>","children":null,"spread":false},{"title":"CH08-05-CALCULATE - Circular Dependency.xlsx <span style='color:#111;'> 185.40KB </span>","children":null,"spread":false},{"title":"CH08-04-CALCULATE - Context Transition.xlsx <span style='color:#111;'> 2.02MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter06","children":[{"title":"CH06-05-SharePoint list.xlsx <span style='color:#111;'> 252.46KB </span>","children":null,"spread":false},{"title":"CH06-04-Word table.docx <span style='color:#111;'> 13.33KB </span>","children":null,"spread":false},{"title":"CH06-01-Linked Tables.xlsx <span style='color:#111;'> 219.42KB </span>","children":null,"spread":false},{"title":"CH06-02-2005Plans.xlsx <span style='color:#111;'> 37.88KB </span>","children":null,"spread":false},{"title":"CH06-03-2005_Plans.txt <span style='color:#111;'> 292B </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter14","children":[{"title":"CH14-08-GENERATE.xlsx <span style='color:#111;'> 5.53MB </span>","children":null,"spread":false},{"title":"CH14-04-SUMMARIZE.xlsx <span style='color:#111;'> 5.52MB </span>","children":null,"spread":false},{"title":"CH14-01-SimpleQuery.xlsx <span style='color:#111;'> 5.58MB </span>","children":null,"spread":false},{"title":"CH14-07-CROSSJOIN.xlsx <span style='color:#111;'> 5.52MB </span>","children":null,"spread":false},{"title":"CH14-05-Link Back.xlsx <span style='color:#111;'> 5.60MB </span>","children":null,"spread":false},{"title":"CH14-03-ADDCOLUMNS.xlsx <span style='color:#111;'> 5.51MB </span>","children":null,"spread":false},{"title":"CH14-02-FILTER.xlsx <span style='color:#111;'> 5.55MB </span>","children":null,"spread":false},{"title":"CH14-06-ABC in Excel.xlsx <span style='color:#111;'> 5.69MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter01","children":[{"title":"CH01-01-Classical Excel PivotTable.xlsx <span style='color:#111;'> 10.06MB </span>","children":null,"spread":false},{"title":"CH01-03-Power View Report.xlsx <span style='color:#111;'> 10.11MB </span>","children":null,"spread":false},{"title":"CH01-02-Dashboard.xlsx <span style='color:#111;'> 3.53MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter05","children":[{"title":"No demo files for this chapter.txt <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter15","children":[{"title":"CH15-01-RecordingMacro.xlsm <span style='color:#111;'> 5.53MB </span>","children":null,"spread":false},{"title":"CH15-02-Dynamic ABC.xlsm <span style='color:#111;'> 5.71MB </span>","children":null,"spread":false},{"title":"CH15-03-Loading Data.xlsm <span style='color:#111;'> 4.41MB </span>","children":null,"spread":false},{"title":"CH15-04-Connections.xlsm <span style='color:#111;'> 4.41MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter09","children":[{"title":"CH09-02-Parent Child.xlsx <span style='color:#111;'> 257.83KB </span>","children":null,"spread":false},{"title":"CH09-01-Hierarchies.xlsx <span style='color:#111;'> 5.37MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter04","children":[{"title":"CH04-05-Star Schemas.xlsx <span style='color:#111;'> 8.93MB </span>","children":null,"spread":false},{"title":"CH04-02-Data Model.xlsx <span style='color:#111;'> 366.26KB </span>","children":null,"spread":false},{"title":"CH04-01-Understanding Relationships.xlsx <span style='color:#111;'> 56.81KB </span>","children":null,"spread":false},{"title":"CH04-06-Advanced Relationships.xlsx <span style='color:#111;'> 5.46MB </span>","children":null,"spread":false},{"title":"CH04-03-Understanding Normalization.xlsx <span style='color:#111;'> 108.39KB </span>","children":null,"spread":false},{"title":"CH04-04-Querying OLTP.xlsx <span style='color:#111;'> 15.93MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter11","children":[{"title":"CH11-05-Sets.xlsx <span style='color:#111;'> 2.69MB </span>","children":null,"spread":false},{"title":"CH11-03-Power View Metadata.xlsx <span style='color:#111;'> 4.07MB </span>","children":null,"spread":false},{"title":"CH11-07-DrillThrough.xlsx <span style='color:#111;'> 9.73MB </span>","children":null,"spread":false},{"title":"CH11-02-Power View.xlsx <span style='color:#111;'> 2.75MB </span>","children":null,"spread":false},{"title":"CH11-01-KPI.xlsx <span style='color:#111;'> 2.71MB </span>","children":null,"spread":false},{"title":"CH11-04-Power View Metadata - Map.xlsx <span style='color:#111;'> 4.32MB </span>","children":null,"spread":false},{"title":"CH11-06-Perspectives.xlsx <span style='color:#111;'> 9.69MB </span>","children":null,"spread":false}],"spread":true},{"title":"AdventureWorks DW 2012.accdb <span style='color:#111;'> 102.65MB </span>","children":null,"spread":false},{"title":"Chapter12","children":[{"title":"CH12-08-YTD.xlsx <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"CH12-03-Multiple Calendar Tables - Renamed.xlsx <span style='color:#111;'> 5.59MB </span>","children":null,"spread":false},{"title":"CH12-06-Working Days - Holidays in DAX.xlsx <span style='color:#111;'> 5.68MB </span>","children":null,"spread":false},{"title":"CH12-11-ClosingBalance.xlsx <span style='color:#111;'> 394.72KB </span>","children":null,"spread":false},{"title":"CH12-13-Stocks Moving Average.xlsx <span style='color:#111;'> 1.59MB </span>","children":null,"spread":false},{"title":"CH12-07-Working Days Delay.xlsx <span style='color:#111;'> 6.04MB </span>","children":null,"spread":false},{"title":"CH12-01-Calendar Table.xlsx <span style='color:#111;'> 5.36MB </span>","children":null,"spread":false},{"title":"CH12-12-ClosingTransaction.xlsx <span style='color:#111;'> 446.40KB </span>","children":null,"spread":false},{"title":"~$CH12-08-YTD.xlsx <span style='color:#111;'> 165B </span>","children":null,"spread":false},{"title":"CH12-05-Working Days - Holidays.xlsx <span style='color:#111;'> 5.63MB </span>","children":null,"spread":false},{"title":"CH12-10-SemiAdditive.xlsx <span style='color:#111;'> 348.65KB </span>","children":null,"spread":false},{"title":"CH12-02-Multiple Calendar Tables.xlsx <span style='color:#111;'> 5.58MB </span>","children":null,"spread":false},{"title":"CH12-09-Previous Year.xlsx <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"CH12-04-Working Days.xlsx <span style='color:#111;'> 5.61MB </span>","children":null,"spread":false}],"spread":false},{"title":"Chapter10","children":[{"title":"CH10-06-Power View Map.xlsx <span style='color:#111;'> 4.13MB </span>","children":null,"spread":false},{"title":"CH10-01-Power View.xlsx <span style='color:#111;'> 7.26MB </span>","children":null,"spread":false},{"title":"CH10-04-Bubbles.xlsx <span style='color:#111;'> 2.75MB </span>","children":null,"spread":false},{"title":"CH10-03-Card.xlsx <span style='color:#111;'> 2.75MB </span>","children":null,"spread":false},{"title":"CH10-07-Power View Tiles.xlsx <span style='color:#111;'> 4.15MB </span>","children":null,"spread":false},{"title":"CH10-02-Matrix.xlsx <span style='color:#111;'> 2.75MB </span>","children":null,"spread":false},{"title":"CH10-01-01-Power View.xlsx <span style='color:#111;'> 7.26MB </span>","children":null,"spread":false}],"spread":true},{"title":"Chapter16","children":[{"title":"No demo files for this chapter.txt <span style='color:#111;'> 0B </span>","children":null,"spread":false}],"spread":false},{"title":"Chapter02","children":[{"title":"CH02-01-PowerPivot Data Model.xlsx <span style='color:#111;'> 5.48MB </span>","children":null,"spread":false},{"title":"~$CH02-01-PowerPivot Data Model.xlsx <span style='color:#111;'> 165B </span>","children":null,"spread":false},{"title":"CH02-02-Distinct Count.xlsx <span style='color:#111;'> 5.47MB </span>","children":null,"spread":false}],"spread":false},{"title":"AdventureWorksDW2012_Data.mdf <span style='color:#111;'> 201.25MB </span>","children":null,"spread":false},{"title":"Chapter13","children":[{"title":"CH13-06-NewCustomers.xlsx <span style='color:#111;'> 5.65MB </span>","children":null,"spread":false},{"title":"CH13-10-ABC Analysis.xlsx <span style='color:#111;'> 1.02MB </span>","children":null,"spread":false},{"title":"CH13-01-Banding.xlsx <span style='color:#111;'> 1.61MB </span>","children":null,"spread":false},{"title":"CH13-04-Ranking - 2.xlsx <span style='color:#111;'> 175.81KB </span>","children":null,"spread":false},{"title":"CH13-02-Banding Wrong Config.xlsx <span style='color:#111;'> 1.61MB </span>","children":null,"spread":false},{"title":"CH13-11-Currency Conversion.xlsx <span style='color:#111;'> 2.60MB </span>","children":null,"spread":false},{"title":"CH13-05-Many-to-many.xlsx <span style='color:#111;'> 5.33MB </span>","children":null,"spread":false},{"title":"CH13-03-Ranking.xlsx <span style='color:#111;'> 154.38KB </span>","children":null,"spread":false},{"title":"CH13-08-KEEPFILTERS 2.xlsx <span style='color:#111;'> 4.10MB </span>","children":null,"spread":false},{"title":"CH13-09-Basket Analysis.xlsx <span style='color:#111;'> 1.74MB </span>","children":null,"spread":false},{"title":"~$CH13-02-Banding Wrong Config.xlsx <span style='color:#111;'> 165B </span>","children":null,"spread":false},{"title":"CH13-07-KEEPFILTERS.xlsx <span style='color:#111;'> 4.10MB </span>","children":null,"spread":false}],"spread":false}],"spread":false}],"spread":true}]