Categories

Entries for the 'Consulting Services' Category

Custom Data Logging from a Siemens PLC to Microsoft SQL Using VBScript
Alexander Yared

Custom Data Logging from a Siemens PLC to Microsoft SQL Using VBScript

DMC worked on a project where we wanted to log data to a local Microsoft SQL server to be able to save and display it using Microsoft Report Designer. However, the standard format of Siemens’ data log did not match up with the schema we wanted to use in our SQL table. Not all projects require a full PC Station, there is also the option of using a Comfort Panel and logging data as a CSV file to the onboard USB drive or SD card slot. For a walkthrough of that method, visit my colle...

Continue reading →


Creating Multiple Pivot Charts from One Table of Data in Excel
Jamie Handelman

Creating Multiple Pivot Charts from One Table of Data in Excel

Have you ever wanted to create multiple PivotCharts in Excel showing different data from one table? I know I have, plenty of times! This step-by-step tutorial will show you a quick and easy way to create PivotCharts that all refresh, update and filter together. The first thing you'll want to do is open the applicable Excel sheet that you'd like to create PivotCharts in. I created a sample table of data for this tutorial. From this table, I want three different charts s...

Continue reading →


DMC To Lead "Dashboard in a Day" in St. Louis
Rick Rietz

DMC To Lead "Dashboard in a Day" in St. Louis

After leading a Power BI "Dashboard in a Day" Chicago workshop in November and an upcoming Chicago workshop in February, Microsoft has invited DMC to lead a third workshop in St. Louis. On March 27, 2019, Senior Consultant Michael Dannemiller and others from the Digital Workplace Solutions team will lead the Power BI hands-on training workshop at the Microsoft Technology Center in St. Louis from 9 am - 5 pm. The goal of this workshop is to help ...

Continue reading →


DMC to Lead "Dashboard in a Day" for a Second Time
Rick Rietz

DMC to Lead "Dashboard in a Day" for a Second Time

After leading a Power BI "Dashboard in a Day" workshop last November, Microsoft has invited DMC back to lead a second workshop. On February 21, 2019, Senior Consultant Michael Dannemiller will lead the Power BI hands-on training workshop at the Microsoft Technology Center in Chicago from 9 am - 5 pm. Microsoft, in partnership with DMC, is pleased to offer this one-day workshop for a second time covering the capabilities of Power BI. The goal of this workshop is to ...

Continue reading →


DMC Leads "Dashboard in a Day" Workshop at Microsoft
Rick Rietz

DMC Leads "Dashboard in a Day" Workshop at Microsoft

DMC Senior Consultant Michael Dannemiller led a Power BI “Dashboard in a Day” workshop at the Microsoft Technology Center in Chicago earlier this month. The goal of the workshop was to help participants understand how to analyze their data in a rich and compelling way. We started the day off with coffee, breakfast and an introduction to Power BI and the benefits of the platform. Michael gave a high-level overview of the uses of Power BI and the different dashboards participan...

Continue reading →


Announcing the Chicago Women in Technology (WIT) Network and Event
Anjali Bharadwa

Announcing the Chicago Women in Technology (WIT) Network and Event

I am excited to announce the launch of the Chicago WIT Network! WIT (Women in Technology) is a community of professionals across the world that believe in making it easier for women to imagine, begin, and develop a career in IT. There are over 80 chapters in over 40 countries that provide a vast and varied network of events, contacts, and opportunities. As co-chair of the Chicago WIT chapter, I am especially excited to further WIT’s mission: Build a global community of l...

Continue reading →


DMC to Lead "Dashboard in a Day" Workshop at Microsoft
Rick Rietz

DMC to Lead "Dashboard in a Day" Workshop at Microsoft

DMC Senior Consultant Michael Dannemiller will lead a Power BI "Dashboard in a Day" hands-on training workshop at the Microsoft Technology Center in Chicago on Tuesday, November 6 from 9 a.m. to 5 p.m. Microsoft in partnership with DMC, Inc. are pleased to offer this one-day workshop covering the capabilities of Power BI. The goal of this workshop is to help you understand how to analyze your data in a rich and compelling way.  You are enc...

Continue reading →


An Introduction to Power BI's Query Editor
Jason W

An Introduction to Power BI's Query Editor

Power BI is a fantastic tool for creating visually appealing reports to analyze numerous sources of data. Report creation is often as simple as dragging and dropping if the data available is appropriately formatted. However, this is not always the case. Fortunately, Power BI contains a powerful Query Editor that allows you to transform your data into exactly the form you need. Below is a list of features that can make life easier! To access the query editor, navigate to the home tab, and clic...

Continue reading →


Employee Onboarding and Offboarding in SharePoint
Dan Mitchell

Employee Onboarding and Offboarding in SharePoint

In our work with various organizations, DMC’s Digital Workplace Solutions team has found that many organizations have no formal onboarding process in place. Without an organized system, it is easy for key onboarding tasks to fall through the cracks resulting in employees arriving on their first day unable to begin working. Beyond the lost productivity of the new employee, a mismanaged onboarding process can cause frustration across departments, damage the employer’s brand, and hav...

Continue reading →


Inside the New Microsoft 365 Bundle
Jimmy Brady

Inside the New Microsoft 365 Bundle

In previous posts I wrote about different Office 365 bundles as well as ways to purchase Microsoft Office 365 subscriptions directly from a Microsoft partner like DMC. Today, I want to go over Microsoft's newest bundled offering, Microsoft 365. Microsoft Office 365 gives companies the ability to purchase a bundle of Windows 10, Office 365, and the Enterprise Mobility + Security suite, with one per user/per month license. These bundles are geared towards IT departments and business ow...

Continue reading →


Dynamics 365 for Sales Professional
Jimmy Brady

Dynamics 365 for Sales Professional

In my last post I discussed Microsoft's Dynamics 365 for Sales offering. That app was geared towards enterprise-level CRM customers, and while it is significantly cheaper than its main competitor, Salesforce, it is still too expensive for many sales teams in the SMB (Small and Midsized Business) market. Almost two years after the original Sales app was released, Microsoft rolled out the SMB version of their sales app, Dynamics 365 for Sales Professional. The Sales Professional app is...

Continue reading →


5 Ways DMC Engineers Ensure Project Success with Critical Support
Jesse Batsche

5 Ways DMC Engineers Ensure Project Success with Critical Support

To ensure broad-based project success, DMC places a significant focus not only on the technical and engineering aspects of our projects, but also on following well-formulated project communication, management, and quality practices. Thus, as part of DMC’s standard project process, there are many critical supporting services that DMC performs for our clients. Here are five ways DMC ensures the success of projects:  Design Reviews Application Testing and Project Quali...

Continue reading →


DMC Achieves Microsoft's Gold Data Analytics Competency
Rick Rietz

DMC Achieves Microsoft's Gold Data Analytics Competency

DMC is proud to announce that we have earned the Microsoft Gold certified competency for Data Analytics. This certification recognizes DMC for excellence in helping clients gain insight into their data and make predictions and recommendations through the application of Microsoft Power BI and SQL Server technologies. DMC joins an elite tier of Microsoft Partners by adding this Gold competency to our book of six Microsoft certified competencies. Through the Partner Network program, DMC has acce...

Continue reading →


DMC Presents at the 2018 CSIA Executive Conference
Jessica Mlinaric

DMC Presents at the 2018 CSIA Executive Conference

DMC has been attending the annual Control Systems Integrators Association (CSIA) Executive Conference for over a decade. It's a wonderful opportunity to connect with fellow integrators from around the world and share best practices. This year, CSIA set a record of around 600 attendees to the conference! DMC was proud to be part of the record-breaking event by leading two presentations.  The 2018 CSIA Executive Conference took place at the Hyatt Regency in San Fran...

Continue reading →


DMC Travels to Washington and Advocates for Technology Policy Changes
Rick Rietz

DMC Travels to Washington and Advocates for Technology Policy Changes

This Spring, I traveled to Washington DC and met with a congregation of other leaders in the technology industry at the invitation of Microsoft’s advocacy organization, Voices for Innovation. The occasion was an “advocacy blitz” that the group had planned for the following day to inform senators and representatives from all states about issues that directly affect the technology industry. I received an invitation to join the three member delegation from Illinois in DC to adv...

Continue reading →


DMC Joins Salesforce Partner Program
Dan Mitchell

DMC Joins Salesforce Partner Program

DMC is proud to announce that we have joined the Salesforce Partner Program! Rick Rietz, DMC’s Director of Consulting Services, is thrilled about the new partnership.“Our team is very excited about joining the Salesforce partner program, and our clients are too. We’ve been helping clients with Salesforce development for quite some time, but we never marketed our ability to provide these services. With newly acquired access to training that is exclusive to Salesforce par...

Continue reading →


DMC Presented at Beckhoff IoT Seminar
Jessica Mlinaric

DMC Presented at Beckhoff IoT Seminar

DMC, a member of the Beckhoff Integrator Network, led two presentations at Beckhoff's recent IoT Seminar. The event was held at Beckhoff's Chicago Field Office on March 16, 2018. The educational seminar focused on the world of IoT and its opportunities for industrial automation.  Program The program began presentations from Beckhoff breaking down IoT into its basic components and services. Attendees learned how to connect real-world applications, machines a...

Continue reading →


DMC to Host IAMCP Chicagoland Event on April 19
Rick Rietz

DMC to Host IAMCP Chicagoland Event on April 19

DMC Chicago will host area Microsoft Partners at the Chicagoland International Association of Microsoft Channel Partners (IAMCP) April meeting. IAMCP members will gather at DMC on Thursday, April 19 from 3 - 5 p.m. to learn about Microsoft PowerApps and Flow.  Event Information Using Microsoft PowerApps and Flow to Quickly Address Business Process Needs Did you know non-programmers can quickly build line of business solutions to collect data, eliminate manual...

Continue reading →


Onboarding Employees using SharePoint Workflow
Michael Dannemiller

Onboarding Employees using SharePoint Workflow

Click here to see our latest onboarding workflow solution. Here at DMC, we take great pride in our onboarding process for new employees. We love that all new hires feel welcome and hit the ground running their first week. Have you ever arrived at a job and spent the first few days waiting for system access? Or for a manager to figure out what to do with you? That doesn't happen here. But as our company continues to expand the process is becoming difficult to manage. With each new emplo...

Continue reading →


How to Create a SharePoint Online Provider-Hosted App
Curtis Weir

How to Create a SharePoint Online Provider-Hosted App

Provider-hosted apps allow us to run powerful processes and access data externally from SharePoint. This guide is intended to provide a clear, and easy-to-follow process for configuring an application that can utilize data from both SharePoint Online and Microsoft Azure. If you are unfamiliar with the differences between SharePoint-hosted and Provider-hosted add-ins, please read Microsoft's guide on how to choose a development pattern for your add-in. Requirements Microsoft Az...

Continue reading →


Page 1 of 8First   Previous   [1]  2  3  4  5  6  7  8  Next   Last   

Categories