I recently attended the Microsoft’s DevConnections Conference. As a database developer, my focus was on sessions dealing with the business intelligence and data warehousing technologies that ship with Microsoft SQL Server.
The concepts of data warehousing is something I have been researching for the past year; I believe it’s a concept that can assist organizations in making better decisions about their business. The sessions I attended covered all of Microsoft’s data warehousing tools – from tools that help you develop a data warehouse to tools that help deliver business intelligence to key decision makers.
There were a few sessions that stuck with me the most. The first two – “Why Data Warehousing Projects Fail” and “Avoiding Common Analysis Services Mistakes” – provided guidelines on how to design a data warehouse solution and avoid common mistakes. The other session focused on delivering business intelligence to the end user and addressed how to create a digital dashboard with the reporting tools that are a part of Microsoft SQL Server.