PowerPivot file setup

I have a lot of data I want to work with in PowerPivot 2013.
I'm not sure what approach would be the best to initially pull the data.
I have 3 databases on 2 servers.

Table                company      server      Join      Final join
Sales Header      A      A      1A      Sales Header
Credit Header      A      A      1A      Sales Header
Sales Header      B      A      2A      Sales Header
Credit Header      B      A      2A      Sales Header
Sales Header      C      B      3A      Sales Header
Credit Header      C      B      3A      Sales Header
                        
Sales DETAIL      A      A      1B      Sales Detail
Credit DETAIL      A      A      1B      Sales Detail
Sales DETAIL      B      A      2B      Sales Detail
Credit DETAIL      B      A      2B      Sales Detail
Sales DETAIL      C      B      3B      Sales Detail
Credit DETAIL      C      B      3B      Sales Detail

I need 20-25 fields out of each table where there are 75-100 fields.
The Sales & Credit files need to be combined first to get all sales.
Then those combined for each company.

Should I build views 1st to combine the data in each company on each server?
Or a suggestion?

This is all new and I'm kind of jumping in with both feet, so please excuse if this seems like a simple question to you.