Dan English's BI Blog

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

Minnesota Microsoft BI User Group 2013 Q3 Meeting–Sep 10

Posted by denglishbi on August 12, 2013

The next MN Microsoft Business Intelligence User Group is coming up on Tuesday, September 10. This meeting we will have two presentations starting out with a presentation on master data management (MDM) and master data services (MDS) and then a presentation on parallel data warehouse (PDW). Please register so that we can have your name badge pre-printed.image

Are you planning to attend the PASS 2013 Summit October 15 – 18 in Charlotte, NC? Use the MS BI User Group discount code and receive 10% off!

Your chapter: Minnesota Microsoft BI User Group

Unique Discount Code: SUM156CH

To register for PASS 2013, click here: http://www.sqlpass.org/summit/2013/

Here is the remaining schedule for the quarterly meetings this year:

2013 Meeting Schedule

  • Tuesday, September 10
  • Tuesday, December 3

MN Microsoft BI User Group 2013 Q3 Meeting

Sponsored by:


Date: Tuesday, September 10, 2013

Check In: 2:30 PM Event Time: 3:00 PM – 6:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435 (in LOW 1, 2, and 3)

Please Register Now (Please register so that we can have your name badge pre-printed)


  • 2:30-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : Master Data Management and Microsoft Master Data Services
  • 4:15-4:30 : Break
  • 4:30-5:45 : Recognizing The Parallel Data Warehouse (PDW) Workload
  • 5:45-6:00 : Social and Networking


Session 1: Master Data Management and Microsoft Master Data Services

As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you ensure that your MDS data is up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project


Jeff Prom, Data Architect , Silver Bay Realy Trust Corp – Jeff Prom is a Data and BI Developer with over 15 years of experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect.

Session 2: Recognizing The Parallel Data Warehouse (PDW) Workload

If you are like many, you’ve been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft’s appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads.  But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture?  In this session, we’ll review that question and more with a run through of how to identify MPP workloads?  As part of the session, we’ll also review some of the key components and differentiators of the PDW platform.


Jason Strate, SQL Server Database Architect, Pragmatic Works – Jason Strate is a SQL Server database architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms.  As a PASS community member, Jason has lead user groups, organized SQL Saturdays, and is currently a Regional Mentor for PASS’s North Central US region.  Jason is a well-known presenter and author on SQL Server and data platform topics.  He has been author or editor on five books and blogging at www.jasonstrate.com.  He’s also presented at the PASS Summit, TechEd NA, dozens of SQL Saturdays, and other SQL Server community events.  And if that isn’t enough, he’s never been too far away from the karaoke after parties which may include an occasional unicorn.

Sanjay Kaul, Technology Specialist, Microsoft – Sanjay Kaul is a Technology Specialist at Microsoft who specializes in helping customers envision, design, and deploy data life cycle, data warehouse, and business intelligence focused solutions using the Microsoft platform. In his 12th year at Microsoft, Sanjay has spent time in Microsoft’s consulting group, enterprise SQL Server sales, SQL Server & BI Architect at the Microsoft Technology Center in Minneapolis, before moving to his current role of Data Warehouse Technology Specialist. With all the experience gained in the industry ranging from data architecture, disaster recovery planning, governance, database optimization, and data warehousing, his goal is to gain a deep understanding of the customer’s needs and help create solutions that exactly meet their needs.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: