Pragmatic Works Blog

What's Going On in November?

Written by Pragmatic Works | Nov 01, 2017

We're kicking off the month exhibiting at PASS Summit 2017 in Seattle, WA and hosting our 6th annual SQL Karaoke event, often considered to be the highlight of PASS. You can follow us on our social platforms like Twitter and Facebook to stay updated on daily happenings at this event. 

Check out what else we have coming up this month in our training, software and consulting departments!

BI Quick Start Boot Camp

November 13 - 17, 2017 - Birmingham, AL

Our BI Boot Camp provides a hands-on lab environment. In five days, you will build a fully functional prototype data warehouse using SQL Server 2012/2014/2016, along with the complete Microsoft BI Platform: SSIS, SSAS, SSRS and Power BI.

All bootcamps have limited seating available. Unfortunately, registration is now closed for the Birmingham Boot camp as all seats have been purchased. Check out our upcoming BI Boot Camps by clicking the link below.

Register for BI Boot Camp Here

VIRTUAL Half-Day DAX Workshop

November 2, 2017 - Online

DAX is both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. This half-day virtual workshop teaches the basics, as well as advanced DAX concepts. The goal of this course is to give the student the tools necessary to think like DAX and understand the why behind how calculations work. 

Register for Virtual DAX Workshop Here

Free Training on the t's

November 7, 2017 - Digital Storytelling with Power BI, Devin Knight

November 8, 2017 - Faster and Cleaner SSIS Data Loads with Task Factory,  Brian Knight

November 14, 2017 - Loading External Tables into SQL Data Warehouse, Dan Taylor

November 21, 2017 - SQL Compete, Steve Hughes

November 28, 2017 - Working with M (Power Query) in Power BI, Mitchell Pearson

We offer free virtual webinars every Tuesday at 11 a.m. (EST). Whether you’re just starting out on your BI journey or looking to master your skills, we have the training and resources to meet all your needs.

Register for This Month's Free Webinars

STAFFING DONE RIGHT

We understand how important the right team is. Bringing in the wrong resources can result in lost project time and more importantly, wasted costs, setting you up for a major setback. Unlike traditional staffing agencies, we take a modern approach to staffing by ensuring you have the right resources with the technical skills to match your company’s needs, and that those resources are backed by our consulting team experts.

Download the Staffing Data Sheet

GET THE HELP YOU NEED WITH DATA HELP DESK

Our Data Help Desk program allows you to work with experts to master the technologies you’re working with. Data Help Desk sessions can be designed to fit any schedule and budget. You have the ability to purchase a block of time, then schedule mentoring sessions as you need them. Sessions can be anywhere from 15 minutes to 2 hours long.

Fill out the form below to contact us to get started with Data Help Desk.

 

READ AND WRITE TO CONSTANT CONTACT WITH SSIS USING TASK FACTORY

Manually importing and exporting data from web services can be a time-consuming task. A popular web service used today is Constant Contact for sending emails to your customers. Wouldn’t it be great to get data into or out of Constant Contact in a more automated way using SSIS?

By using the REST Source and Destination component of Task Factory, you can do just that! Task Factory’s REST Source and Destination allows you to quickly and easily connect to almost any web service/cloud application that utilizes a REST API, such as Constant Contact, Google Analytics, GoToWebinar, Salesforce.com, Twitter and many more, and bring that data right into your data flow.

Learn More About This Feature

FASTER AND CLEANER SSIS DATA LOADS WITH TASK FACTORY

November 8, 2017 - Free webinar with Brian Knight

Learn how to load your data up to 700X faster with Task Factory components! In this session, you’ll learn how to performance tune packages, that normally take hours, in seconds with components like the Dimension Merge and Upsert component. You’ll also learn how to create cleaner data with some of the data quality components.

Register For This Free Webinar

ADDITIONAL HAPPENINGS:

JOIN US AT PASS SUMMIT 2017

October 31 - November 3, 2017 - Seattle, WA

Pragmatic Works is excited to participate in the 18th annual Professional Association of SQL Server Summit (PASS), considered the world's largest technical training conference for Microsoft data professionals

We will be represented in booth #307, and will be conducting software demonstrations and providing information on our training and consulting offerings. Stop by to see all our innovative solutions and learn how we can help you improve your business' productivity and increase analytics.  


6th ANNUAL SQL KAraoke 2017

November 1, 2017 - Seattle, WA

Pragmatic Works will also be hosting our SQL Karaoke event on November 1st from 8 p.m. - 12 a.m. at the Hard Rock Café on Pike Street in Seattle. Guests can watch their colleagues and friends sing along with a live band, and maybe even grace the crowd with a song themselves! Be sure to stop by the Pragmatic Works' booth (#307) to pick up your wristband to gain access to the party!

DASHBOARD IN A DAY EVENTS

November 16, 2017 - Houston, TX

November 29, 2017 - Boston, MA

Microsoft in partnership with Pragmatic Works are pleased to offer a 1-day workshop covering the capabilities of Power BI. The goal of this informational session is to help you understand how to analyze your data in a rich and compelling way. Whether you are evaluating its ability to meet organizational requirements around data visualization and analysis or are looking to learn how Power BI can help you be more efficient and make a greater impact on the work you do every day, this is the training for you.

Don't forget to stay updated on the latest in Pragmatic Works' news by subscribing to our blog!