Reference no: EM133229983
You are in charge of the EDM/BI projects for Facebook. As part of your responsibilities, you will use the Internet to find potential vendors offering the products you need. Use the Internet and keyword search vendors that offer analytical database solutions (this is not asking for ETL vendors).
Answer the following:
1. What is an analytical database solution?
2. How is an analytical database solution different from a typical relational database?
3. Give 2 examples of analytical database solutions.
4. Identify 5 vendors that offer analytical database solutions at a large scale. Do not select pure data analytics solutions like Tableau, Power Bi, etc. These are simply analytics and visualization solutions. You should be looking for solutions that allow you to have a read-only subsystem extracted from company warehouse (company data) on specific business metrics, or KPIs, such as sales & inventory, to be used by BI and data scientists for analysis and reporting.
5. Provide a short description of the solution(s) each of the above-chosen vendors offers.
6. Provide a link for each of the solutions.
7. Give a pros/cons analysis of each of the 5 vendors. In addition to descriptive discussion, a comparative table is a great idea here (like what you see from vendors comparing their products with the competition).
8. Provide a simple cost analysis of each of the 5 vendors (i.e., How much will it cost Facebook at this initial phase when you have minimal information? It is difficult to get precise pricing at the inception stage for any project, but you must have an approximate budget to get the ball rolling). It is important to answer this question with the big picture in mind that includes acquisition, deployment, training, ongoing cost, staff required, etc. You may need to look at more or less of this list.
9. What will be the learning curve for each of the 5 vendors as applied to Facebook (i.e., How long, how difficult, etc.)? A comparative table that summarizes your findings may be helpful here as well.
10. Based on your research, which vendor do you pick for Facebook and why?
11. For the vendor you picked, which product(s)/service(s) do you recommend for Facebook? Keep in mind that the selected product(s) must fall under the analytics database solutions.
12. Provide at least 2 visualizations (graphs, charts, pictures, etc. that demonstrate your ideas; quote the sources of your images).