Mohamed Nada
  • Home
  • Blog
  • Resources
    • Pivot Tables e-Book
    • Excel Cheat Sheets
  • About Me
  • Contact
x
Get this eBook for FREE and learn all about Pivot Tables in just one hour!
Picture
Download free ebook

5/29/2017

Analyzing and Visualizing Sales & Marketing Data – Part 2: Setting up and loading data

Comments

Read Now
 
Now we will be doing all of our data analysis and modelling in Power Pivot. 

So first things first. To enable Power Pivot in Excel, go to File -> Options -> Add-ins

In the Manage section at the bottom, choose COM Add-ins -> Go -> and then make sure you select Microsoft Power Pivot for Excel. 
Picture
Picture
Once it’s enabled, you will find it part of the ribbons on the top.
Picture
To open a new Power Pivot window, choose Manage from the Power Pivot ribbon.
 
Once the Power Pivot window is open, you can load data into it from the different sources shown in the “Get External Data” section.
Picture
Now we shall load the sample you downloaded from Part 1
​

First you choose from Database, then from Access.
Picture
Now browse to where you have saved the Access DB file, then click Next.
Picture
Since we are not going to manipulate the data in the Access DB or do any queries to it, we select the first option "Select from a list of tables...", then click next. 
Picture
We select all the tables from the Access DB as shown, and click Finish. Each of these tables contain different kind of information that we will need in our modelling.
Picture
Make sure that all the tables are loaded without failures. 
Picture
Can you see how many rows per table have been loaded? Amazing, right?
 
Once the tables are loaded, you can view them as tables (each table in a separate tab) the same way you view it on Excel. Now skim through each table quickly to understand more about the data it has.
Picture
So now we have seen how to enable PowerPivot in Excel and how to load data into it from an Access Database. Data can come to PowerPivot from many other sources that we will cover in other posts. ​
In the next part, we will look at how to create connections (or relationships) among the loaded tables.

Share

Comments
© 2017 Mohamed Nada. All Rights Reserved.
  • Home
  • Blog
  • Resources
    • Pivot Tables e-Book
    • Excel Cheat Sheets
  • About Me
  • Contact