Sharpoint, add a custom table based on SQL query?

My company uses software that integrates Sharepoint as a main dashboard.  It has standard reporting that is built in but I need to do more advanced custom reporting.  I'm finding out this is a different animal from the sql reports I accustomed to writing.  To do customized web parts in Sharepoint, you apparently have to create cubes, dimensions, etc in SQL Analysis Services just as a starting point.  I'm lost enough with that but I'm not even sure where I go from there.  We are running SQL 2005 and Sharepont 3.0.  
Here is an idea of what I need to do.  The following query is one I would like to add to the Sharepoint site as a table web part.  Does anyone know if this is possible?  Here is the query...

SELECT *, DATEDIFF(DAY, LatestShipDate, GETDATE()) AS [DaysSinceShipment]
FROM (
SELECT  i.ORDER_NO as OrderNumber,
CONVERT(CHAR(10),i.ORDER_DATE,101) as OrderDate,
a.ACCT_NAME as Customer,
i.DOC_ALIAS as DocumentType,
i.CUSTCHAR3 as Project,
i.SALES_REP as Rep_1,
i.CUSTCHAR2 as Rep_2,
(select max(order_date)
  from invoices i2
where i2.ref_no=i.doc_no and i2.status=9) as LatestShipDate
FROM  ADDRESS a, INVOICES i
WHERE  a.ADDR_CODE = i.bill_code
AND i.STATUS=8
AND i.PARTIALLY='T'
AND i.SHIPPED='F'
AND i.DOC_ALIAS not like 'ORDER%'
AND ( select max(order_date)
from invoices i2
where i2.ref_no=i.doc_no and i2.status=9) < GETDATE()-30
) AS derived
ORDER BY [DaysSinceShipment]

If anyone can provide advice or resources to help a newbie learn enough to get started on this,  I would really appreciate it!

Thanks!  Brett
Start Free Trial