Welcome aboard Tyler. Passenger88 nice handle… 
Going to direct you to this post first.
Tips for asking question on the forum - Experts’ Corner - Epicor User Help Forum
The Parttran is the table you will want to look at, and the using the field help against the fields in the part tracker may also yield some information to help you with forecasts.
You will want to take a look at the guides of developing BAQs.
There are a few posts on working with Power BI here as well.
Hope the information helps.