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
