Jeff Prom's SQL Server Blog

Sharing knowledge and tips on SQL Server, Business Intelligence and Data Management.

Posts Tagged ‘SQL Saturday’

SQL Saturday #175 – Fargo, North Dakota

Posted by jeffprom on March 15, 2013

SQL Saturday #175

Saturday, April 27th I will be presenting at SQL Saturday #175 in Fargo, North Dakota. This event will be held at the Microsoft Executive Briefing Center at 4550 42nd Street South, Fargo ND, 58104.
I will be speaking on the following topic:

Data Quality Services
As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.

Check out the SQL Saturday #175 page for more information.

See you at the event!

Advertisements

Posted in DQS, Events | Tagged: , , | Leave a Comment »

Bienvenidos al SQL Saturday #189 – Costa Rica

Posted by jeffprom on February 20, 2013

SQL Saturday #189

I’m excited to announce that I will be speaking at SQL Saturday #189 in beautiful Costa Rica! This event will be held on April 13th, 2013 at the Aurola Hotel Holiday Inn San Jose Downtown.
I will be presenting on the following two topics:

Master Data Services
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session 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 session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Data Quality Services
As the old adage goes, ‘Garbage in, garbage out.’ Stop spending hours manually cleansing your data, and start using DQS! DQS is the new data quality tool provided with SQL Server 2012. By leveraging knowledge bases, you can correct invalid data and improve the quality of your data.

In this session we will cover creating a knowledge base, data cleansing, data matching, and using 3rd party knowledge bases (Reference Data). We will talk about installation, show how to use the DQS tool, and how to integrate DQS into your SSIS packages. After this session you should have a good understanding of what DQS is, how to use it, and how to get started with your own Data Quality initiative.
………………………………….
Last November I was fortunate enough to meet several chapter members at the PASS Summit event in Seattle. I look forward to the opportunity to meet again in San Jose this April.

Check out the SQL Saturday #189 for more information.

Posted in Events, SSAS, SSRS | Tagged: , | Leave a Comment »

SQL Saturday #206 – Madison, Wisconsin

Posted by jeffprom on February 18, 2013

SQL Saturday #206

Saturday, April 6th I will be presenting at SQL Saturday #206 in Madison, Wisconsin. This event will be held at Madison Area Technical College – Truax Campus, 3550 Anderson St, Madison, WI 53704.
I will be speaking on the following topic:

Master Data Services
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session 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 session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.

Check out the SQL Saturday #206 page for more information.

Hope to see you there!

Posted in Events, MDS | Tagged: , , | Leave a Comment »

SQL Saturday #149 Minneapolis (Sept 28-29, 2012)

Posted by jeffprom on September 17, 2012

The 2012 SQL Saturday Minnesota event is almost here. It will be held on Saturday, September 29th at the University of Minnesota – Keller Hall. Registration is still open, and details can be found on their site (http://www.sqlsaturday.com/eventhome.aspx?eventid=231). This year I will be giving a presentation on Microsoft’s Master Data Services. I will cover using 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. Reserve your spot today and take adavantage of this great event.

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