When our customers ask us what the best data warehouse is for their growing company, we consider the answer based on their specific needs. Usually, they need nearly real-time data for a low price without the need to maintain data warehouse infrastructure. In this case, we advise them to use…
Added by Luba Belokon on April 19, 2018 at 5:30am — No Comments
ETL stands for Extract, Transform, Load. It has been a traditional way to manage analytics pipelines for decades. With the advent of modern cloud-based data warehouses, such as BigQuery or Redshift, the traditional concept of ETL is changing towards ELT – when you’re running transformations right in the data warehouse. Let’s see why it’s happening, what it means to have ETL vs ELT, and what we can expect in the future.
ETL arose to solve a problem of…Continue
Added by Luba Belokon on April 6, 2018 at 7:30am — No Comments
It wouldn’t take a genius to notice the evolution of modern technology. In just the past ten years, we’ve watched the flip-phone transform into the smartphone and the automobile inch towards autonomy. Within our own space, we’ve noticed similar shifts, as the resurgent process of data virtualization is growing in importance within the larger data integration market. To further understand the nature of this shift, we take to Gartner:
Added by Amy Flippant on April 10, 2017 at 10:30am — No Comments
There really is no set amount of data that prompts the need for data warehousing. Some may become overwhelmed by the volume of data their company is producing, while other may become overwhelmed by the amount of data sources they need to integrate. To decide if you’re close to needing a warehouse, you can start by first gathering together your different data sources.
What really indicates you need some form of streamlined solution is when you must pull from these multiple…Continue
Added by Keith Cawley on August 5, 2014 at 11:23am — No Comments
Your custom MDM solution: Don’t make these mistakes (Part 1)
Most MDM implementations will be based on a commercial software product. By relying on a packaged solution, the architectural considerations have been addressed by the software vendor, allowing the project team to focus on the data management considerations. However, there are cases when a custom MDM solution may be needed. When proceeding down the path of custom development for MDM, we have some advice for you:…Continue
Added by Sullexis LLC on January 29, 2014 at 11:15am — No Comments
Added by Mitchell A. Sanders on October 29, 2013 at 1:30pm — No Comments
Understanding how data converts from data to information to intelligence can be seen in the flow across the databases in an enterprise. What is a data warehouse? How do we get Business Intelligence? In this video I explain the high level view of how large corporations like Dell evolve their data to the front-end BI applications.
Added by Mitchell A. Sanders on August 27, 2013 at 4:30pm — No Comments