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