Logo Logo Logo Logo
Menu
  • About Us
    • About Stridely
    • Global Partners
    • Engagement Models
    • Execution Model
    • Quality of Service
  • Services
    • Digital Services
      • Enterprise Mobility
      • Application Development
      • Dot Net Development Services
      • Enterprise Application Integration
      • Robotic Process Automation
      • IoT Platform Development
    • BI Analytics & Big Data
      • Business Intelligence
      • Predictive Analytics
      • Data Warehousing
      • Big Data
    • ERP Services
      • ERP Implementation and Support
      • SAP Consulting
      • Microsoft Dynamics
      • Oracle ERP
      • Enterprise CRM
      • Human Capital Management
    • Application Mordernization
      • Legacy Application Migration
      • Application Re-Platforming
      • Cloud Migration
    • Managed Services
      • Operations Support & HelpDesk
      • IT Infrastructure Management
      • Accounting And Finance
    • Testing
      • Automation
      • Manual
      • Device Testing
      • Security Testing
  • Technologies
    • Microsoft
      • Power Platform
      • .Net Core
      • .NetMVC
      • BizTalk
      • SharePoint
    • SAP
      • SAP Cloud 
      • SAP Business One
      • ECC & S/4HANA
      • SAP RFID
    • Oracle
      • Oracle ADW
      • Oracle ODI
      • Oracle Apps R12
      • Oracle JDE
    • Integration Platform
      • PAAS
      • IPAAS
      • SAAS
    • Emerging Technologies
      • BLE Apps
      • RPA Technology
      • IoT (Azure IoT)
      • Machine Learning
    • Analytics & Visualization
      • Power BI
      • Tableau
      • QlikView
      • SAP BI
      • Oracle BI
      • Ms Core BI
      • Microstrategy
    • Cloud
      • Azure
      • AWS
      • DevOps
    • Database
      • My SQL
      • MS SQL
      • Oracle
    • Mobile
      • iOS
      • Android
      • Xamarin
    • Js Framework & Frontend
      • Angular JS
      • React JS
      • Vue JS
      • Node JS
      • HTML5 & CSS3
  • Business Solutions
    • Microsoft Dynamics Field Service
    • Dynamics CRM
    • Account Receivable Tool
    • Unified IoT Platform
  • Career
    • Life @ Stridely
    • Current Openings
    • Submit Resume
  • Resources
    • Blog
    • Case Studies
    • News & Events
    • Whitepapers
    • Presentations
    • Webinar
  • Contact Us
Menu
  • About Us
    • About Stridely
    • Global Partners
    • Engagement Models
    • Execution Model
    • Quality of Service
  • Services
    • Digital Services
      • Enterprise Mobility
      • Application Development
      • Dot Net Development Services
      • Enterprise Application Integration
      • Robotic Process Automation
      • IoT Platform Development
    • BI Analytics & Big Data
      • Business Intelligence
      • Predictive Analytics
      • Data Warehousing
      • Big Data
    • ERP Services
      • ERP Implementation and Support
      • SAP Consulting
      • Microsoft Dynamics
      • Oracle ERP
      • Enterprise CRM
      • Human Capital Management
    • Application Mordernization
      • Legacy Application Migration
      • Application Re-Platforming
      • Cloud Migration
    • Managed Services
      • Operations Support & HelpDesk
      • IT Infrastructure Management
      • Accounting And Finance
    • Testing
      • Automation
      • Manual
      • Device Testing
      • Security Testing
  • Technologies
    • Microsoft
      • Power Platform
      • .Net Core
      • .NetMVC
      • BizTalk
      • SharePoint
    • SAP
      • SAP Cloud 
      • SAP Business One
      • ECC & S/4HANA
      • SAP RFID
    • Oracle
      • Oracle ADW
      • Oracle ODI
      • Oracle Apps R12
      • Oracle JDE
    • Integration Platform
      • PAAS
      • IPAAS
      • SAAS
    • Emerging Technologies
      • BLE Apps
      • RPA Technology
      • IoT (Azure IoT)
      • Machine Learning
    • Analytics & Visualization
      • Power BI
      • Tableau
      • QlikView
      • SAP BI
      • Oracle BI
      • Ms Core BI
      • Microstrategy
    • Cloud
      • Azure
      • AWS
      • DevOps
    • Database
      • My SQL
      • MS SQL
      • Oracle
    • Mobile
      • iOS
      • Android
      • Xamarin
    • Js Framework & Frontend
      • Angular JS
      • React JS
      • Vue JS
      • Node JS
      • HTML5 & CSS3
  • Business Solutions
    • Microsoft Dynamics Field Service
    • Dynamics CRM
    • Account Receivable Tool
    • Unified IoT Platform
  • Career
    • Life @ Stridely
    • Current Openings
    • Submit Resume
  • Resources
    • Blog
    • Case Studies
    • News & Events
    • Whitepapers
    • Presentations
    • Webinar
  • Contact Us

Blog

Home / Resources / Blog / Do we really need a Data hub for BI
Home / Resources / Blog / Do we really need a Data hub for BI

Do we really need a Data hub for BI

18 May, 2018

Do we really need a Data hub for BI

So now when you have chosen a platform for Business Intelligence: flexible, usable, manageable, scalable: getting all these great abilities in one package. Soon you’ll integrate, visualize and collaborate across the company as never before. A consistent view of the data is in your hand. You can see the end of spreadsheet hell. With no more complaints about compliance.

But as usual it never quite works that way, does it? Your carefully crafted architecture strains to hold together from the first day of deployment.

At 9pm, the night before the quarterly business review, with numbers to crunch and new charts yet to create, your sales team is still reaching for Excel rather than your cool BI tool. Convenience wins over compliance, and years of choosing Excel makes easy choice. Nor should you think this scenario a bad thing: people are working hard in your company to get things done.

Elsewhere in your organization, an expert needs just that one visualization your BI tool lacks. Or that data source. Or that algorithm. Soon enough, there will be one more tool for you to manage when you find out about it, belatedly. It will be a little more specialized and gaining a foothold.

Data hub- The BI Architecture

We can however design an architecture to deal with change from it. And to do so, your aim should be to insulate systems from breaking changes while enabling simple integration and rapid development of new designs.

Users might access the underlying data models from a wide variety of tools, even the latest cool BI visualizations. Architects might add new sources to the data warehouse or even new subject areas following a merger. Administrators maintain the authority of the data by strict quality controls.

There are been certain myths about Data warehouse automation. Yet a data warehouse such as this seems unlikely to be your answer either. No doubt the architecture can live on, for certain subject areas where absolute control of the process is more important than flexibility.

For your other use cases such as marketing, supply chain, sales analysis and production, a data hub will more likely meet your needs.

A hub integrates with just as many sources and clients as a data warehouse. In the late hours, your users may go for Excel rather the BI platform, but they source data from your hub as easily as from any other Excel table and that is the benefit.

As per my experience, whether working on SQL Server, PowerPivot or Qlik, data architectures work best when they meet the real world needs of an evolving environment and a changing toolset. I like hubs for that reason, and with automated development, I Love them even more.

Search by categories

Reset Categories
  • Subscribe to our email newsletter for useful technology insights.
  • Our Resources

    Explore our hub of resources across different industries for real-life

    • MICROSOFT GOLD PARTNER
    • SAP GLOBAL PARTNER
    • ORACLE PARTNER
    • AUTOMATION ANYWHERE
    • SECURITY WEAVER
    • ISO CERTIFIED
    • ISO CERTIFICATION 27001:2013

    Technologies

    • Microsoft
    • SAP
    • Oracle
    • Emerging Technologies
    • Cloud
    • Database

    Services

    • Enterprise Mobility
    • BI Analytics & Big Data
    • ERP implementation & Support
    • Microsoft Dynamics
    • Human Capital Management
    • Legacy application migration
    • Quality Assurance
  • Copyright © 2021. Stridely Solutions. All Rights Reserved.  |  Privacy Policy |  GDPR Policy
    • linkedin
    • facebook
    • twitter
    • instagram
    • youtube
  • X

    Continuous Support amid Corona Pandemic


    In this unprecedented time of Coronavirus (COVID-19) outbreak, we are sure that we can continue operations regardless of any contingency with all the equipment and technologies to provide continual and uninterrupted support and services to our valuable customers.

    Read More



    In this unprecedented time of Coronavirus (COVID-19) outbreak, we are sure that we can continue operations regardless of any contingency with all the equipment and technologies to provide continual and uninterrupted support and services to our valuable customers. We are still committed to our customers to provide valued services irrespective of time and locations.


    Stay Safe, Stay Healthy!

    Stridely Solutions


    Privacy & Cookies Policy

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
    Necessary Always Enabled

    Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

    Non-necessary

    Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.