Marketing Analytics: Data-Driven Techniques with Microsoft® Excel®. Published by Microsoft and Excel are registered trademarks of Microsoft Corporation. Helping tech-savvy marketers and data analysts solve real-world business problems with Excel. Using data-driven business analytics to understand customers. Marketing Analytics: Data-Driven Techniques with Microsoft Excel [Wayne L. Winston] on maroc-evasion.info *FREE* shipping on qualifying offers. Helping tech- savvy.
|Language:||English, Spanish, Dutch|
|Genre:||Children & Youth|
|Distribution:||Free* [*Registration needed]|
maroc-evasion.info - download Marketing Analytics: Data-Driven Techniques with Microsoft Excel book online at best prices in India on maroc-evasion.info Read Marketing Analytics . Marketing Analytics: Data-Driven Techniques with Microsoft Excel eBook: Wayne L. Winston: maroc-evasion.info: Kindle Store. Marketing Analytics: Data-Driven Techniques with Microsoft Excel shows business managers and data analysts how to use a relatively simple tool--Excel-- -to.
Winston, this practical resource shows you how to tap a simple and cost-effective tool, Microsoft Excel, to solve specific business problems using powerful analytic techniques—and achieve optimum results.
Improve your marketing results with Microsoft Excel and the invaluable techniques and ideas in Marketing Analytics: Data-Driven Techniques with Microsoft Excel.
View Instructor Companion Site. He has won more than 45 teaching awards at Indiana University. He has also written numerous journal articles and a dozen books, and has developed two online courses for Harvard Business School.
Request permission to reuse content from this site. Undetected country. NO YES.
Marketing Analytics: Selected type: Added to Your Shopping Cart. Evaluation Copy Request an Evaluation Copy. Figure 1. Throughout this section you will learn to analyze this data using Excel PivotTables to answer the following questions:. The first step in creating a PivotTable is ensuring you have headings in the first row of your data.
Notice that Row 7 of the example data in the data worksheet has the headings Product, Month, Store, and Price. Because these are in place, you can begin creating your PivotTable. To do so, perform the following steps:.
If you want a percentage breakdown of the sales by store, you need to change the way Excel displays data in the Values zone. To do this, perform these steps:. You can also use a PivotTable to break down the total revenue by month and calculate the percentage of sales that occur during each month. To accomplish this, perform the following steps:.
Another important part of analyzing data includes determining the revenue generated by each product. To determine this for the example data, perform the following steps:.
You can now see the revenue that each product generated individually. When slicing and dicing data you may encounter a situation in which you want to find which set of products generates a certain percentage of total sales.
The well-known Pareto Hilfe Warenkorb Konto meine eBooks Anmelden. Neuheiten Bestseller Firmenlizenz. Suchen und Finden. Nur ebooks mit Firmenlizenz anzeigen: Infos und Kontakt. Firmenkunden Bibliotheken Buchhandel Verlage.
In this chapter you learn how to use PivotTables to perform the following: Examine sales volume and percentage by store, month and product type. Analyze the influence of weekday, seasonality, and the overall trend on sales at your favorite bakery. Investigate the effect of marketing promotions on sales at your favorite bakery. Determine the influence that demographics such as age, income, gender and geographic location have on the likelihood that a person will subscribe to ESPN: