12:30PM Registration - Lunch Provided by Covenant Technology Partners
2:00PM Self-Service BI with Power Query and Building Models Against the Various Data Sources
3:00PM The Basics of Analysis Services and Their Role in the BI Stack
4:00PM Q&A and Wrap up
In this session, learn how anyone with Excel experience can take advantage of PowerPivot, the free add-in for Excel, to quickly and easily turn data from different sources such as traditional databases, Analysis Services, Excel, or the web into a workable dataset. Use this data for ad hoc analysis or to create visually impressive reports directly in Excel. Then leverage SharePoint to automatically refresh the data and publish it to share with others in the organization.
Speaker: Melissa Meyer, Covenant Technology Partners
Melissa is a senior consultant with Covenant Technology Partners with a passion for all things data. Melissa has been working in BI for 10 years and specializes in implementing the SharePoint BI stack and BI solutions of all types and sizes. In her free time, she enjoys travel, hunting, cooking and spending time with family
Self-Service BI with Power Query and Building Models Against the Various Data Sources
It’s powerful to put BI into the hands of users with Power View and Power Query. This makes the business efficient and reduces the workload of IT!
Come see how analysis against databases can be executed quickly by business users with these relatively new Microsoft tools.
Speaker: Clayton Groom, Covenant Technology Partners
Clayton Groom is a founding partner of Covenant Technology Partners. He has worked at the world’s best IT consulting organizations before helping to create CTP.
Clayton is a frequent speaker at User’s Groups and local conferences as well as leading the Business Intelligence practice at Covenant and taking care of his growing family.
The Basics of Analysis Services and Their Role in the BI Stack
The presentation will cover the basics of Analysis Services or Microsoft’s multi-dimensional (cube) database. Relational tables are great but sometimes fast, efficient analysis requires another tool: the multi-dimensional database and a complex meta-data engine. You will see how cubes are designed and how they relate to a data warehouse. You will also see fast that makes ad-hoc data analysis. Finally, you will see how the meta-data engine of Analysis Services is a key to other Microsoft BI Products. Read More
Performance tuning SQL Server Integration Services (SSIS)
In this demo-rich presentation, Devin shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes.
Don’t miss the 2-Day Self-Service BI Workshop that starts in the morning and ends January 22nd.
Speaker: Devin Knight, Training Lead, PragmaticWorks
Devin a Microsoft MVP and the Training Director at Pragmatic Works Consulting. He is an author of five SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).
Lync Meeting Information Read More