About the Speaker – Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Pluralsight, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields including manufacturing, insurance, telecommunications and nuclear power.
Session #1 Title: Introducing the SSAS BI Semantic Model, aka Tabular
Session #1 Abstract: SQL Server Analysis Services 2012 introduced the BI Semantic Model, also known as the Tabular model. In this session you’ll learn about the newest way to do analytics in SQL Server. We’ll compare and contrast it with the traditional Multidimensional Model, then see how to create your first “cube” using the Tabular mode. Finally we’ll look at some of the reporting options for using your new Tabular database, including SSRS, Excel, and PowerView.
Session #2 Title: Zero to Hero with PowerShell & SQL server
Session #2 Abstract: There are two kinds of people in the IT world. Those who are using PowerShell, and those that will be. In this session you’ll learn how to become one of the “cool kids” using PowerShell. We’ll begin with a super-fast paced introduction to PowerShell starting with a quick overview of the two environments you can use PowerShell in, command windows and the ISE (Integrated Scripting Environment). Next you’ll learn about cmdlets, variables, functions, and logic flow. You’ll then see how to use PowerShell to assist you in your development efforts. Don’t be left behind, learn how to leverage the power of PowerShell!