Multidimensional Data Cubes and Data Mining in the Real World
In this session, we will build out a multidimensional data cube based on ACH transaction data. The data will be approximately 25 million rows of data. Once we go over the design and load of the data cube, we will look at the data mining capability built into SQL Server to see what kind of insight we can get from the data using SQL Server-based tools. We are going to simulate the data that a financial institution would be receiving in direct deposits and other ACH type transactions. Remember, if your organization is using the enterprise version of SQL Server, all of the associated tools are free to install and use.
I have been using SQL Server since MS split it off from Sybase in 1994. I love data and finding out what ti can tell the business. At 65, I have started a Master's of Science degree in Business Analytics so I can become even better at making data knowledge.
- SSAS 4 Recordings