sqlsathistory

Nr: 800

Back to Main list

SQLSaturday #800 - Atlanta - BI Edition 2018

Start Time (24h) Speaker Track Title
09:00:00 Daniel Glenn Cloud Application Development Deployment Using Your On-prem Data in a Cloud World
09:00:00 Teo Lachev Advanced Analysis Techniques Bridge Analytics and Developer Worlds with Power BI and PowerApps
09:00:00 Marco Russo BI Platform Architecture, Development Administration My Power BI report is slow: what should I do?
09:00:00 Rie Irish Professional Development Mentoring Women in Tech: A Guide for Men Women Who Want to Help
09:00:00 Kevin Wilkie Application Database Development The function of Windowing Functions
09:00:00 Melissa Coates BI Platform Architecture, Development Administration Best Practices for Delivering Sharing Content in Power BI
09:00:00 George Bryant BI Platform Architecture, Development Administration Little and Large - Cubes to Scale
10:15:00 Leslie Andrews BI Platform Architecture, Development Administration The Power of Data: The Complete Beginners Data Warehouse Kit
10:15:00 Michael Wharton Cloud Application Development Deployment Create IaaS SQL Server Test Premise Environment in Azure Cloud
10:15:00 Thomas LeBlanc BI Platform Architecture, Development Administration Getting started with Tabular Analysis Services
10:15:00 Karlyn LeBlanc Professional Development Whipping Away Stress
10:15:00 Melody Zacharias Strategy and Architecture Introduction to Azure AI - The Art of the possible
10:15:00 Julie Smith Application Database Development Introduction to Azure Search
10:15:00 Kellyn Pot'Vin-Gorman Advanced Analysis Techniques Taming of the Shrew - Optimizing Power BI
12:30:00 Jose Chinchilla Data Integration Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
12:30:00 Spencer Swindell BI Platform Architecture, Development Administration Applying Data Warehousing Principles
12:30:00 Stuart Ainsworth Professional Development All (Data) Things Considered: The Lean Coffee Workshop
12:30:00 Jeremy Frye BI Platform Architecture, Development Administration Power BI Deployment Strategies: The Business versus I.T.
12:30:00 Shabnam Watson BI Platform Architecture, Development Administration Performance Monitoring Analysis Services Tabular
12:30:00 Samara Soucy Cloud Application Development Deployment Creating Near Real Time ETLs Using Serverless Architecture
13:45:00 Ryan Wade Analytics and Visualization Create Amazing Custom Visualizations in Power BI using ggplot2
13:45:00 Chris Voss BI Platform Architecture, Development Administration Should This Be Normalized? When Database Normalization Seems Abnormal
13:45:00 Elizabeth Noble Professional Development How to win Dev and influence QA
13:45:00 Neal Waterstreet Strategy and Architecture Data Quality - Plain Simple
13:45:00 Dan Evans BI Platform Architecture, Development Administration Power BI Next Gen
13:45:00 Adam Saxton BI Reporting Debugging common DAX and Model performance issues
13:45:00 Paco Gonzalez Data Science Artificial Intelligence, Cognitive Services, and Power BI
15:00:00 Ed Watson BI Platform Architecture, Development Administration A Beginner's Guide to Power BI
15:00:00 Bhakthi Liyanage Data Science Getting started with Azure Machine Learning Services
15:00:00 Trey Johnson BI Platform Architecture, Development Administration A Whistle stop Tour of Microsoft SQL Server and Azure BI Offerings
15:00:00 Edward Roepe BI Platform Architecture, Development Administration How to Perform a Health Check
15:00:00 Shakeel Khan Analytics and Visualization Power BI for Healthcare
15:00:00 Patrick LeBlanc BI Reporting Power BI: Best Practices for Designing Reports and Visuals
15:00:00 Patrick LeBlanc Advanced Analysis Techniques Using Artificial Intelligence and Power BI to detect Audience Emotion
15:00:00 Mark Tabladillo Analytics and Visualization Advanced Analytics with Power BI

SessionID: 83536

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint.

SessionID: 83671

Bridge Analytics and Developer Worlds with Power BI and PowerApps

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Teo Lachev

Title: Bridge Analytics and Developer Worlds with Power BI and PowerApps

Abstract:

SessionID: 83764

My Power BI report is slow: what should I do?

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marco Russo

Title: My Power BI report is slow: what should I do?

Abstract:

You created a wonderful Power BI report, but when you open it you wait too much time. Changing a slicer selection is also slow. Where should you start analyzing the problem? What can you do to optimize performance?

This session will guide you in analyzing the possible reasons for a slow Power BI report. By using Task Manager and DAX Studio, you will be able to determine whether you should change the report layout, or if there is something in DAX formulas or in the data model that is responsible for the slow response. At the end of this session, you will understand how to locate a performance bottleneck in a Power BI report, so you will focus your attention on the biggest issue.

SessionID: 84618

Mentoring Women in Tech: A Guide for Men Women Who Want to Help

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: Professional Development

Speaker: Rie Irish

Title: Mentoring Women in Tech: A Guide for Men Women Who Want to Help

Abstract:

Women make up less than 20% of the tech world and they're leaving the field at a rate over 3 times the rate that men are. Women cite lack of effective mentorship as one of the leading reasons for their exodus. Whether you're a colleague, a manager or someone who wants to change the status quo, your opportunity to effectively tip the scales changes.

What do you do for a living, what level are you at in your career and are you in any kind of management role? Can utilizing women's groups either at work or via a professional organization work for you? In this session, we'll discuss different ways you can mentor and sponsor women in tech. We'll provide concrete steps you can take to mentor, sponsor or just offer support. These solutions vary based on who YOU are, where you are in your career, if you have hiring/promotion influence, etc. Learn how you can make a difference.

SessionID: 84718

The function of Windowing Functions

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Kevin Wilkie

Title: The function of Windowing Functions

Abstract:

What is a windowing function?

What do I do with them? Are they actually useful?

By the end of the class, you'll be asking yourself -

Why haven't I used these before? How can I use them more often?

Learn more about the class of functions that are known as "windowing functions" and why you should get to know them more!

SessionID: 84726

Best Practices for Delivering Sharing Content in Power BI

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Best Practices for Delivering Sharing Content in Power BI

Abstract:

Power BI offers several ways to deliver and distribute content for internal colleagues and external users. In this session we will clarify when using the sharing functionality is appropriate, and techniques to effectively use My Workspace versus App Workspaces. We will discuss situations when a Power BI App becomes the optimal way to distribute content. We will also cover when to consider utilizing Power BI Premium, Power BI Embedded, or Power BI Report Server. You will leave this session with an understanding of options for collaboration and distribution of content in the context of personal BI, small teams, large teams, and enterprise-wide BI initiatives.

SessionID: 84886

Little and Large - Cubes to Scale

Back to calendar

Event Date: 22-09-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

Title: Little and Large - Cubes to Scale

Abstract:

In 2018 creating a cube is one of the easier tasks in BI, however what happens when the cube you inherit is so big that it officially becomes the biggest cube in the Midwest, and therefore one of the biggest cubes in the country? This session shows how to handle tabular models of size and scale. It also delves into what assistance and considerations are required when considering moving, or even building, your cubes in Azure.

SessionID: 83011

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 83030

Create IaaS SQL Server Test Premise Environment in Azure Cloud

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Michael Wharton

Title: Create IaaS SQL Server Test Premise Environment in Azure Cloud

Abstract:

Why create a SQL Server Test premise environment in Azure cloud? One of the first steps into moving to Azure cloud, is building an environment that looks a feels like premise but only in the cloud. This session is an overview of getting started with basics of Azure environment, such as Accounts, virtual networks, Storage and creating virtual machines.. Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.

SessionID: 83225

Getting started with Tabular Analysis Services

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Thomas LeBlanc

Title: Getting started with Tabular Analysis Services

Abstract:

This session will give the basics of starting a tabular model with Analysis Services 2016 and PivotTables from Excel. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in Excel and Power BI.

SessionID: 83605

Whipping Away Stress

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whipping Away Stress

Abstract:

Did you know stress releases chemicals into the blood? These chemicals give more energy and strength, which can be a positive if the stress is caused by physical danger. But this can also be a negative, if the stress is in response to something emotional and there is no way to release the extra energy and strength. Need stress management techniques? Stressed out? Learn how to cope and ultimately whip stress away.

SessionID: 84608

Introduction to Azure AI - The Art of the possible

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: Strategy and Architecture

Speaker: Melody Zacharias

Title: Introduction to Azure AI - The Art of the possible

Abstract:

According to the Economist magazine, data is the world’s most valuable resource. So, it makes sense that Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals, we need to know how these core pieces will affect what we do, and how we can use the Azure AI suite to help our clients. Microsoft’s AI suite is the central hub for learning and implementing each of these core pieces. Using an easy to follow example, I will show the flow from problem to solution. Multiple demonstrations of the different pieces will show use cases of the AI suite. This overview of Azure AI will use the various pieces like a puzzle which, when brought together, will form a seamless picture of the whole so that participants can see that the individual pieces were meant to work together.

SessionID: 84796

Introduction to Azure Search

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Julie Smith

Abstract:

In this session I will introduce the features and use cases for Azure Search, based on an implementation by Innovative Architects. Learn how IA leveraged Azure Search to quickly perform "fuzzy matching" on a client's product catalog. Topics covered: Creating an Azure Search, Indexes, documents, natural language ability, scoring profiles, and a few more good things.

SessionID: 84875

Taming of the Shrew - Optimizing Power BI

Back to calendar

Event Date: 22-09-2018 - Session time: 10:15:00 - Track: Advanced Analysis Techniques

Speaker: Kellyn Pot'Vin-Gorman

Title: Taming of the Shrew - Optimizing Power BI

Abstract:

No one wants to tell a report user that while running a report in Power BI they have time to go get a cup of coffee…in another town. Although data sets will often be the focus of performance issues, it’s important to know how to locate performance problems in Power BI and how to eliminate them.

This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.

Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.

SessionID: 83182

Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: Data Integration

Speaker: Jose Chinchilla

Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Abstract:

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.

SessionID: 83557

Applying Data Warehousing Principles

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Spencer Swindell

Title: Applying Data Warehousing Principles

Abstract:

Many data analysts typically begin to work with data as a single flat table. While this works for small datasets, as the size of the data grows these naive methods do not scale. Processing records takes longer, queries become more complex, and introducing new datasets is inconsistent at best. In order to solve these problems, we must take into account the underlying architecture of our data and how it should be modeled. During this talk we will discuss key concepts, patterns, and techniques for designing a data model that is simple to query, scales with your data, and is extendable to new datasets.

SessionID: 83776

All (Data) Things Considered: The Lean Coffee Workshop

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: Professional Development

Speaker: Stuart Ainsworth

Title: All (Data) Things Considered: The Lean Coffee Workshop

Abstract:

Collaboration is the heart of SQLSaturday's, but too often attendees move from session to session in a passive learning mode. This session is based on the Lean Coffee model, and is a structured workshop with no pre-planned agenda. The goal is to involve YOU in the conversation; bring your questions, your answers, your business cards, and your desire to learn. YOU set the agenda, YOU decide when to move on, and YOU engage and learn.

SessionID: 84427

Power BI Deployment Strategies: The Business versus I.T.

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: Power BI Deployment Strategies: The Business versus I.T.

Abstract:

Microsoft’s Power BI service has allowed end users and business analysts to exercise their creativity as developers. The expansion of department resources to create elegant and visually appealing reports for themselves and their organization at a fast pace, has taken some of the burden off developers, or has it?

Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports? In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and data modeling. In this session, we will look at potential data management concerns that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity. We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.

SessionID: 84689

Performance Monitoring Analysis Services Tabular

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: Performance Monitoring Analysis Services Tabular

Abstract:

Learn about how SSAS Tabular utilizes system resources and how to monitor its performance.

You will see demos of how to use SQL Server Extended Events, Windows Perfmon, and SSAS DMVs to collect SSAS performance metrics. You will learn different options for storing and querying these metrics and how to use them to identify performance problems such as memory/processor bottlenecks.

Finally you will see a demo of a set of Power BI reports that display the collected performance data.

While this session focuses on SSAS Tabular servers many of the concepts apply to SSAS Multidimensional servers as well.

SessionID: 84724

Creating Near Real Time ETLs Using Serverless Architecture

Back to calendar

Event Date: 22-09-2018 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: Samara Soucy

Title: Creating Near Real Time ETLs Using Serverless Architecture

Abstract:

Demand for up to the minute data has increased as businesses leverage their reporting to make decisions based on current conditions. This requires a different type of ETL architecture that can consume individual events as they occur instead of bulk processing.

Azure offers several services to fill this need, to the point where the sheer number and variety of them can become confusing. We’ll take a look at these different options individually as well as how they can fit together to create flexible, scalable stream of data.

The focus will be on Azure’s serverless offerings, but other PaaS services will be discussed where they may interact with a serverless design.

SessionID: 84105

Create Amazing Custom Visualizations in Power BI using ggplot2

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: Create Amazing Custom Visualizations in Power BI using ggplot2

Abstract:

Power BI offers great visualizations capabilities. You have powerful visualizations that comes pre-packaged in Power BI and you also have access to amazing visualizations in the AppSource marketplace. Even with those features you may find yourself in need to create your own custom visualization. Fortunately, you can easily do so leveraging the built-in R integration in Power BI. In this session we will learn how to create production quality visualizations in Power BI by using the ggplot package from R, along with a few supporting R packages.

SessionID: 84686

Should This Be Normalized? When Database Normalization Seems Abnormal

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Voss

Title: Should This Be Normalized? When Database Normalization Seems Abnormal

Abstract:

Ever since database normalization was introduced as a concept by Edgar Codd, there has been continuous debate on how far we should go to eliminate data redundancy. A new developer may be asking why there is a need to create multiple tables, and a DBA may be concerned that performance is being sacrificed. In this semi-interactive talk, we’ll discuss 1st, 2nd, 3rd, and Boyce-Codd Normal Forms, evaluate the pros and cons of normalization and denormalization for integrity and performance, and run through some demos involving scenarios of various data model formats. All to answer the question, "should...this...be...normalized?"

SessionID: 84876

How to win Dev and influence QA

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: Professional Development

Speaker: Elizabeth Noble

Title: How to win Dev and influence QA

Abstract:

Are you having a hard time enforcing or updating processes? Are you having trouble getting the business to see your vision of the future? Do you want to improve process or tasks at your office? Your answer to these challenges may be to improve relationships with key departments like Development and Quality Assurance.

In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.

SessionID: 85002

Data Quality - Plain Simple

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: Strategy and Architecture

Speaker: Neal Waterstreet

Title: Data Quality - Plain Simple

Abstract:

Data quality is a subject that comes up over and over again in many organizations. Most executives are concerned about the quality of the information used in their decisions. We talk about "good data" and "bad data" but what do those terms mean? In this presentation, we will first define what data quality is and look at how to measure it with data quality dimensions. Then, we'll explore common causes for data quality issues and how to perform a data quality assessment. Finally, we'll review the results and discuss some strategies and tools that can help improve the quality of the data in your organization.

SessionID: 85197

Power BI Next Gen

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dan Evans

Title: Power BI Next Gen

Abstract:

With recent announcements from the Microsoft Business Applications Summit around new updates coming later this year, there will be some big changes to how Power BI will work even better in your organizations. The late July update of Power BI Desktop brought some game-changer preview features with Composite models and other ways to connect and interact with data. Come hear more about what’s in store for the rest of 2018 for Power BI and some recommendations on how to prepare for these changes to take best advantage of the tools. Bring your questions and we’ll discuss how they can be answered and addressed to help your Power BI journey.

SessionID: 85204

Debugging common DAX and Model performance issues

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: BI Reporting

Speaker: Adam Saxton

Title: Debugging common DAX and Model performance issues

Abstract:

In this session, we will explore real-world DAX and Model performance scenarios. These scenarios range from memory pressure to high CPU load. Once you see the problem, watch as we will dive into the model and improve performance by going through concrete examples. Will it be fixed by optimizing the DAX statement or by making changes to the model? Come watch to find out!

SessionID: 85997

Artificial Intelligence, Cognitive Services, and Power BI

Back to calendar

Event Date: 22-09-2018 - Session time: 13:45:00 - Track: Data Science

Speaker: Paco Gonzalez

Title: Artificial Intelligence, Cognitive Services, and Power BI

Abstract:

Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.

SessionID: 83507

A Beginner's Guide to Power BI

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 83518

Getting started with Azure Machine Learning Services

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: Data Science

Speaker: Bhakthi Liyanage

Title: Getting started with Azure Machine Learning Services

Abstract:

Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment and model management at cloud scale. The session will teach the attendees how to get their hands on each tool in the stack.

SessionID: 84578

A Whistle stop Tour of Microsoft SQL Server and Azure BI Offerings

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Trey Johnson

Title: A Whistle stop Tour of Microsoft SQL Server and Azure BI Offerings

Abstract:

Get ready for a wild ride as we identify discuss the combination of Microsoft technologies which make up the “Data territory”, the offerings for BI/DW/Data Science practitioners. Some parts of the territory are ripe w/opportunity while other less-discovered parts are a bit hostile.

We’ll leave the engine running at each stop but spend enough time for the passengers to understand exactly what the various components mean. Throughout the tour, we’ll talk to the applicability of the components based on sizes of data (and customer).

At journey’s end, the attendee will want to take action and their own path into Microsoft “Data Territory”.

Learnings: Attendees will have a more complete view of Microsoft’s SQL Server and Azure BI “Data Platform” offerings Attendees can expect to be whisked into aspects of the Microsoft Offerings they may have never heard of or understood. Attendees should be able to correlate the various Microsoft offerings to the size and scope of their own projects

SessionID: 84628

How to Perform a Health Check

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Edward Roepe

Title: How to Perform a Health Check

Abstract:

Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?

In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis

At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.

SessionID: 84684

Power BI for Healthcare

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Shakeel Khan

Title: Power BI for Healthcare

Abstract:

Healthcare organizations are constantly evolving in managing, transforming and analyzing clinical, operational and financial data to improve care and reduce cost. On the other hand, Microsoft’s Power BI is becoming a tool of choice in organizations across all industries. With its powerful capabilities, Power BI can serve as a versatile tool to prepare, analyze and visualize data in Healthcare organizations already using Microsoft Technologies for data management and work flows.

This session will provide an overview of how Microsoft Excel users and Power BI beginners in healthcare organizations can transition to Power BI for an agile data analysis and visualization. We will discuss use cases and illustrate rapid data processing and visualization using a sample healthcare dataset (Electronic Health Record or Claims Data).

Takeaways: • Understand the path from Microsoft Excel to Power BI • Connect and prepare data • Model and analyze data • Create and publish reports and dashboard

SessionID: 85205

Power BI: Best Practices for Designing Reports and Visuals

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: BI Reporting

Speaker: Patrick LeBlanc

Title: Power BI: Best Practices for Designing Reports and Visuals

Abstract:

in this session I will provide best practices for designing reports in Power BI. Starting with planning, it discusses principles of design that you can apply to your reports and to the pages and individual visuals that make up that report. Many of these best practices apply to dashboard design as well.

SessionID: 85343

Using Artificial Intelligence and Power BI to detect Audience Emotion

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: Advanced Analysis Techniques

Speaker: Patrick LeBlanc

Title: Using Artificial Intelligence and Power BI to detect Audience Emotion

Abstract:

Our facial expressions tell a million stories each time they change. Your eyes, your mouth, and the lines in your forehead all contribute to how you are feeling at that moment. Now imagine trying to quickly detect the emotion of ever person in an audience. Almost impossible or is it. Join me in this session where I will explain and demonstrate how to I used Microsoft’s Vision API and Power BI to build a vision-enable application to detect the emotions of individuals attending my presentation. This is a demo-heavy session that you don’t want to miss.

SessionID: 85996

Advanced Analytics with Power BI

Back to calendar

Event Date: 22-09-2018 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Mark Tabladillo

Title: Advanced Analytics with Power BI

Abstract:

Power BI has become an increasingly important data analytics tool. This presentation focuses on the advanced analytics options currently available in Power BI. Attendees to this talk will see:

· Microsoft’s perspective on advanced analytics development: the Team Data Science Process

· What the general options are for advanced analytics on Azure

· What the specific native advanced analytics capabilities are in Power BI

· Some ideas on pairing Power BI with other technologies in advanced analytics architectures

This site is open source. Improve this page.