2173 Salk Avenue, Suite 250 Carlsbad, CA

support@assignmentprep.info

How many individual sales were there?

June 17, 2021
Christopher R. Teeple

Project: Sales Data AnalyzerDescription: This project is similar to the Analyze Music Playlist Challenge you completed in module 12. You should use the module 12 challenge for reference as you work through completing this project.For this final project you are to create a C#/.NET console application that analyzes sales data contained in a comma-delimited data file and generates a report that answers a set of provided questions that is saved in a text file. The path to the music sales data file and the path to the report text file are provided to the program as command line arguments. If the user runs the program without supplying the arguments, they are to be provided with the syntax for running the program. All exceptions and errors are to be appropriately handled by giving the user feedback and exiting the program. Under no circumstances is the program to crash.Purpose: This project evaluates your ability to create a C#/.NET console application that accepts command line arguments, reads and parses tab-delimited data, creates data structures, queries data using LINQ, writes a report to a text file, and handles exceptions/errors.Project Name: SalesDataAnalyzerTarget Platform: ConsoleDevelopment Platform: .NET CoreProgramming Language: C#The program is to receive the path to a comma-delimited data file containing slaes information as a command line argument. If the comma-delimited data file is in the same directory as the program, then the user can just supply the name of the file as the path.The records in the comma-delimited data file are to be read by the program and placed in a collection of structured data. Then, Language Integrated Query (LINQ) along with general C# code is to be used to determine the answers to a set of questions and a report is to be generated in a text file that is saved. The path of the report file is also to be supplied as a command line argument. If the path of the report file is just the name of the file, then it will be saved in the current directory.When the application is being run, tested, and debugged in Visual Studio Code, place the salesData.csv file in the same directory as the SalesDataAnalyzer.csproj and Program.cs files. When the program runs from within Visual Studio Code from the Terminal, the project directory is the current directory and where salesData.csv is found, if the name of the file is supplied as the path.Sales Data Comma-Delimited Data FileThe data in this file was collected from major online retail sellers.The first line of the data file is comprised of the headers that identify the columnsInvoiceNo,StockCode,Description,Quantity,InvoiceDate,UnitPrice,CustomerID,CountryYou can inspect the data file using a plain text editor. Use the headers to identify the meaning of the data. When your program reads the file, the first line needs to be skipped since it doesn’t contain data. When a line is read from the file, it can be split on the comma so that the pieces of data are put in an array. The order of the data elements in the array will be the same order as they are listed in a record in a line.Handle ErrorsA well-written program should not crash regardless of the input or data provided to it. You are to handle all exceptions and error conditions that arise when the program is run. If an exception or error occurs, it is to be reported to the user and the program is to exit.If the user runs the program without providing the two command line parameters, then the program is to display a message to the user indicating how the program is to be run.SalesDataAnalyzer The following are some of the errors that could occur that need to be handled. Note, there is no implication that these are all the possible errors. They are being provided to give you a sense of error conditions that could arise that need to be handled.Sales data data file can’t be opened.
Error occurs reading lines from sales data file.
Record doesn’t contain the correct number of data elements.
Record contains data that is not of the right type. Note: Some data elements are strings and some are integers.
Report file can’t be opened or written to.
When you display an error message to the user, be as specific as possible about the problem and where it occurred. For example, if a record is malformed the line number of the record in the file should be included in the message to the user along with any other info that could be helpful in finding and correcting the problem.The following is an example of an error message to the user when the wrong number of values is encountered in a record.$”Row {lineNumber} contains {values.Length} values. It should contain {NumItemsInRow}.”QuestionsList all the items sold to customers in Australia (stockCode and Description).
How many individual sales were there? To determine this you have to count the unique invoice numbers. You should group by invoice number?
What is the sales total for invoice number 536365? Sales total for an invoice will be the sum of (Quantity * UnitPrice) for all products sold in the invoice.
List the total sales by country?
Which customer has spent the most money during the period?
What are the total sales to customer 15311?
How many units of “HAND WARMER UNION JACK” were sold in the dataset?
What was the total value of the “HAND WARMER UNION JACK” sales in the dataset?
Which product has the highest UnitPrice (stockCode and Description).?
What is the total sales for the entire dataset?
Which invoice number had the highest sales?
Which product sold the most units?

Struggling With a Similar Paper? Get Reliable Help Now.

Delivered on time. Plagiarism-free. Good Grades.

What is this?

It’s a homework service designed by a team of 23 writers based in Carlsbad, CA with one specific goal – to help students just like you complete their assignments on time and get good grades!

Why do you do it?

Because getting a degree is hard these days! With many students being forced to juggle between demanding careers, family life and a rigorous academic schedule. Having a helping hand from time to time goes a long way in making sure you get to the finish line with your sanity intact!

How does it work?

You have an assignment you need help with. Instead of struggling on this alone, you give us your assignment instructions, we select a team of 2 writers to work on your paper, after it’s done we send it to you via email.

What kind of writer will work on my paper?

Our support team will assign your paper to a team of 2 writers with a background in your degree – For example, if you have a nursing paper we will select a team with a nursing background. The main writer will handle the research and writing part while the second writer will proof the paper for grammar, formatting & referencing mistakes if any.

Our team is comprised of native English speakers working exclusively from the United States. 

Will the paper be original?

Yes! It will be just as if you wrote the paper yourself! Completely original, written from your scratch following your specific instructions.

Is it free?

No, it’s a paid service. You pay for someone to work on your assignment for you.

Is it legit? Can I trust you?

Completely legit, backed by an iron-clad money back guarantee. We’ve been doing this since 2007 – helping students like you get through college.

Will you deliver it on time?

Absolutely! We understand you have a really tight deadline and you need this delivered a few hours before your deadline so you can look at it before turning it in.

Can you get me a good grade? It’s my final project and I need a good grade.

Yes! We only pick projects where we are sure we’ll deliver good grades.

What do you need to get started on my paper?

* The full assignment instructions as they appear on your school account.

* If a Grading Rubric is present, make sure to attach it.

* Include any special announcements or emails you might have gotten from your Professor pertaining to this assignment.

* Any templates or additional files required to complete the assignment.

How do I place an order?

You can do so through our custom order page here or you can talk to our live chat team and they’ll guide you on how to do this.

How will I receive my paper?

We will send it to your email. Please make sure to provide us with your best email – we’ll be using this to communicate to you throughout the whole process.

Getting Your Paper Today is as Simple as ABC

No more missed deadlines! No more late points deductions!

}

You give us your assignments instructions via email or through our order page.

Our support team selects a qualified writing team of 2 writers for you.

l

In under 5 minutes after you place your order, research & writing begins.

Complete paper is delivered to your email before your deadline is up.

Want A Good Grade?

Get a professional writer who has worked on a similar assignment to do this paper for you