Demo: Financial forecasting in a data warehouse project

About this demo


This demo shows how to use SQL Spreads and Excel to create a solution where end users enter forecasting data into a data warehouse.

The user selects for which Month, Company and Region to enter the forecasting data. The Excel spreadsheet is then pre-loaded with data from the data warehouse displaying Budgets, Actuals, and previously entered forecast. The user updates the forecasts and saves the data which is stored in a forecasting table in SQL Server.

Scenarios
:
  • Data Warehouse Project

Demo video



Downloadable Demo files


Download Demo Files 

Installing the demo

Note: The database contains data for all SQL Spreads demos, so you only have to install the demo database once.
  1. Download and install the SQL Spreads Excel Add-In
  2. Download the demo zip-file and copy the folder inside the zip file to your desktop
  3. Install the database by opening the "SQL Spreads Demo database.sql" file in SQL Server Management Studio and execute the query. 
  4. Open the demo's Excel file in Excel
  5. The demo is set up to use a Microsoft SQL Server on your local machine (localhost). If you see a message that SQL Spreads cannot load data,
     you must update the connection to the SQL Server where you installed the demo database by clicking the Database Connection button in the SQL Spreads tab in Excel. 
Click the Refresh button in the SQL Spreads panel to load the data from the database into Excel.

Click the Save button in the SQL Spreads panel to write any changes you make in the data in Excel back to the database.

Key Features Used

  • Import and Export of data between Excel and SQL Server.
  • Database Import Filters for selecting data (Month, Company and Region)
  • Validation of data entered into Excel against SQL Server data types.
  • Tracking of the time when a row was changed and which user that changed the row.
  • Conflict Detection to prevent overwriting of changes when several users are working with the same data.

Feedback and Knowledge Base