HomeGrown Solutions

04/14/2023

Cash Giant, a Michigan based retail chain specializing in small lending, groceries, and gift card transactions, was looking for a centralized POS System for its multiple retail locations to use in order to log daily transactions and track inventory. The stores were previously tracking sales manually through excel.

HGS delivered a react-based web application hosted on Google Cloud that would allow Cash Giant to implement a central POS System that all stores could use simultaneously to track transactions and update inventory automatically in real time. An admin console allows system admins to control user rights and authenticated users to view and update transaction and inventory logs.

The react-based web application consisted of a console that requires authentication through Google Auth. These logs can be updated by authenticated users in the system in real-time according to the assigned permissions levels by the system admins.

At a system level, inventory is dynamically updated with each logged transaction. Custom logic is written to dynamically update transactions with rules specific to product categories as given by Cash Giant, allowing for customizable processing of transactions.

04/13/2023

A manufacturing and marketing company based out of Herndon, VA, was looking for help with Tableau and Salesforce development. On the Tableau side, PMMI needed a heat map developed in Tableau that would give them their customer locations nationally. On the Salesforce side, PMMI needed help with custom field objects being linked to form automation via Pardot.

With the help of HGS, PMMI was able to understand the capabilities and limitations of incorporating Pardot marketing automation into their Salesforce environment, a module they needed insights on. They were also able to build geographical Tableau-based reporting for their senior marketing manager to be able to analyze their customer KPIs by zip code throughout the nation. This data was previously held in an Excel spreadsheet.

03/13/2023

American Marketing & Publishing is a marketing and advertising agency based in Illinois.

The business wanted to move its existing reporting-based SSRS solution to a newly spun-up Tableau reporting environment. In the lift and shift, AMP also wanted to add new logic to the SQL layer regarding new business logic to automate new and existing reporting processes to support their marketing, HR, and sales departments.

AMP also worked on their existing CloseBy PHP-based SMS, email, and IVR application and built new supporting .NET data applications.

Migrating Sales Reporting from SSRS to Tableau:
https://shop.hgs.app/blogs/news/amp-migrates-optima-sales-reporting-from-ssrs-to-tableau

Commissions Process Automation with SQL Server, .NET, and Tableau: https://shop.hgs.app/blogs/news/amp-commissions

03/13/2023

MAK Chemical Inc., a global chemical manufacturing and distribution company was looking to re-design its existing static website to a modern dynamic website that would allow for more functional capabilities and control. The mid-sized business was looking for a solution that could provide company information, a dynamic product catalog, display warehouse location information, a blog engine, and allow prospective clients to contact the company via email.

HGS delivered an angular-based web application hosted on AWS that would allow for MAK Chemical to launch a dynamic web solution. This dynamic site has an admin panel that gives MAK the ability to be able to update its product catalog on the fly, post blogs, and display all of its company information for prospective and existing clients.

The react-based web application consisted of a central console linked to the domain name and an admin console enabled through AWS lambda authentication. This allows site admins to update several back-end site features through a custom, simple, and interactive UI. Each Dynamo table corresponds to site key dynamic site features that allow for the user to update and log daily information for their customers and site audience, including a blog engine and a product catalog. A column-store, NoSQL solution, the Dynamo tables are built for scale and performance, allowing for millions of records and quick database calls.

Visit the site here: http://mak-chemical.homegrown-solutions.com/

Read More: https://shop.hgs.app/blogs/news/mak-chemical-re-designs-and-implements-dynamic-company-website

02/23/2023

Connect Electric is an electric company based out of Richmond, VA. The company is black-owned and works in businesses and 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.

To help Connect Electric achieve its robotic process automation goals, HGS delivered a series of RPA offerings via zaps in Zapier at a fixed price per zap.

These zaps included:
- Automation of appointment messaging for technicians and managers through Service Titan.
- Communication of website form entries from Wix to Service Titan.
- Automation of Service Titan form entries to Slack
- Conditional 48-hour job window slack notifications.

Do you run a service based business and are looking to unify your team?

Interested in building out your CRM or ticketing system to help empower your technicians through a single customized user experience?

Reach out to an HGS representative today! 📱(703)-386-7255 ✉️[email protected]

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...

11/15/2022

WaTech is the state of Washington’s core technology agency that hosts the state’s data center and provides central networking services for the state of Washington.
WaTech had recently moved over to a new Avaya phone messaging system while partnering with Cerium Networks. WaTech identified that they needed reports built on top of the phone messaging system that could be fetched from their hosted database behind the scenes on the Avaya side.

WaTech was looking to configure their Reporting Server and spin up reports needed from their old phone systems on top of their new Avaya phone system by their associated companies for each Washington state agency.

HGS delivered interactive SSRS reports allowing WaTech to run the information they needed for four reports they identified on top of their Avaya phone messaging system. User lists and subscriptions were also set up and tested for delivery from the SSRS administration side.

The core engineer performed this entire SOW over screen share via Team Viewer through live working sessions, bypassing all access needs.

Read the full case study here: https://shop.hgs.app/blogs/news/watech-builds-ssrs-reports-on-avaya-phone-system

08/23/2022

Intrahealth is one of the world's largest global health nonprofits who has worked in over 100 countries since 1979 to help eradicate the world from curable and preventable diseases. By working alongside the CDC to administer vaccines and treatments world wide, Intrahealth is looking to eradicate some of the world’s deadliest diseases over time including HIV.

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.

HGS delivered interactive Power BI dashboards that would allow Intrahealth to measure the vaccination rates across all of their global facilities for all of the testing that they were doing.

The data models for these dashboards were built in Azure Analysis Services on top of the Azure Data Factory pipelines administered by Intrahealth. HGS built C # scripts to automate the population of the metrics built on the Analysis Services hosted TOM data model used for the Power BI reporting. This way no DAX is ever needed to be built by Intrahealth data analysts for their reporting as the new columns and measures are built dynamically every time the C # script is run.

Are you a Microsoft customer looking to modernize your data infrastructure and BI/AI capabilities? Call us today!

Contact us at 📞 (703) 386-7255 or [email protected]

08/19/2022

Jason, is the owner of Transportation Logistics Services (TLS), a major Fortune 5000 logistics company run on McLeod software.

He 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.

With the help of HGS, TLS has been able to use their Power BI dashboards to get real time updates from their SQL Server hosted McLeod software.

This has saved Jason hundreds of hours of manual work being done in Power BI previously to put monthly reports together for his team. Now they get the data in real time everyday on a TV in their office!

And now Jason is a Power BI pro!

08/18/2022

See how we helped Computer Ingenuity Associates implement Power BI embedded reporting for their exisisting .NET based software as a service solution and Microsoft based infrastructure.

The hotel analytics company servicing major hotel branches such as Sonesta leverages Microsoft's technology stack and was looking to maximize their business intelligence capabilities on top of their SQL Server datawarehouse that is used for all of their customers.

Using Row Level Security, Ciasoft was able to create dashboards that render at a customer level for all of their customers inside of their existing .NET application. Now, Ciasoft customers are able to get a BI as a service in addition to the out of the box offerings Ciasoft was already giving them.

https://www.youtube.com/watch?v=UjtvIS4-IMA

Power BI embedded reporting for Ciasfot, a hotel analytics company servicing major hotel branches such as Sonesta leveraging Microsoft technology stack inclu...

07/17/2022

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.

With the help of HGS, Norfolk Public Schools has been able to use the dashboard to efficiently track COVID-19 data for over 5,000 employees. The custom dashboard includes navigation capabilities, allowing users to select which data they would like to view, including employee vaccination status, weekly testing results, and regulation compliance.

All data and visualizations can be filtered by school building. This has allowed the district to seamlessly find out which schools across the county have the highest rates of infection and determine what precautionary quarantine measures need to be taken.

Furthermore, this project involved the migration of the district’s data from Excel to SharePoint. This eliminated the need for an individual to host the spreadsheet locally, increasing reliability and efficiency. With this new technology, Norfolk Public Schools has been able to keep COVID-19 outbreaks under control across the school district.

06/03/2022

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.

To help Connect Electric achieve its robotic process automation goals, HGS delivered a series of RPA offerings all delivered via zaps in Zapier at a fixed price per zap.

These zaps included:

Automated appointment messaging for technicians and managers through Service Titan.
Communicate website form entries from Wix to Service Titan.
Automatically send Service Titan form entries to Slack.
Conditional 48 hour job window slack notifications.

Run a service based business?

See how we can help you achieve your RPA goals to help keep your team connected and workflows autoamted at all times. Empower your front line with technology and automation custom suited for your needs.

Read More:
https://shop.hgs.app/blogs/news/hgs-delivers-zapier-automation-to-unify-service-titan-google-workspace-and-slack

06/01/2022

Intrahealth is one of the world's largest global health nonprofits who has worked in over 100 countries since 1979 to help eradicate the world from curable and preventable diseases. By working alongside the CDC to administer vaccines and treatments world wide, Intrahealth is looking to eradicate some of the world’s deadliest diseases over time including HIV.

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.

HGS delivered interactive Power BI dashboards that would allow Intrahealth to measure the vaccination rates across all of their global facilities for all of the testing that they were doing. Using Azure Data Factory, Azure Analysis Services, and C #, HGS was able to deliver the automated TOM model consumed by the Power BI reports.

Read More:

https://shop.hgs.app/blogs/news/intrahealth-builds-azure-analysis-services-data-models-via-azure-data-factory-for-global-facility-power-bi-immunization-reporting

https://shop.hgs.app/blogs/lms/automating-dax-using-c-to-create-dynamic-metrics-on-tom-power-bi-models-in-visual-studio