In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then evolve it into a fully scalable Azure BI solution.
„A picture is worth a thousand words“ - compelling visualizations beyond the usual bar, line or scatter plots, produced with the help of the ggplot2 package and friends.
This is a session for the all of you with short attention spans (like me!) In this session, we will rapid fire tip after tip to help you be a better report author. We'll use the popular Microsoft tools, SSRS and Power BI.
Automate SSRS management using Microsoft's PowerShell module
There has always been a challenge of publishing an on-prem developed reports to external clients (non-AD users). Is this achievable with the latest SQL Server 2017 with RLS enabled?
Are you still asking yourself, what is big data? What is HDInsight and how can I benefit from it? which type of HDInsight Cluster should I use? come to this session and find an answer
Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios
A tour of Cassandra, a popular NoSQL DBMS
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
Get the most from Data Catalog with patterns and practices.
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Tabular Editor is an open source offline editor experience for SSAS Tabular, which offers lots of features in a simple UI that can vastly improve your productivity when developing Tabular Models at compatibility level 1200+
Mike Prince, Senior Technical Consultant and Independent User of MaxParallel™ reveals how it worked for Ultima Business Solutions and details the levels of performance enhancements they now achieve.
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
Best bractices in DAX formulas from real world experience.
This session takes a closer look at Azure Stream Analytics, and how you can make it work in your Projects.
How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames? Watch my talk and you will know!
Real-world scenarios and stories of a DBA who has to deal with different database platforms and their constant battle with efficiency. This session will offer neat solutions, demos, and tools to make your job more pleasant.
Introducing the ROC curve and its use in Azure ML.
Microsoft Power BI supports custom visuals from the Office Store ( In this session I will demonstrate what is needed for starting building your own.
Selecting the right PaaS components in Azure
We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.
For anyone frustrated by column-hoarding users and developers
Algorithms like Neural Nets, Deep Learning, SVM and KNN are dominating the Machine Learning world. You don’t need to know the maths behind them but you do need to know how they work in order to use them effectively. This talk will explain just that.
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Extended Events was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Combining Always ON Availability Groups and Powershell will make your life easier
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?
It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.
So you're thinking about doing implementing data science project in your business? If you fail to plan, you plan to fail, so come to this session to help you construct your data science plan to help you succeed!
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
Row Level Security based on related tables
Deep learning is an essential component of an analytical toolbox. There are considerable challenges in training deep learning models and this presentation explores how to overcome these using Microsoft’s scalable ML offering, Azure Batch AI.
Securing your Data is Easier than ever with Azure SQL Database: A Walk Around the Security Toolset. This will be a demo-heavy overview of the latest security capabilities available, including the newest intelligent data protection features.
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
Microsoft SQL Operations Studio is a new light-weight, free and multi-os tools for SQL Server, Azure SQLDB and DW running anywhere.
When you're in a rush, following best practices is a luxury you may not be able to afford. What about just avoiding worst practices instead? Join me for this session and learn from my mistakes!
SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next.
In this session, I'm going to show you six amazing tools that must be in your developer/consultant toolbelt. These tools help you develop, manage, monitor and optimize your Tabular model, in other words, it makes your day to day job easier.