Grab some

coffee and

enjoy the

pre-show

banter before the

top of the

hour!

H T Technologiesof 2016

HOST:RebeccaJozwiak@rebeccajozwiak

THISYEARis…

THELINEUP

ANALYST:

DezBlanchfieldDataScientist,TheBloorGroup

ANALYST:

RobinBloorChiefAnalyst,TheBloorGroup

GUEST:

StanGeigerSeniorProductManager,IDERA

INTRODUCING

RobinBloor

Monitoring BI

Robin Bloor Ph D

The Role of BI

BI is the feedback loop for corporate systems

The Driving Force: Insight = Analytics

And Optimization?

The Begetting of BI

u  Desire for knowledge begets user requests

u  User requests beget analytics projects

u  Analytics projects beget data lakes

u  Data lakes + analytics beget insights

u  Insights beget BI

A Full BI Platform: Much Simplified

Corporate Reality

BI Disruption

u  Data volumes u  Data sources u  Streaming & speed of arrival u  Unstructured data u  Social (unclean) data u  IOT data u  Data provenance u  Compute power (parallelism) u  Machine learning u  New analytic workloads

Bi is not a static situation.

The Internet of Things

Event-driven Architectures

Real-time Everything

The Future BI Landscape Includes…

BI: Of The User, By The User, For The User

u  Data flow integration/automation u  Performance/timeliness (overall) u  Data coverage: data sources, also

structured/unstructured data u  Data cleansing u  Data access skills u  Visualizations u  Shareability u  Actionability

The issues in summary:

About BI Monitoring…

Unless the BI SERVICE is dependable and timely, it isn’t a SERVICE

INTRODUCING

DezBlanchfield

@dez_blanchfield

Maintaining&MonitoringHealthyB.I.pla4orms

@dez_blanchfield

modernB.I.pla.ormshave

manycomplexmovingparts

@dez_blanchfield

ModernBusinessIntelligencepla.ormsaremadeupofmanycomplexmovingparts,it’snotjustaboutkeepingthelightson.

§  Availability&Qualityofdatasources

§  Databases&DataWarehousing

§  SystemAdmin&Management

§  Pla4ormSecurity&Governance

§  User&SystemAccessControls

§  UserInterfaces&PresentaFon

§  AnalyFcsPla4orms&Tools

§  ReporFng,Monitoring&Dashboards

Morethanjustkeepingthelightson..

@dez_blanchfield

thechallengeofmanaging

B.I.pla.ormsatanyscale

@dez_blanchfield

BusinessIntelligenceiso@enthelifebloodofanorganizaBon,anyB.I.pla.ormperformancehitswillimpacttheboDomline.

§  LossofaB.I.pla4orm=flyingblind

§  PoorperformanceimpactsadopFon

§  Accessissuesimpacteverything

§  Decisionmakingcompanywide

§  Accurate&TimelyreporBng

§  Capacitytorunthebusiness

§  Staffperformance&moral

§  Compliance&Governance

B.I.pla4ormsdemandperformance..

@dez_blanchfield

asingleperformanceissuecan

impacttheenBreecosystem

@dez_blanchfield

Aswithsomanythings,theRumsfeldConundrumapplies,knownknowns,knownunknowns,andunknownunknowns..

§  CoreBusinessSystemPerformance§  Sales,MarkeBng,Finance

§  HR,OperaBons,LogisBcs

§  Planning,ForecasBng,ReporBng

§  Backendsystems&pla4orms§  ResponseBmes&loadaverages

§  Workloads/Batches/Backups

§  Maintenance/Updates/Patching

§  Misc.manualsystemadmin

§  ManualDataImportsorExports

Coreareasthatcanimpactperformance..

@dez_blanchfield

complexsystemsrequiresmart

toolstomanageperformance

INTRODUCING

StanGeiger

© 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.

BUSINESS INTELLIGENCE PLATFORM HEALTH Monitoring the Microsoft BI Stack

28 © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.

BUSINESS INTELLIGENCE ARCHITECTURE

29 © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.

MICROSOFT PLATFORM ARCHITECTURE

§  Source Data •  Relational Databases (SQL Server, Oracle, etc.) •  NoSQL (MongoDB, Cassandra, Hbase)

§  Data Storage and Aggregation •  SQL Server Database •  Azure Data Warehouse •  Analysis Services (SSAS)

§  Presentation/Analytics •  Excel •  Reporting Services (SSRS) •  PowerBI

“

30 © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential.

You don’t know what you don’t know.

Noam Chomsky

31 © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.

PLATFORM MONITORING §  Availability

•  Resource Availability (up/down) •  Root Cause Identification

§  Performance •  Server level performance metrics •  Resource level performance •  Identify bottlenecks

§  Utilization •  User Sessions •  Requests (queries, reports, etc.)

“

32 © 2015 IDERA, Inc. All rights reserved. Proprietary and confidential.

When you need it, and don't have it…you sing a different tune.

Bert Gummer, Tremors 2

33 © 2016 IDERA, Inc. All rights reserved. Proprietary and confidential.

THANKS! Any questions?

You can find me at: stan.geiger@idera.com

TheArchiveTrifecta:•  InsideAnalysiswww.insideanalysis.com•  SlideSharewww.slideshare.net/InsideAnalysis•  YouTubewww.youtube.com/user/BloorGroup

THANKYOU!