Case Studies

  • WaTech Builds SSRS Reports on Avaya Phone System

    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.

  • Power BI Reporting for Operators from Mcleod Software on top of SQL Server

    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.
  • HGS Delivers Zapier Automation to Unify Service Titan, Google Workspace, and Slack

    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.
  • Intrahealth Builds Azure Analysis Services Data Models via Azure Data Factory for Global Facility Power BI Immunization Reporting

    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 County Implements Power BI for COVID-19 Tracking

    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.
  • Commissions Process Automation with SQL Server, .NET, and Tableau

    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.
  • Ciasoft Creates Power BI Dashboards within Legacy .NET Application

    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 Re-designs and Implements Dynamic Company Website

    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.