Category Archives: Uncategorized

XLhub, Excel and Your SQL Server Data Warehouse

We recently came across an application of XLhub in a Data Warehouse. Here is the scenario: The contents of the dimension tables in a data warehouse need to be modified from time to time. For example, new Products have to … Continue reading
Posted in Uncategorized | Tagged , , , , , | Comments Off on XLhub, Excel and Your SQL Server Data Warehouse

Using Excel for Tracking Salary and Bonuses

Employee salary information is very confidential, yet many companies maintain salary and bonus information in Excel spreadsheets, and often email these files as attachments to large distribution lists. A simple oversight by someone could put this information in the wrong … Continue reading
Posted in Uncategorized | Comments Off on Using Excel for Tracking Salary and Bonuses

Excel Aficionado Talks Excel and XLhub

Scott Maier is a faculty member and professor of journalism at the University of Orego. He has over 20 years experience as a wire-service reporter, and his “beats” have spanned from city hall to the state legislature, Latin America, as … Continue reading
Posted in Uncategorized | Comments Off on Excel Aficionado Talks Excel and XLhub

Spreadsheet Complexity Index

Here’s a tool for assessing the complexity of your Excel spreadsheet model. If your model is complex, as a spreadsheet design guideline we recommend separating these three key features of Excel: Reporting Calculation Data Storage The more tightly coupled are … Continue reading
Posted in Uncategorized | Comments Off on Spreadsheet Complexity Index

The Spreadsheet Engineering Project

I would like to share some interesting information I learned from the Spreadsheet Engineering Project. This research project was undertaken at the Tuck School of Business at Dartmouth College. Professors Baker, Powell and Lawson conducted the research. Quoting from their … Continue reading
Posted in Uncategorized | Comments Off on The Spreadsheet Engineering Project

Where Did You Get Your Data?

Ever been through a PowerPoint presentation with impressive charts and tables explaining trends in your company’s operations? Did you start to wonder where is the data that was used to create the charts? The data (and the chart) probably came … Continue reading
Posted in Uncategorized | Comments Off on Where Did You Get Your Data?

Excel, the Last Mile in Business Intelligence

As business intelligence consultants, we come across Microsoft Excel where ever we go. Excel is a fantastic tool. It is easy to learn, incredibly flexible and has powerful data management and business intelligence features. Our clients have sophisticated enterprise systems … Continue reading
Posted in Uncategorized | Comments Off on Excel, the Last Mile in Business Intelligence