Marketing Analytics: Data-Driven Techniques with Microsoft by Wayne L. Winston

By Wayne L. Winston

Supporting tech-savvy agents and knowledge analysts resolve real-world enterprise issues of Excel

Using data-driven company analytics to appreciate buyers and increase effects is a brilliant notion in conception, yet in today's busy workplaces, dealers and analysts desire easy, reasonably cheap how you can approach and utilize all that facts. This professional e-book bargains the proper resolution. Written via information research professional Wayne L. Winston, this useful source indicates you the way to faucet an easy and reasonable software, Microsoft Excel, to unravel particular company difficulties utilizing robust analytic techniques—and in attaining optimal results.

Practical workouts in every one bankruptcy assist you follow and make stronger recommendations as you learn.

Shows you the way to accomplish subtle company analyses utilizing the reasonable and greatly to be had Microsoft Excel rather than dear, proprietary analytical tools
Reveals easy methods to aim and preserve ecocnomic buyers and steer clear of high-risk customers
Helps you forecast revenues and increase reaction charges for advertising campaigns
Explores how one can optimize cost issues for services, optimize shop layouts, and enhance on-line advertising
Covers social media, viral advertising and marketing, and the way to take advantage of either effectively
Improve your advertising effects with Microsoft Excel and the helpful options and ideas in advertising Analytics: Data-Driven suggestions with Microsoft Excel.

Show description

By Wayne L. Winston

Supporting tech-savvy agents and knowledge analysts resolve real-world enterprise issues of Excel

Using data-driven company analytics to appreciate buyers and increase effects is a brilliant notion in conception, yet in today's busy workplaces, dealers and analysts desire easy, reasonably cheap how you can approach and utilize all that facts. This professional e-book bargains the proper resolution. Written via information research professional Wayne L. Winston, this useful source indicates you the way to faucet an easy and reasonable software, Microsoft Excel, to unravel particular company difficulties utilizing robust analytic techniques—and in attaining optimal results.

Practical workouts in every one bankruptcy assist you follow and make stronger recommendations as you learn.

Shows you the way to accomplish subtle company analyses utilizing the reasonable and greatly to be had Microsoft Excel rather than dear, proprietary analytical tools
Reveals easy methods to aim and preserve ecocnomic buyers and steer clear of high-risk customers
Helps you forecast revenues and increase reaction charges for advertising campaigns
Explores how one can optimize cost issues for services, optimize shop layouts, and enhance on-line advertising
Covers social media, viral advertising and marketing, and the way to take advantage of either effectively
Improve your advertising effects with Microsoft Excel and the helpful options and ideas in advertising Analytics: Data-Driven suggestions with Microsoft Excel.

Show description

Read Online or Download Marketing Analytics: Data-Driven Techniques with Microsoft Excel PDF

Similar marketing books

The Religious Dimensions of Advertising (Religion Culture Critique)

This groundbreaking paintings explores media pupil Sut Jhally's thesis that advertisements services as a faith in past due capitalism and relates this to serious theological stories. Sheffield argues that ads isn't itself a faith, yet that it comprises spiritual dimensions--analogous to Durkheim's description of gadgets as totems.

TechnoLeverage: Using the Power of Technology to Outperform the Competition

TECHNOLEVERAGE utilizing the facility of know-how to Outperform the contest "Respond to consumers. " "Cut bills to the bone. " those are established enterprise strategies. yet advisor Michael Hruby has visible that obtaining expertise "under your small business" will do way more to spice up revenues, elevate earnings, and maintain you aggressive.

PRICING INTELLIGENCE 2.0: A Brief Guide to Price Intelligence and Dynamic Pricing

In an period of knowledge transparency and the empowered patron, the way you cost your product can make or holiday your online business. expense too excessive and you’ll most likely lose to the contest. fee too low and you’ll degrade the worth of your items and companies. expense most excellent, and you’ve placed your self in leading place to win the sale.

Extra info for Marketing Analytics: Data-Driven Techniques with Microsoft Excel

Sample text

Crosstabs analyses are also useful to determine where firms should not make investments. For instance, there are hardly any subscribers to ESPN: The Magazine that are 78 or older, or with household incomes above $229,000, so placing ads on TV shows that are heavily watched by wealthy retiree is not recommended. Figure 1-27: Crosstabs Analysis of subscribers Pulling Data from a PivotTable with the GETPIVOTDATA Function Often a marketing analyst wants to pull data from a PivotTable to use as source information for a chart or other analyses.

If you find an error in this book, like a spelling mistake or a calculation error, we would be very grateful for your feedback. By sending in errata you may save another reader hours of frustration and at the same time you will be helping us provide even higher quality information. com and complete the form on the Ask a Question tab there to send us the error you have found. indd 12/11/13 Page xxix xxix xxx Marketing Analytics the information and, if appropriate, post a message to the book’s errata page and fix the problem in subsequent editions of the book.

Put your cursor inside the data from the data worksheet and drag the Location field to the Column Labels zone and Value zone. 2. Apply Value Field Settings and choose Show Value As ➢ % of Row Total to obtain the PivotTable, as shown in the Location worksheet and Figure 1-26. You find that 46 percent of subscribers live in the suburbs; 40 percent live in urban areas and 15 percent live in rural areas. indd 12/12/13 Page 24 Slicing and Dicing Marketing Data with PivotTables Constructing a Crosstabs Analysis of Age and Income Often marketers break down customer demographics simultaneously on two attributes.

Download PDF sample

Rated 4.67 of 5 – based on 12 votes