Stories & Tips

Up to date information on Retail data, the latest in Technology and related matters to Microsoft

2 / 22 / 2017

Power Pivot & Power BI training in Bentonville at Walmart Intl Building

Here are Harvest, we’re proud of our partnerships.  Last year we were fortunate to help Walmart International bring in Rob Collie who wrote the book on PowerPivot for training.  We’re very fortunate he’s back here this year again for private on-site training that we are making available to our readers and customers. What is Power Pivot? PowerPivot is a built-in Microsoft EXCEL Add In (2013

Read More >>
2 / 13 / 2017

DAX calculation for local time versus UTC

DAX is Microsoft’s powerful language behind Excel and Power BI.  Very few users of Excel know that you can utilize it, but it’s predominately available in one of the most underutilized features called PowerPivot.  Fortunately DAX is used also in Power BI and while creating a report for use by a customer I needed to translate log times from local time and compare it to UTC time. Probl

Read More >>
2 / 8 / 2017

Spam domains

So recently I’ve had some issues with people calling and emailing trying to get my business for outsourcing.  Looks like my information was “scraped” from LinkedIn.  In an effort to help others, here is a list of domains that I’m blocking.  I’ll keep it updated as I block them from our email server.  I’ll put the newer domains at the top. It’s important to note th

Read More >>