Assignment:
1. Use the ‘Dell Placeholder Mapping’ tab to correctly associate Site and Type as new columns on the ‘Dell Raw Data’ tab. Ultimately you are providing friendly names to otherwise numbered Placeholder ID’s to assist with the analysis.
2. Conduct an analysis with the metrics you have available (clicks, orders, sales) in addition to any calculated metrics that would be important (hint: we spoke about these metrics during our interview).
Please provide top performing days by site and further by type.
Please provide any recommendations or optimizations based upon these findings.
Please provide any charts, diagrams or tables to further aid in your analysis.
Background:
· This is an actual earnings report we receive from Dell, it is our job each day to understand which Sites and within each sites what type of promotions or placements are performing the best or worst. The placeholder mapping is something we’ve assigned based upon the links we want to track and where we are using them. Effectively these placeholders are identified on our side by which site the activity is coming from and where it’s happening so we can inform our team accordingly.
Analytical and performance driven financial professional with diversified experience in financial analysis, projection and investment. Expertise in investment strategies, asset valuation and portfolio management combined with business development. Tapped into market and business trend as well as market analysis. CFA level I candidate with an MBA and MS in Financial Engineering degree
I got my master's degree in biochemistry. I wrote my thesis in word and do my experiments calculation in excel by myself, so I think I am suitable for this type of work and I will achieve it in a short time.
like my everyday work. no Problem, do that sort of stuff every day. give me a Chance to look into dataset and I can tell you definitely the outcome. am experienced in Excel and have MS certifications. I work in Business Administration of a big German company and used to endless lists