<< VIEW FULL RESOURCE LIBRARY

Shedding Light on Cloud BI Options

April 11, 2019

Analytics Demystified, Cognos Analytics (v11), Microsoft, Tableau

Amazon. IBM Cognos Cloud. Microsoft Power BI Service. Tableau Online. Azure.

Which cloud service do you choose? And should you be moving your BI to the cloud in the first place? We shed much needed light on this confusing subject, along with pros, cons and important considerations.

During this recorded webinar, we discuss

  • Public vs. private vs. hybrid cloud
  • Cloud vendor
  • BI vendor cloud offerings
  • Cloud challenges 
▼ PRESENTER

Todd Schuman
Practice Lead – Installations, Upgrades and Performance Tuning
Senturus, Inc.

Todd has a finely-honed understanding of BI platforms, developed in the 17+ years he has been an architect and consultant across a range of industries. He is particularly well versed in platform optimization and installation. Todd heads up the installation, upgrade and performance tuning practice for Senturus.

▼ PRESENTATION OUTLINE 1

  • What is the cloud?
    • The cloud is not new—it’s simply a technical term and a fancy way of saying stuff that’s not on your computer but is stored on a server somewhere
  • Why cloud?
    • “The worldwide public cloud services market is projected to grow 17.5 percent in 2019 to total $214.3 billion, up from $182.4 billion in 2018.” -Gartner 2019
  • Revenue forecast
    • 2020 = $110.5 billion
    • 2021 = $126.7 billion
    • 2020 = $143.7 billion
  • Cloud benefits
    • Flexible costs
    • Fresh software
    • High availability
    • Cost effective
    • Flexible capacity
    • Improved collaboration
    • Improved mobility
  • Compliance

Public vs. private vs. hybrid

  • Public cloud
    • Hardware, software owned by cloud provider
    • Share hardware, storage, network resources with other organizations or cloud “tenants”
    • Access via browsers
    • Advantages
      • Lower cost
      • Low maintenance
      • High scalability
      • High reliability
    • Private cloud
      • Exclusive to one business or organization
      • Can be located at company on-site data center or by third party service provider
      • Maintained in private network
      • Dedicated hardware and software
      • Advantages
        • More flexibility
        • Improved security
        • High scalability
      • Hybrid cloud
        • Best of both worlds
        • Applications in public cloud
        • Data in private cloud
        • Advantages
          • Total control
          • Flexibility
          • Cost effective
          • Ease

Cloud vendors

  • Amazon basics–AWS Infrastructure-as-a-Service (IaaS)
    • Offerings
      • Content storage and delivery
      • Compute
      • Networking
      • Database
    • AWS Security and Identity Services
      • AWS Certificate manager for managing SSL/TLS certificates
      • AWS CloudHSM for hardware-based key storage and management
      • Amazon CloudWatch for infrastructure resource use monitoring
      • AWS Cloudtrail for tracking user activity and API use
      • AWS config for tracking resource inventory and changes
    • Benefits
      • Global coverage and number of data centers
      • Toolsets
      • AWS developer tools
        • CodeCommit, CodePipeline, CodeBuild, CodeDepoly
      • Analytics tools
        • Athena – S3 data
        • EMR – HADOOP
        • QuickSight for business analytics
        • RedShift – petabye-scale data warehouse
        • Glue – ETL
        • Data pipeline – move data

▼ PRESENTATION OUTLINE 2

  • Azure basics
    • Offerings
      • Data management/databases
      • Compute
      • Networking
      • Performance
    • Azure Security and Identity Services
      • Active Directory Federation Services
      • Azure Active Directory
      • Multi-factor auth
      • Role-based access for cloud-based security
    • Benefits
      • Microsoft Enterprise
      • Azure migrate
        • Evaluates on-premise environment
        • Informs if on-premise apps are suitable for migration to Azure
        • Estimate size and cost of Azure virtual environment
        • Integrates with Azure Database Migration Service
      • Built for hybrid cloud
        • Allows on-premise servers into Azure environment with Azure Stack
      • Other considerations
        • Costs/existing licenses
        • Migration complexity
        • Microsoft shops more inline with MS Stack
        • Amazon is more multi-platform/open source

BI vendor cloud offerings

  • IBM Cognos Cloud
    • Details
      • 2 options
        • Multi-tenant (public)
        • Single-tenant (private)
      • SoftLayer data center
    • Benefits
      • Installed/upgraded by IBM
      • Rent, no need to buy servers
      • Content Store hosted/maintained by IBM
    • Challenges
      • DQM only
      • Reduced feature set
      • No access to server
      • Storage limits
      • Additional servers for DEV/QA/sandbox come at additional cost
      • Must upgrade 2 times a year
  • Tableau Cloud
    • Details
      • 2 options
        • Public
        • Online
      • AWS
    • Benefits
      • Installed/upgraded by Tableau
      • Rent, no need to buy servers
    • Challenges
      • On-prem data requires Tableau Bridge
      • No access to server
      • Additional servers for DEV/QA/sandbox come at additional cost
      • Local auth only, SSO requires SAML
      • Storage limits (extracts?)
  • Microsoft Power BI Service (cloud)
    • Details
      • Part of Azure
    • Benefits
      • Latest updates from Microsoft (monthly)
      • Rent, no need to buy servers
      • Access cloud and on-prem
    • Challenges (on-prem)
      • 2-3 Updates per year
      • Unable to create Power BI reports in the browser
      • Dashboard not available
      • Analyze in Excel not available
      • Email subscriptions not available
    • Challenges
      • Data access
        • Loading data into the cloud
        • Setup VPN tunneling to on-premise data sources
        • Need for server/DBA to allow external connections and open ports
      • Security
        • Configure SAML($), OpenID, ADFS, etc.
        • Possible namespace/authentication migration
      • Automation
      • Data latency
        • Bandwidth
      • Costs