A User's Guide to Pyramid Analytics

Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence (BI) solutions using Microsoft technologies. He 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 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 Microsoft Office System components. He speaks about BI at numerous technical conferences, user groups, and other professional groups each year and leads the local SQL Server and Power BI Users Group in Louisville, Kentucky.

Over the last 18 months, Dave has been the lead resource for implementing the BI Office suite from Pyramid Analytics within the Department of Veterans Affairs. Having been a member of the BI team at the VA for the last seven years, he has helped architect and build the entire data warehouse and BI environments and infrastructure supporting over 350 employees serving more than six million veteran patients each year. As the lead for implementing BI Office, Dave has been responsible for installing, configuring, and managing the BI Office infrastructure and environment for use throughout the VA. Dave has also been the lead resource for educating content users and content developers within the VA, crafting and managing a full training and support system that helps over 20,000 users use over 50,000 reports and over 10,000 dashboards on a daily and weekly basis.