Phoenix Power Platform World Tour has ended

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Technical [clear filter]
Wednesday, December 4

10:45am PST

Back to the Past! Travel with me on an adventure back in time… in your Power BI report!
What do you do when a user asks to see a report backdated in time? If the current month is August 2019 but they want to see the report backdated to June 2018, how do you accomplish this in Power BI?

This session will show you a technique where users select a single Year-Month as the report end date, and your report visuals backdate automatically without having to change DAX measures. This technique can be applied to most date (month) based visuals including showing the Last X Months (rolling 12 months), Year-to-Date sums, Calendar Year-to-Date Month totals, and Multi-Year totals.

This technique is advanced as it uses a combination of DAX, new tables linked to a Calendar table and relationships needed between the tables.

Come and learn this solution! Your users will thank you!

avatar for Mark Baich

Mark Baich

President, Certified Power BI consultant, Baich Consulting
Senior Power BI consulting opportunities, all aspects of Power BI development and management. Open to making connections on LinkedIn at www.linkedin.com/in/MarkBaich

Wednesday December 4, 2019 10:45am - 11:45am PST
Canyon B

1:00pm PST

 Working With Data in the Power Platform
avatar for Sameer Chabungbam

Sameer Chabungbam

Principal Program Manager Lead, Microsoft
Sameer leads the connector platform for the Microsoft Power Platform, where he is helping a lot of partners deliver their connectors for Power Apps, Power Automate and Power BI. He has been working with Microsoft for more than 13 years in various teams.

Wednesday December 4, 2019 1:00pm - 2:00pm PST
Canyon B

2:15pm PST

Application Lifecycle Management for Power BI using Azure DevOps
This session is about DevOps and how Application Lifecycle Management is done in Power BI using DevOps. It talks about the different methods, best practices and success stories with demo.

avatar for Shankar Narayanan

Shankar Narayanan

BI Solutions Specialist, Visual BI Solutions
Shankar Narayanan SGS is a Technology specialist with extensive knowledge and vast experience in R&D, Designing and Implementing BI Solutions, Cloud Computing, Application Architecture and Deployment. He loves to talk about BI Solutions in Azure and DevOps and can be reached @ ww... Read More →

Wednesday December 4, 2019 2:15pm - 3:15pm PST
Canyon B

3:30pm PST

Playing with (M)agic: an introduction to writing M code in Power BI
Do you love Power Query? Are you ready to take your skills to the next level? Learning to write M code is easier than you think! Writing M code can reduce maintenance and create a more dynamic solution for you and your users. In this session you will learn: 1. Where you can write M code in PowerQuery. 2. The different types of objects you can use as variables in your code. 3. Different ways you can leverage variables to create a dynamic solution.

avatar for Kristine Dyess

Kristine Dyess

Director, Client Services, PowerPivotPro
I'm originally from Pittsburgh, PA and relocated to Phoenix, AZ in 2000. I've held roles in Reporting, Analytics, Modeling, Strategy, Management, and Consulting. My Power BI journey started with PowerPivot In Excel (in 2013) and lead to becoming a Principal Consultant with PowerPivotPro... Read More →

Wednesday December 4, 2019 3:30pm - 4:30pm PST
Canyon B
Thursday, December 5

9:00am PST

Modern data architecture for massive data processing

Data has become the strategic asset used to transform business to uncover new insights

IDC Projects that this data exploration of data will result in 40 zeta bytes by 2020

To drive the business forward, the enterprise needs to integrate,adapt their enterprise data warehouse to evolve into modern data warehouse

avatar for Rakesh Jayaram

Rakesh Jayaram

Associate Director, IQVIA
AWS & Microsoft Certified - Architect BloggerData Enthusiast

Thursday December 5, 2019 9:00am - 10:00am PST
Canyon B

11:30am PST

Advanced Power BI Modeling Techniques
Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper.

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures or KPIs in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.

avatar for Martin Schoombee

Martin Schoombee

Chief Data Wrangler, 28twelve consulting
I help customers make sense of their data.

Thursday December 5, 2019 11:30am - 12:30pm PST
Canyon B

1:30pm PST

Power BI Development Best Practices
Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Moving from "quick and dirty" deployments to production ready solutions intended for larger audiences means that you should already be thinking about performance, standardization and (most importantly) your end users.

In this session we will take a good look at some of the considerations and best practices when developing Power BI models, reports and dashboards to help you bridge the gap and make your solutions enterprise ready.

avatar for Martin Schoombee

Martin Schoombee

Chief Data Wrangler, 28twelve consulting
I help customers make sense of their data.

Thursday December 5, 2019 1:30pm - 2:30pm PST
Canyon B