Educational Blogging

Today we'll see how to unpivot data using Power Query in MS Excel .  How can we  transpose data  that are in  multiple columns , but also has multiple headers, which is more like a reporting type of layout into a  tabular data  set so that it's easy for us to create a  pivot table , or do further analysis using formulas? We want to do it dynamically, though so that if we end up adding more columns to this, all we need to do is refresh the end report and everything will pull automatically through. So we have our customer names, we have an article description, and we have a nice report about sales values by month, which are recorded as dates and by scenario. What we want to do is to transform the report into a proper  tabular data  set. In the end, we should just have a single column for a customer, for the article. There shouldn't be any gaps, then we have a separate column for a scenario, followed by a separate ...

This is  Google Drive 2020 Tutorial , where I’ll tell you how to use  Google Drive  and highlight some of the best  Google Drive features . Today, I want to give you guys a more in-depth #GoogleTips on how to use  Google Drive .  And, since we’re about in the last part of 2020, I figure now is a good time to go over some aesthetic and functionality changes and features that have happened in the last year in  Google Drive . So without further ado, let’s dive into Drive. If you’re new to Google Drive, let’s start with  what is Google Drive ? Google Drive  is a  free cloud storage solution , that features  file storing ,  file syncing , and sharing files  across devices. So if you’ve ever created or read a Google Doc, for example, that’s all part of  Google Drive ecosystem . So there are multiple ways to access Google Drive. Now for me, I always access my drive from my  Gmail ...

We’ll discuss the configuration of kdump on an Oracle Linux server .All steps and procedures explained and performed are based on Oracle Linux release 7 . What is kdump? Kdump is the crash dump mechanism of the Linux kernel which allows us to save the system memory contents for analysis . Oracle recommends that you enable the kdump feature as it helps Oracle Linux support to find the root cause whenever a server panics or crashes. To help identify the cause of the crash in case of a system failure, a memory image called the vmcore is created by kdump. An exclusive system memory portion will be requisite for kdump to be enabled. Being exclusive, this memory is not available for other purposes. Kdump utilizes kexec to boot to a second kernel whenever the system crashes. What is kexec? Kexec is a quick boot mechanism that allows the Linux kernel to boot from within a kernel context that is already running without going through the bootloader stage. ...

Today I'm going to tell you how to make the  Giant Sour Patch Kid as part of DIY funfoods . You can do it too, and I'll even tell you how to make the mold.  So one of the first things we need to make our  Giant Sour Patch Kids  is a mold. And since I can't just go on Amazon and buy a  Giant Sour Patch Kid  mold, I have to make my own. So the first thing I did was print out a picture of a  Sour Patch Kid,  and cut it out just on a piece of paper. I just did the full length of the paper.  This is going to be our guide. And what I'm going to try is I've done this before with cookie cutters, making my own cookie cutter. And I'm going to see if this works as a mold too. So the first thing I did was I took a  cookie sheet , just lined it with some foil. That's simple. Next, what you're going to need is one of these which is a  disposable baking tin , and we're going to cut these up. These are pretty cheap. It...