RSS Feed
March 2009
« Feb   Apr »

Supplier Quality Management Portal

March 31st, 2009 by Pat Rundall in Adapt Data Solutions, EnterpriseWizard

A few questions….

  • Does your company need to track supplier quality?
  • How do you manage supplier quality data? Paper? Excel spreadsheets? Access?
  • What about metrics? Do you have a supplier scorecard? A supplier quality dashboard?
  • Do your suppliers respond quickly to quality issues (corrective action reports, audit findings, etc.)? Do you have to nag them in order to get a response?
  • How much money is wasted in your company chasing supplier quality issues and generating reports?

Imagine a better way to manage supplier quality issues. Imagine a low cost, online system that allowed your suppliers to login and update corrective action reports. Imagine not having to send repeated “nag notices” to suppliers reminding them to follow up on quality issues. Imagine having a powerful supplier quality dashboard that is easily accessed by the people in your company who need it. Imagine the next time an auditor (ISO, etc.) visits your site and compliments your oversight of  supplier quality.

We can help.

If you would like to streamline your supplier quality management system take a few minutes and read this brief PDF on creating a simple web-based supplier quality portal. In just a few days, Adapt Data Solutions can help you use EnterpriseWizard to more effectively manage quality in your supply chain.

Microsoft CRM Dashboards vs EnterpriseWizard

March 13th, 2009 by Pat Rundall in EnterpriseWizard, Microsoft Dynamics

The best charts in the world aren’t useful if they are never used.

Over the years, companies began to shift from being “gut instinct driven” to “data driven”.  With this phenomenon came charts. Lots of charts. More data = more charts.

Good charts are good. Great charts are great. Bad charts waste money – they take time to create, they may lead the organization to making bad decisions,… poorly defined charts are just plain bad news.

CRM and issue tracking dashboard

CRM and issue tracking dashboard

That’s exactly the reason over the past few years, folks from moved away from endless amounts of charts of unknown value to selecting a few really good charts and placing them on a management dashboard.

MS CRM 4.0 Custom Dashboard Creation

The Microsoft team has posted to their blog the steps required to add a dashboard to the Microsoft Dynamics CRM using the Windows Presentation Foundation.  Unless you are a certified MS CRM guru (collecting big $$$ to implement this stuff), you probably won’t bother. The process requires Visual Studio, XAML markups, and lots of custom code that will likely break when a new rev of MS CRM is available. Ug.

CRM and Issue Tracking Dashboards in EnterpriseWizard

OK, the Microsoft CRM solution is not for the faint of heart. Sure, you can build a CRM dashboard with it – but, really, would you?

In EnterpriseWizard, dashboards are much easier to create and maintain. Let’s go through the process:

Step 1: Create some CRM and Issue tracking charts

Let’s say that we want a 4 part dashboard that appears once users login to the CRM and Issue Tracking system. In this case, our system is a CRM and Tech Support portal for a fortune 100 client. This customer wants custom dashboard to track:

  • Number of tech support issues reopened by customers segmented by the assigned support staff
  • Sales quote funnel status showing Quotes Prepared; Sent to Customer; Signed and Accepted
  • Customer support cases segmented by Issue and Priority
  • A Google Widget – (what’s wrong with a little fun on a CRM & issue tracker dashboard?)

So, we create our charts using EnterpriseWizard. No custom code involved – just walk through the wizard to define the data to be presented.

CRM chart creation for dashboard

CRM chart creation for dashboard

Simply walk through the steps to create your charts. For the first, we want to add a technical support chart to the dashboard. So, open your Support Cases chart wizard, choose “New“, name your chart, choose your output (Graphical, Excel, etc.) then hit Next.  On the next screen, pick “Standard Chart” and then hit Next again to choose your chart type (in this case, we want a column bar chart).

CRM chart creation

Select your chart type

Select your data fields to be presented, setup filtering (if necessary) to restrict the data presented on your chart (for example, only show records from the past 3 months), formatting (3D, legend info, …) and so on. Keep walking through each step of the chart setup wizard to create your tech support chart. You’ll be done creating your chart in a few minutes. Really.

Step 2: Setup your CRM – Issue Tracker Dashboard

OK, now that you’ve created some great charts, it’s time to place them on your dashboard. Just click on the Home link in the left panel.

dashboard creation

Dashboard creation in EnterpriseWizard

Your dashboard will appear. Next, edit your dashboard. Then add some charts and a widget to the dashboard by simply clicking New and using the wizard to choose the appropriate table (Support Cases) and the charts associated with that table.

Once you’ve added some widgets to your dashboard, simply select the widgets you would like to display. Then choose the Layout tab to place them on the dashboard using the drag and drop dashboard layout editor.

You can see that the dashboard layout editor allows you to choose the number of rows, columns and placement of each widget. No custom code. Adding a Google widget to the dashboard is just as easy.

CRM/issue tracker dashboard layout

CRM/issue tracker dashboard layout

Finally, Click Finish and enjoy your custom CRM/issue tracking dashboard.  Note: your dashboard can be configured to refresh as often as you wish and includes the ability to easily “drill down” into the data (click the chart to pull up an Excel spreadsheet to dive into the Quotes Sent to Customer data for example).

Cool, huh?