| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Ravi Kumar | BI Development | Power BI In a day Hands-On |
| 08:30:00 | John Miner | Advanced Analysis Techniques | Introduction to Data Science With Python |
| 08:30:00 | Andy Leonard | BI Administration and Performance | Intelligent Data Integration with SSIS |
| 09:00:00 | Chris Seferlis | Advanced Analysis Techniques | Azure Databricks... what makes it better? |
| 09:00:00 | Leslie Andrews | BI Development | The Power of Data: The Complete Beginners Data Warehouse Kit |
| 09:00:00 | Steve Simon | BI Information Delivery | SQL Server Reporting Services 2017 on Steroids!! |
| 09:00:00 | Matt Cushing | Professional Development | Networking 101: Getting Ready for a SQL Event |
| 09:00:00 | Andy Leonard | BI Platform Architecture/Design | Azure Data Factory Design Patterns |
| 09:00:00 | Andy Yun | BI Administration and Performance | Building Winning Business Cases |
| 10:10:00 | Todd Chittenden | BI Information Delivery | Advanced Power BI features for Beginners |
| 10:10:00 | Paul DellaGrotte | Professional Development | Preparing for Power BI Exam 70-778 |
| 10:10:00 | Beth Wolfset | BI Platform Architecture/Design | Designing for Azure Data Warehouse Peformance |
| 10:10:00 | Sunil Kadimdiwan | Advanced Analysis Techniques | Time Intelligence in Azure Analysis Services |
| 10:10:00 | Meghana Vasavada | BI Development | Custom Auditing in SSIS |
| 10:10:00 | Tyler Graham | BI Administration and Performance | Master Data Management: BI and Data Science’s Best Friend |
| 11:20:00 | Jessica Jolly | Advanced Analysis Techniques | Data here, there and everywhere |
| 11:20:00 | James Serra | BI Platform Architecture/Design | Big Data Architectures and The Data Lake |
| 11:20:00 | Varsham Papikian | BI Information Delivery | Using SQL Server, Powershell and Power BI together - achieve amaz |
| 11:20:00 | Sreeja Pullagura | BI Development | SSIS DevOps with Azure Containers |
| 11:20:00 | Veronika Kolesnikova | Professional Development | Artificial Intelligence for everyone |
| 11:20:00 | Taiob Ali | BI Administration and Performance | How to Tune your BI DBs in Azure to save $$$ |
| 12:40:00 | Andy Yun | BI Administration and Performance | Boosting Performance of SSAS (Sponsor) |
| 12:40:00 | Tyler Graham | BI Development | Micro Data Management: Data in the age of Micro-services (Sponsor) |
| 12:40:00 | Beth Wolfset | BI Platform Architecture/Design | Diversity Inclusion Discussion Group |
| 13:50:00 | Ray Kim | Professional Development | Whacha just say? Talking technology to non-technical people |
| 13:50:00 | Edward Pollack | BI Development | Creating and Using Calendar Tables |
| 13:50:00 | Belinda Allen | BI Information Delivery | Not your Daddy's Financial Statements |
| 13:50:00 | George Walters | BI Platform Architecture/Design | Re-Architect your Software as a Service Application for Azure: Tips and Tricks |
| 13:50:00 | Rodney Landrum | BI Administration and Performance | Azure Databricks (ADB) and the Traditional DBA |
| 13:50:00 | Varsham Papikian | Advanced Analysis Techniques | Power BI gets 'smarter': infuse more AI and ML into your BI processes |
| 15:00:00 | Kellyn Pot'Vin-Gorman | BI Administration and Performance | Taming of the Shrew - Optimizing Power BI |
| 15:00:00 | John Miner | BI Platform Architecture/Design | Effective Data Warehouse Storage Patterns |
| 15:00:00 | Tony DiPesa | BI Information Delivery | SQL Server and JSON - It's not a horror movie! |
| 15:00:00 | Deborah Melkin | Advanced Analysis Techniques | Looking "Normal" and Seeing "Stars": Understanding Table Design in BI |
| 15:00:00 | Ryan Kennedy | BI Development | Your Report 2.0: A Data Engineer's Guide to Migrating BI Reports from Old to New Systems |
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Development
Power BI Desktop: What is Power BI and what it is not Introduction Connecting to the data Shaping data at query time Modeling Data Dax Calculations Building Reports
Power BI Service: What is Power BI Service Publishing Power BI Desktop file to the Service (Instructor will provide logins to a test Power BI Service tenant) Get the online data Sharing reports and desktops Refreshing the data Mobile Reports
Power BI On Premises Server: How is Power BI On Premises server different from Power BI Service When should you use Power BI Server
SSAS Tabular: What it is and how it integrates with Power BI
Pre-requisite: Please have Pow
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
Which one of the languages do you choose as an enterprise standard?
My money is on the “Python” language, due to the fact it can be used to solve business problems other than ones related to data science.
Python is a general purpose programming language created by Guido van Rossum in 1991. It was designed for readability and easy syntax by using significant whitespace. The main goal was to allow programmers to solve problems using fewer lines of code.
During this pre-conference course, we will be covering the following topics.
Python Programming Basics Introduction to Data Science with Python
This course is meant for beginners who want to learn Python. At the end of the day, you will have a solid understanding of the language and an introduction to the data science libraries.
Event Date: 30-03-2019 - Session time: 08:30:00 - Track: BI Administration and Performance
Framework.
Attend a day of training focused on intelligent data integration delivered by an experienced SSIS consultant who has also led an enterprise team of several ETL developers during multiple projects that spanned 2.5 years. And delivered.
Attendees will learn:
Topics include:
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: Advanced Analysis Techniques
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: BI Development
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: BI Information Delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: Professional Development
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: BI Platform Architecture/Design
Attend this session to learn:
Event Date: 30-03-2019 - Session time: 09:00:00 - Track: BI Administration and Performance
Come to this session and you'll learn some new techniques on how to engage your busines counterparts, present an effective business case, and get them on your side!
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: BI Information Delivery
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: Professional Development
https://www.microsoft.com/en-us/learning/exam-70-778.aspx
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: BI Platform Architecture/Design
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: Advanced Analysis Techniques
In this session I will show you, using DAX functions in Azure (and on-premise) Analysis Services, how you can develop Date based dimensions and measures that will help answer such questions.
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: BI Development
However, what if you encountered an error, or a package failure? Suppose, a Data warehouse developer is performing an ETL to load a Dimension of a Data mart and would like to track the Data being processed. Audit Transformation Component cannot perform the job effectively.
So lets have an insight of how Auditing can be done by designing an SSIS package that captures the Error information, DML operation on the table (Inserts/Updates/Deletes) along with the package metadata.
We'll create a package with an event handler that loads Data from a Staging to Dimension and creates an Audit table to track information on Data processing.
Event Date: 30-03-2019 - Session time: 10:10:00 - Track: BI Administration and Performance
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: Advanced Analysis Techniques
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: BI Platform Architecture/Design
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: BI Information Delivery
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: BI Development
First, we’ll see how to modify the existing Microsoft Docker file for SQL Server 2017 to run SSIS. Second, we will explore the new container to see what has been created, including SQL Server 2017, required Security roles and users, and the Integration Services catalogue. Third, we will kick off an SSIS job which moves data between databases on the container. Finally, we’ll exercise our SSIS project with unit tests developed in TSQLT (modified version). At the end of this session, we hope you’ll walk away with the confidence to begin or refine your own DevOps journey.
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: Professional Development
Event Date: 30-03-2019 - Session time: 11:20:00 - Track: BI Administration and Performance
In this session I will show you 4 of those tools. You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance. Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure automatically optimize your database.
At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance issues with built in tools in Azure Portal.
Event Date: 30-03-2019 - Session time: 12:40:00 - Track: BI Administration and Performance
Join me for a mostly vendor-agnostic exploration of SSAS performance challenges. We'll break down SSAS workload and discuss factors that impact SSAS query performance. To close, will I show a brief demo of SentryOne's BI Sentry to bring everything together.
When you leave, you will be armed with new insights into SSAS and how to tackle performance challenges.
Event Date: 30-03-2019 - Session time: 12:40:00 - Track: BI Development
Event Date: 30-03-2019 - Session time: 12:40:00 - Track: BI Platform Architecture/Design
Making Diversity and Inclusion a priority at your organization: driving the use case and new policies Improving Hiring, Retention and Promotion
Addressing Everyday Discrimination
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: Professional Development
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: BI Development
There is a common need in analytics and reporting to aggregate data based on date attributes. These may include weekdays, holidays, quarters, or specific times of the year. Crunching these metrics on-the-fly can be slow and inefficient.
Calendar tables allow the complex conversions, definitions, and date-related metadata to be calculated ahead of time and stored in a static, reliable structure. We can then use this table to avoid the need to perform any date math on the fly. This not only saves time and computing resources, but also allows more complex analytics to be performed that would otherwise be very challenging.
This session delves into the design, implementation, and use of calendar tables, providing plenty of demos that illustrate their value and just how much fun they are!
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: BI Information Delivery
The traditional format will always be needed, but for operations perhaps there is a more insightful way to really “see” your data. Attend this webinar and see Belinda present alternatives to the traditional financial statement using Microsoft Power BI and GP data. Learning Objectives: • Start the process of new ways to visualize financial data • Create a plan that can provide information to your team that will help them make more profitable and timely decisions • Provide information that helps your data tel
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: BI Platform Architecture/Design
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: BI Administration and Performance
Event Date: 30-03-2019 - Session time: 13:50:00 - Track: Advanced Analysis Techniques
During the session I will describe the Power BI ecosystem and AI/ML in general. Then we will discuss existing and new 'out-of-box' AI features which are easy to use. I hope it will help you to master 'smarter' approaches and help to start exploring and applying predictive analyses to your processes. Stop only asking questions like 'What happened?' - start asking new new type of questions like 'What will happen next?'. Achieve more by using AI-infused features like QA, Insights and Web search by example.
Event Date: 30-03-2019 - Session time: 15:00:00 - Track: BI Administration and Performance
This session will take the Power User through how to identify time consuming processing in Power BI and how to address it through step-by-step and proven methods used to optimize in multi-tier environments. This method removes frustration and finger-pointing and gets to the heart of the problem with a goal of correcting performance challenges. The results are satisfied end users who get the information they need, when they need it.
Take Aways: Learn how to identify what is taking the time in a Power BI data set and report. Understand the logging and tracing mechanisms and capabilities in the environment. Understand when a problem is really a problem.
Event Date: 30-03-2019 - Session time: 15:00:00 - Track: BI Platform Architecture/Design
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval? This presentation will review the following techniques to fix your woes.
Techniques: 1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 30-03-2019 - Session time: 15:00:00 - Track: BI Information Delivery
This presentation will:
Event Date: 30-03-2019 - Session time: 15:00:00 - Track: Advanced Analysis Techniques
In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa.
By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.
Event Date: 30-03-2019 - Session time: 15:00:00 - Track: BI Development