Tag: Warehouse

Get Your Self-Service On!

Do you need to make an immediate or occasional one-time backup of your Dynamics GP databases, or maybe run a SQL job that populates your BI360 Data Warehouse?  Occasionally, you may be performing some month-end closing procedures, post a large, significant batch, or perhaps you are about to integrate a large amount of your Dynamics GP data into your BI360 Data Warehouse.  It’s critical that you make a good set of database backups to use in recovery in case of a failure, in order to refresh your Dynamics GP data into your Data Warehouse without IT involvement.  There are several ways you can create a one-time backup or run other SQL jobs, like refreshing your Data Warehouse for month-end reporting.  Here are some easiest ways, with some of the tools most people are familiar with:

Read More »
May 11, 2016

Kick-Start Your Data Warehousing

Many of the projects that I’ve been working on over the last 12 months have evolved integrating data into a data warehouse. Specifically companies are looking to import more data from other systems to do various types of analysis.  Data integration is nothing new, companies have been doing it for a long time, but usually with a very manual process that includes vast Microsoft Excel spreadsheets.

What Is a Data Warehouse?

A data warehouse is a database designed to enable reporting and data analysis activities.  Data warehouses store current and historical data from one or more disparate sources.  Some of these sources may include:

Read More »
December 12, 2014