• How to Set Up KNIME and Concatenate, Union, or Merge Datasets in KNIME

    Download KNIME here: Downloads | KNIME

  • Power BI Row Level Security: What is it? How to set it up?

    Row-level security (RLS) in Power BI is used to restrict access of data for given users. This is done by filtering the restricted data at the row level where you define the filter for the role. Roles are also defined in Power BI.

    Follow this article to learn everything you need to know about setting up RLS for Power BI. This is an essential function for a Power BI administrator and you can learn more about our offering to get this done for you here.

  • What can Salesforce CPQ do for you? 

    The Configure-Price-Quote Solution, or Software, by Salesforce was created to be a specialization to this software as a service (SaaS) company that will focus on streamlining their customers Quoting and Sales process by utilizing accurate pricing functions. 

  • AWS Cloud Practitioner Comprehensive Guide

    See our comprehensive AWS Cloud Practitioner Comprehensive Guide that is sourced from AWS experts and updated and maintained by our HomeGrown Solutions AWS team. This guide should be able to give you the ability to pass the first of thirteen AWS cloud certification exams.

    This first AWS Cloud Practitioner Exam is available here. You can take it at a scheduled time in a proctored environment via webcam at home or at a certified testing facility. Having studied the AWS Cloud Practitioner Comprehensive Guide and with a basic fundamental level understanding of all AWS services, you should be able to pass with a score of at least 70%. 

  • WordPress vs. Squarespace vs. Wix

    There are a lot of platforms to choose from when building a website for your business. Should you use WordPress, Squarespace, or Wix? It can start to become overwhelming when exploring all of your options. Let's compare the current leading low code technologies for website building and help you choose one which best fits your needs. When choosing a website builder for your business, it’s important to be aware of the prices, features, benefits, advantages offered, and the good and the bad in each platform.
  • Automating DAX using C# to Create Dynamic Metrics on TOM Power BI Models in Visual Studio

    Hey, everyone! In this blog post, I'm going to show you how to use C# to automate the generation of DAX measures in your Power BI models. This is a great way to speed up the process of building out your reporting and analysis infrastructure, and it can also help you avoid some common errors that can occur when creating DAX measures manually. So let's get started!
  • Using Python to Work with the Keepa API to Automate MySQL Database Ingestion for Power BI

    Python is a versatile language that can be used for all sorts of things, from data analysis to web development. In this blog post, we'll show you how to use Python to work with the Keepa API to automate MySQL database ingestion. Keepa is a site that tracks Amazon prices and allows users to create price alerts. We'll walk you through the steps of setting up a Python environment and using the Keepa API to import data into your MySQL database. Let's get started!
  • Set Up Power BI Licenses and Security for your Organization

    In this blog post, we'll walk you through the steps necessary to get Power BI up and running in your organization. We'll also show you how to configure user permissions and establish security protocols.

    Let's get started!

  • 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!