Category: Blogs

Parameters in Tableau are referred to as containers of values used to calculate and effectively enter values not present in the original dataset. These parameters can include workbook variables like dates, a string of text, a number, or a calculated field which can be used to replace the constant value in a filter or calculation.…

In this tutorial, we will look at how to connect Python with SQL server using Pyodbc Library. The Pyodbc library is an open-source Python module that makes accessing ODBC databases simple. It is also a community-supported software. We have other Database Management Systems(DMS) that also work with ODBC. These Database Management Systems include; Oracle, MS…

JSON stands for JavaScript Object Notation which was derived from the subdivision of Javascript Programming Language dealing with Object Literal Syntax. It is used for representing structured data and is very effective for transmitting and receiving data between a server and web application. JSON is a built-in package that came with Python. This package is very good…

In this tutorial, we will learn how to connect Python with SQL Database. Python is a programming language that allows users to work quickly and integrate systems more effectively while MySQL is the most popular Open Source Relational SQL database management system used for developing web-based software applications. We need to know that Python can…

How to Create an EC2 Instance In AWS -A Step by Step Guide In this tutorial, we’ll be demonstrating how we can create an EC2 Instance in AWS. Let’s discuss a little about what Amazon EC2 is. The Amazon EC2 comprises both Windows and Linux-based operating systems which allows businesses owners to run application programs…

In this tutorial, we’ll show you how to convert text from images into a machine-readable format with the help of the Python Pytesseract module. The Pytesseract Module is a Python wrapper for the Google Tesseract library for OCR. We will be using this module to convert the words in an image to a string. Optical…

  Paginated reports are defined as highly formatted, pixel-perfect output result, reformed for printing or used for PDF generation. They are called “paginated” because they are designed to suit well on multiple pages and as well display all the data in a table, even if the table spans multiple pages. This Paginated reports are also…

The Pdb module(python debugger) comes built-in to the Python standard library. This module uses bdb(basic debugger functions) and cmd(support for line-oriented command interpreters) modules. The python debugger also works on command line which is a great advantage for debugging code on remote servers. The module is already installed when you install python. Therefore, we only…

Python datetime is a module to work with dates in python which consists of four main classes which are: date, timedelta, time, and datetimes. We’ll implement how each of these objects can be used in our code. The Date Class The object represents a date which is an attribute of the year, month and day…

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal or shows how effectively you’re meeting your goals. KPI visual is a functional and effective visualization in Power BI. KPI Elements in Power BI Key Performance Indicators can be broken into three parts; Base value,…