How to solve common data security requirements
Cloud computing requires new security paradigms that are unfamiliar to many application users, database administrators, and programmers. As a result, some organizations are hesitant to implement a cloud infrastructure for data management due to perceived security risks.
In this session, you will learn how to solve common security requirements for new or existing applications using Azure SQL Database and Azure SQL Managed Instance. We will cover Authentication and Authorization, Data Protection, Auditing and Security Management. After completing this session, you will understand how to meet specific security compliance standards and best practices.AdministrationSat 09:45 - 10:45
PowerApps, SharePoint & PowerBi: Better Together
This is a level 200 (intermediate) session that will dig into the synergy between PowerApps and SharePoint. Common scenarios, limitations and tricks will be discussed. What if you want to build a small report on top of the data from your new Power App? The session will also look into how to optimize your report's performance when using SharePoint as the data source. The context is building a small business app that tracks KPIs.AnalyticsSat 09:45 - 10:45
Practical Data Visualization Best Practices
Data visualization is the next hot topic! Tools like Power BI and Tableau make it easy to create stunning visualizations and dashboards. Creating data visualizations that effectively communicate data can take a bit more effort and consideration. In this session:
* an introduction to the key concepts of data visualization
* what is visual perception and how can it help us?
* why does everyone love pie charts but we shouldn't?
* how can we lie with charts?VisualisationSat 09:45 - 10:45
Streamlining your Machine Learning projects with Azure Machine Learning
Having a data scientist working out a complex machine learning model is one thing. Making that machine learning model part of a real solution that is ready for the future and that will evolve together with the business and the data, is another thing.
In this session, you will see how Azure Machine Learning can help in streamlining the team collaboration for Machine Learning. From the experimentation phase, the tuning of models, towards deployment and telemetry (and retraining) of the models.
This session will not dive in the complex details of AI/ML, but focus more on the actual workflow, which is called MLOps. You can expect a lot of demonstrations and demos.ArchitectureSat 09:45 - 10:45
A Python primer for DBAs
Tinkered with Powershell but not with Python yet? Let's get you started, and we'll do that with some practical examples focussed around talking to SQL Server and importing and exporting some data. Did you know that exporting data into csv with Python can be done with just a few lines of code and it processes it just as fast as SSIS does?AdministrationSat 11:00 - 12:00
Power BI Premium Per User & Paginated Reporting
Explore the functionality of printable reports within Power BI with this sessionVisualisationSat 11:00 - 12:00
Replication using Always On Clusters
Support for replication with AO clusters was not possible until the arrival of SQL Server 2017 CU6 and SQL Server 2016 SP2-CU3. The session explains step by step how to set it up correctly.ArchitectureSat 11:00 - 12:00
Rest APIs instead of scripting in Azure Data Factory
In the past we data warehouse developers often fell back to complex scripting solution to do seemlingly simple tasks like scaling and pausing Azure services to save some money on the Azure bill. If scripting is not your cup of tea then let me show you how to accompish all those common tasks with simple Rest API calls via the Azure Data Factory Web Activity.
Besides those often compute related tasks we can also simplify our data warehouse process with Rest API calls. For example retrieving values or secrets from Azure Key Vault to use those in the ADF pipelines, executing ADF pipelines from other Data Factories or processing your tabular models when the ETL process has finished.
And I will also show you how to give Azure Data Factory access to those services to execute Rest APIs without having to supply credentials.AnalyticsSat 11:00 - 12:00
I Lambda, therefore I am
Imagine living in a world full a products to be received, picked and delivered. You are working day and night to get things done. Sometimes there is success, sometimes there is failure. Everyone is analyzing your process and work in the old fashioned way: with their gut feeling. You start collecting excels and ones a month you have an idea what is going on. Existential questions rise, why am I working if I can't see what I accomplish? What did we do in the past? Where are we going? Winter is coming, the nights become darker and darker. You have an epiphany. Isn't there a way to use my old technological database, my reliable friend, to see my business in clear and solid graphs? And this in a way that my hard work in the past will shine like the brightest star in the sky! That warehouses will be accompanied with knowledge screens at the wall, giving people hope on how much orders they still need to ship on that day. That production managers will go to bed with no stress for the next. That you are feeling alive and kicking. That you are thinking and therefore exist.
(Implementing a modern datawarehouse with lambda architecture. A symbiose of realtime and batch analysis with the help of an Azure SQL Database, Stream Analytics, Data Factory, Data Lake and Power BI.)AnalyticsSat 13:00 - 14:00
Manage your Power BI resources with the Power BI CLI
The Power BI command-line interface (CLI) is a set of commands used to create and manage Power BI resources (e.g. reports, users and capacity). The CLI is designed to get you working quickly with Power BI, with an emphasis on automation.
Also, Power BI CLI capabilities make it easy to work with different programing languages and software environments as it is multiplatform (Linux, Windows, MacOS).
In this session I will introduce you to the core capabilities of the Power BI CLI and how to use it in combination together with Bash in an automation script that can be used with in a CI/CD pipeline.AdministrationSat 13:00 - 14:00
The hitchhikers/data consultants guide to the Business Application Platform universe.
CDS? CDM? Power Platform? Dynamics? CRM? Are you also confused? In this session we will focus on Microsoft's enterprise application platform which is changing quite rapidly and learn how data consultants can keep up with all this change. This session will demystify the Business Applications platform. It will focus on the platform's capabilities from a data perspective and how all the pieces fit together.ArchitectureSat 13:00 - 14:00
User Adoption of Your Report - Starting Off on the Right Foot
“If no one’s using your solution, then it’s not a good solution.”
Unused reports and solutions, abandoned in pre-production environments. We’ve all seen it, heard it or experienced it ourselves. It’s thus not surprising to hear Gartner predict that through 2022, up to 8 in 10 business & analytics projects will fail to help the business. What can we do, then, to help ensure adoption of our Power BI report, and for business users to make the most of our data visualizations?
In this talk, I highlight three key areas that impact adoption: measuring success, monitoring data quality, and promoting user engagement. To illustrate my points, I’ll use a hypothetical business case enriched by relatable, real-world experiences. First, I’ll demonstrate some ways that success can be measured, both during development and after launching the reports. Next, I’ll show an easy way to monitor the data quality in your Power BI reports. Finally, I’ll promote a simple post-launch practice to drive user engagement, promote data literacy, and foster an accepting, open data culture between report users and developers.
Achieving success in a business reporting project is a complex endeavor for which there are no quick-win formulas. However, taking steps start off on the right foot with users can dramatically improve not only chances at success, but also the overall experience for all involved!VisualisationSat 13:00 - 14:00
Data governance with Azure Purview
Where is that data stored? With the wide range of data storage options (On-prem, cloud, multi-cloud) it's far from trivial to know where all your corporate data is being kept, in which format, who's responsible? A related question is where sensitive data is being stored.
In this session you can see how Azure Purview collects meta-data from on-prem as well as different cloud sources, identifies sensitive data and makes it easily searchable.AnalyticsSat 14:15 - 15:15
From adaptive to intelligent: query processing in SQL 2019
As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.
In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.AdministrationSat 14:15 - 15:15
Infrastructure as Code: How to set up your (Azure) infrastructure in a matter of minutes
Setting up your cloud infrastructure for your different environments (e.g. Dev, Val, Prod) can be a tedious and repetitive task when doing it manually. This manual work also makes it more difficult to maintain and track the changes, which can result in inconsistent environments . Infrastructure-as-Code (IaC) offers a straightforward solution for this common problem by defining your infrastructure needs as code and deploying them accordingly. In this session I will guide you through the different options and benefits when using IaC, with a focus on Hashicorps' Terraform. A demo on how to use IaC in a CI/CD fashion with Azure Devops will help to get you started on setting up your cloud infrastructure in a matter of minutes.ArchitectureSat 14:15 - 15:15
Power BI like a Pro
An introductory session to help anyone working with Power BI or just beginning with a sensible workflow to keep a maintainable 'landscape'. This can be achieved with certain features and (best) practices, but these are not necessarily obvious when you start using Power BI. Consequently often after people start using PBI at some point the mess needs to be cleaned up... or they cross their fingers and hope it doesn't catch up with them. Naturally prevention is better than cure, so let's do some prevention!VisualisationSat 14:15 - 15:15
Drive a data culture in your organization
How to enable your organization to become data driven? Drive a data culture within your organization! This session is all about why a data culture matters, how you can build it up and how you can keep supporting the organization in driving the data culture!
I will guide you through do's and don'ts when it comes to building a data culture and how you can support your organization to the optimum in driving a data culture from a Competence Center or Center of Excellence perspective!AdministrationSat 15:30 - 16:30
How to enrich your vision on data using Cognitive Services in DataBricks and PowerBI
This session will give you a short walk through text analysis,
starting with an overview of different types of text analysis.
This will be followed by a demo of text and image analysis in DataBricks and how this can be visualized.
The session ends with a demo on how to do basic text analysis by using cognitive Services in PowerBI.VisualisationSat 15:30 - 16:30
How to get a running start at a new job, without getting lost.
"Welcome to your first day at company WeHaveData! Here are your laptop and your account, and you're good to go, right? Let me know if you have any questions; I'll be in an office miles away."
Many of us have been in situations like this. What are the questions you should definitely ask? What things can you do to figure stuff out yourself? How can you get up to speed as efficient and with as little frustration as possible, for both you and your new colleagues/managers/project leads? In this talk I'll guide you through some strategies and tips&tricks on how to get an overview of the data-landscape of a new place, for ensuring a confident start. At the end of the talk, you'll have some checklists with topics to broach, DMVs to use, and resources to keep on hand.ArchitectureSat 15:30 - 16:30
Introduction to Process Mining using PAFnow and Power Bi
Process mining is gaining more and more interest in businesses. Process mining is a set of techniques used for obtaining knowledge of and extracting insights from processes by the means of analyzing the event data, generated during the execution of the process. The session will be about what process mining is in general, to how companies could benefit from process mining. Next more technically to show which data is needed to get the right data in order to conduct process mining. Lastly also a demo of a real-life scenario process mining analysis using PAFnows process mining visuals and PowerBi.AnalyticsSat 15:30 - 16:30