Neal Waterstreet

Atlanta Microsoft BI Group – August Meeting

by Leave a Comment

Please note the new meeting location below.

When: Tuesday, August 28, 2018 6:30-8:30 ET

Topic: Advanced Analytics with Power BI

Overview: Power BI has become an increasingly important data analytics tool. This presentation focuses on the advanced analytics options currently available in Power BI. Attendees to this talk will see:

  • Microsoft’s perspective on advanced analytics development: the Team Data Science Process
  • What the general options are for advanced analytics on Azure
  • What the specific native advanced analytics capabilities are in Power BI
  • Some ideas on pairing Power BI with other technologies in advanced analytics architectures

See https://powerbi.microsoft.com/en-us/blog/power-bi-expands-self-service-prep-for-big-data-unifies-modern-and-enterprise-bi/ for the latest announcements.

Speaker: Mark Tabladillo Ph.D. is a data scientist at Microsoft. His career has focused on industry application of advanced analytics, using a variety of analytics tools including SAS, SQL Server Analysis Services, Cortana Intelligence (including Microsoft R Server and Microsoft Machine Learning Services), R, and Python. He was a founding member of the Atlanta Microsoft BI User’s Group eight years ago, and this group’s second presenter.

Sponsor: Don’t settle for “one size fits all” training. Choose Accelebrate, and receive hands-on, engaging training precisely tailored to your goals and audience! Our on-site training offerings range from ASP.NET training and SharePoint training to courses on ColdFusion, Java™, C#, VB.NET, SQL Server, and more.

RSVP at http://atlantabi.pass.org/

When: Tuesday, August 28, 2018 6:30-8:30 ET

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

Atlanta Microsoft BI Group – July Meeting

by Leave a Comment

Please note the new meeting location below.

Topic: How to Create a Tailored End User Experience with Power BI

Speaker: Scott Fairbanks (CCG)

Summary: Power BI can deliver value in a variety of ways. With its ease of use, high levels of adoption, and growing market share, Power BI is being integrated into Analytics Solutions all over the world. In this session, attendees will see the power in leveraging Workspaces and Apps within Power BI to create a packaged, custom solution tailored to meet the needs of the consumer. With the end user experience in mind, this session will discuss the development process, design considerations, and the Power BI Service deployment of a collection of customized dashboards in a single App.

Discussion Points Include:

  • Power BI Desktop
  • Power BI Service
  • Workspaces
  • Apps
  • Visualizations
  • Interactions
  • Formatting
  • Mobile View
  • Row level security
  • Publishing
  • Consuming

RSVP at http://atlantabi.pass.org/

When: Monday, July 30, 2018 6:30 -8:30 ET

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

Atlanta Modern Excel – May Meeting

by Leave a Comment

Topic: Time Intelligence and Date Tables in Power BI & Excel

Speaker: Marco Russo (MVP, Author, DAX Guru)

Summary: Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation.

This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.

RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/250622970/

When: Wednesday, May 16, 2018

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

DIAD with Prologika

by Leave a Comment

Last week I was able to assist Teo Lachev with the Dashboard in a Day presentation at the Microsoft office in Alpharetta. We had good attendance with over 50 people participating in the class. I’d never attended a DIAD class, and I had a few observations.

The audience appeared to have some experience with Power BI before this class. This experience is evidence of Power BI’s popularity. The reaction last week is what I’d expected from Power Pivot, but that hasn’t really materialized.

There was a wide array of job responsibilities in attendance. A wide range of departments that are learning to use this tool. The questions at the end covered many different topics.

This day goes quickly despite the long list of tasks for attendees. I’d be surprised if anyone finished entirely, but I think that they got a substantial amount completed. Enough to get started!