Building a Data Warehouse in Microsoft SQL Server using SQL Server Integration Services (SSIS)
Not ready for the cloud? No problem. In these cloud-heady days it’s easy to overlook some of the battle-hardened technology and skills that you have in-house. The Microsoft data management ecosystem has continued to evolve and improve; and better yet, provides a unique pathway for moving to the cloud when you’re ready.
In this session, DJ Nemcovsky will show you how to put the tried and true lessons of on-prem data warehousing into practice using the Microsoft stack. Come one, come all! Even if you’ve already set your sights on the cloud, most of the lessons DJ will impart remain relevant and will serve as a great primer for getting started with Microsoft’s data warehousing solutions.This will be a highly practical session, targeted at technical staff such as Infrastructure Managers, DBAs, Data Engineers, Architects, Business Analysts and Engineers.
Understanding the data that exists within your organization is the key to seeing trends and recognizing opportunities. This knowledge can help you take advantage of these opportunities more quickly as well as identify what you are already doing well. But getting a clear picture from data distributed throughout your enterprise is difficult. Getting this disparate information to tell a cohesive story has many challenges. Tracking individual customers through multiple systems, equating the types of information available through these same systems, and settling on a common method of expression across your enterprise to name just a few.
Building a Data Warehouse (DW) is a key first step to leveraging the data that exists throughout your company. Building this DW in Microsoft SQL Server using SQL Server Integration Services (SSIS) provides a solid foundation. This pulls your disparate data together into a single location that understands the relationships that exist among the different facets of your business. It is from this information repository that a truer picture of your enterprise can emerge and help you take advantage of opportunities more quickly.
Watch full video:
Presentation by:
D.J. Nemcovsky
ETL Architect, Caserta
A seasoned DW Architect and developer with more than 30 years of experience, D.J. Nemcovsky has developed solutions of all kinds and all sizes for a wide range of companies. He is an expert in Microsoft SQL Server and SQL Server Integration Services (SSIS).