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 @ 10201 N. Illinois St. 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, Business Information Consultant Anthem Inc.

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):
Dan(Annie) Xu is an Business Intelligence specialist with 8 years of strong academic and working experience in Database Development, Tabular Data Modeling and Information Management consulting projects. Currently, she is working at Anthem Inc, as part of the Business Intelligence Team delivering world-class Enterprise BI solutions. Recently, Annie is certified as MCSA: SQL 2016 Database Development and is working on getting certified as Microsoft Certified Solution Expert. Annie is good at developing SSAS tabular models, building data warehouse, using DAX and tabular Data Modeling to solve ETL problems reside in database server.




Back to Top