微软Excel2013:用PowerPivot建立数据模型

[{"title":"（90个子文件205.64MB）微软Excel2013:用PowerPivot建立数据模型","children":[{"title":"9780735676343_files","children":[{"title":"Chapter07","children":[{"title":"CH07-01-EvaluationContexts.xlsx <span style='color:#111;'>2.09MB</span>","children":null,"spread":false},{"title":"CH07-02-ContextInteractions.xlsx <span style='color:#111;'>185.38KB</span>","children":null,"spread":false},{"title":"CH07-03-ContextsandRelationships.xlsx <span style='color:#111;'>5.36MB</span>","children":null,"spread":false},{"title":"CH07-04-ParameterTable.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-FinalExercise.xlsx <span style='color:#111;'>3.36MB</span>","children":null,"spread":false},{"title":"CH03-02-AggregationFunctions.xlsx <span style='color:#111;'>539.86KB</span>","children":null,"spread":false},{"title":"CH03-04-RelationalFunctions.xlsx <span style='color:#111;'>3.03MB</span>","children":null,"spread":false}],"spread":true},{"title":"Chapter08","children":[{"title":"CH08-03-CALCULATE-ORConditions.xlsx <span style='color:#111;'>4.30MB</span>","children":null,"spread":false},{"title":"CH08-01-WhyCALCULATE.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-SingleColumn.xlsx <span style='color:#111;'>4.30MB</span>","children":null,"spread":false},{"title":"CH08-05-CALCULATE-CircularDependency.xlsx <span style='color:#111;'>185.40KB</span>","children":null,"spread":false},{"title":"CH08-04-CALCULATE-ContextTransition.xlsx <span style='color:#111;'>2.02MB</span>","children":null,"spread":false}],"spread":true},{"title":"Chapter06","children":[{"title":"CH06-05-SharePointlist.xlsx <span style='color:#111;'>252.46KB</span>","children":null,"spread":false},{"title":"CH06-04-Wordtable.docx <span style='color:#111;'>13.33KB</span>","children":null,"spread":false},{"title":"CH06-01-LinkedTables.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-LinkBack.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-ABCinExcel.xlsx <span style='color:#111;'>5.69MB</span>","children":null,"spread":false}],"spread":true},{"title":"Chapter01","children":[{"title":"CH01-01-ClassicalExcelPivotTable.xlsx <span style='color:#111;'>10.06MB</span>","children":null,"spread":false},{"title":"CH01-03-PowerViewReport.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":"Nodemofilesforthischapter.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-DynamicABC.xlsm <span style='color:#111;'>5.71MB</span>","children":null,"spread":false},{"title":"CH15-03-LoadingData.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-ParentChild.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-StarSchemas.xlsx <span style='color:#111;'>8.93MB</span>","children":null,"spread":false},{"title":"CH04-02-DataModel.xlsx <span style='color:#111;'>366.26KB</span>","children":null,"spread":false},{"title":"CH04-01-UnderstandingRelationships.xlsx <span style='color:#111;'>56.81KB</span>","children":null,"spread":false},{"title":"CH04-06-AdvancedRelationships.xlsx <span style='color:#111;'>5.46MB</span>","children":null,"spread":false},{"title":"CH04-03-UnderstandingNormalization.xlsx <span style='color:#111;'>108.39KB</span>","children":null,"spread":false},{"title":"CH04-04-QueryingOLTP.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-PowerViewMetadata.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-PowerView.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-PowerViewMetadata-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":"AdventureWorksDW2012.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-MultipleCalendarTables-Renamed.xlsx <span style='color:#111;'>5.59MB</span>","children":null,"spread":false},{"title":"CH12-06-WorkingDays-HolidaysinDAX.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-StocksMovingAverage.xlsx <span style='color:#111;'>1.59MB</span>","children":null,"spread":false},{"title":"CH12-07-WorkingDaysDelay.xlsx <span style='color:#111;'>6.04MB</span>","children":null,"spread":false},{"title":"CH12-01-CalendarTable.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-WorkingDays-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-MultipleCalendarTables.xlsx <span style='color:#111;'>5.58MB</span>","children":null,"spread":false},{"title":"CH12-09-PreviousYear.xlsx <span style='color:#111;'>5.65MB</span>","children":null,"spread":false},{"title":"CH12-04-WorkingDays.xlsx <span style='color:#111;'>5.61MB</span>","children":null,"spread":false}],"spread":false},{"title":"Chapter10","children":[{"title":"CH10-06-PowerViewMap.xlsx <span style='color:#111;'>4.13MB</span>","children":null,"spread":false},{"title":"CH10-01-PowerView.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-PowerViewTiles.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-PowerView.xlsx <span style='color:#111;'>7.26MB</span>","children":null,"spread":false}],"spread":true},{"title":"Chapter16","children":[{"title":"Nodemofilesforthischapter.txt <span style='color:#111;'>0B</span>","children":null,"spread":false}],"spread":false},{"title":"Chapter02","children":[{"title":"CH02-01-PowerPivotDataModel.xlsx <span style='color:#111;'>5.48MB</span>","children":null,"spread":false},{"title":"~$CH02-01-PowerPivotDataModel.xlsx <span style='color:#111;'>165B</span>","children":null,"spread":false},{"title":"CH02-02-DistinctCount.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-ABCAnalysis.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-BandingWrongConfig.xlsx <span style='color:#111;'>1.61MB</span>","children":null,"spread":false},{"title":"CH13-11-CurrencyConversion.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-KEEPFILTERS2.xlsx <span style='color:#111;'>4.10MB</span>","children":null,"spread":false},{"title":"CH13-09-BasketAnalysis.xlsx <span style='color:#111;'>1.74MB</span>","children":null,"spread":false},{"title":"~$CH13-02-BandingWrongConfig.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}]