I have been working with the Open Flights dataset this semester for BI. This Flight Data could work for future projects, along with anything Kimball or Red Gate related. I enjoyed learning the difference between methodologies on this page, Data Warehouse Architecture.
the best way to learn is to use AdventureWorks database. There is a relational version of it which is to demo the source data and there is star schema version of it, built from a relational one for data warehousing / OLTP system.
Download it from here - many Microsoft books on SQL Server / SSAS use this as example. A friend of mine used it to learn about data warehousing and get his first BI job.
发布评论
评论（5）
这是一个免费的在线数据库数据生成器：
www.generatedata.com
您可以设计一个表结构并让脚本生成行来填充它。
这并不完全是您所需要的，但我认为它可以提供帮助。
This is a free online database data generator:
www.generatedata.com
You can design a table structure and let the script generate rows to populate it.
It's not exactly what you need, but I think it can help.
NOT Northwind 发生了什么事？
http://www.hanselman.com/blog/CommunityCallToActionNOTNorthwind.aspx
还有 SQL Redgate 数据生成器：
http://www.red-gate.com/products /SQL_Data_Generator/index.htm
Whatever happened to NOT Northwind?
http://www.hanselman.com/blog/CommunityCallToActionNOTNorthwind.aspx
There's also SQL Data Generator from Redgate:
http://www.red-gate.com/products/SQL_Data_Generator/index.htm
这学期我一直在为 BI 使用 Open Flights 数据集。 该飞行数据以及与 Kimball 或 Red Gate 相关的任何内容都可以用于未来的项目。 我喜欢学习此页面上方法论之间的差异，数据仓库架构。
OpenFlights.org
此外，还可以在此 可视化数据网页，位于数据集、全球航班网络数据下。
了解有关 DataHub 上的 OpenFlights 数据。
此外，数据位于 dat 文件中，我将其与 Excel 中的分隔列一起导入。 之后，使用这些数据就不再那么困难了。 这是一个关于使用逗号分隔符导入这些数据文件的很好的教程Excel。
另外，我还发现了这个 数据集页面，其中还有 Databaseanswers 上的企业数据模型的其他一些有用的数据示例.org。
如果您发现任何其他有用的数据集学习示例，请告诉我。
I have been working with the Open Flights dataset this semester for BI. This Flight Data could work for future projects, along with anything Kimball or Red Gate related. I enjoyed learning the difference between methodologies on this page, Data Warehouse Architecture.
OpenFlights.org
Additionally, it was can be downloaded on this Visualizing Data webpage, under datasets, Global Flight Network Data.
Learn more about OpenFlights Data at DataHub.
Also, the data was in dat files and I imported it with delimited columns in Excel. After that it wasn't that difficult to use the data. Here was a good tutorial on importing these data files using a comma delimiter in Excel.
Also, I found this dataset page as well that had a few other useful data examples of Enterprise Data Models on Databaseanswers.org.
Let me know if you find any other useful datasets learning examples.
嘿，就用Adventure Works SR4吧
Hey Just use Adventure works SR4
最好的学习方法是使用 AdventureWorks 数据库。 它有一个关系版本，用于演示源数据，还有一个星型模式版本，是从用于数据仓库/OLTP 系统的关系版本构建的。
从这里下载 - 许多关于 SQL Server / SSAS 的 Microsoft 书籍都使用它作为示例。 我的一个朋友用它来了解数据仓库并获得了他的第一份 BI 工作。
http://msftdbprodsamples.codeplex.com/
the best way to learn is to use AdventureWorks database. There is a relational version of it which is to demo the source data and there is star schema version of it, built from a relational one for data warehousing / OLTP system.
Download it from here - many Microsoft books on SQL Server / SSAS use this as example. A friend of mine used it to learn about data warehousing and get his first BI job.
http://msftdbprodsamples.codeplex.com/