BAP302_SQLServer2008R2的自助式商务智能

1、SQL Server 2008 R2的自助式商务智能Self-service Business IntelligenceBAP30223Please translate the sign456789Please translate the headline10111213141516Please translate the headline17181920Can this be translated and still be fun? If not, you can delete.21222324252627Excel Functions in Gemini28Lookup Functions

2、LookupValue (ResultColumn, SearchColumn, SearchValue.)Related (Column)RelatedTable (Table) 29Aggregation FunctionsSUMX (Table, Expression)AVERAGEX (Table, Expression)COUNTAX (Table, Expression)MINX (Table, Expression)MAXX (Table, Expression)EARLIER(Column) EARLIEST(Column)30Table FunctionsRelatedTab

3、le (Table) Filter (Table, Condition)Distinct (Column)Values (Column)All (Table), All(Column)AllExcept (Table, Col1, Col2,.)31Variants of Calculate()Scalar functionsCalculateCalculateAllCalculateAllRowsTable FunctionsCalculateTableCalculateTableAllCalculateTableAllRowsSupporting FunctionsAllAllExcept

4、AllNoBlankRow32Time Intelligence FunctionsFirstDateLastDateFirstNonBlankLastNonBlankStartofMonthStartofYearEndofMonthEndofQuarterEndofYearDateAddDatesBetweenDatesInPeriodParallelPeriodPreviousDayPreviousMonthPreviousQuarterPreviousYearNextDayNextMonthNextQuarterNextYearDatesMTDDatesQTDDatesYTDSamePeriodLastYearTotalMTDTotalQTDTotalYTDOpeningBalanceMonthOpeningBalanceQuarterOpeningBalanceYea