Data Warehouse

15 Feb 2017

Understanding Data Governance: Tools, Documents, Processes, and People

By | February 15th, 2017|Categories: Advisory, Business, Information Management|Tags: , , , , , , , |

Data governance is a common need across organizations, and can be a very challenging subject to tackle. Understanding data governance's components, what good governance looks like, and the drivers behind adopting it is essential to creating a successful governance effort. What Is Governance? Governance (more specifically, data governance) is a discipline for managing all aspects [...]

21 Jun 2016

Agile Data Warehousing with Spark

By | June 21st, 2016|Categories: Information Management, Infrastructure, Strategy & Innovation|Tags: , , , , , , |

Data discovery is a “new” technique that takes a less formal and more agile approach to analyzing data. Okay, well, it’s not really new -- people have been doing this with spreadsheets for decades -- but the products that support it have improved greatly and have forced a more formal consideration of these techniques. The [...]

29 Apr 2016

Crunching Web Logs with Spark: Handling Your Site’s Big Data

By | April 29th, 2016|Categories: Data Science, Information Management, Proven Practices|Tags: , , , , , |

Don’t think you have big data?  Chances are you do.  The fact is if you have a website, you have big data.  Web servers capture and store events related to user traffic.  The web logs they generate essentially tell the story of what users did when they visited your site.  This information can provide your [...]

1 Dec 2015

Industry Case Study: Modernizing the Data Warehouse for Finance IT

By | December 1st, 2015|Categories: Case Studies, Information Management, IT|Tags: , , , , , |

As you've seen in some of our previous articles about the financial services industry, there's a lot that goes on behind the scenes to enable financial services firms to gain new customers and provide accurate investment advice.  What matters most, though, is that the technology powering all the fund transactions, client correspondence, market analytics, and sales [...]

30 Sep 2015

Ironside Webinar Series: Exploring Data Warehouse Strategies

By | September 30th, 2015|Categories: Business Solutions, Information Management, Webinars|Tags: , , , |

On September 24th, Ironside hosted a webinar on Exploring Data Warehouse Strategies.   You will hear from our experts on different data warehouse strategies for traditional and emerging solutions.  Whether traditional, hybrid, or cloud-based, this webinar will give you insight on finding the best data warehouse option for your business. Topics covered included: Data Moving into the [...]

2 Feb 2015

Top 5 Trends in Cloud Data Warehousing and Analytics for 2015

By | February 2nd, 2015|Categories: Advisory, Information Management, Strategy & Innovation|Tags: , , , , , |

In 2014, cloud data warehousing services led the information management category in increased adoption rate, jumping from 24% to 34% according to surveys by Information Week [1]. For organizations challenged by data urgency needs that can be difficult to meet with traditional data warehouse infrastructures, cloud services offer an alternative that can provide value at [...]

29 Aug 2014

Data Warehousing Basics

By | August 29th, 2014|Categories: Advisory, Information Management, Proven Practices|Tags: , , , |

Cognos makes extensive use of data warehousing concepts. Most data warehouses are built using dimensional modeling techniques (also known as the “Kimball style”). Data is divided into fact and dimension tables, which are joined together in star schemas. Restructuring data in this fashion takes a great deal of effort, both in planning and implementation. These types of changes are only done because they are necessary for high-quality analytics. Understanding more about how they work and why they are important can help make Cognos a more efficient and effective reporting tool. […]

1 Oct 2013

Netezza – Design Best Practices & Guidelines

By | October 1st, 2013|Categories: Advisory, Information Management, Proven Practices|Tags: , , , , , , |

Today’s big data challenges for both transactions and analytics are increasing demands on data systems. Traditional data warehouses sometimes struggle as they are often NOT designed to meet the demands of advanced analytics on big data. That's where solutions like Netezza come in. IBM PureData for Analytics (formerly Netezza) is a data warehouse appliance that [...]

28 Aug 2013

Success by Design: Planning Your Information Management Infrastructure

By | August 28th, 2013|Categories: Advisory, Information Management, Strategy & Innovation|Tags: , , , , |

Planning an information management infrastructure is a fun and exciting activity for everyone, whether they work with information systems or not. What? It isn't? Then why are so many people building information management infrastructure solutions in Access and Excel? That's not IM you say? Well in a way it is, though we can agree that it [...]

Load More Posts