Minnesota Events & News
banner

Events

 
BI User Group Meeting feat. special guest Marco Russo
June 19th
 
We are pleased to announce the Microsoft Power BI User Group meeting on June 19 2017, at Microsoft Corporation, 3601 76th St W, Suite 600 Edina, MN 55435 from 4:00 pm to 7:30 pm. We hope you will plan to attend this meeting as we are honored to have the BI guru himself, Marco Russo joining us! *Must be a member to attend. Membership is free, sign up today!
 
Monday, June 19 | 4:00 PM – 7:30 PM
 
June User Group Presentations
 
Analyzing Healthcare Open Data with Power BI
In this session we will explore and evaluate Healthcare data that is freely available to the public. You will see how easily we can consume and integrate the data to analyze and investigate. In the demos you will see some of the latest enhancements and features that have been included with Power BI such as ArcGIS (Esri) maps, forecasting, Top N filtering, grouping / binning, custom R visuals, and maybe a few more along the way. If you are interested in Open Data, Healthcare, or have to perform a lot of data manipulation in Excel or other tools to provide analysis for your job then this is the session for you. Leverage the free capabilities of Power BI, advanced analytics, and help simplify your everyday workload and wow your boss!
Speaker
Dan is the Sr. Data Warehouse Architect at Constellation, Inc., a Microsoft Data Platform MVP, speaker, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 20 years, and over 13 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 and now using 2016 and test driving 2017! Dan has videos on YouTube and Vimeo, is blogger, and tweets. Dan is the group leader for the PASS Business Analytics Virtual Group.
_______________________________________________
 
Time Intelligence in DAX
Time Intelligence is probably the most interesting feature of any analytical solution. Quick measures in Power BI can help you up to a certain point, because if you have more than one date column in your data model, it is also important creating the right data model, having the right Date table, and using the right DAX function to compute calculations such as Year-To-Date, Month-To-Date, Same-Period-Last-Year, and others.
In this session, you will see how to properly use time intelligence calculations in Power BI, avoiding data modeling and DAX mistakes, and using the right work around for the missing “Mark as Date table” feature that you have in Power Pivot.
 
Speaker
Marco Russo is a Business Intelligence consultant and mentor. He has worked with Analysis Services since 1999, and written several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on www.sqlbi.com, mentoring companies’ users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, PASS BA Conference, and SQLBits.
 

 

On-Demand Webinar

To learn about Nihilent Technologies' Agile BI Approach, check out our free, on-demand webinar. See how our approach delivers value to businesses in a timely and cost effective manner, while still keeping in mind the ever changing business requirements and Enterprise Data strategies.

View Webinar >>

News