Welcome to the Indy BI PASS User Group

Indy BI User Group usually meets the first Tuesday of every month. Please check out our new Meetup group we created to track our event attendance at http://www.meetup.com/IndyBI_UG/.  Events will be posted there as well as here with any changes or added details updated at http://www.meetup.com/IndyBI_UG/.

Next Meeting




Indy BI PASS Meeting

  • In-Person @ 6220 Castleway West Drive Indianapolis, Indiana, United States (map)
  • 18:00 - 20:00 Eastern Daylight Time
  • Language: English

Welcome to Indy BI PASS User Group.

Featured Presentation:

From SQL to DAX – another way of extract data

Dan (Annie) Xu, Cloud Solution Architect Microsoft

This presentation is to provide BI consultants and SQL developers with different DAX and tabular modeling solutions which can be replacements of SQL querying and high resource consuming ETL processes. Abstract: Many of us are coming from knowing SQL before they have been introduced with DAX or many of us know how to use tabular model through reporting tool but do not know they can use DAX as query language against a tabular model. Thus, I am glad to provide this presentation focusing on three areas: 1. How to use DAX as a query language to select columns (columns from multiple tables and from value); Group Data; Filter Data; Join Tables; Build customized calculations/measures 2. How to use tracing tools to monitor the performance difference between SQL solution and DAX solution; 3. Use a real life example to demonstrate how to DAX and tabular modeling (Row Contexts vs. Filter Contexts+Bridge Table+Inactive relationship+extended table) to replace high resource ETL Processes

About Dan (Annie):
Annie Xu is a Microsoft cloud solution architect focusing on Data and AI. She has comprehensive educational and working experience in business intelligence, database development and data engineering. In addition, she is building up her skills around AI and Machine Learning. Annie speaks at DMV area Power BI, SQL and Azure user groups. You are welcome to read her blog: https://xuanalytics.com or connect her through LinkedIn @anniexu1990




Back to Top