You work for a consulting company Xaverian Analytics, and have recently been hired to engage on a two week assignment developing a datamart for Ford Canada. The VP of sales at Ford has expressed frustration with the accuracy of her internal reporting and questioned whether the numbers she is seeing are actually true. She has invited your company to create a proof-of-concept data mart that corroborates her data while at the same time, act as a template to follow for future datamarts at Ford Canada. In your first information gathering session, you have collected notes about how the VPs and directors at Ford understand things. This is what you heard:
Trucks are selling more than cars, except for certain types of cars – namely the new Mustang Mach E. It seems customers stopped buying cars because they felt the electric variants were likely to be out soon and it didn’t make sense to buy gas powered. Trucks on the other hand were not anticipated to convert to electric any time soon. Some dealers, especially in eastern regions were able to sell gas variants of cars, but branches found in the more populous cities had more success with electric variants. Each variant (gas/electric) had models that performed well in sales, and others that performed poorly. It seemed to depend on cost-per-kilometer to operate, which was a measure available for each model. Total units sold by branch seemed to surge in the spring and summer, but tended to be weaker in the fall and winter seasons, except October – that was a high selling month. Some dealers were more successful than others, with total revenue sometimes double that of other dealers within the same city. The sales team is interested in knowing what promotions have been successful in the past for each of the models in different cities. The VP of sales wants to know revenue and number of units sold per dealer, per branch, per model, per date. Regions are used to group provinces. Dealers can have multiple branches.
You are reflecting back at this word-soup you just collected, trying to make sense of things.
- Sketch an ER Diagram to help visualize the moving pieces.
- Declare the grain
- Identify Dimensions
- Identify measures
- Sketch a star schema sufficient to address the task at hand.
Order any type of Service We Provide
We are the best assignment service that can satisfy student’s demands in different scientific fields. We perform tasks of any kind. Our specialists provide diverse custom assignment writing services to students from all over the world every day. You can contact us for assistance with:
- Essays of any type (application, scholarship, argumentative, personal, informative, persuasive, compare and contrast, narrative, analytical, cause and effect, critical, process, descriptive, expository essays);
- Homework,
- Assignments,
- Reviews of all types (for a book, an article, or a film),
- Reports,
- Annotated bibliography,
- Projects,
- Thesis,
- Term papers,
- Presentations,
- Lab works,
- Research papers,
- Speeches,
- Critical thinking,
- Capstone projects;
- Business plan;
- Coursework’s;
- Dissertations.
The list is far from complete!
Representatives of our student assignment service are connoisseurs of the peculiarities of presentation in regards to academics. Your college assignment will never turn out an untoward surprise! Whether you need research for high school, an undergraduate program, or a Master’s or Doctoral degree, you will get exactly what you are looking for to sound smart and well-informed.
If you are pressed for time, request our experts!
We are your academic saver. It is a perfect solution for people who need academic help but has no professionals nearby to provide it. Just redirect your home tasks to us and forget about any educational issues. With us, you will get 100% plagiarism-free content delivered on time by an experienced specialist in a particular field.
When you order professional assignments here, you will get:
Original custom papers. We value your academic reputation. Just as well, we value the years of thorough work on our reputation for reliability and never compromise the originality of delivered papers. We will never endanger both. Every custom assignment is written from zero – the only possible first stage of work on the order is research. We apply the latest plagiary checking tools on the final stage, so plagiarism has no chance to emerge in your college assignment writing.
Control over the order completion. To make the process of collaboration comfortable and efficient, we offer our clients to choose the writer themselves taking into account all the requirements and the budget. For you to save nerves, having entrusted your fateful task to some qualified “stranger”, we enable communication with the assigned writer in the process of order completion.
Affordable assistance. We are eager to contribute to the academic achievements of students in need of help with college assignments. We are eager to help you start investing in your career growth today. That is why our service is so affordable. We don’t charge to pay for the latest marketing tricks or advertisements – we choose the best experts in the labor market who write great custom papers in any area, level of complexity, and time frame. Our client’s grateful feedback is a top advertising trick.
On-time delivery. The quality of a paper is only valued when it is delivered within the determined time frame – you will get your custom assignment writing service in time and have a couple of days to revise it and ask for changes in case they are needed. And you will still have time to learn the material.
Protection. We value your trust and take all measures needed to keep your private and banking details safe. We offer only well-tested payment methods. Due to the system of encryption and protected servers, no third party can have access to your data.
Custom support 24/7. We do our best to make the process of collaboration comfortable for the customer. Our “write my assignment” help is always here for you to provide a solution to your problems, give you a prompt answer to any question, and offer clarification as to any issue related to the services. Feel free to contact us anytime!
If you feel that your dissatisfaction with student life is growing every day and you just feel exhausted, don’t hesitate to change the situation for the better today. Order your first assignment from reliable custom assignment services today to evaluate the advantages.
Having seen the difference once, you won’t want to go back to your previous lifestyle. You deserve to find fulfilment in other spheres of your life, have hobbies, spend time with close people but continue making progress. It is possible when you have a professional helper. Don’t put off your life for someday after graduation!