(414) 530-6438

Our Services

 

Enterprise Resource Planning

We focus our efforts on providing precision machine shops and companies in advanced manufacturing with a custom Enterprise Resource Planning (ERP) system using Airtable.  ERP is a tool for managing information where information management is the organized collection, storage and use of data for the benefit of a company.  Our ERP system consists of (1) designing a database specifically for your company using Airtable, (2) automating routine tasks and (3) integrating Airtable with your current technology.  We will work with you to develop the appropriate strategy for your business.

We create custom databases for our customers using Airtable and leverage the power of Zapier to automate routine tasks.  Zapier also allows our system to communicate with other API friendly applications, including but not limited to Quickbooks, Google Drive, PayPal, Stripe, Microsoft Office 365, Gmail, social media platforms, etc.  The database acts as a central hub to manage job scheduling, workflow, inventory, human resources, customer relationships,  sales & marketing, finances, quality control and machine maintenance.

Database Design Process

1️⃣ Business Analysis & Data Modeling

Airtable is a database and database design requires some expertise.  This process is divided in two steps:

  •  Business Analysis: Understand and analyze your company’s processes and workflow.
  •  Data Modeling: Convert business concepts into a data structure.

Deliverable – Entity Relationship Diagram (ERD), which gives you a visual representation of your data model

2️⃣ Airtable Base Setup & Automation

I will create a new Airtable base from scratch that I will customize to fit your business.

  •  Setup: I create a new Airtable base, set up the tables, views, formulas and blocks.
  •  Automation: I set up the KPIs and automatically populated indicators.

Deliverable  Airtable base customized for your company

3️⃣ Test & Feedback

Iteration of tests, review, feedback and modifications until the system fits your workflow perfectly.

  •  Test: You perform tests on the Airtable base I developed with some dummy data.
  •  Feedbacks: I utilize your feedback and make adjustments to improve the functionality and user experience.

Deliverable Airtable base updated and improved based on your feedback

4️⃣ Integration and Training

This could include importing your data into your base.

  •  Integration: I connect Airtable to other API friendly apps using Zapier.
  •  Training: I setup an initial 2 hour training workshop to demonstrate the functionalities of the base and a 2 hour follow-up session.

Deliverable  Fully integrated Airtable base + 4 hours total training

Features

Enterprise Resource Planning

Database Design

Manage large amounts of data with a database designed specifically for your company.

Dashboard/Block Creation

Let us extend the functionality of your base by using blocks to display and summarize your records.

Automations

Let us build a seamless system between Airtable and your other apps using Zapier.

Integration

We will help integrate our system into your company so you can maximize the benefits of organized data.

Reporting

Receive custom reports (Routing Sheets, First Article Reports, Internal Certs, etc).

Monitoring

Once your automations are set up, we watch and maintain them in optimal condition.

Training

Get your team on board with your new system efficiently through customized training.

Managed Backups

All your data will be safely backed up and delivered to you, without any of the hassle.

Metrics Tracking

Monitor key indicators in your database to enable better decision making.

process

CNC Machining on Demand

Order high quality custom prototypes and end‑production parts online.  We currently focus on CNC machining, but more processes are coming soon.  

request for quote

Start by sending us a solid model and/or print of the part that you would like manufactured.  We will determine the manufacturability of your part.

Quotation Process

You will receive a quote based on the type of material, difficulty of manufacturing the part, number of operations and turnaround time.

Production

Once you’ve placed an order, you’ll always be able to check on its status as it moves through production.
U

Inspection

We conduct a first article inspection on all new parts.  You will receive documentation on your part's dimensions and the process used to check your part.
Z

Delivery

You will be able to track your parts once they are shipped

Specialities

Take your ideas from design to production

Cad/cam

CAD/CAM stands for computer-aided design and computer-aided manufacturing.   CAD/CAM software is used to design and manufacture prototypes, finished products and production runs.  After a part is designed, we specify the types of tools that will be used to make the part and create a g-code program.

CNC Machining

CNC machining is a manufacturing process in which pre-programmed computer software dictates the movement of factory tools and machinery.  We upload g-code programs (created using CAD/CAM software) onto CNC mills and CNC lathes to create parts out of various materials.
Z

Quality Control

Quality control is a system of maintaining standards in manufactured products by testing a sample of the output against specifications.  We employ various measuring instruments (CMM, micrometers, optical comparator, gauge blocks/pins, etc) to verify the accuracy of the parts we make for our customers.

process

CAD Design on Demand

Order an accurate 3D model or an entire assembly that can subsequently be used to manufacture your part(s).

request for quote

Start by telling us what type of part(s) you would like modeled.  

Quotation Process

You will receive a quote based on the number of components to be modeled, difficulty of the design and turnaround time.

Design process

Once you’ve placed an order, you’ll always be able to check on its status as it moves through the design process.
i

Prints

We can also create a 2D print of your 3D model.
Z

Delivery

You will receive the appropriate documents in the file types you request once your design is complete. 

Specialities

Take your ideas from concept to design

3D modeling

3D modeling is the process of developing a mathematical representation of any surface of an object in three dimensions via CAD software.  These models can subsequently be used to manufacture parts using CAM software and CNC machines or 3D printers.

assembly Modeling

Assembly modeling is a technology and method used by computer-aided design and product visualization computer software systems to handle multiple files that represent components within a product. The components within an assembly are represented as solid or surface models.
Z

technical drawings

Technical drawings visually communicate how something functions or is constructed.  Technical drawing is essential for communicating ideas in manufacturing.  Our prints consist of 2D orthogonal projections of the part or component they describe.

From Our Founder

Enterprise Resource Planning for Machine Shops

My name is Jeremy Taylor.  I am the founder and CEO of Defiant CNC.  I am a CNC machinist by trade. I have an intimate understanding of CAD/CAM, CNC machining, g-code, macro programming, setup, 3D machining, fixture design and advanced manufacturing.  This knowledge allows me to provide value to my customers who operate businesses with numerous processes.

I love to figure things out and continuously improve operations, whether it is how to machine a part or the best ways to utilize Airtable and Zapier to optimize a business.

I designed and implemented an Enterprise Resource Planning (ERP) system for our machine shop using Airtable, Zapier and other API friendly apps.  It allows us to organize data and eliminate hours of administrative tasks through automations.  With an optimized Airtable setup; your time, money and focus stay on growing your business.