To best explain what we do, below is a comprehensive “soup to nuts” example of San Diego Data Queen’s Four Step Process.
Imagine, if you will, that the Peanuts® characters participate in a week-long Cookie Box Sales Initiative. Lucy, Chuck, Patty, Franklin, Linus, Sally, Pig Pen, and Schroeder all sell cookie boxes for one week. Customers Snoopy and Woodstock hire San Diego Data Queen to visually present and verbally analyze the results.
Step One is up to the client: submission of Raw Data. That can come in several forms: transmission via email (preferred and the least expensive), handwritten notes, or piles of receipts and files.
Using the Peanuts example, at the end of the week, in Step One, Woodstock elects to tabulate the sales results by hand, then them to San Diego Data Queen:
Next, in Step Two, San Diego Data Queen transforms that raw data into an Excel spreadsheet. We build it to customer specifications, incorporating font and color preferences. For customers Snoopy and Woodstock, we tabulate the data and calculate basic percentages:
In Step Three, we create several charts derived from the data – each illustrating a different perspective:
And finally, in Step Four, San Diego Data Queen prepares a comprehensive analysis and summary complete with recommendations.
You’ll find a complete analysis on our Peanuts Cookie Box Sales page.
Let San Diego Data Queen help you organize, manipulate, display, fix, summarize and analyze your data.