PowerQueryisadataconnectiontechnologythatallowsyoutoconnect,combine,andrefinedatafrommultiplesourcestomeetyourbusinessanalysisrequirements.WiththisPowerQuerybook,you’llbeempoweredtoworkwithavarietyofdatasourcestocreateinteractivereportsanddashboardsusingExcelandPowerBI.You’llstartbylearninghowtoaccessPowerQueryacrossdifferentversionsofExcelandinstallthePowerBIengine.Afteryou'veexploredPowerPivot,you’llseewhyExcelusersfinditchallengingtocleandatainPowerPivotandlearnhowPowerQuerycanhelptotackletheproblem.ThebookwillshowyouhowtotransformdatausingtheQueryEditorandwritefunctionsinPowerQuery.AdedicatedsectionwillfocusonfunctionssuchasIF,Index,andModulo,andcreatingparameterstoalterquerypathsinatable.You’llalsoworkwithdashboards,gettogripswithmulti-dimensionalreporting,andcreateautomatedreports.Asyouadvance,you'llcovertheMformulalanguageinPowerQuery,delveintothebasicMsyntax,andwritetheMquerylanguagewiththehelpofexamplessuchasloadingalllibraryfunctionsofflineinExcelandPowerBI.Finally,thebookwilldemonstratethedifferencebetweenMandDAXandshowhowresultsareproducedinM.Bytheendofthisbook,you’llbereadytocreateimpressivedashboardsandmulti-dimensionalreportsinPowerQueryandturndataintovaluableinsights.