Where can I find a real dataset anywhere on the internet where I could try making a data warehouse cube?
2 answers
You can refer to this page to learn how to convert a portion of the Northwind database to a cube star schema : Northwind star schema .
+1
a source to share
Here's an example at Adventure Works - of course it prepared SSAS, but I think you could look at the underlying AventureWorks database and do the sizing simulation yourself.
I think doing DW on an existing popular dataset like Northwind or AdventureWorks is probably not a great idea because so many people have done it. Even StackOverflow had some data mining done , but that might be a good candidate - I'm not sure if Brent actually worked.
So, if you want to make an original project, you may need to look further, if only to distinguish your work from previous work.
0
a source to share