Sessions Overview

Engaged Learning in Data Analytics

Join us at PASS BA Day for a day of focused learning from speakers who have expert knowledge of the Microsoft BI tools and technologies. Discover real-world analytic skills and practices you can put to work immediately. Select from the Advanced Analytics or Data Visualization focused tracks for a deep dive into the topic.

Advanced Analytics:
In-Database Analytics with R and SQL Server 2016.

David Smith, R Community Lead at Revolution Analytics, a Microsoft Company
Seth Mottaghinejad, Data Scientist, Microsoft

With Microsoft SQL Server 2016, data scientists can run in-database analytics using R. This is a “best of both worlds” scenario: delegate database management to SQL Server whilst you create analytics and visualisations in R and Power BI. In this session, we will cover the overall architecture of SQL R Services and go over some best practices. We will look at best practices in analytics and visualisations with a focus on R, and then we delve more in-depth into some practical common use-cases such as:

  • How to build and store and retrieve an R analytics model and use it to score new data 
  • How to use R to produce data visualizations and manage them for retrieval by SQL Reporting Services and Power BI 
  • Examples of everyday, practical data-wrangling operations where R can outshine SQL 
  • Using Microsoft R’s RevoScaleR package to scale analytics on very large datasets

By the end of this one-day session, attendees with gain:

  • A basic understanding of the purpose and use of the R programming language 
  • How to build predictive models with large data sets using the “RevoScaleR” package in Microsoft R 
  • How to build and store and retrieve an R analytics model and evaluate your model 
  • How to use R to produce data visualizations and manage them for retrieval by SQL Reporting Services

Level of Expertise
Familiarity with SQL Server is assumed.  Some familiarity with R might be helpful, but all the R code will be explained.

Session Prerequisites
Attendees should bring their laptops with SQL Server 2016 (Enterprise or Express) installed, along with the “R Services” component.
Alternatively, attendees may use the Data Science Virtual Machine on Azure (Azure account required)

Microsoft R
SQL Server R Services

Data Visualization:
Mastering Power BI Solutions.

Paul Turley, Mentor with SolidQ, BI Architect, and Microsoft Data Platform MVP

In this Power BI hands-on Workshop, you will master the “power” of Power BI. Learn to use self-service and enterprise-scale Power BI capabilities; gain valuable skills to integrate, wrangle, shape and visualize data for analysis. Beginning and intermediate level users will learn to address data and reporting challenges with advanced design techniques.

At the conclusion of the workshop, you will have a complete solution built from real business data, shaped, cleansed & modeled; with a dashboard and interactive report visuals ready for analysis.

Modelling and shaping data using Power BI Desktop:

  • Transitioning from Excel to Power BI Desktop
  • Source data from a variety of platforms & formats
  • Data modelling basics & best practices
  • Modelling approaches with flat, normalized, star & snowflake schemas
  • DAX calculation basics & fundamentals
  • Need-to-know and good-to-know DAX functions & skills
  • Understanding challenging DAX concepts; row & filter context, relationship cardinality & filter flow
  • Advanced DAX calculations & business applications

Visualizing and analyzing business data using Power BI Desktop:

  • Standard report design principles & patterns
  • Self-service end-user coaching
  • Proper applications of filters & slicers
  • Applying report visuals with cross filtering to answer business questions
  • Report & dashboard design showcase
  • Integrating Power BI with SSRS, Excel & SSAS
  • Using R for specialized reporting, statistical & predictive analytics
  • Using custom visuals for advanced & specialized reporting & analytics

Content Sharing / Administration:

  • Managing published models, reports & dashboards in the Power BI service
  • Working with workspaces, content packs & security roles
  • Options for embedding reports & dashboards into sites & web solutions

Data Wrangling for Advanced Content:

  • Connect to live and on-premises data using DirectQuery & SSAS direct connect
  • Accessing advanced data sources
  • Using gateways to manage live & on-premises data sources
  • Manage & schedule data refresh
  • Query design best practices & survival skills
  • Advanced query scripting techniques using “M”/Power Query formulas
  • Working with on-prem, hybrid & published solutions

Level of Expertise
For beginner and intermediate level users of Power BI.

Session Prerequisites
Attendees should bring their laptops with Power BI Desktop already installed; 64-bit Windows & 8 GB of RAM (4 GB min) is recommended.
A Power BI subscription is recommended but not required.

Ready to dive into the world of analytics?

Register Today