Dashboarding and Reporting With Power Pivot and

Microsoft’srevolutionaryPowerPivotisatoolthatallowsuserstocreateandtransformdataintoreportsanddashboardsinnewandmuchmorepowerfulwaysusingthemost-usedanalyticaltoolintheworld：Excel.WrittenbyamemberofMicrosoft’sPowerPivotteamandoneoftheleadingPowerPivotbloggers，thisguidetothebusinessanalysisresourcefollowsJim，afictionalbusinessanalyst，asheattemptstocreateadashboardreportforhisCFOthatwillallowhimtoseebusinessperformanceanddrilldownintothereportsforadditionaldetails.Readerswilllearnwhatadashboardis，howtodesignone，andhowtocreatePowerViewsheetsthatallowforadditionallevelsofreportingandhighlyinteractivedatavisualizations.Thebookcoversindetailhowtocombineandshapetherelevantdata，buildthedashboardinExcel—providinglayoutanddesigntipsandtricks—preparethemodeltoworkwithfiscaldates，andshowvaluesusedinmanyfinancialreports，includingyear-to-date，variance-to-target，percentage-of-total，andrunningtotalsreports.Accessiblywritten，thisbookoffersreadersapractical，real-worldscenarioandcanbeusedasaday-to-dayreference.ThoughtheguidefocusesonPowerPivotforExcel2010，achapterthatdiscussesPowerView—compatiblewithExcel2013—isalsoincluded.