When: Thursday November 15th, 2012 9:00am to 5:00pm
Presented by: Jose Chinchilla, MCITP
This full-day workshop aims to provide attendees with conceptual knowledge and practical skills to design and develop a multidimensional Data Warehouse and Business Intelligence solution. We will do an intro to Kimball style (star schema) data warehouse database modeling, covering concepts like slowly-changing dimensions Type 0,1,2,3,4 & 6, role-playing dimensions, attributes, facts, measures, hierarchies, parent-child relationships, and more. Attendees will learn how to develop SSIS Packages to load a data warehouse, Analysis Services Cubes & basic MDX, Reporting Services reports and Performance Point dashboards. In addition, attendees will learn how to implement self-service BI using PowerPivot and Power View.
This is a hands-on workshop with group and individual labs. Attendees are encouraged to bring their laptops with installed software. A download with lab material and installation requirements will be provided in advanced.
This is a great intro session to get you started as a BI developer!
Presenter Bio: Jose Chinchilla, MCITP, is a Microsoft Certified Database Administrator and Business Intelligence Architect, President of Agile Bay, Inc. a full-service IT consulting firm specializing in BI and Data Warehousing. Jose has developed expertise developing Data Warehouses, OLAP Cubes, Master Data Management and Data Quality frameworks, Performance Point dashboards and self-service BI models using the SQL Server and SharePoint. He is also the current president of the Tampa Bay Business Intelligence User Group and PASS Regional Mentor for the Greater Southeast.
When: Friday November 16th, 2012 9:00am to 5:00pm
Presented by: Mark Tabladillo, Ph.D. and MVP
SQL Server 2012 provides enterprise-level data mining technology, ranging from supporting individual analysts through scalable server solutions. This one-day seminar provides an overview of SQL Server Data Mining within the context of applied practice of the scientific method. The course instructor brings his past experience in not only consulting but also from teaching statistics at the undergraduate and graduate level (Georgia Institute of Technology; University of Phoenix). The overall goal is to explain data mining in a scientifically accurate way while making the technology practically accessible and even fun.
- Provide a fundamental scientific framework for data mining
- Demonstrate the technology with the fundamental Microsoft data mining interfaces
- Provide strategy secrets for implementing enterprise-level SQL Server 2012 data mining
Presenter Bio: Mark Tabladillo (MVP, SAS Expert) promotes insights from data mining, predictive analytics and business intelligence to make actionable decisions. Mark has been a speaker at major conferences like Predictive Analytics World, SAS Global Forum, and Microsoft’s TechEd. Mark also has taught statistics at the undergraduate and graduate level (Georgia Institute of Technology; University of Phoenix). Mark has been an information technology professional since 1998, and provides consulting and training at companies across the United States and around the world.
Mark shares his thoughts on his data mining blog at http://marktab.net and tweets @marktabnet
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.