Enterprise Only BI is a Flawed Strategy in 2016 – Business Intelligence Info

Iaminspiredtowritethisarticlefrommymylifelongexperiencesworkingwithcompanies?

that1)embraceSelfServiceBIasasynergisticadditiontoEnterpriseBIaswellas2)thosethatdon’tembraceSelfServiceBIasanythingotherthananuisance?

Ofcoursethereisanothergroupthatisfullofpeoplethat“don’tevenknowwhatthey?

aremissing”,butIwillleavethatgroupisforanotherday?

WhenIsay“thosethatdon’tembraceSelfServiceBI”,Iamnottalkingabouttheenlightened“BusinessPeople”ofcourse?

Ihaveneverfound1enlightenedbusinesspersonthatfailedtoseethevalueinaugmentingEnterpriseBI?

withSelfServiceBI。

IhavefoundplentyofBusinesspeoplethatdon’tknowanythingaboutSelfServiceBIhowever?

WhenIsay“thosethatdon’tembraceSelfServiceBI”,IamofcoursetalkingaboutasubsetofITfolkthatforwhateverreasonwillsimplynotopentheireyesandears(andminds)tounderstandorembracetheopportunitythatpresents。

EnterpriseBI?

TraditionalBIsolutionsfortypicallylargeorganisationsbuiltonexpensivehardwareandsoftwarewithspecialistITskilledindividualstobuildandoperatethesolution。

Thebuildprojectstendtobelongandexpensive,andinsomecasestheydelivergreatoutcomesforthebusiness?

Inothercasestheprojectsfailtodeliveronthepromise?

Regardlessofthemeasureofsuccess,EnterpriseBIhasalonghistoryandhasinthepast(andwillcontinueinthefutureto)addalotofvaluetomanylargeenterprises。

NoBI?

Someorganisationsdon’thaveBIforwhateverreason?

Thenormalreasonisthecostand/orriskofprojectfailurecan’tjustifythejourney?

Theseorganisationstypicallyrelyoneithertransactionalsystemreporting(usuallylimited),and/orExcel,ortheysurvive(ordon’tsurvive)withnothingbutgutfeelingandinstinct。

SelfServiceBI?

WhenmodernBItoolscanbeputdirectlyintothehandsoftheenduser?

Theuserscangatherandconnecttotheirowndataiftheywant,and/orsimplyconnecttoexistingEnterprisedatasourcestobuildnewreportsandanalysesinnewways?

SelfServiceBItoolscanbean?

affordableBIsolutionfororganisationsthatcan’taffordEnterpriseBI,ortheycanbeasupplementtoEnterpriseBI。

IamnotadvocatingthatmostbusinessesshouldreplaceEnterpriseBIwithSelfServiceBI?

Howeverinsome(many?

)casesEnterpriseBIhasnotmet(andcannotmeet)alltheneedsofthebusiness?

RegardlessofhowsuccessfulEnterpriseBIisinanorganisation,thereisstillnormallyaplaceforSelfServiceBI?

HowevertheroleofSelfServiceBIdoesdependonthesuccessoftheexistingEnterpriseBIsolutions。

SuccessorfailureofEnterpriseBIcanbeshownasacontinuum。

The5samplepointsIcallout(frombesttoworst)are:

Itaddslotsofvaluetolotsofpeople。

It’sOK,lotsof“exporttoExcel”

Someuse,butnotworththecost

Itisafailureanditiswrittenoff

Itisafailure?

butyoukeepit。

NotewhatIlistastheworstpossibleoutcome?

Thesolutionisnogood,andnoonedoesanythingaboutit?

Thisismuchworsethanwritingitoffasafailureasyoucan’tmoveonifyoudon’tacceptyouhaveaproblem。

SelfServiceBIshouldbe,inmostcases?

anaugmentationtowhateversituationyoualreadyhave(inmyopinion)?

InothercasesitcanbeanalternativetoEnterpriseBI?

Icanthinkofanumberofscenarios。

YouaregoingtopurchaseEnterpriseBIbutitis12monthsaway–getstartedwithSelfServiceBI。

Youdon’tknowwhatyouwant/needfromEnterpriseBI–startprototypingwithSelfServiceBI。

YouhavesuccessfulEnterpriseBI,butyoucan’taffordtosolveeverybespokerequirement(duetotimelinessand/orcost)withEnterpriseBI–SelfServiceBItotherescue。

YouhaveEnterpriseBI,butnotallrequireddataisloaded?

–SelfServiceBIcancombinewhatyouhaveloadedwithwhatisnot。

YouhaveEnterpriseBIanditisgreat?

SomepeoplewillfinditfasterandmoreconvenienttodirectlyconnecttothedatawarehousewithSelfServiceBItools。

YouhaveamediocreEnterpriseBIsolutionthatcan’tbewrittenoff?

AugmentitnowwithSelfServiceBI。

YouhaveaterribleEnterpriseBIsolution?

Keepthedatawarehouseandwriteofftherest(ordon’t)?

BuildnewreportingandanalyseswithSelfServiceBItoolsandusetheseasyournewconsumptionapproach。

YouarenevergoingtopurchaseEnterpriseBI–UseSelfServiceBIasbothanEnterpriseBI?

alternative?

andaSelfServicetool。

Noticetheabsenceofthefollowing2itemsinmylistabove

“You’vegotEnterpriseBI–youdon’tneedSelfServiceBI”?

SelfServiceBIisnowhere–everyonegetridofyourEnterpriseBIsolution。

Sowhythendosomebusinesses(ITactually)insistonresistingprogresswithSelfServiceBI?

WellIthinkitcanbeformanyvariedreasons,including:

fearoflossofcontrol

fearthattheremayneedtobeanexpensivewriteoffofan“asset”thatisnotbeingused–ifpeoplestartusingsomethingelse。

fear?

and/orignoranceoftheunknown

fearofmultipleversionsonthetruth

Iamsuretherearemanymore?

Noticethecommonwordthere–fear!

Idon’tthinkthereisonesingleanswer,butthereisasinglecommonthreadtoeveryscenario?

Averysmartguyoncetoldmethat“yougettheITdepartmentyoudeserve”?

WhathemeantbythatisthattheBusinessleadershaveinfluence?

overwhattheITdepartmentdoesforthem?

Therearenormally(always?

)?

alotmorebusinessleadersinanexecutiveteamthanthereareITleaders。

Iftheexecutiveteamacceptsasubstandardresult?

fromIT,thenitgetswhatitdeserves?

IffollowsthereforethatthesecrettogettingagreatITdepartment(thatsupportsSelfServiceBIandeverythingelse)isthattheexecutivemustinfluenceITtodeliverwhatitneeds?

ButitisunlikelythattheseBlevelmanagerswillbetheonesthatdiscoverSelfServiceBI,andhenceitisuptotheCandDlevelbusinessmanagerstolobbyand?

influencetheexecutivebusinessleadersforchange。

Sowhydon’ttheB,CandDlevelmanagersinfluencethe?

change?

Ithinkthereare3mainreasons:

Theyarenotawareoftheopportunity

FearcreatedbyITthattheskywillfallin

Theyarenotwillingtotellanothermemberoftheexecutivehowtodotheirjobforfearitwillbackfireonthem。

Allofthe?

reasonsabovefornotinfluencingchangecanbeovercomeoncethereismotivation。

Letmetalkaboutmotivationforamoment。

Thefactis,ushumans(andprobablyalllivingthingsactually)onlydothingswearemotivatedtodo–really。

Wegotoworktoearnmoneysowecanlivethelifewewant?

Ifwehadabilliondollars,manyofuswouldn’tgotowork(certainlynotourcurrentjobanyway)。

Welineupinalongqueuetogetagreatcoffee?

Ifthecoffeewasn’tgreat,wewouldn’tlineup。

Weworklateintothe?

nightforfearwewillloseourjobifwedon’tgeta?

taskdoneontime。

Weworklateintothe?

nightbecausewewanttogetapromotion。

Weworklateintothe?

nightbecauseweareinspiredbyourmanagerandwewanttohelpthem。

Therearemanyreasons?

ofmotivation?

WhatwillcreatemotivationforanexecutiveinacompanytoembraceSelfServiceBIisabsoluteclarityofthebenefits?

StephenCoveyinhisbook“TheEighthHabit”talksabouttheconceptofaTrimTab?

ATrimTabisthelittlerudderthatsitsattheback?

ofthebigrudderonlargeships?

Theseshipsaresolarge,thattheyneedverylargerudders?

Buttheruddersaresolarge,thateventherudderscan’tturnbythemselves。

ATrimTabisthesmallrudderthatturnsthelargerudderthatturnstheship?

IremembertheTrimTabconceptvividlyasIwasfortunateenoughtomeetStephenCovey(oneofmyidols)?

AsStephenwassigningmybook,hesaid“Matt,becomeaTrimTab”–andthatisexactlywhatIamtryingtobe?

Youshouldtoo。

Youall,theloyalreadersofPowerPivotPro。

comneedtobecomeaTrimTab–anevangelist,trailblazerandinfluencerofthelargerruddersthatsteertheship。

IfyoucandirectlyinfluencetheExecutive,thengoaheadanddothat?

Ifyoucan’tdirectlyinfluencetheExecutive,thenyouneedtoinfluencesomeonethatcan?

ThebestwaytoinfluenceCandDlevelmanagersistoshowthemwhatyoucandowiththeSelfServiceBItools?

ForgetaboutthereasonswhyyouarenotallowedtodothisorthatandinsteadgetonwithusingtheSelfServiceBItoolsyoualreadyhaveaccessto,tocreatevalueforyourorganisation?

Soonerorlatersomeoneisgoingtorealiseyouareontosomething?

Thesoonereveryone(even1personwithinfluence)realisesyouareontosomething,thesooneryouwillgettheITdepartmentyouneed。

Ofcoursesomeofyoucan’tstartusingthesetoolsbecauseIThaslockeddownyourcomputerssohard,thatyoucan’teveninstallthePowerQuerypluginyourself(orPowerPivotifyouarestillon2010)?

Butifthatisthecase,thengettingthischanged?

isamucheasierbattletowin–togetapprovaltoinstallastandardMicrosoftPluginforExcel?

SofightandwinthatbattleandthengetonwithshowingthevaluetotheCandDlevelmanagers,andhavetheminfluencetheExecutive?

Remember,mostoftheexecutivesinmostcompanies(ifnotall)arenotinIT,andtheywillbemotivatedforchangeaslongastheyseethebenefit。

Letsblockads!

(Why?

)

PowerPivotPro