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 | Sep 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases, Enterprise Infrastructure
20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don’t remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...
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 Kathleen Long | Feb 27, 2015 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
Not all data will come from a SQL Server database when you are creating reports in SSRS. There will be times you will need to create a data source to .CSV files, Excel spreadsheets, and MS Access databases. Recently, I had a customer request setting up sample data...
by Kathleen Long | Dec 8, 2014 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...
by XTIVIA | Oct 31, 2014 | Blog, Data Management, Data Warehousing
So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms – Basically means that you created a...
by CRM Team | Oct 22, 2014 | Blog, Business Intelligence, Customer Relationship Management, Data Warehousing, Perspectives
1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential techniques allow us to estimate and draw conclusions about populations from samples 2. Data can be formally categorized in three...
by XTIVIA | Sep 26, 2014 | Blog, Business Intelligence, Data Warehousing, Enterprise Infrastructure
Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you...
by CRM Team | Apr 29, 2014 | Blog, Business Intelligence, Customer Relationship Management, Data Warehousing
Occasionally we find ourselves in situations which do not meet the standard e.g. users placed in a directory tree a few levels deep or the distinguished name uses the common name which has spaces. Below are some tips on handling these situations. A useful tool to...
by XTIVIA | Feb 11, 2014 | Blog, Business Intelligence, Data Warehousing, Databases, Perspectives
This is an important question that anyone responsible for a data warehouse should ask periodically and with some frequency as well. The following table will give you some concrete ideas on what to look for and how to use the metrics. The details of how you collect...
