| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Wolfgang Strasser | BI Platform Architecture, Development Administration | Continuous Integration for the BI Developer |
| 08:30:00 | Pedro Reis | Advanced Analysis Techniques | "DAX" the way to do it |
| 08:30:00 | Marco Russo | BI Platform Architecture, Development Administration | Different Types of Many-to-Many Relationships in Power BI |
| 09:40:00 | Benni De Jagere | Analytics and Visualization | Designing impactful visualisations for your data |
| 09:40:00 | Nikola Ilic | Analytics and Visualization | Magnificent 7 - Simple tricks to boost your Power BI development |
| 09:40:00 | Thomas LeBlanc | BI Platform Architecture, Development Administration | Tabular Analysis Services 2019 from Start to Finish |
| 10:50:00 | Kevin Wilkie | BI Platform Architecture, Development Administration | Checking in on Tabular Models: Making Them Work Better |
| 10:50:00 | Dennes Torres | BI Information Delivery | Advanced ETL with Power Query |
| 10:50:00 | Eugene Meidinger | Analytics and Visualization | An (Advanced) Introduction to DAX |
| 12:00:00 | David Patrick | Cloud Application Development Deployment | Intro to CDS inside of Power Automate (fka Microsoft Flow) |
| 12:00:00 | Armando Lacerda | BI Platform Architecture, Development Administration | Power BI Aggs |
| 12:00:00 | Mihail Mateev | BI Platform Architecture, Development Administration | Deep Dive on Embedded Analytics with Power BI |
| 13:10:00 | James Serra | BI Platform Architecture, Development Administration | Azure Synapse Analytics: A Data Lakehouse |
| 13:10:00 | Paul Turley | BI Information Delivery | Data Modeling Solutions for Challenging BI Data Modeling Problems |
| 13:10:00 | Chris Hyde | BI Platform Architecture, Development Administration | Data Engineering Brick-by-Brick: An Introduction To Azure Databricks |
| 14:20:00 | Kevin Feasel | Cloud Application Development Deployment | Getting Started with Apache Spark |
| 14:20:00 | John Miner | BI Platform Architecture, Development Administration | Exploring the Power BI Desktop Designer |
| 14:20:00 | Melissa Coates | Strategy and Architecture | Top Essential Actions for Governing Power BI |
| 15:30:00 | Edward Pollack | BI Platform Architecture, Development Administration | Improving Analytics Performance With Columnstore Indexes |
| 15:30:00 | Warwick Rudd | Enterprise Database Administration Deployment | Azure Data Studio - Above and Beyond |
| 15:30:00 | Michael McKinley | BI Platform Architecture, Development Administration | Basic Data Modeling for BI Reporting |
Event Date: 05-12-2020 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Especially in BI development, the usage of database projects, unit testing, version control, continuous integration and deployment is an underrepresented area. Join me in this demo-heavy session where I will guide you through the not-so-frightful jungle of continuous integration using SQL Server database projects, SSIS, T-SQLt and Azure DevOps etc. After this 60 minutes you'll have the guidelines and some ideas how easy it is to change your manual BI development and deployment into a powerful and automated no-brainer that - just works!
Event Date: 05-12-2020 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core. I'll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
Event Date: 05-12-2020 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
In this session, we clarify the purpose of the relationships with many-to-many cardinality, highlighting the significant difference with canonical many-to-many relationships. In the meantime, we show how and when to use the different kinds of many-to-many relationships with several practical examples.
Event Date: 05-12-2020 - Session time: 09:40:00 - Track: Analytics and Visualization
During this session, we'll go through some steps on how to maximise the potential of data visualisations. Starting at choosing the right types of visualisations, and which colour palettes are good matches for your message, we'll also make sure that our designs are as inclusive as we can possibly make them. Wrapping up with a few common use cases, you’ll definitely pick up a few new things to take home with you.
Walking out of this session, you can expect to have a decent understanding on a few common design principles for your data visualisations and reports.
Event Date: 05-12-2020 - Session time: 09:40:00 - Track: Analytics and Visualization
Event Date: 05-12-2020 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-12-2020 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-12-2020 - Session time: 10:50:00 - Track: BI Information Delivery
We can create functions, re-use funcitons, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query
Event Date: 05-12-2020 - Session time: 10:50:00 - Track: Analytics and Visualization
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: Cloud Application Development Deployment
Learn how the CDS ties into Power Automate (Flow), what Triggers and actions are available and how you can use this all.
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
In this session I will demo how to design and implement agg's and take advantage of this powerful feature that will allow you to report on virtually unlimited amount of data.
Event Date: 05-12-2020 - Session time: 12:00:00 - Track: BI Platform Architecture, Development Administration
Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded, do not need to have a Power BI account or to know anything about this Azure service. This session covers the major concepts, related to Power BI Embedded Analytics:
Event Date: 05-12-2020 - Session time: 13:10:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-12-2020 - Session time: 13:10:00 - Track: BI Information Delivery
Event Date: 05-12-2020 - Session time: 13:10:00 - Track: BI Platform Architecture, Development Administration
Azure Databricks provides a cloud-based Apache Spark environment that can be scaled up and out to tackle your big data analytics needs. We'll look at how to set up your first Azure Databricks cluster, how to use shared notebooks in a collaborative environment, and how to leverage the integrated Azure Machine Learning capabilities. We'll also discuss where Azure Databricks fits in the modern cloud data warehouse.
Event Date: 05-12-2020 - Session time: 14:20:00 - Track: Cloud Application Development Deployment
Event Date: 05-12-2020 - Session time: 14:20:00 - Track: BI Platform Architecture, Development Administration
The desktop designer is an easy to use application that can mash up data from various sources and create visual reports that will dazzle your users.
Under the hood, the M-Language mashes up data from various sources into a relational data model; the x-velocity engine stores the data in an efficient column store format; and the DAX language can extend the model when necessary.
In short, the Power BI Desktop designer is a one stop place to turn mundane data into dynamic reports.
Event Date: 05-12-2020 - Session time: 14:20:00 - Track: Strategy and Architecture
Event Date: 05-12-2020 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Columnstore indexes provide a speedy and convenient way to store OLAP data within SQL Server. Compression allows the data to be much smaller than other storage methods, allowing for faster reads. Column metadata provides the tools needed for SQL Server to be able to service queries over massive data sets quickly and efficiently.
The basics of columnstore indexes allow an administrator to improve the performance of analytics, but there is much more to learn! Understanding the internals of columnstore indexes allows querying to be even more efficient.
Columnstore indexes have evolved greatly since their introduction in SQL Server 2012. This presentation explores this feature in SQL Server 2017 and SQL Server 2019 and how its newest features can turbo-charge your analytics workloads!
Event Date: 05-12-2020 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
In this session Warwick will introduce you to Azure Data Studio and take you on a demo rich journey on how, when, where and why Azure Data Studio can make your life easier in supporting your ever expanding data estate. If you have not heard of or seen Azure Data Studio before, Warwick will introduce the tool, it’s history and introduce you to its continual enhancements to assist you.
Event Date: 05-12-2020 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do.
In this session, we will review how tools like Power BI work under the covers and how that impacts the way we construct our data models. This is an introductory level course, so we will not get too technical, just enough to get us to the next level and moving back up that learning curve!