Skip to main content


Amlgo Blog - Experience The Experiments

Amlgo Labs Blog  is a step towards our vision to share knowledge and experiences, Amlgoites accept every challenge very enthusiastically. We do experiments, we fail but we learn and build complex solutions to help our clients solve their problems in Data, Analytics, Prediction, Forecasting, Reporting, Designing and Development area. During this process we enjoy immense learning everyday and we have decided to share our thoughts, learnings, experiments and experiences so that we don't work in silos and contribute the best of our knowledge towards community and learn more by views and reviews. This website is maintained and brough to you by  Amlgo Labs Professionals .   Our Strong Basics -  1)   KISS (Keep It Simple and Straightforward) :  We believe most of the problems can be solved by keeping things simple and straight. This is the learning we had in past, sometimes we try to solve technical problems using high end algorithms and complex codes but this results into complications.
Recent posts

SQL Overview

Hello and welcome all to a new series to understand the SQL statements in simpler ways. In this series we will try to learn about Data, Database and SQL statements along with their syntax, execution and examples. Before understanding commands of SQL, we have to learn some basics about SQL. And before we learn about a SQL, let us understand what SQL is used for.

Javascript: Arrow Functions

Hi techies! This blog is the continuation of the 2-part series discussing about Event Loops and Arrow functions. I hope you have already read about Event Loop and have an understanding about it. Let’s continue with this blog the discussion about Arrow Functions.

Javascript: Event Loop

Hi techies! This blog is a 2-part series discussing about Event Loops and Arrow functions. These are important concepts that every JavaScript programmer must be aware of from interview perspective and also to enhance your understanding in JS.

Promises in JavaScript

Hello Techies, in this blog we will discuss about Promises in JS. JavaScript (JS) is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions. While it is most well-known as the scripting language for Web pages, many non-browser environments also use it, such as Node.js, Apache CouchDB and Adobe Acrobat. Let’s begin!

Tableau: Joins

Hello Techies, we are back with another blog on Tableau series. In this blog, we will explore different types of Join in Tableau, which is helpful in selecting data efficiently. Before we start I will recommend you to go through our introductory blog “Tableau: Products and Services” to get an overview of Tableau, moving forward to our today topic of Types of joins in Tableau. There are four types of Join available in Tableau Inner Join, Left Join, Right Join, and Full outer Join.

Tableau: Introduction and Usage

Hello Everyone, This is an introductory blog about Tableau. In this blog we will explain what is Tableau, why we use it, what are the different data sources that we can connect with and what are the different data connection types available. But first let’s understand the importance of Data Analysis and Data Visualization. In today’s world every enterprise, company or organization is collecting huge amount of data from its users or client that can’t be used in its raw form.

How to Connect Windows with Ansible?

Hello Techies, this blog is the continuation of the last blog Install Ansible on Windows which is the second part of the series Ansible with Windows . Before you proceed, I recommend you to please take a look at the introductory blog of this series so to have an understanding of this series.

Install Ansible on Windows

Hello Techies, welcome back. This blog is in continuation of the previous introductory blog and second part of the series Ansible with Windows . I request you to please visit the introductory blog to have an idea about what is Ansible. But if you already know you can just start with this blog of how to install Ansible on Windows. So, let’s get started.

What is Ansible?

As the number of technologies gets increasing, there is also a high demand to cope up with them. Many companies are driven with the DevOps culture and many are in transition. With the introduction of DevOps it makes easier for any organization to focus on each and every aspect from Planning to Building to Release to Deployment, which is otherwise stringent.

JavaScript: The Important Basics

In this weird world of technology people often get confused how does a website work? What all things should I be aware of? So we are here to help you. Most of the content on web is developed with the help of JavaScript. JavaScript is really becoming popular these days with the coming of ECMAScript2015 and ECMAScript 2016, for this reason, some beginners learning React and Angular and are also trying to tackle more modern JavaScript syntax at the same time. If you're new to both, it can be confusing as to "what is JavaScript and what are its important features". This document should serve as a primer to help you get up-to-speed on JavaScript syntax that we feel matters the most for learning React as well as Angular.

Predictive Analytics: Amlgo Labs Seven Step Process

Hi Friends, today we are going to give you a sequence of steps on how you can solve a predictive modelling problem in simple steps. This will help you to understand how an analytics problem is solved, what is the most important step in the process, and are these steps fit in every analytics problem and most importantly why do we need to follow these steps. So, before we jump on any of these questions and the seven-step process, let us look at below example to understand – “what is predictive analytics?”.   My loan application was rejected by the Bank because they predicted I may not repay the loan. In this example banks used some parameters to check what is the probability of me doing default, and this probability must be below certain threshold.   So, how does the Bank predicted it? bank has an algorithm where they provide some parameters (like salary, age, job type, experience, etc.) and it gives the probability of getting default (like 78%, 35%, etc.).   So, the process of building

Power BI Card Visual With Conditional Formatting

In this blog we will take you through the Power BI Card Visual and a workaround to present card with conditional formatting. To know more about what is Power BI please do check Power BI Blog . The conditional formatting, we do will not be on the Card Visual, but the output will certainly look like Card, which is a requirement in some cases. Many Power BI users have used Card Visual to represent some value on the Power BI Reports separately or on above of any other visual, but sometimes clients ask which is deemed difficult to achieve, but not impossible. So, let’s dive into the practical to know more about it.

A simplified view of a QlikView tool:

In our last blog related to Qlikview, we discussed the use of Qlikview for Financial Data Analytics . Qlikview is a Business Intelligence tool that consists of a front end to visualize the processed data and a back end to provide the security and publication of the mechanism for QlikView user documents.

Power BI Blog - What is Power BI and Why we use Power BI.

This Power BI blog is an introduction to the Power BI. In this Power BI tutorial, you will learn Power BI basics - what is Power BI, Power BI Desktop and Power BI Service. Power BI tool is a combination of Business Intelligence and Visualization. Before we dig deep let’s understand what is Business Intelligence. Business Intelligence is a broad spectrum which consists of using different business strategies and techniques to gather data, refine it and process it for the purpose of data analysis which gives us some meaningful information which helps in data driven decision making. When we present this information in the form of some charts, graphs it takes the form of Visualization.

Polybase Installation for Scale-Out process

This part is the continuation of the previous blog about the introduction of  Polybase Scale-Out Group . As we have discussed in our earlier blog PolyBase enables your SQL Server instance to process Transact-SQL queries that read data from external data sources. SQL Server 2016 and higher can access external data in Hadoop and Azure Blob Storage. Starting in SQL Server 2019, PolyBase can be used to access external data in SQL Server, Oracle, Teradata, and MongoDB.