Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 24
Power BI is on the market for a while now. It's seems to be a mature BI platform, but still does not utilize the potential of AI to support business decisions. However, in the last few months Microsoft announced many new Power BI features related to AI which can change the way people will work with this technology in the future. The purpose of this demo-intensive session is to show the AI-based capabilities of Power BI in use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 10:30 AM - 11:15 AM

Room: Aula

Automating the construction and tuning of machine learning (ML) models has long been one of the goals of the ML community. This is due to several factors, most notably a sharp increase in the demand for tailored AI solutions, a relative scarcity of trained ML scientists, and the development of deep learning models with complex architectures requiring accurate design and fine-tuning.
Existing automated machine learning (AutoML) techniques have been remarkably successful in identifying good parameters for a given model, sometimes even outperforming humans. However, these options either take too long to train or they work for only a handful of parameters. That’s why Azure Machine Learning uses probabilistic latent variable model to work with DNNs without needing to fully train them. Azure Machine Learning Services (AML) provides a cloud-based environment you can use to develop, train, test, deploy, manage, and track machine learning models. AutoML in the cloud will soon become mainstream.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (45 minutes)

Track:
Advanced Analysis & Machine Learning

Level: Intermedia

Session Code: [EN\PL]

Date: September 28

Time: 11:30 AM - 12:15 PM

Room: Aula

With SQL Server 2019 announced new capabilities for High Availability and Disaster Recovery on containers in Kubernetes. During the session, you will learn Kubernetes concepts used by the latest version of SQL Server. How SQL Server High Availability works in Kubernetes and how to deploy it
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 3:15 PM - 4:00 PM

Room: Sala Konferencyjna

Integration Services has been in existence for about 14 years, but how it works hasn't really changed.
One of the most important features of SSIS is flexibility, which is also one of the most common failures. In this session you will learn what are the good practices of creating SSIS packages. How to handle errors, what to do to make our SSIS work quickly and efficiently.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code: [PL]

Date: September 28

Time: 11:30 AM - 12:15 PM

Room: S5

Data Flows component for Azure Data Factory brings power of Spark on Databricks with flexible and easy to use user interface. In this session you will learn basics of how Data Factory works, what is Data Flows components, how does it work and how does it integrate with Databricks without writing any code. Session will end with a live demo of Data Factory with Data Flow component.
This is also natural migration path for those working with SSIS.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code: [EN\PL]

Date: September 28

Time: 10:30 AM - 11:15 AM

Room: S9

Przedstawie zarys tego, do czego mozna uzywac sieci neuronowych w kontekscie obrazów - klasyfikacja, detekcja i segmentacja. Skupie sie na segmentacji obiektów na przykladzie znajdowania budynków na zdjeciach satelitarnych w konkursie Mapping Challenge i pokaze kilka pomyslów na usprawnienie modelu. Nastepnie pokaze, jak taki model pracuje na zdjeciach róznych miast z Google Maps i omówie warunki potrzebne do wytrenowania dobrego modelu.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
Advanced Analysis & Machine Learning

Level: Beginner

Session Code: [PL]

Date: September 28

Time: 3:15 PM - 4:00 PM

Room: S9

Aimed mostly at administration and based on real life scenarios, in this audience interactive session we will go through some scenarios DBA's might encounter whilst dealing with SQL Server databases and you will be provided with some options about what to do. Members of the audience will then select from these options what to do and we will follow that path and see what the outcome is from there.

Each selection will have a different outcome, and along the way you will probably learn some new things.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code: [EN]

Date: September 28

Time: 2:15 PM - 3:00 PM

Room: Aula

Session will help to understand term of context in DAX language and will help to understand why so often result of our query differs from expectation.
Basing on queries and visualizations, playing with PowerBI and DAX studio, we will see rules and examples, trying to understand how engine works and how sees what is coded in our calculations.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
Advanced Analysis & Machine Learning

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 2:15 PM - 3:00 PM

Room: S5

Even tough it's nothing new, Docker is a thing nowadays. I've decided to check containers out as well and learn how they can help me. Although I'm a BI consultant and not really using Docker and containers in the current projects, I've already found them to be very helpful on my daily basis learning and other activities. If you are also passionate about data and still experimenting with SQL Server and/or Python and/or any other technology, please join the session and see how Docker can change your life. 
I will show you my journey, my thoughts and my findings regarding the usage of SQL Server and Python together with Docker. And there will be a lot, a lot of demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 11:30 AM - 12:15 PM

Room: Sala Konferencyjna

Nowadays we are dealing with super efficient auto-tuning database servers but our queries sometimes run very slow. Everything looks ok but in our monitoring tools we can see higher resource consumption, wait statistics associated with locks or tempdb activity etc. What is the reason of this? During the session I will show few not very well-known aspects of work with SQL Server that can affect performance of specific queries and entire instance. During the session you will find a lot of practical demonstrations and tips that will help you diagnose specific problems and errors.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 10:30 AM - 11:15 AM

Room: Sala Konferencyjna

We all know CTEs and the recursive version of it. But how does it work internally? Why sometimes it can produce an unexpected result?

If you want to know how does recursive CTE work internally, want to know more about non-blocking, blocking and semi-blocking query plan operators, want to familiarise yourself with the spools, asserts, compute scalars - come to this session. I will analyse the whole query plan flow, describe the internals of the used operators and show you other situations where they are useful (or not).
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code: [EN\PL]

Date: September 28

Time: 1:15 PM - 2:00 PM

Room: Aula

In this session we will show how to get the most advantages out from Azure SQL Database.
We will learn how to monitor the performance of our workload, how to improve it and how to secure it using the tools and features at our disposal on the Azure portal without having to install 3rd party tools.
We will also see some ways to lower the costs or increase performance without having to also increase costs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code: [EN]

Date: September 28

Time: 2:15 PM - 3:00 PM

Room: Sala Konferencyjna

You have two ways to create a new visual for your great Power BI reports. The first one is to take something called Typescript and code a new stuff. It’s simple and exciting, isn’t it?  The second way is easier and cooler... Use Charticulator! This tool with a strange name gives you everything to prepare your own visual from a scratch without coding, only with dragging and dropping.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code: [PL]

Date: September 28

Time: 3:15 PM - 4:00 PM

Room: Aula

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 9:30 AM - 10:15 AM

Room: Aula

TBA
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Advanced Analysis & Machine Learning

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 9:30 AM - 10:15 AM

Room: Sala Konferencyjna

Paleta podstawowa komponentów wizualizacyjnych w Power BI zwykle pokrywa wiekszosc naszych potrzeb, a w razie pojawienia sie wiekszego apetytu mamy mozliwosc korzystac z zawartosci pólek Marketplace lub niezaleznych producentów. Jesli jednak tak szeroka oferta w jakis sposób nie jest zbiezna z nasza wizja to mozemy sami stworzyc komponent wizualizacyjny. W czasie sesji pokaze Wam jak sie do tego zabrac od strony narzedziowej, które "klocki" nalezy poznac i jakiego rodzaju umiejetnosci sa kluczowe przy tworzeniu wlasnego typu wykresu. Oczwiscie, w trakcie tych kilku kwadransów powstanie taki komponent, który bedzie gotowy do uzycia na naszym dashboardzie.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code: [EN\PL]

Date: September 28

Time: 11:30 AM - 12:15 PM

Room: S9

Despite the diversity of processed data, the approach to their presentation still has a lot in common. I'd like to tell you about tools, which have their own approach to SQL language. We will see how NoSQL in MongoDB, OQL in Pivotal GemFire ??and KSQL in Apache Kafka can imitate the most popular elements of the SQL language.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code: [EN\PL]

Date: September 28

Time: 3:15 PM - 4:00 PM

Room: S5

Have you ever wondered how to introduce powerful analytical functions to your application? How many times have you failed to complete this task? During this session, you will learn how to implement the power of Power BI in your own application. You will learn how to enrich your solution by placing excellent reports and dashboards.

Based on selected case studies, I will show you step by step on how to add data visualizations and interactive reports to your application.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code: [PL]

Date: September 28

Time: 1:15 PM - 2:00 PM

Room: Sala Konferencyjna

Processing of Tabular model is very common situation, there are many of solution for this problem: starting from  SSIS packages and ends on Azure Logic App. But what, when there is very large data model and time for processing limited to 5 minutes? The full processing takes too long, what's more there is no necessary to reload all the data, only data from last month can be changed and needs to be reloaded. In this case Partition manager is good solution which can limit the processing time to necessary minimum. During the session I will show how to easy implement solution, also I will tell about processing types and performance tips for large tabular models. 
Session in Polish.
Speaker:

Session Type:
Regular Session (45 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code: [PL]

Date: September 28

Time: 9:30 AM - 10:15 AM

Room: S5

Adaptive or Intelligent? Maybe both? SQL Server 2017 has come into the light packed with automated query tuning based on the Query Store and Plan Cache. 
SQL Server 2019 has a lot more important features like  =batch mode on rowstore, memory grant feedback, interleaved execution, adaptative joins, deferred compilation and approximate query processing. So now we have entered the Intelligent Query Processing world!.

I would like to present both the AQP and IQP to show what you can expect in the nearest future and how these features help your queries running faster
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (45 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code: [EN\PL]

Date: September 28

Time: 2:15 PM - 3:00 PM

Room: S9

Sessions Found: 24
Back to Top cage-aids
cage-aids
cage-aids
cage-aids