Categories

All

Services

Industries

SQL Server BI

Page 1 of 1First   Previous   Next   Last   

Power BI Reporting Using Zoho, Quickbooks, and FunctionPoint

Posted in Business Intelligence, Microsoft Consulting Services, Office 365 Power BI, SQL Server BI

DMC brought together data from three separate and disparate systems to provide a single dataset within Power BI to automate repetitive manual processes and create up-to-date dashboarding for a full-service advertising agency.

Continue reading →

Factory-wide MES Data Collection System

Posted in Business Intelligence, Custom Software and Hardware Development, Food and Beverage, Manufacturing Automation and Intelligence, Manufacturing Execution Systems, Microsoft Consulting Services, SQL Server BI

DMC implemented an extensive data collection system for a client in the confectionary industry. The resulting system allows the client a closer lens into their processes with automated data aggregation.  

Continue reading →

FactoryTalk Metrics OEE Reporting and Production Monitoring

Posted in Allen Bradley PLC Programming, Automotive, Business Intelligence, HMI and SCADA Systems, Manufacturing Automation and Intelligence, Manufacturing Execution Systems, Microsoft Consulting Services, PLC Programming, Rockwell FactoryTalk, SQL Server BI

DMC implemented a Rockwell FactoryTalk Metrics production monitoring and reporting system for an automotive supplier. FactoryTalk Metrics was configured to interface with the Allen-Bradley PLCs that control their production lines. DMC used SQL Server and SQL Server Reporting Services (SSRS) to customize data collections and reporting to fit the client challenges and needs. The end solution included real-time emailing of reports to key personnel.

Continue reading →

Turnkey Solution for Food and Beverage Product Testing

Posted in Automated Test Stand Design, Business Intelligence, Data Analysis, Data Mining, and Reporting, Food and Beverage, LabVIEW Programming, Microsoft Consulting Services, SQL Server BI, Test and Measurement, Test and Measurement Automation

DMC designed and developed a custom test station and software for a beverage carbonator line to check for pressure leaks. The client needed a pressure decay test for a sub-assembly valve manifold in a restaurant-grade consumer appliance. DMC worked with the client to replicate and improve upon the manual test procedure, including interactive control and retesting ability. The product delivered was a complete, custom turn-key solution, involving mechanical, electrical and software engineering. Pressure...

Continue reading →

End of Line Test Station for Beverage Dispensing Valves

Posted in Automated Test Stand Design, Business Intelligence, Consumer Goods, Data Analysis, Data Mining, and Reporting, Food and Beverage, LabVIEW Programming, Microsoft Consulting Services, SQL Server BI, Test and Measurement, Test and Measurement Automation

DMC supplied a fully automated end-of-line tester for high-end beverage dispensing valves. The system tests and calibrates each valve to ensure that it meets the client's stringent manufacturing standards. The test stand supplies varying pressure water to the valve throughout the test to simulate different real-world conditions. During each phase of the test, extremely accurate coriolis flowmeters within the test stand continuously monitor the flowrate through each section of the valve to...

Continue reading →

Automated Hipot Test Station for Beverage Machine Manufacturer

Posted in Business Intelligence, Food and Beverage, LabVIEW Programming, Manufacturing Automation and Intelligence, Microsoft Consulting Services, SQL Server BI, Test and Measurement, Test and Measurement Automation

DMC developed an automated Hipot (High Potential) test station for a beverage machine manufacturer. The system is used to verify proper electrical grounding and isolation in the chassis of the beverage dispensing machine.

Continue reading →

Page 1 of 1First   Previous   Next   Last   

Categories

All

Services

Industries