Data blog — how to RSS

Create Excel baseline for your data

When you work with data, it is very useful to create a baseline to which you compare your data set. For example you can create the baseline from production data, and compare the results of a process you are implementing after the changes were introduced. This is a huge benefit for controlled environments: SelectCompare will highlight the changes in the output, and you don't have to query the production system anymore! Create Excel baseline from source data It is very easy to create a baseline in SelectCompare. When you create a project, write a query that will return the data you will want to use as the baseline. Use the required logic to extract the data that you need. Run the...

Continue reading

SQL Data Comparison - User Manual

You visit this page because you know how to write a SQL query. Learn how you can use your expertise to do your work better and save your time! The Idea The SelectCompare idea is very simple: write an SQL query to extract data to compare on each data source. With SelectCompare, you create comparison projects that define data connections to each of the data sources and you write SQL queries for these data connections. You can create data connections separately from comparison projects, and reuse data connections in multiple projects. This is a quick manual that will show you how to compare data using SelectCompare. Step by step When you launch the program, you are presented with the page containing all defined comparison projects. Initially...

Continue reading