Technology What is a data workbench, and does your organization need one?

01:35  11 june  2021
01:35  11 june  2021 Source:   techrepublic.com

NHL's COVID protocol-related absences for April 17, 2021

  NHL's COVID protocol-related absences for April 17, 2021 Players in the protocol are: Colorado's Bowen Byram, Philipp Grubauer and Joonas Donskoi; Edmonton's Dmitry Kulikov; Los Angeles' Matt Roy; Montreal's Jon Merrill and Erik Gustafsson; Philadelphia's Jackson Cates; Toronto's Nick Foligno, Riley Nash and Ben Hutton; and Vancouver's Nate Schmidt and Jake Virtanen. Read more here.APRIL 15The NHL has confirmed that the Vancouver Canucks will not return to play from their lengthy COVID-19 pause Friday night versus the Edmonton Oilers as originally hoped.

graphical user interface: Image: ZinetroN/Shutterstock © Provided by TechRepublic Image: ZinetroN/Shutterstock

Artificial intelligence and analytics have come a long way in a few short years, but the fact is, the majority of companies still use traditional reporting that derives from legacy systems and no- or low-code report generators. Every two or three years, IT reviews these reports, and the usual outcome is that 80% of reports go unused while 20% see major usage.

SEE: Electronic Data Disposal Policy (TechRepublic Premium)

More about artificial intelligence

  • Why ML, not AI, is the right way forward for data science
  • Coding for robots: Need-to-know languages and skills
  • 40 women leading the way in AI innovation
  • AI on the high seas: Digital transformation is revolutionizing global shipping (free PDF)
graphical user interface, diagram © Image: ZinetroN/Shutterstock

The goal of report reviews is to identify which reports are used and to eliminate the rest; but a more essential exercise in reporting and data is to align both around each company business unit, which would enable IT to better understand business information needs from the eyes of the business.

NHL's COVID protocol-related absences for May 8, 2021

  NHL's COVID protocol-related absences for May 8, 2021 Players in the protocol are: Colorado's Devan Dubnyk and Washington's Evgeny Kuznetsov.Calgary – TBA

Here's how that would work: The customer service department uses standard system reports that show how many service calls it has each month, how long it takes to complete each call and what the service issue was. Customer service also has standard reports that review manpower usage, budget allocations and spend, etc. Customer service uses an AI system to troubleshoot problems in real time in the field, and also an unstructured data repository of searchable product and parts schematics and manuals. For field logistics, the department uses a GIS mapping system that tracks each service vehicle by location.

SEE: How to break down data silos: 4 obstacles and solutions (TechRepublic)

Now this is the IT view: Customer service uses a mix of data and reporting that ranges from standard reports that process structured data in batch to real time and batch AI analytics systems that utilize both structured and unstructured data. This means that a data fabric must be knit that can enable access to structured data from legacy systems and unstructured data from schematics and GIS maps. As systems grow and Internet of Things data capability gets added, IT's job is to position integration so it can be as much plug-and-play as possible. This gives customer service flexible options for adding new systems and eliminates data silos.

Coal miners, crawfish offer, full-capacity Opry: News from around our 50 states

  Coal miners, crawfish offer, full-capacity Opry: News from around our 50 states How the COVID-19 pandemic is affecting every stateStart the day smarter. Get all the news you need in your inbox each morning.

The idea of a departmental data workbench

By understanding all of the data that customer service needs in order to do its job and to assess performance and trends, IT can begin to formulate a data fabric that is malleable, scalable and able to process any kind of data customer service needs. In the process, IT will also identify the systems and applications that customer service uses to process this data. The end result is a departmental "data workbench" that gives IT a holistic understanding of customer service as a business because the workbench aligns and catalogs all of the applications, systems and data that customer service uses.

SEE: Snowflake data warehouse platform: A cheat sheet (free PDF) (TechRepublic)

Why does a data workbench matter?

Approaching each business function with a data workbench approach that holistically integrates all departmental applications, systems and data, gives IT a better understanding of the business and its individual functions. Data and system integration is facilitated, and silos are eliminated.

SEE: 3 steps to build a data fabric to integrate all your data tools (TechRepublic)

To date, few IT organizations use a data workbench approach with their individual user departments, but hopefully more in the future will consider it because of its potential to better align data and applications with the business, diminish standalone and archaic systems and data, and spread business intelligence across the enterprise.

A special grand jury is secretly hearing from witnesses in the Manhattan DA's Trump investigation. Here's how it'll decide whether to bring criminal charges. .
The DA's office is quietly whisking witnesses in front of a "special" grand jury for what may be one of the most pivotal criminal cases in US history.The grand jury is "special" in two ways. It'll be convened for six months, rather than one month, which is standard. It also could be asked to do something no one has ever done before: indict a former president.

usr: 1
This is interesting!