Thank You for Attending in New York

The Power BI World Tour made a stop in New York 19-20 September, 2017 to provide unprecedented access to premium Power BI content designed by your local PUG team.

The stop allowed Power BI users to connect and dive deep with hundreds of peers and industry experts through twenty seven sessions targeted for the Business User, Business Analyst, Power User, or Techie. The event kicked off with a technical roadmap session led by Microsoft, offered a unique Microsoft track specializing in key announcements around Reporting and Analysis Services, served complementary tracks, and concluded with sessions reinforcing the information learned, exposing your new Power BI super power.

Read the New York Recap blog.

Stay connected



Join the virtual NY/NJ Power BI User Group community and continue the conversation and learning.

Visit Community

AGENDAS

Agenda is subject to change without notice.

Tracks below for Newbie/Business Users, Enterprise Business Intelligence Users, and Technical Users are just general guidelines based on interest and experience. An attendee may switch tracks or sit in on any class below at any time.

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: Empire A
Kim Manis and Charles Sterling - Microsoft
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break
10:45 - 11:45Introduction to Power BI | Room: Bryant Park 
Kim Manis - Microsoft
After a brief introduction to the community, we will demonstrate how Power BI can help your organization by leveraging powerful new reporting capabilities. We will investigate the options of using self-service BI and connecting Power BI into a Data Warehouse. We will recommend best practice approaches to implementing Power BI in your organization.
11:45 - 1:00Networking Lunch - Sponsor Showcase - ZAP | Room: Empire A 
Get Even More from Power BI with ZAP’s Automated Data Management (12:15 -12:45)
Bill Tennant & Sara Breedon - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
1:00 - 2:00Data Modeling | Room: West Village 
Cristi Nicola - NCA Dynamics
Creating great Power BI reports starts at getting the right data in the right shape. This session will provide a tutorial on importing data from various sources as well as how to model and extend that data without assistance from your helpful but overstretched IT department.
2:00 - 2:15Session Break
2:15 - 3:15From Excel to Power BI Desktop | Room: West Village
Scott Sewell - Hitachi Solutions
To long time information workers, ‘All the world’s a spreadsheet’ – but today the power-combo of Excel + PowerBI opens the doors to so many new possibilities. – In this beginner-oriented session, we’ll step, carefully at first, out from our workbooks and into this exciting world of PowerBI. We’ll look at using Excel as a source for PowerBI, we’ll explore how excel files stored in OneDrive can be imported into PowerBI.com for visualization and we’ll complete this circle by exploring data sourced from a PowerBI report, in Excel!
3:15 - 3:30Session Break
3:30 - 4:30Making Financials Come Alive with Power BI | Room: West Village
Michael Elbrish - AKA Enterprises Solutions
Dashboards illustrate your company's key data, allowing you to leverage data to start internal conversations and give your business a strategic edge. Come to this interactive session where we can talk through what and how to get the most out of your financial data, what formatting makes the most impact and how to make the key drivers of your business shine through.
4:30 - 6:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Data Visualization Best Practices for Power BI | Room: West Village
Dan Edwards - Crowe Horwath LLP
Power BI dashboards are meant to simplify the data analysis process for busy business managers and workers who don’t necessarily have the time or inclination to dig deeply into data. Charts, graphs, gauges and alerts are all designed to make BI data easy to grasp. But building dashboards can be a daunting assignment for BI teams, in no small part because the intended user base often consists of corporate executives and the heads of business units. And they can be a demanding audience. A dashboard is a visual display of the most important information needed to achieve one or more objectives that has been consolidated on a single computer screen so it can be monitored at a glance, but how do you make all of this information easy to understand? And more importantly how to do you make it compelling to use? In this session we will look at some key best practices that will make it easier to deliver your message to our audience and make your dashboard compelling to use.
09:30 - 9:45Session Break
9:45 - 10:45Leveraging Power BI to Create a User Friendly, Customer-Facing KPI Dashboard on the Public Internet | Room: Chelsea
Eric Kerstead - Beavex Logistics Inc
Beavex Logistics has developed a unique, market-differentiating Business Intelligence Dashboard that's embedded in our Customer Portal on the Public Internet. The Analytics Dashboard provides several Key Performance Indicators (KPI's) that lets our customers see how we're performing on their account. The dashboard harnesses the strengths Power BI in new and unique ways to create an online experience that is unmatched in the Logistics Industry. When we added the Analytics Dashboard to our customer portal, it immediately moved us to the front of the pack in Logistics for Customer-Facing Technology. Our system incorporates a backend design that completely removes traditional database queries, regardless of the complexity of the dashboard. The absence of backend database queries provides dramatic performance improvements over similar systems. Our customers typically see their Dashboard refresh in under 4 seconds, regardless of the changes they’ve made to their Dashboard.
10:45 - 11:00Session Break
11:00 - 12:00Using Power BI to Drive Results in an Editorial Organization  | Room: West Village 
David Johnson - Haymarket Media
This session will discuss experience using power bi in editorial organizations to speak to the following.
1. Creating engaging and intuitive dashboarding for the editorial staff.
a. Forecasting
b. self-directed exploration
c. Understanding what content is resonating.
d. Managing channel strategy
e. Identifying and showcasing best practices by author/asset.
2. Using Power BI to identify value classes (cohorts) of users. How do we identify which content and channels are of value to fostering high engagement. Which Authors personify this?
3. Articulating the Audience relationship journey
4. Quantifying ROI.
12:00 - 1:15Lunch with Peers 
1:15 - 2:15 Developing a Business Intelligence and Analytics Roadmap | Room: Chelsea
Neal Levin - Rightpoint
In this session, “Creating a Business Intelligence and Analytics Roadmap”, Rightpoint’s Vice President for Business Intelligence and Analytics, will present a methodology organizations’ can follow to define and prioritize the delivery of key performance measures and metrics. In addition to a methodology, a case study for a Rightpoint client, will be highlighted, along with a demonstration of the solution delivered via Power BI.
2:15 - 2:30Session Break
2:30 - 4:00Use What You Learned | Room: Chelsea
If today was a whirlwind of new Power BI knowledge, this session is for you. During the session, we will learn to apply the concepts and methodologies of Power BI, such as visuals, into your real business scenarios to ensure that you walk away from Power BI Thursday with a sound understanding of how Power BI can work for you.

Business Enterprise Intelligence Users

08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap | Room: Empire A
Kim Manis and Charles Sterling - Microsoft
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break
10:45 - 11:45Super Charge Power BI and What is new with Analysis Services | Room: Empire A
Christian Wade - Microsoft
Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session introduces Azure Analysis Services as a fully-managed platform as a service (PaaS) in Azure. We will discuss where Analysis Services fits into Microsoft’s BI platform and strategy, reference architectures and cloud efficiencies. Modeling and analytics features covered by the last two compatibility levels will be reviewed and demonstrated, including Power Query connectivity, object-level security, and Detail Rows for non-technical users to drill through to transactional records.
11:45 - 1:00Networking Lunch - Sponsor Showcase - ZAP | Room: Empire A 
Get even more from Power BI with ZAP’s automated data management (12:15 -12:45)
Bill Tennant & Sara Breedon - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
1:00 - 2:00Creating Enterprise Grade BI Offerings with Azure Analysis Services | Room: Empire A
Christian Wade - Microsoft
As you have seen in the previous two sessions, Analysis Services enables consistent data across reports and users of Power BI. This session will focus on optimizing configurations, management automation, governance, sizing considerations and best practices. Various modeling enhancements will be included such as Detail Rows allowing users to easily see transactional records, deployment and application-lifecycle management (ALM) features to bridge the gap between self-service and corporate BI. Security drill down such as logging where and how your data is stored, and look at how to leverage additional Azure services to make your information even more secure.
2:00 - 2:15Session Break
2:15 - 3:15Power BI Report Server: Self-Service BI and Enterprise Reporting On-Premises | Room: Empire A
Dustin Ryan -Microsoft
Love Power BI but need an on-premises solution today? Meet Power BI Report Server -- self-service analytics and enterprise reporting, all in one on-premises solution. Design beautiful, interactive reports in Power BI Desktop, publish them to Power BI Report Server, and view and interact with them in your web browser or the Power BI app on your phone. And since Power BI Report Server includes the proven enterprise reporting capabilities of SQL Server Reporting Services, it can even run your existing Reporting Services reports too. Join us for an overview of Power BI Report Server and demos of its features in action.
3:15 - 3:30Session Break
3:30 - 4:30Enterprise BI deployments and governance with the Microsoft Power BI Service | Room: Empire A
Charles Sterling- Microsoft
Whether you're planning an enterprise-wide reporting deployment or providing structure to self-service BI activities within teams, Power BI has you covered. Learn about tools for developing, publishing, and managing your BI assets. We cover the data gateway, managing report lifecycle, publishing options, administration and governance controls, and end-user capabilities across devices and platforms.
4:30 - 6:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30PowerApps & Flow  | Room: Madison
Charles Sterling - Microsoft
In today's fast paced world, putting data quickly at the business analyst's fingertips is more important than ever. With the increased integration points between PowerApps and Power BI, you can now better enable business decisions. Learn how to use Power BI, PowerApps and Microsoft Flow to create and customize your very own business applications that utilize Power BI real time data.
09:30 - 9:45Session Break
9:45 - 10:45Data Management will be Critical for High Performing Businesses of all Sizes | Room: West Village
Bill Tennant - ZAP
More and more data is being generated by businesses of all sizes. IDC research suggests that data doubles every two years and will reach 40 trillion gigabytes by 2020. With this amount of data comes great opportunity, but also potential issues. It is important that businesses of all sizes consider their approach to data management. Not just how they capture and analyze it, but how they manage (integrate, model, etc.) and govern it to ensure it is accurate, secure and accessible. Join this session to find out what you should be considering in terms of the best-practice approaches to managing data to ensure you seize the opportunity it presents and negate the potential issues it can create.
10:45 - 11:00Session Break
11:00 - 12:00Data Modeling - How to Apply Dimensional Data Modeling | Room: Chelsea
Greg Baldini - Nihilent Technologies, Inc.
With examples of real problems and (attempted) solutions, this presentation will examine dimensional modeling techniques which simplify and speed up measure evaluation. A fast-paced and language/tool-agnostic look at some common and uncommon reporting scenarios, including:
• All manner of date calculations and comparisons
• Slowly changing dimensions
• Events in progress
• Conditional evaluation of measures
By the end of this talk, you should have a stronger understanding of the right questions to ask that will make your BI solution simpler for end users and more performant at run-time.
12:00 - 1:15Lunch with Peers
1:15 - 2:15 Putting the R in PoweR BI | Room: Madison
Greg Baldini - Nihilent Technologies, Inc.
Are you using R in your organization? Are you considering using R but don’t know how to share your impactful results to a wide audience? This presentation will address the mechanics - how to do it, what's required, and how to set it up – of using R in Power BI to communicate your data story. We’ll also learn where can R complement Power BI functionality, and how R can help us surpass the limits of DAX and M for advanced analytics, and unlock thousands of new visualizations!
2:15 - 2:30Session Break
2:30 - 4:00Certification Opportunity | Room: West Village
Ready yourself for Microsoft Exam 778 with this preparatory readiness class that will include a review of exam coverage, vital ways to prepare and additional details.
08:30 - 09:30Registration and Networking Breakfast
09:30 - 10:30General Session: Microsoft Roadmap| Room: Empire A
Kim Manis and Charles Sterling - Microsoft
With weekly and monthly releases, there are a lot of fantastic new Power BI features to explore. In this session, we will have an overview of what has been just released in Power BI and a look forward. Drill down topics to include the new collaboration features, in the cloud-based business analytics service, the new authoring and modeling features of Power BI Desktop, extending your reach to mobile applications, new Power BI resources and finally, what is new for developers leveraging the Power BI platform.
10:30 - 10:45Session Break
10:45 - 11:45Azure Data Services and Power BI | Room: West Village 
Kathy Kinnier and Andrew Kinnier - Data Ignite
The cloud based Platform as a Service (PaaS) offerings from Microsoft will be demonstrated as well as how they integrate with Power BI. The demonstration will include Azure Stream Analytics, Azure SQL DB, Azure SQL Data Warehouse and Azure Analysis services. A quick run-through will be done on how to setup each of the services and then use Power BI to provide analytics from each of these data sources. Also, 3 different types of connections to Power BI will be demonstrated: live streaming, Import, and Direct Connect, and discuss the pros and cons of each.
11:45 - 1:00Networking Lunch - Sponsor Showcase - ZAP | Room: Empire A 
Get even more from Power BI with ZAP’s automated data management (12:15 -12:45)
Bill Tennant & Sara Breedon - ZAP
Increase trust in your business information and remove inefficiencies and costs related to data preparation and exploration. See how ZAP unifies data from multiple sources automatically and makes it simple to prepare for analysis with Power BI. ZAP’s warehouse automation makes it quicker and more cost-effective to produce a secure, governed hub of business-wide data, which enables richer, more trusted business information to be created more efficiently by Power BI users.
1:00 - 2:00Implementing Advanced Security Solutions | Room: Bryant Park
Laurent Banon - Microsoft
We’ll look in detail at the Power BI Architecture, Data Storage and the security best practices around giving users access while training them to keep important business data safe.
2:00 - 2:15Session Break
215 - 3:15DAX 101 | Room: Bryant Park 
Mitchell Pearson- Pragmatic Works
In this breakout session, you'll learn the basics of the DAX language, Power BI’s modelling language. We will introduce you to the concept of evaluation contexts, and how they impact calculated columns and measures, with some practical examples that you will reproduce on your machine. This introduction will cover basic calculations and an overview of the most common scalar and table functions.
3:15 - 3:30Session Break 
3:30 - 4:30Power BI Dataset Design | Room: Bryant Park
Brett Powell - Frontline Analytics
A Power BI Desktop file can be much more than just a report. With thoughtful design of the data connectivity, retrieval, modeling and analytical expressions, a Power BI dataset can scale to support reporting across multiple business processes, teams, and use cases. This scalability is further enhanced with new and future Power BI premium features as well as migration to SQL Server Analysis Services. This presentation focuses on fundamental dataset design and development topics including the choice and implementation of DirectQuery versus Import datasets, how to parameterize your data sources and queries, how to design efficient, manageable data retrieval processes, and data modeling topics including bidirectional versus single direction relationships. In this fast-paced demo heavy session, top design patterns with both the M and DAX functional language will be described as a means to build robust, sustainable datasets.
4:30 - 6:00Welcome Reception (Social & Networking)
07:30 - 08:30Networking Breakfast
08:30 - 09:30Understanding the Power Query Formula Language in Power BI | Room: Chelsea
Mitchell Pearson - Pragmatic Works
The query editor in Power BI is a powerful GUI that generates Power Query Formula Language, also known as “M”. The GUI only offers a glimpse at the true power of M. In this session we are going to take a deeper dive behind the UI and learn how to do even more data cleansing and transformation in Power BI using M.
09:30 - 9:45Session Break
9:45 - 10:45SSRS, Power BI Migration and Coexistence Strategy to Maximize Business Impact W | Room: Madison
Dutt Kalluri - BlueOrbit Solutions
Many business leaders already know the inherent value of analytics insights for improving operations and driving smarter decisions. While the intent to make analytics the main stream of an organization is great, when you look deep into their organization you will find pockets of high adoption within some functions, but what you mostly see is a dependence on spreadsheets and other tabular report tools. In this session we will discuss how we helped enhance the analytical capabilities of an organization enterprise-wide and maximized the impact by adopting a SSRS and Power BI coexistence strategy. We will discuss how we developed a multi-step process to rationalize the client’s SSRS reports, created functional and cross functional groupings, developed a migrate-retain strategy and migrated identified reports to Power BI.
10:45 - 11:00Session Break
11:00 - 12:00Advanced DAX | Room: Madison
Mitchell Pearson - Pragmatic Works
The DAX language was designed specifically so that users could quickly learn the basics and immediately improve the analytical capabilities of their data models. But then what? The DAX language can be difficult to understand once you master the basics and begin moving on to more complex calculations. In this demo heavy webinar we are going to focus on the building blocks necessary for building more complex calculations in DAX.
12:00 - 1:15Lunch with Peers
1:15 - 2:15 Collaborating in the Power BI Service | Room: West Village
Laurent Banon - Microsoft
2:15 - 2:30Session Break 
2:30 - 4:00Ask The Experts | Room: Madison
During this session ask the Microsoft team, MVPs, and Industry Experts the questions that you didn't get answered during the regular sessions. This session is always jam packed with information and tidbits from the brightest and the best.

Agenda Icon Legend

  • Registration
  • General Session
  • Session Break
  • Refreshments
  • New Business User
  • Enterprise Business Intelligence
  • Technical
  • Lunch/Dinner

Thank You to Our New York Sponsor

ZAP-Logo.png

Helping Customers get a single, trusted view of their Business. We help hundreds of customers around the world get a single, trusted view of their operational and financial business performance in a simple, cost-effective way. Our aim is to remove the technical effort associated with traditional business intelligence and data warehouse projects. All ZAP solutions are pre-packaged, automated, and easily configurable. The result is faster deployment, quicker time-to-value, and reduced cost and risk for our customers.