Visualizing OLAP Data With Multiple Products BIWA Summit PDF Free Download

2y ago

55 Views

1 Downloads

2.58 MB

39 Pages

Report/dmca

Download PDF

Transcription

Visualizing OLAP Data With MultipleProductsBIWA Summit 2013Dan VlamisVlamis Software t 2013, Vlamis Software Solutions, Inc.

Visualizing OLAP Data Agenda Background on OLAPVisualizing OLAP dataOBIEESimba’s MDX Provider for Oracle OLAPMicrosoft ExcelArcplanDeltaMasterOther front ends and webcast announcementMore information (Q&A)Copyright 2013, Vlamis Software Solutions, Inc.

Dan Vlamis and Vlamis Software Solutions Vlamis Software founded in 1992 in Kansas City, Missouri Developed more than 200 Oracle BI systems Specializes in ORACLE-based: Data WarehousingBusiness IntelligenceDesign and integrated BI and DW solutionsTraining and mentoringExpert presenter at major Oracle conferenceswww.vlamis.com (blog, papers, newsletters, services)Developer for IRI (former owners of Oracle OLAP)Co-author of book “Oracle Essbase & Oracle OLAP”Beta tester for OBIEE 11gReseller for Simba and Nokia map data for OBIEEHOL Coordinator for BIWA Summit 2013Copyright 2013, Vlamis Software Solutions, Inc.

Oracle OLAPLeveraging Core Database InfrastructureOracle Database 11gData WarehousingOracle SpatialOLAPData Mining Single RDBMS-MDBMSprocess Single data storage Single security model Single administration facility Grid-enabled Accessible by any SQL-basedtool Embedded BI metadata Connects to all related OracledataCopyright 2013, Vlamis Software Solutions, Inc.

Easy AnalyticsOptimized Data Access MethodHow do Expenses compare this Quarter versus Last QuarterWhat is an Item’s Expense contribution to its Category? 3MarketTimeCopyright 2013, Vlamis Software Solutions, Inc.Data stored in dense arraysOffset addressing – no joinsMore powerful analysisBetter performance

OLAP Is Fast For Dimensional Queries Dimensions are natural indexes to data Dimensions are natural way to look at data By, across, over, down – prepositions are often dimensions Handles multiple levels easily – embedded totalhierarchies Inter-row calcs are easy Share, index Yr/yr or prior period comparison MovingtotalCopyright 2013, Vlamis Software Solutions, Inc.

Dimensions Are Key to OLAP Model OLAP good at unpredictable query pattern if query fitsdimensions of data Don’t confuse limitations of pre-calculated data withlimitations of OLAP If filter invalidates OLAP, likely invalidates summarytable logic Example: Sales by Region (easy) Hard: Sales by Region for stores open 1 yr If demand ultimate flexibility, must calc on the fly andperformance will be a problem if accessing lots of dataCopyright 2013, Vlamis Software Solutions, Inc.

Analytics Made EasyCalculations include: Time-series Comparison to peers (i.e.share) Alerts (uncover issues atlevels below currentselection) Statistical Forecasts and multiple layers ofnested calculations at any level of detailCopyright 2013, Vlamis Software Solutions, Inc.

Highlights from Gartner’s BI Magic QuadrantReport 2012 BI and Analytics named as “Top Priority” for 2012 “Organizations continue to turn to BI as a vital tool forsmarter, more agile, and efficient business.” OBI has highest aggregate “Ability to Execute” score. Broadest global deployment score Average user population nearly 3000 Average data volumes nearly 5 TerabytesBelow average complexity scores(mostly used for static reporting)Below average ease of use scoresOBI has low “data discovery” scoreCopyright 2013, Vlamis Software Solutions, Inc.

Hierarchical Reporting Hierarchical Columns can be put in Table or PivotTable views Can be mixed with other column types Drag and Drop rearrangement supportedCopyright 2013, Vlamis Software Solutions, Inc.

Trellis View - Simple Single type of inner visualizationCommon synchronized scale across all graphsHas scale showing by default (can turn off)Lots of graph types Vertical BarHorizontal BarLineAreaLine-BarPieScatterBubbleCopyright 2013, Vlamis Software Solutions, Inc.

Trellis View - Advanced Pivot table with numbers or graphs in cellsEach microchart has its own scale and not shownMost often used to see trend linesNo axis description, so across should be timeCan have different visualizations for different measures Spark bar Spark line Spark area numbersCopyright 2013, Vlamis Software Solutions, Inc.

Oracle Test Drive Free to try out Oracle BIGo to www.vlamis.com/testdrive-registration/Runs off of Amazon AWSHands-on Labs based on Collaborate 2012 HOLsTest Drives for: Oracle BIBI PublisherMicrosoft Excel against Oracle OLAPOracle Data Mining Once sign up, you have private instance for 5 hours Available nowCopyright 2013, Vlamis Software Solutions, Inc.

Simba MDX Provider Opens Doors Oracle OLAP uses SQL as query languagePredominant query language for OLAP front ends is MDXSimba translates MDX into SQLEnables many MDX-based products to work against OracleOLAP Not all MDX is the same—may require some tweaks Can often fool products by telling them back end is MSAnalysis Server XML/A provider allows for even more BI front ends Cognos Business Objects Many moreCopyright 2013, Vlamis Software Solutions, Inc.

Simba MDX Provider to Oracle OLAP Client applications talkMDX Simba translates to SQL Simba MDX Provider isOracle’s recommendedsolution for connecting BIapplications to OracleOLAP data sources Provides live access todata without replicatingfrom OLAP cubesCopyright 2013, Vlamis Software Solutions, Inc.Client application

Front ends enabled by MDX and XML/A Microsoft ExcelExcel ServicesArcplanDeltaMasterTableauBusiness ObjectsCognosMicrostrategyLogiXMLLots of others to try outCopyright 2013, Vlamis Software Solutions, Inc.

arcplan HQ in Dusseldorf, Germany. US base in Philadelphia. Works with multiple back ends including Oracle OLAPvia Simba MDX Provider Flexible development tool for developing customscreens Many products in suite of products Showing arcplan EnterpriseCopyright 2013, Vlamis Software Solutions, Inc.

arcplan Differentiators One integrated platform for all of your BI needs, including dashboardsand reporting; budgeting, planning and forecasting; ad-hoc reporting;and mobile BI. Offers powerful analysis and visualizationcapabilities that are too complex for other BIsystems (e.g. Pareto/80-20 analysis) Leverages your existing infrastructure,making it easy to report off of Oracle andnon-Oracle data sources. The #1 front-end to Oracle for the second year in a rowaccording to the world's largest survey of BI users (The BI Survey 10, 2011). Enables easy report and dashboard creation and a user-friendlyinterface for even casual users.Copyright 2013, Vlamis Software Solutions, Inc.

arcplan 7Comm. Interfaces & Standards IBM - IBM Cognos TM1, IBM DB2, IBM InfoSphere Cubing Services Microsoft - Microsoft SQL Server, Microsoft SQL Server Analysis Services,Microsoft Sharepoint Oracle - Oracle RDMBS, Oracle Essbase, Oracle Hyperion Enterprise,Oracle Hyperion Financial Management, Oracle OLAP MDX (via SimbaTechnologies) Paris Technologies - PowerOlap SAP - SAP BI, SAP BI-Integrated Planning (SAP BI-IP), SAP R/3, SAP Query,SAP HANA, SAP NetWeaver Portal, NetWeaver certified Teradata - Teradata OLAP Connector Other vendors - Infor PM OLAP Server (former Alea), MIK OLAP,Software AG Adabas Standards - All ODBC compliant databases, All OLE DB compliant databases,OLE DB for OLAP, XML/A, XML, XBRL, Web services (SOA), LDAPAs of: arcplan version 7.1.1Copyright 2013, Vlamis Software Solutions, Inc.TechnologyPartners

DeltaMaster Available from BissantzHQ in Nuremburg, GermanyWorks with multiple back endsAvailable from resellers such as Vlamis SoftwareIntegrated software for various experience levels Report recipients Adhoc users and builders Analysts Advanced visualizations Focus on business users Preconfigured reports / analysis templatesCopyright 2013, Vlamis Software Solutions, Inc.

Analysis methods need to be preconfigured. and freely combinable by business end users

Data-dense visualization. enables comparisons which allow for more analyses

Integration of automation and visualization. allows the business end user to dig-in deeply into data warehousesDrag&Drop

User and licence pyramidFunctionality and license offers for every target groupIReport recipientII“Activeenquirer”IIIData analysis expertcorporate analystplanning expertUsergroupLicence levelNumber of usersData mining modules (e.g. market basketanalysis or profiling) and geographical analysesMiner ExpertMiner ProfessionalDescriptionfewKPI cockpit with automated pool of methodsfor analytical planning and reportingAnalyzerAutomated methods for basic ad hocbusiness analyses and reportingPivotizerOLAP analysis techniques combined withcontext-related visualization, definition ofcalculated measures and basic reportingViewerFlexible view definition for standardreportsOnline ReaderReceiving and viewing standard reportswith live database connectionOffline ReadermanyReceiving and viewing standard reportswithout database connection

Summary BI Data is best stored in multi-dimensional databaseOracle Database EE already has cubes–Oracle OLAPOracle OLAP can work with multiple front endsOracle OLAP works with any product that issues SQLSimba MDX provider translates MDX to SQLMDX enables many front end products Arcplan Bissantz DeltaMaster Many others, including using XML/ACopyright 2013, Vlamis Software Solutions, Inc.

Questions? More information on: Vlamis Software: www.vlamis.com, dvlamis@vlamis.com Oracle BI Test Drive: www.vlamis.com/testdrive-registration/ IOUG: www.ioug.org BIWA: www.oraclebiwa.org Oracle BI SampleApp: /obiee-samples-167534.html Simba: www.vlamis.com/simba Excel: http://office.microsoft.com/en-us/excel/ Bissantz DeltaMaster: ts/ Arcplan: /enterprise/Copyright 2013, Vlamis Software Solutions, Inc.

Essbase vs. Oracle OLAPEssbaseOracle OLAP Separate server Built into Oracle DB List price* 184K/CPUSeparate adminAdminister by LoBMust build cubesPart of middle tierExcellent writebackQuery via MDX, XML/AList price* DB 23K/CPUAdmin same as Oracle DBAdminister by ITMust build cubesPart of server tierLimited writebackQuery via SQL (now MDX)* tmlCopyright 2011, Vlamis Software Solutions, Inc.

IBM - IBM Cognos TM1, IBM DB2, IBM InfoSphere Cubing Services Microsoft - Microsoft SQL Server, Microsoft SQL Server Analysis Services, Microsoft Sharepoint Oracle - Oracle RDMBS, Oracle Essbase, Oracle Hyperion Enterprise, Oracle Hyperion Financial Management, Oracle OLAP MDX