Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 38
Aggregations are now generally available in Power BI and are one of the most important optimization methods for managing large datasets. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database.

In this session, you will learn about aggregations, different table storage modes, how to set up aggregation tables and configure them to improve query performance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 19

Time: 3:00 PM - 4:00 PM

Room: Centennial

This session is about the new possibility of doing AI inside Power Apps and Microsoft Flow.  the audience will get familiar with the new update announced in Business Application Summit on AI Builder that provides the facility to run easy AI inside Power Apps and Flow. a demo of how to create a form processing application using AI builder, Flow and Apps will be demonstrated
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: October 19

Time: 10:15 AM - 11:15 AM

Room: Bellwood Quarry

Data is the new gold and companies are producing it in massive amounts. Historically it has been tough for companies to mine the data because of the amount of technical resources and human capital it takes to mine it. Fortunately, Microsoft has added tools and services in its data platform that addresses this problem. 
 
In this session we will take a tour of the Microsoft ecosystem and explore some of these tools and services. We will explore:
 
-  How AI models are easily productionized in the cloud using Azure Machine Learning Services and Azure Databricks
-  How Microsoft brought data science to the database via SQL Server Machine Learning Services
-  How AI can be used to enhance Power BI data models

Come to this information packed session, and you will walk away with ideas of how you can help your company leverage the gold mine of data it is sitting on to gain a competitive advantage.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 19

Time: 1:45 PM - 2:45 PM

Room: Piedmont Park

The next evolution in cloud computing is a smarter application not in the cloud. As the cloud has continued to evolve, the applications that utilize it have had more and more capabilities of the cloud. This presentation will show how to push logic and machine learning from the cloud to an edge application. Afterward, creating edge applications which utilize the intelligence of the cloud should become effortless.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 19

Time: 3:00 PM - 4:00 PM

Room: Palisades

Implementing a Power BI solution is not just about the report development, dashboard design, and DAX queries. Designing the right architecture is an essential part of a Power BI implementation.

There are many areas to consider when you are designing a Power BI architecture. From sharing reports and security, to the type of connection and usage of other components such as dataflow.

Come to this session to learn about important things you need to know about the architecture of a Power BI solution. You will learn some blueprints of what are key things to consider and how to design the architecture for your solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 19

Time: 9:00 AM - 10:00 AM

Room: Grant Park

There's so much buzz around Data Science right now.  What is it?  What can I do with it?  Do I need a Ph.D. and a team of super nerds?  In this introductory session, we'll see that Azure Machine Learning Studio's intuitive interface and selection of built-in modules brings the power of Data Science to the people....no advanced degrees necessary.  Bring your data hats and sense of adventure, because the world of data science just got a lot more inviting!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 19

Time: 3:00 PM - 4:00 PM

Room: Powers Island

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 19

Time: 10:15 AM - 11:15 AM

Room: Big Creek

In this session, Daniel & Chadwick will demonstrate why ADF can be a powerful new tool in your ETL toolbelt.  They will show what the on-ramp looks like for an ETL Developer jumping into this brave new world of cloud ETL.  The basics of the tool will be covered, plus some cool things from real-world projects that demonstrate the power of the new platform.  Topics include:
 
What is it and why do I care?
How do I translate my ETL skills into a new product?
Real-world examples (cool things!)
What does it cost really?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 19

Time: 1:45 PM - 2:45 PM

Room: Powers Island

The California Consumer Protection Act (CCPA) has substantial implications on the data governance and data management practices of all companies that have customers in California.   The CCPA will come into effect in 2020 and has substantial potentially large monetary penalties for non-compliance.   Are you ready?   We will discuss what the CCPA is and who is required to comply with the law.   A presentation of MetaCenter, an enterprise metadata management and data governance solution,  will be given to show how a tool can be used to help you comply with the data inventory and data lineage requirements of the CCPA.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 19

Time: 11:30 AM - 12:30 PM

Room: Centennial

One of the biggest problems I come across lately is poor performing Power BI reports due to bad data model designs.  Since the data model is the foundation to all the reports, if you get it right the first time everything else tends fall inline.  Join this session to learn the key steps and best practices you need to take to ensure a good data model.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 19

Time: 12:30 PM - 1:30 PM

Room: Grant Park

Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy.  This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 19

Time: 12:30 PM - 1:30 PM

Room: Palisades

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. Belinda will introduce you to the concept of calculated columns, measures, and basic data modeling, with some practical examples. This introduction will cover basic calculations and an overview of scalar and table functions. This session has practical examples of business analytics and users.  To the Developer, DAX feels like a programming language; to the user, DAX feels like Excel formulas.  
1.	Define DAX and understand where it fits and why it is important
2.	Perform and Review some basic DAX commands
3.	Differentiate modeling with DAX versus the Power BI Query Editor
4.	Build a Date Table to allow for the use of Time Intelligence DAX calculations
5.	Overview of CALCULATE in DAX functions.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 19

Time: 10:15 AM - 11:15 AM

Room: Centennial

The Microsoft Tabular model is a core technology in Microsoft's business intelligence offerings, found in Power BI, Azure Analysis Services, and Excel PowerPivot. Understanding DAX (Data Analysis Expressions) is the key to unlocking the power of the Tabular model. This session will cover some fundamental concepts and common pitfalls encountered while learning DAX. 

Topics include:
* Row and filter context
* Context transition
* Filter vs filter
* Active relationships
* Automatic table to scalar conversion
* Variables
* Basics of time intelligence
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Intermedia

Session Code:

Date: October 19

Time: 9:00 AM - 10:00 AM

Room: Centennial

No matter the complexity of your BI application, dimension management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how to unlock more value from your analytics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: October 19

Time: 11:30 AM - 12:30 PM

Room: Piedmont Park

With Power BI becoming a leading BI tool over the last few years, a question arises… What does this mean for the existing SSRS environment? This session will explore an analysis plan on your existing reporting landscape to provide you options and considerations to be able to make an informed decision about how Power BI could best be used in your environment. You will learn how to get valuable SSRS usage metrics. You will understand the benefits and limitations between the two BI tools and what questions to ask your users. By Monday morning you will be able to provide an analysis plan on what is involved to introduce Power BI into the enterprise.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 19

Time: 10:15 AM - 11:15 AM

Room: Grant Park

Power BI introductory course with data from Amazon account to show purchases. Connections, importing/transforming data and visualizations will be covered.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Beginner

Session Code:

Date: October 19

Time: 12:30 PM - 1:30 PM

Room: Powers Island

This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 19

Time: 10:15 AM - 11:15 AM

Room: Palisades

Your company has completed its data migration to Azure and now various teams are wanting to build, share and view Power BI reports and dashboards using the data.  Additionally, the access to the data has been limited to a specific list of applications and users but not to Power BI.

So how do you support the automatic data refresh of the data within Power BI and still ensure that the security of your company's data is not compromised?

This advanced Power BI session presents several techniques that can be used to maintain (and sometimes enhance) the security of your company's data while ensuring that Power BI datasets are regularly refreshed.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Power BI

Level: Advanced

Session Code:

Date: October 19

Time: 9:00 AM - 10:00 AM

Room: Big Creek

In the world of Power BI, data modeling is what separates the Rockstars from the Rookies. Join me to learn how dimensional modeling - a concept developed 20+ years ago - continues to be the best approach for delivering self-service BI to the masses.

Not only will good data modeling result in better Power BI solutions that support a wider range of reporting requirements, but they will also be easier for the business users to understand and work with. 

In this session, you'll learn how to create flexible data models that can be expanded upon over time, unlock the power of the date table, and a variety of DAX patterns supporting common but complex business logic.
 
If your Power BI solutions typically contain a single table, if you're frequently banging your head against the wall trying to figure out how to write a DAX calculation, or if you've never heard the term "dimensional model" or "star-schema", this session is for you.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 19

Time: 3:00 PM - 4:00 PM

Room: Grant Park

Change is constant, especially with source files. Health care claims data files change at least yearly. You develop an SSIS package to load the source file. You meticulously identify each of the columns and map them to the targets. Your package runs fine for months. Then the file format changes. Again, you tediously select each column, etc. Wouldn't it be nice to simply document the structure of the file, the file's metadata, and generate the SSIS from that metadata? Your users demand the documentation anyway. If the file changes, you simply change the metadata. 

To demonstrate such an approach, I import some US census data. I create the SSIS package using BIMLScript and metadata. When the format changes, I change the metadata and generate a whole new package. And if your whole ETL approach changes to say Azure Data Factory? I will demonstrate how to generate an Azure Data Factory pipeline from the same metadata.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 19

Time: 1:45 PM - 2:45 PM

Room: Palisades

Sessions Found: 38
Back to Top cage-aids
cage-aids
cage-aids
cage-aids