February 2018 PASSMN Meeting

PASSMN (Minnesota SQL Server User Group)
PASSMN (Minnesota SQL Server User Group)
Public group

Microsoft Technology Center

3601 76th St W; Suite 600 · Edina, MN

How to find us

6th Floor, check-in at the registration desk with photo id, meet in Lake of Woods rooms I and II

Location image of event venue


• What we'll do
Meeting Agenda:

3:30-4:00 : Registration, Networking, and Food
4:00-4:10 : Kickoff / Announcements
4:10-5:25 : How to: Build a SQL Server Dashboard with Power BI Desktop (Dan English)
5:25-5:35 : Closing

Meeting Sponsor: DallasDbas.com (Kevin Hill) - http://dallasdbas.com

Presentation topic and abstract for this meeting:

How to: Build a SQL Server Dashboard with Power BI Desktop

This session will provide an overview of Power BI tools including the Desktop, Service, and Mobile application. We will use Power BI to pull some information about SQL Server databases such as the count, sizes, last backup, recovery model, and file information. We will explore some of the recent capabilities that were added to Power BI Desktop like drill through and bookmarks. The example will be provided after the meeting so that you can review the code, try it out, and enhance the reports on your own.

Speaker bio:

Dan English 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 is currently using 2017! Dan has videos on YouTube and Vimeo, is a blogger, and tweets. Dan is the group leader for the PASS Business Analytics Virtual Group and Director of Technology for the PASSMN SQL User Group.

• What to bring
There will be free wifi available with an event code and please bring a pen to fill out the survey / feedback forms.

• Important to know
Have a photo id available for registration desk to get printed badge. We typically serve pizza and have pop and water available when you arrive.