San Francisco, California
London, United Kingdom
Delivering BI solutions using the Microsoft stack of tools requires knowledge of several different technologies, an understanding of what you are trying to accomplish, and the fortitude to do things right the first time. Too many organizations attempt to simply throw something together in order to gain insight and intelligence from the data they have. More often than not, however, this produces poor results, a solution that is not easy to manage or extend, and unsatisfied users.
During this day-long journey, we’ll explore all the steps and technologies needed to deliver fully functioning BI solutions within an organization. We’ll start with BI-centric database designs, learn about Extract/Transform/Load (ETL) development and management, and take a look at both multidimensional and tabular On-Line Analytical Processing (OLAP) solutions. We’ll also look at various reporting and analytics options, including relational reporting, OLAP reporting, and several of Microsoft’s newest analytics tools. Finally, we’ll round out the day discussing challenges and solutions related to managing and extending the BI solution and the overall BI environment over time.
Attendees will learn about the BI features included with SQL Server 2012 (including SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services) as well as the analytics features built into Office 2013 and Office 365. The sessions will include several instructor-led demonstrations, but will not include student exercises or labs; thus, students are not required to bring laptops to the session. Attendees will receive handouts of all session materials along with a CD containing scripts and artifacts related to the demonstrations completed during the day.
- This day long workshop will be helpful to DBA’s, BI Architects, Developers, and others seeking to better understand how to build and deliver BI solutions.
- It will cover SQL Server 2013, Office 2013, and Office 365.
- Laptops are welcome, but not necessary since the course material does not include any student exercises or labs.
- Handouts of the course materials will be available along with a CD containing scripts and other artifacts from the course demonstrations.
- Course fee covers snacks for breakfast and a boxed lunch. Parking in the school parking lot is free.
- This course needs a minimum of 15 people enrolled, failing which it will be cancelled with a full refund. Given PayPal policies, the refund will be made via check if payment is received 3 months prior to the event date; otherwise, the refund will be made via PayPal.
- We are unable to accept any forms of payment other than PayPal.
- No cancellations are allowed post registration.
- Contact email@example.com for any questions.
About the teacher:
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
When & Where
SQL Saturday Louisville