Power BI: From Beginning To End...

Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly, blog posts are flying across twitter. How can you keep up? In this full day session I will explain and demonstrate how to implement a full enterprise Power BI solution. This will include preparing your organizations network for Power BI, deciding if you need to build an SSAS Semantic Model or will the Power BI desktop work as an alternative. In addition, there will be a few hand-on labs that will help each attendee get started working with both the Power BI Desktop and the Power BI Service. Bring your laptop, grab a cup of coffee and get ready to learn. See the agenda below:

Preparing Your Organization for Power BI

• What is Power BI?
• What role does Office 365 play?
• Preparing User Accounts and Licenses

To Data Warehouse or Not

• Connecting to Disparate Data Sources
• Using a Traditional Data Warehouse

Introduction to Power BI Desktop

• Importing Data
• Directly Connected to Data
• Shaping Data with the Query Editor
• Modeling Data
• Visualizing Data

Introduction to the Power BI Service

• Publishing Datasets and Reports from the Power BI Desktop
• Creating Dashboards
• Sharing and Collaborating
• Using the Service to Get Data

Connecting to and Refreshing Data

• Using the Power Gateways (Personal, Enterprise and Power BI SSAS Connect)*
• Scheduling Data Refresh

Power BI meets Cortana
Near-real time Dashboards (if time permits)

*subject to change depending on changes by Product Team

Presented by Patrick LeBlanc

Patrick LeBlanc is a currently a Data Platform Solutions Architect. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.

This precon is sponsored by SQL Saturday Richmond

Don't forget to register for SQL Saturday Richmond at http://www.sqlsaturday.com/486.