The ever-growing need for data protection and security is creating legislation in various forms throughout the world. These laws and regulations often contain strict policies for organisations that handle personal data of citizens and how that data should be handled. One of the largest efforts we’ve seen is the European Union General Data Protection Regulation (GDPR).
As a business owner and someone who is responsible for sales, reporting in SalesForce.com is challenging to say the least. The reporting is tightly restricted to a few objects and the interface can't create the beautiful reports that those in the data industry are used to seeing. Most importantly, I can't merge the data with my existing data sources like data from accounting, HR or our other internal systems. This is why most people pull data from SalesForce.com into a central reporting database to do more advanced reporting. This blog shows you my method for pulling data into a single repository for further reporting.
One of the most frustrating things about SalesForce.com is the feeling of constantly looking over your shoulder to make sure you don't run out of space. Doing bulk deletion of records in SalesForce.com to fix this issue is done 200 rows at a time and takes a lot of time to setup. While there are many tools out there to help with this issue, the tend to cost quite a bit. This blog and video shows you a quick 4 minute solution to remove tons of rows from SalesForce using a free tool in Visual Studio, Task Factory and SSIS.
Promo Code: NEWYEAR
Pragmatic Works is offering $200 off any virtual training class purchased by January 15, 2015 when you use the promo code NEWYEAR at checkout. Additionally, if you book your virtual training class by December 31, 2014, Pragmatic Works will donate $50 to Seamark Ranch for every class puchased.
We've had a number of questions recently about tuning MOLAP cubes. I thought it would be a great time to brush off this old webinar about how to tune MOLAP cubes. This is only an hour webinar but the entire Master's SSAS class that we teach dives WAAAY deeper into the tuning. This webinar will teach you about to tune the follwing: