by CRM Team | Aug 9, 2016 | Blog, Customer Relationship Management
Customer Relationship Management (CRM) will provide a 360-degree view of your customer, especially when integrated to back-end systems such as your ERP, sales, or e-commerce systems. Read on for these CRM Best Practices. By implementing the 5 Best Practices of...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
by XTIVIA | Dec 9, 2015 | Blog, Business Intelligence, Data Warehousing, Perspectives
What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it. Imagine business teams...
by XTIVIA | Jul 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases
SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the...
by XTIVIA | Oct 7, 2013 | Blog, Business Intelligence, Databases
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two...
by XTIVIA | May 7, 2013 | Blog, Business Intelligence
Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Absolutely! The reports from Gartner are great (at least from my perspective) and there is a lot of useful information in them. I found the latest one particularly engaging. As I read through the report, I started thinking about what it means to us (as practitioners...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Two bits of Information I picked up from our principal Informatica Architect. When I used these, it did really work wonders. Aggregators and joiners should have sorted input. The Sorter Transformation sorts rows more efficiently that the Aggregator...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence, Data Warehousing
Lately, we at XTIVIA have seen a marked uptick for interest in open source ETL tools. Each customer situation is unique, but I would like to propose a few factors that you should review before making the decision: Incumbent Tool Set: Decisions around your choice...
by XTIVIA | Jul 30, 2012 | Blog, Business Intelligence, Data Warehousing
We get quite a few questions around Dashboards and Scorecards. I think it is good to enumerate the differences between the two so that when you are ready to implement you don’t lose sight of the differences. So, without further ado, here are the differences that...
