Dave Torp Email & Phone Number

Eden Prairie, Minnesota, United States

I create analytical models and dashboards in Power BI and Excel to show service history by machine, customer and territory. The models show details down to the part level which show the frequency of breakdowns and can also help to identify the root causes. I also develop parts analytics summaries to show the parts most often used which can indicate.

Greater Minneapolis-St. Paul Area

I created and developed very sophisticated spreadsheet tools to be used for sales and marketing analytics as well as major projects. Through extensive Microsoft Excel expertise, I showed any desired measures and trends over any time period. The tools that I developed required only a few simple data inputs from the end users and the data sets were easily.

Greater Minneapolis-St. Paul Area

I developed complex financial and sales models as well as dashboards to streamline the analysis of large amounts of data and compress long analytical processes into just a few minutes. I combined Access query functions as well as complicated Excel lookup functions, nested if statements, weighted average formulas, pivot tables, complex conditional.

Arden Hills, MN

I developed analytical tools for use in both the field sales and internal analyst organizations. Data originated from multiple sources such as SAP Business Objects, Rainmaker, large text files and other large Microsoft Excel spreadsheets. I created detailed summaries from large data sets and multiple advanced query functions in Microsoft Access to assist.

I performed in-depth cost and pricing analysis for manufactured plastic films. I did extensive spreadsheet creation and analysis using multiple lookups, references and complex formulas to show costs, margins and opportunities to grow new and existing sales volumes. The databases that I created in Access could extend past millions of rows of data and were.