sqlsathistory

Nr: 919

Back to Main list

SQLSaturday #919 - Atlanta - BI Edition 2019

Start Time (24h)	Speaker	Track	Title
09:00:00	Cornell Emile	Power BI	Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets
09:00:00	Lance England	Power BI	DAX Fundamentals
09:00:00	Chad Buher	BI Platform Architecture, Development Administration	Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks
09:00:00	Armando Lacerda	BI Platform Architecture, Development Administration	Power BI Dataset Tuning
09:00:00	Hilary Wilkie	Professional Development	User Experience Brilliance in Power BI Dashboards
09:00:00	Lucas Feiock	Cloud Application Development Deployment	Speed up your data models using Azure Analysis Services
09:00:00	Reza Rad	Power BI	Architecture Blueprints for Power BI Implementation
10:15:00	Brad Llewellyn	BI Platform Architecture, Development Administration	The Power of Electric Snakes! An Introduction to PySpark for Big Data Analytics
10:15:00	Ed Watson	BI Platform Architecture, Development Administration	The Psychology of Better Power BI Reporting
10:15:00	Belinda Allen	BI Platform Architecture, Development Administration	DAX 101 and 102
10:15:00	Warren Sifre	Advanced Analysis Techniques	Introduction to Azure Streaming Analytics
10:15:00	James McAuliffe	Application Database Development	Changing Data Is Easy, Managing Data Change is Hard!
10:15:00	Leila Etaati	Data Science	AI Builder: AI in Power Apps and Microsoft Flow
10:15:00	Preston Mesarvey	BI Platform Architecture, Development Administration	Evolving Your BI Environment From SSRS To Power BI
11:30:00	Jay Rajendran	Analytics and Visualization	Running Windows and SQL Workloads on Google Cloud Platform
11:30:00	Tyler Graham	Power BI	Dimension Management for Power BI
11:30:00	Geoffrey Rayner	Strategy and Architecture	Data Governance Implications of the California Consumer Protectio
12:30:00	Reza Rad	Power BI	Unleash Row Level Security Patterns in Power BI
12:30:00	Leila Etaati	Data Science	Microsoft AutoML the Next Generation of Machine Learning
12:30:00	Ganesh Lohani	Advanced Analysis Techniques	Data Science 101: An Introduction to Data Science Using Python
12:30:00	Patrick LeBlanc	Power BI	Data Modeling and DAX Tips for Power BI
12:30:00	Jason Russell	Power BI	Intro to Power BI (or "How Power BI changed my Marriage")
12:30:00	Teo Lachev	Strategy and Architecture	Power BI Pro, or Premium: that is the question
12:30:00	Javier Guillen	Power BI	Power BI for Data Scientists
13:45:00	Andy Leonard	Cloud Application Development Deployment	Moving Data with Azure Data Factory
13:45:00	Ryan Wade	Analytics and Visualization	AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem
13:45:00	Russel Loski	BI Platform Architecture, Development Administration	Managing ETL Change Using BIMLScript
13:45:00	Samara Soucy	Power BI	Power BI Embedded for Fun and Profit
13:45:00	Paul Waters	Application Database Development	SQL Server Data Tools (SSDT) = Awesome
13:45:00	Daniel McConnell	Cloud Application Development Deployment	Cool Things You Can Do With Azure Data Factory
13:45:00	Patrick LeBlanc	Power BI	Power BI Performance in 6 Demos
15:00:00	Bill Anton	BI Platform Architecture, Development Administration	Level Up: Data Modeling for the Power BI Rockstar
15:00:00	Jared Rhodes	Cloud Application Development Deployment	AI on the Edge
15:00:00	Brad Llewellyn	Advanced Analysis Techniques	Azure Machine Learning Studio: Making Data Science Easy(er)
15:00:00	Julie Smith	Data Science	Using Python In Power BI
15:00:00	Shabnam Watson	Power BI	Aggregations in Power BI
15:00:00	Daniel Glenn	BI Platform Architecture, Development Administration	Using Your On-prem Data in a Cloud World
15:00:00	Paco Gonzalez	BI Platform Architecture, Development Administration	Power BI Architecture

SessionID: 96118

Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: Power BI

Speaker: Cornell Emile

Title: Keeping Your Data Secure In Azure While Automatically Refreshing Power BI Datasets

Abstract:

Your company has completed its data migration to Azure and now various teams are wanting to build, share and view Power BI reports and dashboards using the data. Additionally, the access to the data has been limited to a specific list of applications and users but not to Power BI.

So how do you support the automatic data refresh of the data within Power BI and still ensure that the security of your company's data is not compromised?

This advanced Power BI session presents several techniques that can be used to maintain (and sometimes enhance) the security of your company's data while ensuring that Power BI datasets are regularly refreshed.

SessionID: 96128

DAX Fundamentals

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: Power BI

Speaker: Lance England

Title: DAX Fundamentals

Abstract:

The Microsoft Tabular model is a core technology in Microsoft's business intelligence offerings, found in Power BI, Azure Analysis Services, and Excel PowerPivot. Understanding DAX (Data Analysis Expressions) is the key to unlocking the power of the Tabular model. This session will cover some fundamental concepts and common pitfalls encountered while learning DAX.

Topics include:

• Row and filter context
• Context transition
• Filter vs filter
• Active relationships
• Automatic table to scalar conversion
• Variables
• Basics of time intelligence

SessionID: 96397

Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chad Buher

Title: Replace Hundreds of Fragmented SSRS Reports with Integrated Dashboards in Weeks

Abstract:

Has your organization accumulated a ton of reports that are crucial, yet fragmented and difficult to maintain? This session deals with the challenge of documenting those disconnected reports and replacing them with integrated dashboards. We will also discuss the trade offs of different data integration architecture options such as data lakes, dimensional models, real time solutions like data virtualization, and cloud based solutions.

In this session, we will explore:

• Different industry solutions to document your existing SSRS reports and SSAS cubes to identify all the columns used in source tables/objects.
• Interrogating the database objects (views, stored procedures, etc.) to decipher the ETL mappings and transformations and present this in a human readable format of data lineage with business rules applied to the source system.
• Grouping these reports into sets to be consolidated in a few dashboard
• Different solutions to accommodate the desired data integration architecture

SessionID: 96582

Power BI Dataset Tuning

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Armando Lacerda

Title: Power BI Dataset Tuning

Abstract:

Most Power BI reports rely on a small dataset. And due to a lighting fast data engine most data model mistakes are shadowed by the speed of the service. When the dataset gets bigger then best data modeling practices are required. The trick here is Power BI data engine is not relational and therefore most data modeling techniques either don’t apply or don’t deliver. In this session we will go over how to model and measure performance for larger Power BI datasets.

SessionID: 96584

User Experience Brilliance in Power BI Dashboards

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: Professional Development

Speaker: Hilary Wilkie

Title: User Experience Brilliance in Power BI Dashboards

Abstract:

User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?

Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that give the best user experience? In this session, we will explore how to start using UX and the psychology behind it to empower you with Intel that will make YOUR dashboards Kick Booty!

SessionID: 97967

Speed up your data models using Azure Analysis Services

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Lucas Feiock

Title: Speed up your data models using Azure Analysis Services

Abstract:

Azure Analysis Services is a platform as a service (PaaS) offering that hosts Tabular Models in the cloud. The same capabilities with on-premise SSAS Tabular Models are applied to this new version. Benefits to running Azure AS is the ability to scale up\down, pause, and resume on demand. In this session we will build a semantic data model, migrate to Azure, and visualize using Power BI. If you are running Tabular Models that are compatibility level 1200 and higher this session will show you how quick and easy it is to migrate to Azure.

SessionID: 98006

Architecture Blueprints for Power BI Implementation

Back to calendar

Event Date: 19-10-2019 - Session time: 09:00:00 - Track: Power BI

Speaker: Reza Rad

Title: Architecture Blueprints for Power BI Implementation

Abstract:

Implementing a Power BI solution is not just about the report development, dashboard design, and DAX queries. Designing the right architecture is an essential part of a Power BI implementation.

There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security, to the type of connection and usage of other components such as dataflow.

Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.

SessionID: 95615

The Power of Electric Snakes! An Introduction to PySpark for Big Data Analytics

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brad Llewellyn

Title: The Power of Electric Snakes! An Introduction to PySpark for Big Data Analytics

Abstract:

Big Data Analytics is becoming a major priority for more organizations every day. However, traditional Hadoop skills are still difficult to find, expensive to hire and time-consuming to train. In this introductory session, we'll see how it is easy to get started with Big Data Analytics using Spark and Python. We'll learn how to perform standard analytical tasks, like creating RDDs and Data Frames, transforming columns and creating aggregations. Be sure to bring your rubber suits, because we'll be playing with lightning...snakes.

SessionID: 96042

The Psychology of Better Power BI Reporting

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: The Psychology of Better Power BI Reporting

Abstract:

In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.

SessionID: 96135

DAX 101 and 102

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Belinda Allen

Title: DAX 101 and 102

Abstract:

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. Belinda will introduce you to the concept of calculated columns, measures, and basic data modeling, with some practical examples. This introduction will cover basic calculations and an overview of scalar and table functions. This session has practical examples of business analytics and users. To the Developer, DAX feels like a programming language; to the user, DAX feels like Excel formulas.

1. Define DAX and understand where it fits and why it is important
2. Perform and Review some basic DAX commands
3. Differentiate modeling with DAX versus the Power BI Query Editor
4. Build a Date Table to allow for the use of Time Intelligence DAX calculations
5. Overview of CALCULATE in DAX functions.

SessionID: 96795

Introduction to Azure Streaming Analytics

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Streaming Analytics

Abstract:

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.

SessionID: 96852

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: Application Database Development

Speaker: James McAuliffe

Title: Changing Data Is Easy, Managing Data Change is Hard!

Abstract:

Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

SessionID: 98009

AI Builder: AI in Power Apps and Microsoft Flow

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: Data Science

Speaker: Leila Etaati

Title: AI Builder: AI in Power Apps and Microsoft Flow

Abstract:

This session is about the new possibility of doing AI inside Power Apps and Microsoft Flow. the audience will get familiar with the new update announced in Business Application Summit on AI Builder that provides the facility to run easy AI inside Power Apps and Flow. a demo of how to create a form processing application using AI builder, Flow and Apps will be demonstrated

SessionID: 98081

Evolving Your BI Environment From SSRS To Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Preston Mesarvey

Title: Evolving Your BI Environment From SSRS To Power BI

Abstract:

With Power BI becoming a leading BI tool over the last few years, a question arises… What does this mean for the existing SSRS environment? This session will explore an analysis plan on your existing reporting landscape to provide you options and considerations to be able to make an informed decision about how Power BI could best be used in your environment. You will learn how to get valuable SSRS usage metrics. You will understand the benefits and limitations between the two BI tools and what questions to ask your users. By Monday morning you will be able to provide an analysis plan on what is involved to introduce Power BI into the enterprise.

SessionID: 98278

Running Windows and SQL Workloads on Google Cloud Platform

Back to calendar

Event Date: 19-10-2019 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: Jay Rajendran

Title: Running Windows and SQL Workloads on Google Cloud Platform

Abstract:

Google Cloud Platform enables you to exit non-differentiating, capital intensive activities like hardware procurement and maintenance. Retire hardware, improve server utilization and deploy your Windows and SQL Workloads in an open cloud environment. Google enables extending your SQL database with advanced Server-less Analytics and AI/ML offerings. Deliver a complete platform without the burden of provisioning, scaling and upgrading infrastructure. This session will provide a walk-through of Google's approach to running Windows/SQL workloads in the Cloud and architectural patterns to address your needs.

SessionID: 98826

Dimension Management for Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 11:30:00 - Track: Power BI

Speaker: Tyler Graham

Title: Dimension Management for Power BI

Abstract:

No matter the complexity of your BI application, dimension management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how to unlock more value from your analytics.

SessionID: 99067

Data Governance Implications of the California Consumer Protectio

Back to calendar

Event Date: 19-10-2019 - Session time: 11:30:00 - Track: Strategy and Architecture

Speaker: Geoffrey Rayner

Title: Data Governance Implications of the California Consumer Protectio

Abstract:

The California Consumer Protection Act (CCPA) has substantial implications on the data governance and data management practices of all companies that have customers in California. The CCPA will come into effect in 2020 and has substantial potentially large monetary penalties for non-compliance. Are you ready? We will discuss what the CCPA is and who is required to comply with the law. A presentation of MetaCenter, an enterprise metadata management and data governance solution, will be given to show how a tool can be used to help you comply with the data inventory and data lineage requirements of the CCPA.

SessionID: 98007

Unleash Row Level Security Patterns in Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Power BI

Speaker: Reza Rad

Title: Unleash Row Level Security Patterns in Power BI

Abstract:

Security is different from Sharing; Sharing is about sharing the entire content with others, security is about authorizing different views of the content to others. In this session we go through many different Row Level Security patterns; Static Row Level Security, Dynamic Row Level Security, and many variations of the dynamic RLS, such as giving manager access as well as employee access, you will learn about user profile security scenarios, and hierarchical access levels. This session shows you how DAX and Power BI security comes together to play an important part in a Power BI project lifecycle: Row Level Security.

SessionID: 98010

Microsoft AutoML the Next Generation of Machine Learning

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Data Science

Speaker: Leila Etaati

Title: Microsoft AutoML the Next Generation of Machine Learning

Abstract:

Automated machine learning simplifies the traditional machine learning process () by creating models with applying hyperparameter settings, and different algorithms. Also, choosing the best models among them based on the performance of each algorithm. Moreover, it provides more detail about the experiment and how much time has been spent to run each iteration and so forth. In this one hour session, an overview of what is Automated Azure ML will be provided, the latest updates of this products will be shown and the audience will learn how to set up the environment and how to use the mode in Power BI services and SQL Server.

SessionID: 98014

Data Science 101: An Introduction to Data Science Using Python

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Advanced Analysis Techniques

Speaker: Ganesh Lohani

Title: Data Science 101: An Introduction to Data Science Using Python

Abstract:

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.

SessionID: 98225

Data Modeling and DAX Tips for Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Power BI

Speaker: Patrick LeBlanc

Title: Data Modeling and DAX Tips for Power BI

Abstract:

One of the biggest problems I come across lately is poor performing Power BI reports due to bad data model designs. Since the data model is the foundation to all the reports, if you get it right the first time everything else tends fall inline. Join this session to learn the key steps and best practices you need to take to ensure a good data model.

SessionID: 98276

Intro to Power BI (or "How Power BI changed my Marriage")

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Power BI

Speaker: Jason Russell

Title: Intro to Power BI (or "How Power BI changed my Marriage")

Abstract:

Power BI introductory course with data from Amazon account to show purchases. Connections, importing/transforming data and visualizations will be covered.

SessionID: 98542

Power BI Pro, or Premium: that is the question

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Teo Lachev

Title: Power BI Pro, or Premium: that is the question

Abstract:

One question that always pops us during my Power BI assessments for companies planning to adopt Power BI is which SKU to buy. The choice might seem obvious to your organization, but there is much more below the surface. Join this session and learn important considerations that might influence your decision, including:

• Licensing cost • Hosting organizational semantic layers • External reporting • Features • On-premises reporting

SessionID: 98606

Power BI for Data Scientists

Back to calendar

Event Date: 19-10-2019 - Session time: 12:30:00 - Track: Power BI

Speaker: Javier Guillen

Title: Power BI for Data Scientists

Abstract:

Data Scientists often use a variety of tools to perform engineering and predictive modeling activities in their quest to squeeze as much value from data as possible. Although Power BI is sometimes seen as “just” a front-end visualization tool, its capabilities for data manipulation along with its interoperability with popular data science platforms make it a good choice for data experimentation on a broad set of scenarios.

This session will provide an overview of typical use cases that benefit from Power BI’s rich exploration capabilities in support of data science efforts. Attendees will learn about integration points between Power BI and data science platforms that can help uncover valuable business insights.

SessionID: 95764

Moving Data with Azure Data Factory

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Andy Leonard

Title: Moving Data with Azure Data Factory

Abstract:

Azure Data Factory - ADF - is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) - or "SSIS in the Cloud."

Attend this session to learn:

• How to build a "native ADF" pipeline;
• How to lift and shift SSIS to the Azure Data Factory integration Runtime; and
• ADF Design Patterns to execute and monitor pipelines and packages.

SessionID: 96245

AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: AI for the Masses: The Democratization of Artificial Intelligence in the Microsoft Ecosystem

Abstract:

Data is the new gold and companies are producing it in massive amounts. Historically it has been tough for companies to mine the data because of the amount of technical resources and human capital it takes to mine it. Fortunately, Microsoft has added tools and services in its data platform that addresses this problem.

In this session we will take a tour of the Microsoft ecosystem and explore some of these tools and services. We will explore:

• How AI models are easily productionized in the cloud using Azure Machine Learning Services and Azure Databricks
• How Microsoft brought data science to the database via SQL Server Machine Learning Services
• How AI can be used to enhance Power BI data models

Come to this information packed session, and you will walk away with ideas of how you can help your company leverage the gold mine of data it is sitting on to gain a competitive advantage.

SessionID: 96313

Managing ETL Change Using BIMLScript

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russel Loski

Title: Managing ETL Change Using BIMLScript

Abstract:

Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata.

To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.

SessionID: 96378

Power BI Embedded for Fun and Profit

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Power BI

Speaker: Samara Soucy

Title: Power BI Embedded for Fun and Profit

Abstract:

You COULD hire a front end developer to build data visualizations for your app. You COULD use "Publish to Web" to expose your sensitive data to anyone who gets a hold of the link. You COULD even force your users to leave what they were working on and tab over to the Power BI service to look at the data relevant to their current task.

None of that is fun, and it certainly isn't the most efficient use of time or funds. Fortunately, Power BI embedded is coming to your rescue. You can use the visualizations you've already built, keep the security you've already put in place, and allow your users to view contextual data in your applications-- right where they need it. You'll learn how embedding works within the Power BI service and how to create a successful embedded deployment.

SessionID: 98044

SQL Server Data Tools (SSDT) = Awesome

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Paul Waters

Title: SQL Server Data Tools (SSDT) = Awesome

Abstract:

Visual Studio SQL Server Data Tools (SSDT) is awesome! Here are a few reasons why.

• Create and organize database objects more easily with the Database project template.
• Write SQL code faster with IntelliSense.
• Checks for errors in real-time to identify mistakes quickly.
• Makes refactoring database objects seem like magic.
• Includes powerful tools for comparing database schemas and data.
• Integrates with source control systems including GIT.
• Helps make team development easier and safer.
• Enables continuous integration and deployment for modern end-to-end application lifecycle (ALM) practices.

Best of all… It’s free! Also, it works with all versions of Visual Studio – including the free community edition. In this presentation, I will show you how to get started with SSDT, get some quick wins, and touch on some of the advanced features. By the end of the presentation, I hope to make you as excited about SSDT as I am.

SessionID: 98045

Cool Things You Can Do With Azure Data Factory

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Daniel McConnell

Title: Cool Things You Can Do With Azure Data Factory

Abstract:

In this session, Daniel Chadwick will demonstrate why ADF can be a powerful new tool in your ETL toolbelt. They will show what the on-ramp looks like for an ETL Developer jumping into this brave new world of cloud ETL. The basics of the tool will be covered, plus some cool things from real-world projects that demonstrate the power of the new platform. Topics include:

What is it and why do I care? How do I translate my ETL skills into a new product? Real-world examples (cool things!) What does it cost really?

SessionID: 98224

Power BI Performance in 6 Demos

Back to calendar

Event Date: 19-10-2019 - Session time: 13:45:00 - Track: Power BI

Speaker: Patrick LeBlanc

Title: Power BI Performance in 6 Demos

Abstract:

We will explore some practical and common performance problems that customers encounter when using Power BI. From report design to your data, we will cover different aspects of Power BI to get you thinking about how to use the service within your organization.

SessionID: 95595

Level Up: Data Modeling for the Power BI Rockstar

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Anton

Title: Level Up: Data Modeling for the Power BI Rockstar

Abstract:

In the world of Power BI, data modeling is what separates the Rockstars from the Rookies. Join me to learn how dimensional modeling - a concept developed 20+ years ago - continues to be the best approach for delivering self-service BI to the masses.

Not only will good data modeling result in better Power BI solutions that support a wider range of reporting requirements, but they will also be easier for the business users to understand and work with.

In this session, you'll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic.   If your Power BI solutions typically contain a single table, if you're frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you've never heard the term "dimensional model" or "star-schema", this session is for you.

SessionID: 95597

AI on the Edge

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment

Speaker: Jared Rhodes

Title: AI on the Edge

Abstract:

The next evolution in cloud computing is a smarter application not in the cloud. As the cloud has continued to evolve, the applications that utilize it have had more and more capabilities of the cloud. This presentation will show how to push logic and machine learning from the cloud to an edge application. Afterward, creating edge applications which utilize the intelligence of the cloud should become effortless.

SessionID: 95612

Azure Machine Learning Studio: Making Data Science Easy(er)

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: Advanced Analysis Techniques

Speaker: Brad Llewellyn

Title: Azure Machine Learning Studio: Making Data Science Easy(er)

Abstract:

There's so much buzz around Data Science right now. What is it? What can I do with it? Do I need a Ph.D. and a team of super nerds? In this introductory session, we'll see that Azure Machine Learning Studio's intuitive interface and selection of built-in modules brings the power of Data Science to the people....no advanced degrees necessary. Bring your data hats and sense of adventure, because the world of data science just got a lot more inviting!

SessionID: 95884

Using Python In Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: Data Science

Speaker: Julie Smith

Title: Using Python In Power BI

Abstract:

Python is a powerful general purpose programming language that has emerged as one of the main tools of data scientists. Python was added to Power BI in June of 2018. This session will demonstrate the two areas python can be used inside the Power BI desktop-- how to leverage python scripts inside the Power BI query editor and how to use python visuals in Power BI reports.

SessionID: 96831

Aggregations in Power BI

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: Power BI

Speaker: Shabnam Watson

Title: Aggregations in Power BI

Abstract:

Aggregations are now generally available in Power BI and are one of the most important optimization methods for managing large datasets. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database.

In this session, you will learn about aggregations, different table storage modes, how to set up aggregation tables and configure them to improve query performance.

SessionID: 98524

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

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 Server.

SessionID: 99225

Power BI Architecture

Back to calendar

Event Date: 19-10-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paco Gonzalez

Title: Power BI Architecture

Abstract:

Having the right architecture is key to the adoption of Power BI, and to make the most of your business intelligence solution. This session guides you through different Power BI architectures, such as Direct Query, Import, Connect Live, Composite Models, and Embedded. We will analyze different techniques in data refresh, incremental extraction, integration and collaboration to provide a quick overview of the different approaches available.

This site is open source. Improve this page.