March 2013
Intermediate to advanced
304 pages
9h
English
book
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
by Isaac Gottlieb
Content preview from Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS), 2nd Edition
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 27
Data Mining Using Pivot Tables
This chapter is about more advanced PivotTable techniques. After you master the basics of the previous chapter, you can explore many more of the PivotTable features in this chapter.
On the Example sheet of the Chapter 27 Excel file, you will see a partial database of 1,000 customers’ purchases. Using this sales report, you can try and detect patterns in the data—mining as it is called—using Excel’s PivotTable report. In doing so, you will master many of the possibilities offered by the PivotTable. Figure 27.1 shows a small section of the database. (The sample data has 1,000 sales records.)
FIGURE 27.1 A Database with 1,000 Customers
As an analyst, you might want to explore relationships between the different variables; for example, between the customers’ attributes and purchases. It may help your marketing and salespeople to identify the type of customers they want to target to increase sales—particularly if you have limited resources, and marketing wants to reach only part of the customer base.
The goal is to try to detect patterns. You can also check the relationship between the number of children and purchases. Try something else: the married/single attribute and purchases. Should marketing target customers with more children? Should they target married or single customers? You can try and find out these relationships using a PivotTable. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.