Precon #2: Build a Data Warehouse in 1 Day
Thursday, November 7, 2013 from 9:00 AM to 5:00 PM (EST)
Build a Data Warehouse in 1 day
Ready for a full day of fun and interactive learning? Join Business Intelligence Architect and SQL Server expert, Jose Chinchilla, MCITP, for a day of hands-on training on architecting, modeling and developing a Data Warehouse and Business Intelligence solution. We will start by analyzing the business requirements, then we'll move on to develop ETLs and a cube and finalize with reports and Dashboards.
You will have the opportunity to follow along the exercises and create fact and dimension tables, SSIS Packages, SSAS Cube and SSRS Reports.
- Understand the process of architecting and modeling a datwarehouse
- Learn how to develop SSIS ETL Packages to load a multidimensional data warehouse with Fact and Dimension tables
- Learn how to load Slowly Changing Dimensions Type 0,1 and 2.
- Learn how to build an Analysis Services cube with hierarchies and KPIs
- Learn how to develop Reporting Services reports and dashboards
Presenter: Jose Chinchilla, MCITP, President & CEO Agile Bay, Inc.
Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Architect, President of Agile Bay, Inc. a full-service IT consulting firm specializing in BI. Data Warehousing and Big Data solutions. Jose has developed expertise developing Data Warehouses, OLAP Cubes, Master Data Management and Data Quality frameworks, and Performance Point dashboards with SQL Server and SharePoint platform. He is also the current president of the Tampa Bay Business Intelligence User Group and serves as PASS Regional Mentor for the Greateer Southeast Chapters.
Food: Lunch will be provided at the event location.
Cancellation policy: You can cancel or request refund 48 hours before the event. Full payment is due at the time of registration.
When & Where
Tampa Bay SQL BI
We are a free membership user group that meets the first Monday of every month to discuss and learn about Business with a focus on Microsoft's SQL Server BI stack. We are an accredited PASS (Professional Association of SQL Server) Chapter.
SQL PASS User Group Mission
Empower the local Microsoft SQL Server and Business Intelligence community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server platform.