Friday, September 26, 2014

"See the Future with Running Totals" Presentation Download

Hi!  Here are the links to download my PASS BI presentation from Google Drive: 

Script install instructions:
Run CreateDemoEnvironment.sql to create a new database called PASS_DEMO, with tables and views.


Table Name  Rows   
RT          1005967
DimDate     18629
POItem      324
COItem      39
BOM         18
Item        13
Inventory   11
PO          6
CO          5

Saturday, July 26, 2014

See the Future with Running Totals

Hi it's me, checking in again with an update! I'm preparing a talk on Running Totals.  Did you know that T-SQL and SSRS both have functions to help calculate running totals?  I use these in my day job as a data warehouse developer for a manufacturing operation.  We compare all the planned Demand and Supply for the upcoming few months, and need to predict whether we will have all the parts in time to build what it needed.
Stay tuned to this space to learn more about this topic, including links to a presentation I am preparing for an upcoming SQL Saturday.