www.sqlpass.org    Professional Association for SQL Server
 Welcome, Atlanta Microsoft Business Intelligence Users!

Meet other local Business Intelligence fans to discuss the Microsoft BI Platform. Unless otherwise announced, we meet on the last Monday of every month. Membership is complimentary but please register at sqlpass.org and associate with our group.

Please RSVP your attendance for each meeting by submitting the survey on the right. Please note that the voting system tracks votes by cookies. If you don't see an option to submit the survey, clear your browser cookies or right-click the Internet Explorer icon and click Start InPrivate Browsing.

Meeting Agenda
6:30 - 6:55 - Networking, Announcements, Prototypes with Pizza
6:55 - 7:15 - Sponsor Presentation(s)
7:15 - 8:15 - Main Presentation(s)
8:15 - 8:30 - Q&A, Discussion

Meeting Place
115 Perimeter Center Place
Atlanta, GA 30346

South Terraces Building
The Auditorium room (first floor)

Covered parking at South or North Terraces: FREE but take and validate ticket at security guard
Open non-ticket parking: FREE, next to North Terraces (off Perimeter Center Terrace street)


 Next Meeting

Rate this meeting

http://aka.ms/PUGSurvey, PUG ID: 104


Self-service Data Preparation for Data Analysts

Level: Intermediate


Monday, May 23th, 2016


6:30 – 8:30 PM ET


South Terraces Building (Auditorium Room)

115 Perimeter Center Place

Atlanta, GA 30346


Power BI has a lot to offer to data analysts interested in creating data models using Power BI Desktop or Excel. However, unless you analyze data stored in a data warehouse, data is rarely clean. Fortunately, Power BI Desktop and Excel include powerful data shaping and transformation capabilities that help the data analyst improve the data quality before importing the data in the model. In the first part of this session, Teo Lachev will show you how to use the Power BI built-in features to apply various data transformation tasks. In the second part, you’ll see how Alteryx can bring Power BI data transformation and analytics even further with:

  • Data Preparation: Quickly prep, blend, and analyze data from multiple sources for Power BI consumption. Deliver a repeatable workflow process to reduce the time spent on manual processes. Push datasets directly to Power BI to create rich visualizations.
  • Advanced Analytics: Utilize the power of spatial and predictive analytics in a simple drag-and-drop interface without having to write code. Add a new dimension of insight to your visualizations with advanced modeling tools to handle complex use cases such as Multi-Channel Analysis, Predictive A/B Testing, Location Selection, Market Basket Analysis, and more.
  • Text Analytics: Build repeatable analytic workflows and harness the power of Azure Machine Learning to easily perform sentiment analysis and extract key phrases from your data.


Teo Lachev is a consultant, author, and mentor, with a focus on Microsoft Business Intelligence. Through his Atlanta-based company “Prologika”, a Microsoft Gold Partner in Data Analytics, he designs and implements innovative solutions that unlock the power of data and bring tremendous value to his customers, ranging from small companies to Fortune 50 organizations.
Håkan Söderbom is a Director, Technology Alliances at Alteryx, Inc. For the last 20 years Håkan has driven alliances either at Microsoft with Partners, or at Partners with Microsoft. Now he is thrilled to be with Alteryx, in particular since the successes are being recognized by Gartner. His work in the Microsoft ecosystem has taken him from his native Sweden, via several international roles based out of the UK and the US to settle in Redmond, WA, on the doorstep of Microsoft's corporate headquarter.


Alteryx provides business users with the unique ability to easily prep, blend and analyze all of their data using a repeatable workflow, then deploy and share analytics at scale for deeper insights in hours, not weeks. nalysts can connect to and cleanse data from data warehouses, cloud applications, spreadsheets and other sources, easily join this data together, then perform analytics – predictive, statistical and spatial – using the same intuitive user interface, without writing any code.

Prototypes with pizza

Narratives and Row-level Security with Teo Lachev
Take a glimpse of how you can narrate and secure Power BI reports with narratives and row-level security


Meetings in 2016

January 25th
February 29th
March 28th
April 25th
May 23th
June 27th
July 25th
August 29th
September 26th
October 31st
December 5th

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.
I'll attend the next meeting

Submit Survey  View Results
 Topic Poll
What BI area are you most interested in?

  View Results
You must sign in to vote in this survey.
 Choose Meeting Day
Which day do you prefer for our meetings?

Submit Survey  View Results