• Get All Possible Combinations from a List using Python

    See this script in which we are taking a list from an array, getting all the possible combinations using itertools, writing that output to a data frame using pandas, and then printing that data frame to an excel file using pyexcel.
  • Convert XLS Files to XLSX Files using Python

    In order to automate converting excel file types, we can use scripting languages such as Python or PowerShell.

    The script in this article converts all of the XLS files in an existing folder to XLSX files, also making sure to delete any previously existing XLSX files that were in the folder previously.

  • SQL vs NoSQL

    SQL databases are the appropriate choice when the data is structured in relational tables, when performing relational queries, and when enforcing constraints. When there is a need for high performance and minimal delay, particularly when dealing with unstructured, large amounts of data, NoSQL databases are the best option.
  • How to Create Your First Power BI Report

    In this article, you will learn how to create your first Power BI Report. First, you will need to download and install Power BI Desktop. Navigate to the Microsoft Power BI Desktop download page. Click “Download.” This opens the Microsoft Store. Select the blue “Get” button and the download will begin. Now that the installation and setup is complete, it’s time to start creating your first report!