Transcription

Data Modeling Comparison:Tableau, Power BI & CognosThe Trifecta Chronicles1

GoToWebinar control panelClick arrow to restorefull control panelSubmit questionsin this section2

To obtain this presentationVisit the Resource Libraryon the Senturus websiteto download this presentationand explore other assets:senturus.com/resources3

Agenda Introduction What is Modeling & Transformation Comparison demos Comparison summary and review Senturus overview Additional resources Q&A4

IntroductionMichael WeinhauerDirector of Training and ContentSenturus, Inc.5

PollWhich BI platforms do you currently use? (select all thatapply) Tableau Power BI Cognos Other6

BI design stagesSourceModel &transformVisualizeVisualize& e &Publishcollaborate&Collaborate- Pin- Collaborate- Embed- AnalyzeSecureAdminister 2020 Senturus, Inc. Any reproduction or distribution of these materials is strictly prohibited7

Modeling & transformation definedCreating analysis-friendly data sets borate Joining, cleaning and otherwise “shaping” data Data warehouse myriad other - sourcesFilter- Slice- Interact- Drill-ConfigurePinCollaborateEmbedExportAnalyze Tools have capabilities to prepare and modeldata Roles are shifting towards self-service8

Demonstrations9

Source - Cognos Framework Managerclient Relational Multidimensional ODBC JDBC SAP XML Salesforce Data sets Other metadata sources10

Source - Cognos Framework Manager Relational Multidimensional Cloud SAP Teradata Salesforce Data sets Flat files XLS11

Source - Cognos data modulesExisting data modulesPre-configured databaseconnectionsFiles (Excel, CSV)Data setsPackages12

Source – Cognos options diagramData modulemodeling instead ofFMSummaries forperformanceOLAPFlat FilesCognos 11.1DatabasesIntegrate otherdata sourcesOther Sources13

Source – Tableau Relational Spatial Multidimensional JSON ODBC Python (TabPy) JDBC PDF SAP Application specific Flat files Live or extract Statistical14

Source – Tableau Prep Relational Multidimensional ODBC JDBC SAP Flat files Statistical PDF Application specific15

Source – Power BI Relational Statistical Multidimensional JSON ODBC PDF JDBC Python SAP Web URL Flat files SaaSapplications16

Model & transform – CognosFramework ManagerMulti-tier designNamespaces and folders used to organize “querysubjects”Allows for multiple layers of abstraction andorganizationModel dimensionally17

Model & transform – CognosFramework ManagerSet format, aggregations, data types, etc.18

Model & transform – CognosFramework ManagerResolve potentially complex design issuesJoin ambiguity and “loops”Recursive joinsMultiple logical hierarchiesFact-to-fact (many-to-many) joinsBlind spot queriesRole-playing dimensions19

Model & transform – CognosFramework ManagerApply package and object-level securitySet governorsSet query timeoutsAllow/disallow cross-product joinsAllow/disallow outer joinsSet large text item limits20

Model & transform – CognosFramework ManagerPublish packages for use by authors21

Model & transform – Cognos datamodulesSelf-service web-based modeling22

Model & transform – Cognos datamodulesCreate relationshipsFilter dataFormatSplitCleanChange data typeCreate hierarchiesDefine security*Combine sourcesOrganize“Intent” – AI/keyword search modelsuggestions23

Model & transform – TableauSingle pane (perdata source)View propertiesby selecting“describe”24

Model & transform – Tableau Splitting String fields can be split intomultiple fields for easier analysis Automatic or custom splitoptions Split based on a commonseparator Aliasing Roles – i.e., time (shipdate/order date) Binning (high/low sales) Renaming Data typing Geographic roles Calculations Pivoting Data interpreter Hierarchies – basic Time intelligence25

Model & transform – Tableau PrepVisual datapreparation toolAI/fuzzy logic drivenTableau-centric –currently outputsonly to flat file orextract26

Model & transform – Power BI queryeditor layout11 Ribbon (Home,Transform, etc.)2 Queries pane3 Query settings pane4 Data preview of table23427

Model & transform – Power BI queryeditor layout1 Query context menu2 Table context menu3 Column data type context menu4 Column context menu132428

Model & transform – Power BI dataviewInspectionExplorationUnderstanding29

Model & transform – Power BI modelviewBreak outcomplex modelsinto separatediagramsView and modifypropertiesSet display foldersto simplifynavigation30

Comparison of basic modeling &transformation capabilitiesTableau Desktop Tableau Prep Power BI Desktop Power BI Data Flows Cognos FM Cognos DMJoinUnionData iesComposite/federateCustom SQLStored procedures x x x * x* Calculation only31

Comparison of advanced modeling &transformation capabilitiesTableau Desktop Tableau Prep Power BI Desktop Power BI Data Flows Cognos FM Cognos DMRemove rowsReplace/cleanIntelligent gate awareScript (R/Python)Product Strength xx x x xx xxxxxx xxx xx **x ** Database sources only32

Comparison of other modeling &transformation capabilitiesQuery/storage optionsLineageAI/ML/Fuzzy Logic M&TVersion controlTableau Desktop Tableau Prep Power BI Desktop Power BI Data Flows Cognos FM Cognos DMLive/ExtractExtractDirect/import/hybrid Direct/import/hybridLiveLive/Data SetCatalogCatalogx xxxxxxx x Intentx33

SummaryLots of ways to get from point A to point BYou can probably get there with any of the toolsQuestion of, among other things:Analytics culture (self-service vs. centralized)SkillsetsTool choiceUse cases/business requirementsData source(s)34

Next steps Related resources Enterprise security: Tableau vs. Power BI Dashboarding Comparison: Power BI, Tableau & Cognos Training Tableau, Power BI & Cognos Ad hoc support On-demand support/bucket of hours35

The authority inBusiness IntelligenceExclusively focused on BI,Senturus is unrivaled in itsexpertise across the BI stack36

Bridging the data & decisioning gapBusiness needsDecisions & actionsAnalysis-ready data37

Full spectrum of BI services Dashboards, reporting and visualizations Data preparation and modern data warehousing Hybrid BI environments (migrations, security, etc.) Software to enable bimodal BI and platform migrations BI support retainer (expertise on demand) Training and mentoring38

A long, strong history of success 19 years 1300 clients 2500 projects39

Expand yourknowledgeFind more resourceson the Senturus website:senturus.com/senturus-resources40

Upcoming events Using New Cognos KPI Capability & Relative Time Structures Live demo and how-to of the best new features in Cognos Thursday, Jan. 23, 2020, 11am PT/2pm ET How to Share Power BI Datasets: Dataflows and Certified Datasets Demo and discussion of how to extend enterprise sharing in Power BI Desktop Thursday, Feb. 6, 2020, 11am PT/2pm ET41

Complete BI training offeringsTailored group sessionsMentoringInstructor-led online coursesSelf-paced learning42

Additional resources from SenturusUnbiased product reviewsTechnical tipsInsider viewpointsMore on this subjectProduct demosUpcoming events43

Q&A If your question or issueis broader than what weare able to answer today,contact us at [email protected] and we will set up afree consultation.44

Thank YouMichael [email protected] 264 8402www.senturus.com888 601 [email protected] 2020 by Senturus, Inc. This presentation may not be reused or distributed without the written consent of Senturus, Inc.

Source - Cognos Framework Manager. Existing data modules Pre-configured database connections Files (Excel, CSV) . Tableau Desktop Tableau Prep Power BI Desktop Power BI Data Flows Cognos FM Cognos DM Query/storage options Live/Extract Extract Direct/import/hybrid Direct/import/hybrid Live Live/Data Set