If coding/automation is not about us fooling the machine to get our work done, we haven't yet exploited our powers enough. I, in my daily life, do all sorts of problem-solving involves complex coding, cloud computing, etc. but I get my real kick when I solve the smallest problem like hacking excel, or automation of workflow using power query. Here is my latest gig, I tried to connect to an excel in SharePoint and ensure that every time the database is updated my query picks the latest file. This is the first time I am using power query and it sounds so powerful. So without further delay, let's see what I did: 1. Connect Excel to DataBase: Open an excel file, Select Data from the green ribbon, go to Get Data , select the drop-down on From File , and connect to share point select From SharePoint Folder. Fig1: Select DataBase Once you select the database which is SharePoint in our case, you will get a window like this popping up to conn...
Yeah, very mediocre title to the blog but imagine if google SEO would ever find it if I used my imagination here and named it "My Jump Into The Herd Of Data Scientists". This was the first choice but you know yeah! Beside writing the aim of this blog is also to find you and ensure you like following this one. Therefore, subscribe to stay updated So the next thing is to clarify that this blog is about a journey, a never-ending marathon, and inspirations that led me here today. No algorithms!