By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    predictive analytics in dropshipping
    Predictive Analytics Helps New Dropshipping Businesses Thrive
    12 Min Read
    data-driven approach in healthcare
    The Importance of Data-Driven Approaches to Improving Healthcare in Rural Areas
    6 Min Read
    analytics for tax compliance
    Analytics Changes the Calculus of Business Tax Compliance
    8 Min Read
    big data analytics in gaming
    The Role of Big Data Analytics in Gaming
    10 Min Read
    analyst,women,looking,at,kpi,data,on,computer,screen
    Promising Benefits of Predictive Analytics in Asset Management
    11 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Automate the Boring But Essential Parts of Your Data Warehouse
Share
Notification Show More
Latest News
ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence
How Big Data Is Transforming the Maritime Industry
How Big Data Is Transforming the Maritime Industry
Big Data
Aa
SmartData Collective
Aa
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
Last updated: 2015/08/13 at 1:14 AM
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

ai software development

Key Strategies to Develop AI Software Cost-Effectively

AI is Driving Huge Changes in Omnichannel Marketing
Maximize Tax Deductions as a Business Owner with AI
Marketers Use AI to Take Advantage of 3D Rendering
Top Five AI-Driven Digital Marketing Tools in 2023
  • “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.

Keith Peterson August 13, 2015
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

ai software development
Key Strategies to Develop AI Software Cost-Effectively
Artificial Intelligence
ai in omnichannel marketing
AI is Driving Huge Changes in Omnichannel Marketing
Artificial Intelligence
ai for small business tax planning
Maximize Tax Deductions as a Business Owner with AI
Artificial Intelligence
ai in marketing with 3D rendering
Marketers Use AI to Take Advantage of 3D Rendering
Artificial Intelligence

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

ai software development
Artificial Intelligence

Key Strategies to Develop AI Software Cost-Effectively

10 Min Read
ai in omnichannel marketing
Artificial Intelligence

AI is Driving Huge Changes in Omnichannel Marketing

12 Min Read
ai for small business tax planning
Artificial Intelligence

Maximize Tax Deductions as a Business Owner with AI

9 Min Read
ai in marketing with 3D rendering
Artificial Intelligence

Marketers Use AI to Take Advantage of 3D Rendering

7 Min Read

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

giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?