Case Studies

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