Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for June, 2017

Microsoft Data Insights Summit 2017 Sessions Available On-Demand

Posted by denglishbi on June 14, 2017

If you missed out on attending or watching the live streaming event the last two days you can now watch the content on the MS Power BI YouTube channel.

image

And if you missed out on the 2016 event, those videos are also available.

Enjoy!

Posted in Training | Tagged: , , | Leave a Comment »

MN PASS Microsoft BI User Group Meeting – Jun 19

Posted by denglishbi on June 12, 2017

The next MN Microsoft BI User Group meeting is on Monday, June 19. There will be two presentations, the first one is Analyzing Healthcare Open Data with Power BI (presented by me) and the other is Time Intelligence in DAX (by Marco Russo!).

Please Register Now (Please register so that your name badge is pre-printed)

MN Microsoft BI User Group June 2017 Meeting

Date: Monday, June 19, 2017

Check In: 3:45 PM Event Time: 4:00 PM – 7:30 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435

Please Register Now (Please register so that your name badge is pre-printed)

Agenda:

  • 3:45-4:00 : Check-In
  • 4:00-4:15 : Microsoft BI User Group Updates and Announcements
  • 4:15-5:15 : Analyzing Healthcare Open Data with Power BI (Dan English)
  • 5:15-6:00 : Break, Dinner, Networking
  • 6:00-7:00 : Time Intelligence in DAX (Marco Russo)
  • 7:00-7:30 : Closing / Prizes

Presentations:

Session 1: 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 English, Sr Data Warehouse Architect and Microsoft Data Platform MVP

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.

Session 2: 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, Microsoft Data Platform MVP

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.

Posted in Power BI, Training | Tagged: , , | Leave a Comment »