Pragmatic Works Los Angeles BI Boot Camp
Click to purchase a seat in the Pragmatic Works Los Angeles BI Boot Camp. Microsoft has a wide range of offerings in the business intelligence space and it can take a lot of work to figure out how they all...
Category: Business Intelligence
Upcoming Presentation – Space Coast SQL/.Net User Group
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me! I’ll be speaking at the newly merged Space Coast SQL/.Net User Group on Power Query. This topic is...
How To Use the Unpivot Transform in SSIS
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially....
Monitoring BI Performance: Scripts and Slides
I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing 3 additional posts that go into a little more detail and contain screenshots of how to monitor each BI tool...
Webinar Q&A: SSRS Subscriptions and Data Alerts
Updated 10-16-2014 at 11:20 AM Eastern Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We...
Webinar Q&A: Getting Started with Change Data Capture
Yesterday I presented about Change Data Capture for the Pragmatic Works Free Training on the T’s. I covered the basics of what Change Data Capture (CDC) is and showed how to use it. We had a good turn out, so...
Webinar Q&A: Getting Started With Analysis Services
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about Getting Started With Analysis Services. We covered some of the differences between the two project types at a high level then built one of each...
Webinar Q&A: New BI Features in SharePoint 2013
I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience...
Presentation Update: New BI Features in SharePoint 2013
It’s time for another free webinar!! Whether you like it or not SharePoint is here to stay! With every release of SQL Server or SharePoint (which follow different release cycles) the feature set for Business Intelligence professionals gets more fragmented...
Presentation Update: Change Data Capture (CDC) Made Easy With SSIS 2012
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients...