Microsoft BI in a Day

Learning the Microsoft BI Data Platform with Patrick LeBlanc and Adam Saxton of Microsoft Data is everywhere. It’s coming from every device, web page, application, and system in your organization. How do you prepare for it? How do you share the data with the end-users that need access to the data? How do you secure the data? In this session we will explain and demonstrate how to build out an efficient and effective Data Platform that will scale across your entire organization. We will present on-premises, hybrid and cloud-based options. You will leave will the tools needed to develop, deploy and manage the entire solution. The following is the detailed agenda:

I) Preparing your organization for a Business Intelligence Solution

a. On-Premises/Hybrid/Cloud

b. Sample Topologies

c. Office 365

d. Authentication

II) Building a Data Warehouse

a. SQL Server

b. Azure SQL Server

c. Azure SQL Data Warehouse

d. All Other Data (HDInsight, Stream Analytics, etc…)

III) Loading a Data Warehouse

a. SQL Server Integration Services

b. Azure Data Factory

IV) Building a Semantic Model

a. Power BI Desktop

b. Power Pivot

c. Tabular Models

d. Multidimensional Models

V) Sharing and Visualizing your Data

a. Power BI

b. SQL Reporting Services

c. Excel

d. Datazen

Patrick LeBlanc is a currently a Microsoft SQL Server and Business Intelligence 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 also the co-founder of First Hand Training, which delivers Business Intelligence training across the United States.