Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Data Management
Previous Previous
 
Next Next
New Post 12/26/2014 3:54 AM
User is offline NitWitNick
259 posts
5th Level Poster


Re: Data Management 

"The next most important think to remember is that holding data beyond it's useful life is a business risk."

Depends where you are ... 

When I did a Bank Merger, all the data each bank had from basically day one to some current date was put into a Data Warehouse as an "active archive". Every month the current database was checked and any data longer than a certain time period was moved to that "active archive".

A data warehouse is usually one of the largest databases a company has. They cost money to maintain, back-up, restore, pushing data across networks, disk space, time to data-mine and produce reports, etc.

 
New Post 2/15/2015 2:53 PM
User is offline vlookup
39 posts
9th Level Poster


Re: Data Management 

Good thread, nice to see different takes.  

I think the biggest risk is the controls around the data in which it's input and output (GIGO).  Having clean ETL's into your database / data warehouse is critical.

Having Bob the DBA running complex joins over and over again with no controls to update different pieces of the data is RISKY.  Of course poor design is critical as well, knowing when to index, which tables to backup, architecture in general is critical.  

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  Data Management

Community Blog - Latest Posts

Fabricio Laguna talks Business Analysis and AI
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC