Entries for the 'Business Intelligence' Category

DMC recently upgraded our Silver Cloud Productivity competency to Microsoft Gold for Cloud Productivity! This certification recognizes DMC for its expertise and experience helping clients deploy Microsoft cloud and hybrid solutions. Hybrid solutions rely on a combination of cloud and existing investments in on-premises resources.  This Microsoft Gold level certification makes DMC eligible for exclusive training opportunities that further the implementat...

Continue reading →

DMC is hosting a Power BI, Azure, and Azure IoT event that includes a hands-on BI workshop and IoT demonstration on Tuesday, May 10th (8:30 a.m. –12:00 p.m. CDT) at DMC Chicago (2222 N. Elston Ave., Ste. 200). Participants will learn how to take advantage of these offerings to improve business operations. Event Overview This event is ideal for business, engineering and IT leaders. You will walk away with a practical understanding of how these technologies work and...

Continue reading →

DMC has joined Microsoft’s Power BI Red Carpet Partner Program. DMC was selected by Microsoft to join the program based on our demonstrated proficiency in developing and implementing Power BI solutions for our customers. This recognition of our expertise with Power BI comes right on the heels of our selection to join the Azure IoT Red Carpet Partner Program last month. By joining this network of Microsoft Partners, DMC will be identified as a specialized provider of Power BI solutions. ...

Continue reading →

DMC is proud to announce that it has achieved Microsoft’s Silver Partner Status for Business Intelligence (BI) solutions. This achievement recognizes DMC’s proven ability to help customers monitor, analyze and plan business performance based on actionable business insight. DMC’s BI service offerings are geared towards helping clients identify and define high-level Key Performance Indicators (KPIs), design visually appealing dashboards, and complete technical data integration.&n...

Continue reading →

Reporting is almost a universal requirement for new projects coming into DMC these days. As part of an HMI we developed for a customer we also installed SQL Server Reporting Services (SSRS) on a Siemens PLC. This is used to generate reports for production batches run on that PLC. The customer desired these reports to be in PDF format, which after some investigation was easy to do with SSRS. A little background on SSRS... SSRS is a web application that generates nice graphical reports from SQL...

Continue reading →

Recently I worked on a project where I needed to import test data from a chemical process contained in text files into a MS SQL Server database. I was about to start a C# .NET project to do this task, but I thought there has to be a quicker and easier way to do this. That is how I stumbled upon SQL Server Integration Services (SSIS). SSIS can do exactly what I needed. This tool is a component included in all versions of Microsoft SQL Server 2005 (except Express and Workgroup) that can handle dat...

Continue reading →

In the past, DMC has used MS SQL Server Reporting Service (SSRS) on multiple projects as a web-based reporting engine. I personally liked using SSRS a lot because it allowed us to design quite complicated reports in very little time. At the same time, I wished it were possible to edit data viewed in the report, such as editing row comments. While it wasn’t possible to edit report data using the standard set of SSRS features, our team was able to find a way around this by creating a cust...

Continue reading →