At HomeGrown Solutions, we understand the challenges that business face every day in today's data-driven, competitive landscape. We help you address these challenges by delivering lean and efficient technology solutions that not only produce immediate results, but also lead to transformed experiences across your projects.
Public organizations leverage HGS enterprise data offerings to build embedded analytics solutions for their external customers and in house departments and stakeholders.
Sample COVID Power BI Report
Healthcare organizations put data to work everday with HGS, enabling enterprise EMR reporting and reporting on patient portals and other hosted digital applications.
Power BI is Microsoft's business intelligence platform. The Power BI suite is a part of Microsoft's Power Platform technology suite and comes with Power BI Desktop, the Power BI online service, and the Power BI paginated report builder, formerly known as SSRS (SQL Server Reporting Services).
Marketing is made easy with Canva. Canva is a great tool to use for creating social media posts, ads, marketing designs, logos, business cards, and much more. This tool is very easy to use. Your business can use Canva to significantly improve the marketing of your services. First, we will walk through the steps of using Canva for beginners, then we will look at a few things it can create that are crucial for your business to have.
Google Analytics is a data tool for looking at how your internal website is performing. Google Analytics can answer a lot of questions for your website that will help increase profit. This can include the bounce rate of your users, new users vs returning users, the location of your users, the device used, how you acquire users, and much more. We will use the data from the Google Merchandise Store as an example.
What is SQL? In today’s increasingly digital world, nearly every business has an online presence and must store information in a database. The ability to access, extract, and manipulate this data for analysis to arrive at data-driven decisions is crucial in taking your business to the next level.
Power BI is a software developed by Microsoft. It allows users to create data visualizations for business intelligence. Microsoft currently offers Free, Pro, and Premium versions of Power BI. Typically a free license is for personal use only since it does not allow for content sharing. In this article, we will compare Power BI Pro and Power BI Premium to help you decide which license best suits the needs of your business.
Tags are very flexible and have many different uses. When using tags to organize your products, you will first need to add a new tag. When adding a tag to your product, simply scroll down to the area labeled: Tags, type in the desired name of the tag, then select add a tag. This new tag will be available under tags and can be used to organize any of your products.
In this article, you will learn how to create your first Tableau Report. Tableau Public is free and great for practice. For enterprise, however, it is strongly recommended that you install Tableau Desktop. Once you have installed the software you will be using, you can begin creating your report. Select File → New to create a new workbook. Then, click “Connect to Data.” From here, you can choose files to upload.
SEMrush is a very powerful tool for managing your website’s health. If you want to stay competitive, it’s important to check your website’s analytics when it comes to traffic, backlinking, and overall daily usage. You can do this seamlessly through SEMrush. It offers multiple tools for your website from SEO to content marketing. Located in the SEO section of SEMrush, you will find backlinking tools.
Hootsuiteprovides social media automation and analytics for your business. It’s easy to use and can save you a lot of time and money by providing you with robotic process automation to let your employees focus on more important tasks. Instead of wasting time logging in to each platform and uploading posts separately, Hootsuite’s API technicalities do it all in half the time.
Learn how to connect an SharePoint Excel Files to Power BI using the Power BI web connector step by step. Also, learn how to connect a SharePoint Folder to Power BI and merge all of the files together step by step. Lastly, learn how to automate Form Responses to Excels hosted in SharePoint step by step.
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.
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.
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%.
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.
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!
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!
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.
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.
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.
WaTech was looking to configure their Reporting Server and spin up these reports parameterized by Company code so they could segment their data across their state’s company ids for each corresponding state agency.
HGS delivered interactive SSRS reports that would allow WaTech to run the reports that they needed for four reports that they identified on top of their Avaya phone messaging system. User lists and subscriptions were set up and tested for delivery from the SSRS administration side as well.
Jason needed a way to get data in real time from his Mcleod logistics software that he runs his business on into Power BI. Luckily he called us to figure out that he can get the data from the SQL Server directly connected to Power BI. HGS worked with Jason everyday to deliver SQL Server customizations, a Power BI Gateway set up, and Power BI dashboards.
Connect Electric is an electric company based out of Richmond, VA. The company is black-owned and works in businesses as well as homes local to Richmond. Joy, the CEO at Connect Electric, was looking to unify their Service Titan CRM, Google Workspace, and Slack to automate communications and tasks to save time and money.
As a part of Intrahealth’s efforts to monitor its facility’s efforts globally, the organization was looking to build a data model that would populate its measures dynamically and programmatically every time global facility reporting results were delivered.
Norfolk Public Schools is a school district located in Norfolk County, Virginia. As one of the largest school districts in the state, Norfolk Public Schools was looking for an efficient means of tracking COVID-19 infection and regulation requirement compliance for all employees across their 64 schools and facilities. This tracking process was originally being done manually in Excel.
American Marketing & Publishing is a marketing and advertising agency based out of Illinois. The mid-sized business was looking to create an automated way to calculate its monthly and bi-weekly commission process according to a custom pay plan and bonuses administered to the AMP sales team. This legacy process was being done manually via Excel.
HGS delivered a Power BI based reporting solution, new SQL Server customizations in a new reporting database, Power BI administration, including scheduling, row level based security, and AD group based security, and post-implementation on going customizations and support.
MAK Chemical Inc., a global chemical manufacturing and distribution company,was looking to re-design its existing static website to a modern dynamic websitethat would allow for more functional capabilities and control. The mid sized business was looking for a solution that would be able to provide company information, a dynamic product catalog, display warehouse location information, a blog engine, and allow for prospective clients to contact the company via email.