Mi4 Blog
Want a better way to document and report on your downtime? Check out Productioneer’s new downtime codes! Productioneer comes with a list of 26 downtime codes but our customers can make any customizations and additions that fit their operations.
Uptime/Downtime is a KPI that is relevant from the field to the boardroom. These discrete codes and the analytics expertise of Mi4 team make Productionner a great platform for tacking your performance.
It’s time to spring forward for most of us in the US (not forgetting about you in Arizona and Hawaii), but what about the rest of the world? Well I compiled some data from Time and Date and put together a quick Power BI dashboard on my lunch break…ok a lunch break and a coffee break….ok 2 coffee breaks.
Kestrel is the built-in web server for Microsoft’s dotnetcore platform. I do not know the actual etymology of Kestrel, but it sounds like a planet or the name of some obscure band that played at Fitzgerald’s in 1997. My band never played Fitzgerald’s in the 90’s. We played the Firehouse Saloon and The Side Car Pub, but that was 2000. We had some pretty catchy tunes.
Here is a quick tip for analyzing daily data in Power BI. If you have a query or dataset that contains a date, a category, and a value measure for that category and you want to create a static measure that always returns the total value for all categories, here is the DAX expression you would use:
DailyTotalAllCategories = CALCULATE(sum(Query1[value]),ALL(Query1[categoryname]))
You could then use this daily total DAX measure in calculation of the percentage of the total for each category with this formula:
PercentDailyTotal = DIVIDE(SUM(Query1[value]),DailyTotalAllCategories)
If you are only interested in the percent daily total you could bypass the DailyTotalAllCategories measure altogether and your formula would look like this:
PercentDailyTotal = DIVIDE( SUM(Query1[value]), CALCULATE( sum(Query1[value]), ALL(Query1[category]) ) )
Speaking in generalities can be a little hard to follow. A simple oil and gas implementation of these concepts is after the break. Continue reading “Power BI Tip: Daily Total and Percent of Daily Total DAX Expressions”
Our first Productioneer update of 2018 has been released! Version 2.5.0.1 has added lots of new data points for analysis and reporting. The official “What’s New” content is below:
Continue reading “Productioneer 2.5.0.1 Update”
For those of you not in the Houston area, the city is pretty much shutdown today due to icy conditions. We remain open, most of us wearing finger-less gloves, coding away.
Here are some pictures from the Mi4 team documenting the icy conditions around our office.
I had a previous post about Bitnami’s virtual machine offerings. What I failed to mention is that those VM images are available in VirtualBox or VMWare formats. I am partial to Hyper-V; so what’s an Mi4 developer on a Saturday night supposed to do?
Well after some searching a found a process using Powershell to convert VMWare hard drive images (vhdk files) to Hyper-v virtual hard disks (vhdx files). Continue reading “More VM Tips: vhdk to vhdx”
Coffee is still a developer’s best friend, but Bitnami is definitely in my circle of friends.
Over at Bitnami they have preconfigured virtual machines for software development. If you want to get up and running on a different software stack quickly it’s a good place to go. It’s not a bad place to spend a Saturday night either (if you’re the kind of person who lists websites in your circle of friends).
Their offerings are comprehensive, convenient, and free: WordPress, Joomla!, Elk, Rails, Tomcat, etc. And if you don’t want to spin up an entire VM, Bitnami can install the stack into an existing environment.
Virtual Machines are great. Free stuff is great. Free Virtual Machines are awesome.
Many people are unaware that Microsoft offers Windows virtual machines (VMs) for free. In fact they offer Windows VMs with the latest updated versions of Visual Studio installed on them. This is super useful for software development and testing.
https://developer.microsoft.com/en-us/windows/downloads/virtual-machines
Microsoft also provides virtual machines from Windows 7 to present with various preinstalled browser configurations. These VMs are intended for web developers to use for compatibility testing, but they can be freely used by anyone for other purposes as well.
https://developer.microsoft.com/en-us/microsoft-edge/tools/vms/ Continue reading “Virtual (Machine) Reality”