Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Automate the Boring But Essential Parts of Your Data Warehouse
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Automate the Boring But Essential Parts of Your Data Warehouse
AnalyticsBusiness IntelligenceData ManagementData MiningData QualityData VisualizationData WarehousingDecision ManagementPredictive AnalyticsRisk ManagementSoftwareUnstructured Data

Automate the Boring But Essential Parts of Your Data Warehouse

Keith Peterson
Keith Peterson
5 Min Read
SHARE

If you are in IT and responsible for your company’s data warehouse and reporting capabilities, chances are you will identify with at least one of these statements:

If you are in IT and responsible for your company’s data warehouse and reporting capabilities, chances are you will identify with at least one of these statements:

More Read

Executive Involvement Helps Ensure Intranet Success
How Big Data Analytics Benefits Bitcoin & Other Cryptocurrencies
Can Analytics Make Your Work More Fun?
Big Data Makes the Super Bowl a Personal Experience
First Look – Mobile Agent Technologies
  • “We are too buried with maintaining our existing database to take on new initiatives”
  • “We need to get out of the report writing business”
  • “We cannot give you that information from the data warehouse without a lot of development”
  • “It’s too hard to make changes to our existing process because it breaks too easily”
  • “That new data source doesn’t fit in our existing data model and we can’t extend it” 

If so, then you may be an ideal candidate for Data Warehouse Automation (DWA). Companies realize that data warehouses are not going to be replaced by Hadoop or in-memory solutions.  A 2014 Gartner survey found that only 3% of IT leaders believe that big data or in-memory systems can replace their existing data warehouse infrastructure. That’s a dramatic drop over recent years.  As such, DWA is getting a fresh look as a better way to build and manage a data warehouse.

Until recently, DWA was associated mostly with automating ETL development – such as generating SSIS packages in the Microsoft environment.  Today, however, it covers all the major components of data warehousing from design, development and testing to deployment, operations and change management.  It also covers advanced functionality like support for slowly changing dimensions and change data capture.

In our experience, DWA delivers up to 80% improvements in the cost-effectiveness of building and running a data warehouse.  And, just as important, DWA is far better aligned with modern agile development practices because it encourages a rapid, iterative approach to design.

The benefits of automation are profound for IT organizations.   Developers and DevOps teams see greater efficiency in the development and maintenance phases of the data warehouse lifecycle through a number of advantages: 

Data Warehouse Development

Data Warehouse Operations

 

  • Greater productivity for developers means more delivered in less time
  • Consistency of practices and standards leads to the development of more maintainable systems
  • Automation means increased support for agile development practices
  • Standardized testing processes supports QA cycles
  • Simpler development and prototyping makes it easier to respond to changing requirements
 
  • Maintenance processes are simplified and packaged to reduce manual effort
  • Documentation is generated automatically and kept current with releases
  • Assess impact of proposed DW changes using enhanced metadata capabilities
  • Add enterprise features to basic data warehouses to increase DW lifespan
  • More robust, standard processes leads to a more stable environment

DWA is commonly criticized by vendor competitors as being either 1) “the wrong approach” compared to in-memory; or 2) not as effective as hand-crafted, custom database development approaches.  Both arguments are purist and too simplistic. In-memory has tremendous analytical benefits but is lacking in support for data governance, single source of truth, and performance.  Customization is almost always needed for business critical tasks – but not for the more common routine and repetitive uses.  Custom development is more error prone than DWA, and much harder to maintain over the long run. 

Automation does not mean excluding in-memory analytical tools or precluding customization.  It means blending the best of the best to create a scalable, high performing solution at lower time and development cost.

Next Generation Data Warehouse

To deliver on your company’s future demands for data and insights, you will need to maintain your existing data warehouse – and add the great new capabilities available with big data management and in-memory analytics. The real opportunity is in making those technologies work together smoothly with minimum effort and risk.  That means continuing to automate the rote and routine parts of your developer’s daily task so they can focus on moving your organization to a higher level of development and value, and ultimately provide better access to the data that is valuable to the company.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive
data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

The Newest Market Research Trade Organization

4 Min Read

REvolution Computing welcomes Danese Cooper

2 Min Read
big data analyst
AnalyticsBest PracticesBig DataBusiness IntelligenceData ManagementJobsPolicy and Governance

The Big Data Analyst’s Skillset

5 Min Read

Email Gaining Ground, Says Forrester

4 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai is improving the safety of cars
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence
AI chatbots
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
Chatbots

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?