• Daten Import und Visualisierung in Power BI für Anfänger

    Diese Einsteiger-Session bietet eine umfassende Einführung in den Datenimport sowie die Visualisierung in Power BI. Die Session richtet sich an alle Anfänger, die keine oder nur geringe Vorkenntnisse in Power BI haben. In der Session werden Sie durch praxisnahe Beispiele und Schritt-für-Schritt-Anleitungen geführt, um das grundlegende Verständnis für den Import von Daten und die Erstellung beeindruckender Visualisierungen zu erlangen. Folgende Punkte werden in der Session ausführlicher behandelt:
    - Grundlagen von Power BI
    - Datenimport
    - Datenmodellierung
    - Visualisierung
    - Dashboard-Erstellung

    Ich freue mich, mit Ihnen gemeinsam die Möglichkeiten von Power BI zu entschlüsseln!

    Anzünder
    Thu 10:00 - 11:00

  • A Day In The Life Of A(n Accidental) Fabric Administrator

    Do you know your way around Power BI Desktop, but don't know what happens beyond it, or what has to be managed in the Service?
    Do you have the privilege, as an IT Admin or Global Administrator, to "also take care of Power BI/Fabric"?
    Did you just receive the responsibility for some, or even all, Fabric Administrator tasks?
    Do you also not know what the Power Platform (management) truly encompasses?

    If you answer Yes to any of the questions above, this session is for you!
    And did you know a Premium Capacity is not a switch you turn on and just walk away from. It's like heating tomato soup in the microwave: if you don't pay attention, it becomes a mess very quickly.

    In this session, we will take a look at tasks and components that can be part of a Power BI Admin's daily routine.
    - The role of the Power BI Admin
    - Tenant settings
    - Handling My Workspace
    - Premium and Admin Monitoring
    - Power Platform Admin Center

    When you start applying the tips and tricks of this session, you will get a grip on your Fabric tenant and have happier users!

    Zange
    Thu 10:00 - 11:00

  • Hands-on Lipstick on a Pig - Improving a Power BI Report Step by Step

    You've been handed a report that could best be described as "visually suboptimal" or simply - "terrible".

    You would like nothing more than to spend the hours it deserves in a bid to make it much more clear, concise and useable, but the simple fact of the matter is that nobody wants to pay you for spending those hours.

    But - sometimes closing your eyes, groaning inwardly, and passing the report up the chain just isn't an option either. Something needs to be done, but it needs to be done quickly in order to make the report at least useable while not costing a fortune.

    This session will walk through every step how to turn a really bad report into something decent, discuss how to prioritize content and why accessibility is not only useful but vital for good report design.

    This session will not only show you what can be done but also explain why it not only may be done, but also why it really should.

    Grillrost
    Thu 10:00 - 11:00

  • Understanding the Azure Data Platform Options

    Azure offers many options for data platform services, and it can be confusing to choose the right platform for you application. In this session you will learn about all of the different Azure SQL and non-SQL data offerings and how they fit into you data ecosystem.

    Holzkohle
    Thu 10:00 - 11:00

  • Delivering Real World Actionable Finance P&L Dashboards in Power BI - Data Engineering to Analytics

    Getting from data engineering to real-world analytics is always a challenge, especially in the finance sector. In this session we'll show you how to do exactly that using advanced techniques in Power BI, covering data modelling and Zebra BI custom visuals.

    For example:
    • How can we reduce our monthly, quarterly and yearly review meeting time and focus on measures to be taken?
    • What is the best way to create actionable finance dashboards?
    • How can we overcome performance issues within our P&L statement in Power BI?

    We'll take a look at the financial services industry from a backend and frontend perspective covering data engineering possibilities and focusing on a real-world Power BI dashboard being the most used report in a global organization. Learn everything from data modelling, power query transformations (M), high performing DAX calculations and visualization advantages to create a complete profit and loss (P&L) statement that finance and controlling can use daily.

    As a bonus, learn all the skills required to add real value to your reporting approach across other industries using the Microsoft tools.

    Anzünder
    Thu 11:15 - 12:15

  • Building an Azure Data Resources with Bicep

    As you know Azure Resources can be built via ARM Templates. In this demo packed session german Data Platform MVP Frank Geisler will show how to build Azure Data Resoures with Biceps, the new way of declarative creating Azure Resources.

    Grillrost
    Thu 11:15 - 12:15

  • Exploring the Microsoft Semantic Link for improved data science

    Microsoft's Semantic Link is a powerful feature that provides a bridge between Power BI data sets and Synapse Data Science in the Microsoft Fabric.

    Data scientists can connect to the Power BI ecosystem from within notebooks using Semantic Link and the provided SemPy library. For example, by eliminating the need to reimplement business logic embedded in Power BI measures, Semantic Link enables seamless collaboration between data scientists and business analysts. This approach ensures that both parties are able to work in an efficient and productive manner and maximise the potential of their data-driven insights. Microsoft's underlying FabricDataFrame is the core data structure of Semantic Link. It is a subclass of the pandas.DataFrame and adds metadata such as semantic information and provenance. FabricDataFrame is the primary data structure that is used by Semantic Link to distribute the semantic information from the Power BI data sets to the data science environment.

    In this session we will go into detail about the structures and capabilities of Semantic Link, SemPy and the new FabricDataFrame. We will also present several use cases that can be implemented using Semantic Link.

    Zange
    Thu 11:15 - 12:15

  • Databricks' Medallion Architecture with Template-Based Notebooks and Unity Catalog

    Join us for a session on Databricks Azure, where we will explore the game-changing Medallion Architecture. The session will focus on the integration of template-based notebooks, where we will showcase how this feature enhances collaboration, accelerates workflows, and ensures consistency in analytics projects. Additionally, we will discover the power of Unity Catalog integration, providing a centralized hub for metadata management and optimizing data discoverability.

    Holzkohle
    Thu 11:15 - 12:15

  • From Rockstar to Rookie: A Journey of Career Transformation in Data Analytics

    Embark on a captivating journey of career metamorphosis as we follow the path of a former truck-driving Rockstar turned data analysis Rookie. In this session, we'll delve into the transformation story that showcases the power of passion, determination, and the audacity to start anew.

    Thrash through the Rookie's journey from data zero to analytical hero. Uncover the power chords of online courses, mentorship, and grit that propelled them forward.

    Anzünder
    Thu 13:15 - 14:15

  • an Introduction to DuckDB

    Described as the SQL Lite for Analytics, DuckDB is the in-process OLAP engine that every Data professional should know about. This Open Source engine with Dutch and German roots can handle analytics workloads, and prove that it's really not always needed to use distributed spark systems.

    Grillrost
    Thu 13:15 - 14:15

  • Dashboard Design - The icing on the cake

    5 steps to put the icing on the dashboard(cake).
    A session for beginning and intermediate dashboard designers showing some easy steps to make a dashboard visually appealing and easy to read.
    The session's story is comparing building and designing a dashboard with baking a cake at a baking competition. Everyone has the same ingredients (data) and the same recipe (business question) but in the end, the cakes (dashboards) look different. Using the steps of this session you will learn how you can quickly improve a dashboard without spending too much time. The goal of the session is to inspire and guide dashboard builders and give them confidence in presenting their dashboard to the "jury" (the business) after building it.

    Zange
    Thu 13:15 - 14:15

  • Data Engineering Execution Optimization

    If you are using an execution framework to run scripts, pipelines, or any other ETL processes; you need to tune and optimize how they run.

    In this session we will discuss:
    - What an execution framework?
    - What do some common frameworks look like?
    - What is a directed acyclic graph (DAG)?
    - How do you measure your ETL execution?
    - What is the Longest Path Problem?
    - How do we remove dependencies in our DAG?

    All of these questions lead to the main tenants of DataOps of Automation, Observability & Monitoring, and Incident Response.

    Holzkohle
    Thu 13:15 - 14:15

  • There is no talent shortage in Data & Analytics!

    It is widely agreed that the talent shortage is one of the biggest challenges for businesses everywhere.

    Data & Analytics teams especially struggle to find highly skilled professionals. With the need for more advanced analytics, new cloud technologies and machine learning, demand has skyrocketed.

    In this session, I will argue that the talent shortage might be a misconception and how a people-centric approach to recruiting and talent development can fix that.

    We will also explore how every team member can help create an inclusive workplace that everybody is happy to work in.

    Anzünder
    Thu 14:30 - 15:30

  • Design for All: Increase the Accessibility of your Power BI Dashboards

    Designing accessible dashboards is crucial to foster inclusivity and ensure that all users can access and interpret the data equally. My session on Design for All focuses on this very principle and will have an overview of the different aspects which one needs to consider while designing their dashboards. The session will cover the best practices and features available in Power BI with walkthrough examples that will empower the participants to implement dashboards that can reach a wider audience.

    Zange
    Thu 14:30 - 15:30

  • DevOps and FinOps: A Strategy for Cost-Effective Data Platforms

    This sessions aims to illuminate the role of integrating Financial Operations (FinOps) within DevOps practices to build a more cost-effective Data Platform in the Cloud.
    As organisations strive to accelerate their digital transformation, the need for a harmonious blend of both these methodologies has become increasingly crucial.

    The essence of DevOps – emphasising continuous integration, continuous delivery, and rapid deployment – is elevated when intertwined with FinOps principles.

    This integration facilitates real-time financial oversight and cost optimisation without impeding the speed and quality inherent in DevOps.

    This session will explore the dynamics of this integration, focusing on how real-time financial data can inform and refine operational decisions, thus leading to more efficient resource utilisation and reduced financial waste.

    This session targets professionals seeking to optimise their organisation's business delivery lifecycle by aligning technical operations with financial objectives.

    Grillrost
    Thu 14:30 - 15:30

  • Exploring Execution Plans

    Getting started reading execution plans is very straight forward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you’ll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.

    Holzkohle
    Thu 14:30 - 15:30

  • Handling complex Row- and Column-Level-Security at scale in Databricks

    Do you have complex requirements for your row level security setup like…
    • Multiple fact tables containing sensitive data?
    • Users and or Fact tables belonging to different business domains (Sales, Finance) with partly overlapping access rights? (AD Group “GlobalManagers” can access both, others the one or the other)
    • Multiple dimensional columns per fact table relevant for row level security?
    • Column level security dependent on row level security? (Global Data without compensation data, but just for Germany with compensation data)
    • Complex combinations of OR, AND as well as IN (‘Value’, ‘List’) conditions per user? (Country in (‘Germany’,’Austria’) OR CostCenterGroup = “Sales”)
    • Exclusions? (Global Finance Data except CostCenter = “CEO”)

    Did you made more than 2 ticks in the box?

    This session covers the concepts and implementation ideas to handle these complex Row- and Column-Level-Security requirements at scale in Azure Databricks. In addition to the requirements above, there are some technical restrictions met like
    • minimal RLS-related overhead for end-user data retrieval (max 5 seconds) and
    • fast processing time for pre-calculating the mapping tables used during the data retrieval

    Let’s have fun with building a brain-knot and untie it again.

    Anzünder
    Thu 15:45 - 16:45

  • Deep Dive into Power BI Source Control

    2023 has brought significant new capabilities to Power BI for source control and deployment automation - Developer Mode, TMDL, and Fabric Git Integration, to name a few. Features many Pro users have been demanding for years.
    With further extensions to those technologies planned for early 2024, this session is your opportunity to learn about the current state of source control for Power BI in a deep-dive workshop.
    The session will focus on professional development patterns in a collaborative environment. It will explain and show how all the latest Pro Dev features in Power BI can be utilized to set up practical team development workflows.
    Furthermore, attendees will understand where Microsoft's tooling still has gaps, and how external tools can be brought in to help.

    Zange
    Thu 15:45 - 16:45

  • Maximizing Database Performance With Isolation Levels

    Databases have long been able to process queries from multiple users concurrently, but managing processes that can lock and block each other is no simple feat! This session will explain the isolation levels supported by Azure SQL Database and SQL Server, how they work, and how they differ. Multiple demonstrations will also show how changing isolation levels can affect not only query performance, but also determine which rows are (or are not) returned in the result set. Attendees will learn how to choose the optimal isolation level for a workload, and will see how simple it can be to improve performance with the proper isolation setting.

    Whether in the cloud or on premises, understanding database isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address. Attend this session and gain senior-level skills on how to maximize your database's ability to handle concurrent operations!

    Grillrost
    Thu 15:45 - 16:45

  • From substitutions to public keys - an introduction to cryptography

    Cryptography is everywhere. Most of what you do on the Internet and in the cloud is encrypted. If you’re working with data or cloud infrastructure, just checking the TLS checkbox is only half the job. You need to have a decent understanding of what goes on underneath the padlock icon in order to keep your company’s dirty secrets safe.

    In this high-level introduction to cryptography, we’ll look at the origins and evolution of encryption, leading up to modern-day symmetric and asymmetric encryption, signatures and certificates. After the session, you’ll be able to use hand-wavy phrases like “certificate chain” and “public key infrastructure”, as if you know what they mean.

    No PhD required.

    Holzkohle
    Thu 15:45 - 16:45

  • Leveraging Field Parameters for Dynamic Data Visualization

    In today's data-driven landscape, the need for adaptable and versatile reporting is paramount. The challenge often lies in accommodating diverse requirements without overwhelming your report with redundant visuals.

    Enter Field Parameters—a robust feature designed to add dynamic flexibility to your reports.

    In this session, attendees will gain hands-on experience in implementing field parameters within a reporting framework. This will empower users to interactively explore their data in a methodical and efficient manner, thereby eliminating the need for multiple static visuals and enhancing the user experience.
    Learn how to make your reports not just informative, but also intuitive and user-friendly through the incorporation of Field Parameters.

    Anzünder
    Thu 17:00 - 18:00

  • Dynamic M query Parameters in Power BI Desktop

    In Power BI, dynamic M query parameters are used to create flexible and interactive data transformations. These parameters allow you to change the behavior of your queries at runtime, making your data analysis more versatile and user-friendly. Let's explore together the process of creating Dynamic M query parameters and utilizing them in Power BI Desktop through live demos.

    Zange
    Thu 17:00 - 18:00

  • Lessons learned: Governance and Adoption for Power BI

    Rolling out Power BI within an organization is not an easy job. There are usually two strategies: Decide on a governance and adoption strategy first and roll out Power BI accordingly, or make Power BI widely available and set up governance and adoption afterwards. Especially in the latter scenario, setting up a proper governance and adoption strategy might become a challenge. Users might resist new guidelines as they are used to their own way of work and feel neglected without any guidance on how to use Power BI. On top of that, there might widely used solutions in place which are violating the company regulations, leading to more resistance in changing and rearranging the way of work.

    This session focuses on the (re)governance and (re)adoption of Power BI within an organization in which Power BI is already being (widely) used by users with limited governance and adoption. As there are multiple paths to success, we will focus on a few core concepts to take into account when walking one of these paths. These concepts include, but are not limited to:

    - Practices: Clear and transparent guidance and control on what actions are permitted, why and how.
    - Content ownership: Managing and owning the content in Power BI.
    - Enablement: Empowering users to leverage Power BI for data driven decisions.
    - Help and Support: Establishing a support system with training, various levels of support and community.

    In this session we will combine these theoretical concepts with lessons I learned along the way of implementing these concepts at various projects.

    Grillrost
    Thu 17:00 - 18:00

  • It's just a SQL - Crash course on Fabric Warehouse for T-SQL ninjas!

    Are you a seasoned T-SQL developer, used to solving each and every challenge by writing plain old SQL? But, now you need to leverage data coming from semi-structured or unstructured sources?

    What if I tell you that you can get your mission accomplished by writing your favorite T-SQL syntax?

    In this session, you will learn what is a Warehouse within Microsoft Fabric, how it works behind the scenes, how it compares to a traditional data warehouse, and how you can preserve your "T-SQL Ninja" status even when dealing with the data coming from CSV, Parquet, or Delta files. You'll also understand the difference between the Warehouse and Lakehouse in Microsoft Fabric, and how to leverage T-SQL language to get the best of both worlds, by combining the data from Warehouse and Lakehouse!

    This session WILL NOT teach you how to write SQL - I assume you are already familiar with the T-SQL basics, and that you are now eager to apply your T-SQL skills in a different environment!

    Holzkohle
    Thu 17:00 - 18:00

  • Riding The Wave of Everchanging Technologies

    The technology field, especially the cloud is in a constant change and it is challenging to keep up! We've got AI, Copilots and of course Microsoft Fabric as the latest to learn more about. So how do you really keep up?

    In this session I will talk about how to handle being faced with a lot of unknowns, having to learn completely new concepts and solutions very quickly (and implement them!). I will share my experiences and the insights I've learned on my own career, as well as some of the research that can help us understand learning in such a fast passed environment. This session can be useful for anyone looking to keep their knowledge up to date or expand knowledge to a new area - and get excited (instead of overwhelmed) about learning again!

    Anzünder
    Fri 08:30 - 09:30

  • Designing and managing a cost-effective data platform in Azure Synapse Analytics

    Azure Synapse Analytics is a powerful data platform, but it can also be expensive if you don't know what you're doing. In this session, we will go through the different components of Azure Synapse Analytics and discuss how to design a cost-effective data platform.

    We will cover topics such as choosing the right pricing tier, optimizing data storage and processing, and leveraging built-in cost management features. We will also discuss how to optimize your data platform for cost efficiency by using features such as serverless compute, pre purchase compute and reserved capacity.

    Attendees will leave with a better understanding of how to design and manage their Azure Synapse Analytics platform for cost efficiency and how to design a cost-effective data platform that meets your organization's needs.
    Topics we will cover:

    - Pricing Models for compute Resources in Azure Synapse Analytics
    - Storage Types and Tiers
    - Pricing Models
    - Optimizing Cost with Resource-Scaling
    - Using serverless compute and reserved capacity options for cost savings

    Grillrost
    Fri 08:30 - 09:30

  • Talking API with your data: REST, GraphQL and more

    The use of REST APIs has become the de-facto standard for modern web applications and integrative scenarios. It is therefore no surprise that there is also a lot happening in the Microsoft SQL world and with the native integration for calls to external REST endpoints in Azure SQL Database and Data API builder, two exciting projects can be discovered.

    If you're in the mood for a little exploration, this session is just the right way to get started!

    Zange
    Fri 08:30 - 09:30

  • dbatools - Wheel of Fortune

    Ad voice: Want to play Wheel of Fortune dbatools style?

    Come and join us on a demo-driven session where you will be the player and we gift you with some next-level demos using dbatools!

    Spin the wheel and let luck be with you!

    There are so many things we want to show you with dbatools that we couldn't decide - so now you decide!

    Demos could include:
    - Managing Availability Groups
    - Migrating databases
    - Refreshing test environments
    - Masking sensitive data
    - Checking we're meeting best practices
    - Managing Logins, Users & Permissions
    - Using Database Snapshots for Application Upgrades
    - Document your entire SQL environment
    - Backups and Restores
    - Copy table data around
    - Deploy tools including WhoIsActive & Ola maintenance scripts
    - Patching SQL Servers
    - Finding objects
    - and others - who knows where the wheel may take us

    Holzkohle
    Fri 08:30 - 09:30

  • Talking about mental health for you and for them

    Everyone experiences, or is adjacent to people who experience, challenges with mental health. We often find it difficult to talk with people about these challenges.

    In this session I will enable you to face these uncomfortable conversations with a set of tools that can help to make them easier for everyone involved

    You will leave this session with some tools to be able to help yourself identify and deal with these challenges as well as a better understanding and knowledge of how to be most supportive for your family, friends and colleagues who are facing them.

    Anzünder
    Fri 09:45 - 10:45

  • Branching strategies 101 for data professionals

    Branching strategies are essential for any data professional - whether you're a DBA, DEV or BI professional.

    Even as a data professionals you can create and manage different versions of your code, data, and models without affecting the main branch/definition of your code, data, and models.

    Branching also enables easy collaboration, experimentation, and testing in a safe and organized way.

    In this session, we will introduce the basic concepts of branching, such as branch creation, merging, and deletion.

    We will also discuss some common branching strategies, such as feature branches, release branches, and hotfix branches.

    Finally, we will put this into practice using Git as well as try and provide you with some best practices and tips for using branching effectively in your data projects.

    Zange
    Fri 09:45 - 10:45

  • Power BI meets UX Design: Accessible Insights

    Imagine crafting a compelling report—rich in insights and visuals—only to discover your audience can't use it or struggles to grasp its depth. In "Accessible Insights," we'll delve into inclusive UX design principles, revealing the strategic use of icons, text, and visual cues within Power BI.

    Stepping into the shoes of users with varying abilities, we'll emphasize the crucial role of empathetic design and uncover the hidden, built-in accessible capabilities of Power BI.

    Join this session to learn how to create reports that transcend barriers and speak universally to diverse audiences.

    After all, accessibility is not just a buzzword—it's a necessity.

    Grillrost
    Fri 09:45 - 10:45

  • Getting Started with GraphQL

    Let's dive into GraphQL, the groundbreaking API technology that's setting new standards in data interaction. Originated at Facebook and now an open-source marvel, GraphQL allows you to ask for exactly the data you need, cutting out the noise of multiple endpoints. From fetching to querying, it serves as your customized data concierge, bringing order to your API structure. Adopted by industry giants like Github, Yelp, and Shopify, GraphQL is not just a trend but a paradigm shift. Come find out what it can do for your projects.

    Holzkohle
    Fri 09:45 - 10:45

  • Overcoming the Fear: Exploring Microsoft Fabric from a Power BI Angle

    Discover the potential of Microsoft Fabric as it connects Power BI and Data Engineering, merging these domains into a unified landscape. This groundbreaking development may ignite your curiosity to explore new frontiers, even though the unfamiliar elements and tasks might seem daunting. Are you unsure about learning new skills such as Python, data integration pipelines, and Spark notebooks? Perhaps the thought of these technologies and coding languages is a bit intimidating because you've never used them before?

    If you find yourself nodding along, then this session is perfect for you! Join us as we explore Microsoft Fabric from a Power BI perspective. We'll dive into the familiar components we already love, discussing the complete process from ingesting data to serving it to your end users. And the best part? Together, we'll build a solution using the full capabilities of Microsoft Fabric.

    By the end of this session, you'll feel confident and ready to create your own solutions with Microsoft Fabric. It opens up exciting possibilities to expand your skills and venture into the fascinating world of data from various angles.

    Anzünder
    Fri 11:00 - 12:00

  • Can Microsoft Purview Answer All Your Data Governance Needs?

    Your company has amassed more data than it can possibly use, yet no one can find the data they need. Your company also deals with sensitive data, but you have no idea what your exposure is should a breach occur. This session will introduce you to Azure Purview and what problems it was designed to solve for. We'll walk through all the major features of Purview, including Data Map, Data Catalog, Workflows, Policies, and Insights to see if Azure Purview can answer all your data governance needs.

    Zange
    Fri 11:00 - 12:00

  • Streamlining Power BI with PowerShell

    Power BI is a vital tool for data analytics, but managing workspaces, access, and data sets manually can be time-consuming and error-prone.
    This session explores how PowerShell automation simplifies and streamlines these tasks.

    Bringing these two different worlds together is a challenge in itself. But let's give it a go and see how far we can automate PowerBI.

    PowerShell can:

    Automate workspace management.
    Control user access.
    Manage data sets, connections, and refresh schedules.
    Schedule routine tasks for data maintenance and reporting.

    PowerShell enhances efficiency, reduces errors, and improves data security.
    This session highlights its role in transforming Power BI management for data-driven decision-making and operational efficiency.

    Grillrost
    Fri 11:00 - 12:00

  • Code, deploy and maintain your Azure (data) Infrastructure with confidence

    Have you been deploying your Azure databases and all connected resources through the portal?
    Are you fed-up with clicking, weird resource naming and mostly, with having to deal with changes manually?

    If you are working in Azure and you have anything to do with data and the infrastructure, this session is for you!

    Azure Infrastructure as Code offers a plethora of possibilities, but the first time I checked it out, all I saw were Azure Resource Manager (ARM) templates. Hard to read, harder to write. They gave me headaches. It seems I wasn't the only one with that problem, because there are excellent tools to help you out! My favourite, and the one I'm using in this session is Terraform.

    Now why is this presenter talking about this? I've deployed a number of customer environments with this language. Whenever there's a security update, like a new policy for example, I can deploy this to all customers in minutes. I'll only have to code this once and can easily deliver it many times, saving them time and money. Resources we can spend in other areas like ETL, ELT etc.

    During the session, I'll demonstrate the basics of a data deployment, following the spirit of the Microsoft Well Architected Framework. I'll show you my way of working, the structure and and the end result. There is no need to try and photograph what's happening on screen, all the scripts will be available after the session.

    Holzkohle
    Fri 11:00 - 12:00

  • Gender 101

    Between 0.5% a 5% of people does not identify with the gender they were assigned at birth. Chances are you work with someone, or will work with someone in the future, who is not cisgender, and is transgender and/or nonbinary.

    Do these sentences already confuse you and use terms you do not know? Want to learn what all the letters in the LGBTQIA* acronym stand for? And how to create a welcome environment at your workplace for queer folk of all shapes and sizes? Come to this talk! Feel free to ask the questions you were always afraid to ask (as long as they're asked with an open mind and with respect).

    Anzünder
    Fri 13:00 - 14:00

  • Dynamic Pivot – Making Columns out of Rows

    You have a result set in relational format, but you want to pivot the result set for presentational reasons, so that that the values in some column(s) in the result set become column in what the user sees. And in many cases, you don’t know these values beforehand, so the pivot operation has to be dynamic.

    This is a non-relational operation, which may be better done client-side. Nevertheless, being able to do a dynamic pivot in SQL is a valuable asset to have in your tool belt.

    To be able to write a dynamic pivot, you need two master two things: writing static pivot queries and dynamic SQL.

    In this session, we will start learning how to write static pivot queries. In case you already feel acquainted with the PIVOT operation in T-SQL, here is a teaser: we will not use that operator, but a much more flexible scheme.

    Next, we will move on to the basics of dynamic SQL. Dynamic SQL itself is quite an advanced feature, but we will only have time for the basics – and some words of caution.

    Finally, we will put these things together and learn how to write dynamic pivots.

    This is a level-200 session. Preferably, you should have been working with writing queries and stored procedures for two-three years to have full benefit of the session.

    Grillrost
    Fri 13:00 - 14:00

  • The Sixth Sense: Using Log Analytics to Efficiently Manage Your Azure Environment

    Log Analytics sees all, knows all, and is an ever-present help in any Azure environment. Azure Monitor logs and diagnostics can be collected from almost any Azure resource you could ever think of, and can help offer powerful insights on the performance metrics of your resources and activities, keep track of changes and deployments in your environment, and more!

    This session will cover the benefits and capabilities of Log Analytics and the underlying Kusto engine, and how you can interactively analyse your logs and metrics using the Kusto Query Language (KQL). You'll learn how to manage and optimise your Azure estate with demonstrations of how you can visualise resource usage over time, spot anomalies and trends and configure alerting that could be crucial to keeping your business-critical resources up and running.

    Zange
    Fri 13:00 - 14:00

  • Introduction to Microsoft Fabric - the future of Power BI and Synapse?

    Microsoft Fabric is here, but what is it and why is it needed?
    This session will give you a solid understanding of what Fabric is, the architecture, how data warehousing and data lakes fit into Power BI, and why it's the future for our data engineering and data analytics projects.

    Holzkohle
    Fri 13:00 - 14:00

  • Using your existing knowledge, skills and experience to “make it” in the Tech World.

    Are you new to tech or have you started along the journey and are looking to make a success of working in this industry but aren’t sure how? Are you struggling to progress and want to know how to get further in your career?

    Whether you are starting your first job, you already have years of experience in other areas or you are already part way into your journey, it’s only natural to think that it will be difficult to thrive in the Data World! However, don’t let this put you off. What if I told you that you might just find you have more relevant skills and experience to progress in tech than you first thought?

    In this session, I will share my own experiences and how I have overcome many obstacles during my career so far where I have worked in a wide range of industries. Even if you are not new to tech but are keen to help others along their journey and learn from it, then this session is also for you.

    We will talk about the skills and tools we have at our disposal that you can leverage to help kick-start your new tech career!

    Anzünder
    Fri 14:15 - 15:15

  • From Frustration to Fun: Mastering Power BI Errors with a Smile

    Errors are often the most valuable learning moments. This session is about the most common errors in in Power BI Desktop and Power BI Service every Power BI report developer will encounter at some point, and how to fix them. I will demonstrate each error, explain the error message (which often doesn’t provide sufficient guidance), why the error is thrown and what needs to be done to fix it, including debugging strategies. By unleashing the Power of Errors, I am transforming setbacks into valuable insights!

    Learning objectives:
    Recognise the most common Power BI error messages
    How to read/understand Power BI error messages
    How to fix the most common Power BI errors
    How to fix other errors: debugging strategies

    Grillrost
    Fri 14:15 - 15:15

  • Kusto - an introduction

    Kusto is the language to use for, amongst others, Azure Data Explorer, streaming data, and data from Log Analytics. The language seems to be a bit like SQL, but when things get rolling it can be confusing and hard to get right,

    In this introduction session I cover the basics of the Kusto language and how to get started working with streaming, Log analytics and time-series data. I'll take a start from an introduction to the language, usable examples and implementations of different queries. I will also cover the method for working with scalar variables and window functions.

    This is a level 100 session with a bit of level 200 at the end. A good session to get started with Kusto and is directed towards developers who are interested in the Kusto language and would like to get started.

    Zange
    Fri 14:15 - 15:15

  • Uncovering Secrets and Mysteries in your Power BI Tenant

    Microsoft Power BI is all the rage, with enterprise and user adoption soaring year after year. New users get onboarded, reports,models, dashboards, dataflows, .. get created and tweaked every day. Whoa, things must be going great if we have so many things happening every day! Right?

    And yet, as the usage skyrockets in our organisation, it's crucial to keep a solid oversight of the artefacts and activities generated by our colleagues. All too often, organisations have procedures, governance models, methodologies, and more in place, without having a structural way of making sure it actually works for the business processes. Enabling the business to make their decision on usage information for their artefacts will assist them in making informed decisions. Making sure this information gets to Data Stewards (workspace owners) is often left untouched, as there's no ready to go solution out there.

    This session will focus on creating a Self-Service Power BI model and report, where users can follow up on activities performed on artefacts in their zone of control. We'll start with collecting the necessary information through various APIs, defining a model with Row-Level Security, and layer a Power BI Report on top of this.

    Leveraging a solution like this, can drastically improve the general overview of the general usage of Power BI in the organisation, and make informed decisions for the BI Information Delivery flow.

    Holzkohle
    Fri 14:15 - 15:15

  • Tales from the Field - How to Avoid Burnout

    In the fast paced "always plugged in world" we all live in today, getting burned out is something that you will most likely experience. That feeling of emotional and physical exhaustion that leaves you overwhelmed, trapped, defeated and stagnant can be unbearable. Taking the time to learn how to avoid burnout can be game-changer for your mental health, motivation, and productivity. In this session, we will discuss ways to help prevent that burn out.

    Anzünder
    Fri 15:30 - 16:30

  • Database Deployment Automation using Database Projects & Azure DevOps

    You have implemented Database Projects and Azure DevOps for database development successfully in your organization and you want to make your life easier by automating your database deployments? If the answer is yes, this session is for you!

    At the beginning of this session, we will do a quick recap of Database Projects and Azure DevOps. Just to make sure that we are all on the same page.

    During the session, we will set up an example build and deploy pipeline. Since there are a couple of ways to deploy changes from Azure DevOps to your target database, we will discuss these cases and I will be showing you which method I'm using.

    - 1 Release Pipeline to rule them all
    - multi-step deployment

    During this session, we will also cover the deployment pipeline differences between SQL Server and AzureSQL.

    At the end of the session, you should have a starting position to be able to start your database deployment automation.

    Grillrost
    Fri 15:30 - 16:30

  • Old Name - New CLI - why you should take a look at sqlcmd

    Introduced with SQL Server 2005 and replacing osql, sqlcmd has been a part of SQL Server professionals toolbox for a long time now.
    Many people only know it from the sqlcmd mode switch in SSMS, while others use it within automation as a lightweight easily available query runner. I have long recommended that DBAs are familiar with using it as it may be the only option to query an instance in severe emergencies.
    Times they are a changing.
    There is a new sqlcmd available and it has some awesome new capabilities.

    Let me introduce you to the new sqlcmd in a fun filled demo session and show you the new things it can do and why they will be of benefit to all Data Professionals

    We will cover deploying a database into a container from a backup with one command.

    Querying it, Opening it in Azure Data Studio, all from the command line and much more

    Zange
    Fri 15:30 - 16:30

  • Web Scraping with Power BI & Microsoft Fabric

    Sometimes you need to source data from the internet, but there isn't an API to access partner, industry or public data available out on the web... and that's when you need to roll up your sleeves and get your hands dirty.

    In this session we'll start out with "Get Data" in Power BI with a little bit of "Add Table Using Example" and move quickly into the Power Query Advanced Editor and explore the M code that is the magic of the Html.Table function. This is where we must put our Web Dev hat on for a bit while we explore the Document Object Model. Then we take things to the next level with some Python libraries to solve some of the bigger challenges.

    This Session would be mostly demos and conversation with the audience.
    Slides to support resources used and key points.

    Holzkohle
    Fri 15:30 - 16:30

  • Social Engineering: Hacking People

    “It is much easier to trick/force someone into giving a password for a system than to spend the effort to crack into the system.” This is a common line of thought in today’s world of increased cyber-security dangers. In this interactive session we’ll take a look at how social engineering works, the psychology behind it and why is it still the most effective way to gain access to your company’s secrets. The best attacks happen when people don’t even realize they are being attacked and in this session we’re going to try to fix that and educate you on how to realize when someone is trying to socially engineer you.

    Anzünder
    Fri 16:45 - 17:45

  • Normalization beyond Third Normal Form

    Do you believe the myths that “Third Normal Form is good enough”, or that “Higher Normal Forms are hard to understand”?
    Do you believe the people who claim that these statements are myths?
    Or do you prefer to form your own opinion?
    If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!

    Grillrost
    Fri 16:45 - 17:45

  • OpenAI vs Azure OpenAI

    Have you been asked by your employer to start exploring AI, especially LLMs (Large Language Models)? How could it help your business? How to use ChatGPT? Do you want to better understand AI tooling that will allow you to generate and interpret images? Such as DALL·E and CLIP? Whatever your journey, more and more of us want to better understand OpenAI and what it can offer us.

    Whether your thirst for understanding of OpenAI is a result of your day job, or simply a growing interest, the suite of tools available within OpenAI is invaluable. However, how suitable is it to start using these tools professionally? If you are asking yourself this question you are not alone. One of the most common questions emerging from the industry is “What is the difference between OpenAI and Azure OpenAI?”

    In this session, we will look at the differences between OpenAI (including ChatGPT Free, Plus and Enterprise) and Azure OpenAI. We’ll look at when best to use each offering, with direct comparisons including security, reliability, training, and support.

    By the end of this session, you will have a better understanding of the different serving offerings for OpenAI and have more confidence in when to use each one.

    Zange
    Fri 16:45 - 17:45

  • What's new in Azure SQL MI

    Let us review the latest and the greatest investment that Microsoft has made into the Azure SQL Managed Instance, the product that serve as the best target for the existing SQL Server migration into Azure PaaS.

    Holzkohle
    Fri 16:45 - 17:45
Session and Speaker Management powered by Sessionize.com