I need to create a SharePoint site that is nothing but dashboards, charts, graphs, etc within in it. I have views that I created within SQL to get my data that I need. How can I go about connecting to my views and creating the items listed above in my sharepoint
I see when I create a new SharePoint site\collection, I see an option for a BI site, is that the correct way or can I create a team/blank site and add web parts to it that shows my graphs, grids, dashboards, etc.
What version of sharepoint do you have? 2010 enterprise? There are several different reporting options, and some of them depend on your version of sharepoint.
If you have a cube in SQL, then PerformancePoint dashboards can be created using the dashboard designer. If you have a flat table structure, SQL Server Reporting services is awesome, but you have to install that on the SharePoint server first.
There are many many blogs and help files on Microsoft's site about both of these products.
Here's a page that compares several different BI products: