If you are using the tracking profile editor to map orchestration shapes/events to BAM activity, the date time value that appears in views and cubes will be in UTC (Coordinated Universal Time) time. With a little tweaking of a stored procedure for each activity, you can display the date time value in your local time.

The stored procedure to modify is: bam_<Activity Name>_PrimaryImport. Add the following couple of lines in this stored procedure:

DECLARE @TimeDifference int
SELECT @TimeDifference = ROUND(DATEDIFF(mi, GetUTCDate(), GetDate()), -1)

For each variable of datetime type passed into this stored procedure, add the following:

SELECT @yourVariable = DATEADD(mi, @TimeDifference, @yourVariable)

That's it!

I want to thank Seong Joon Kwak for asking the question and going through a couple of solutions before I arrive at this simple solution.