I am asked to work on a Dashboard project using Power BI. This will be implemented in Office 365 site. I was unable to find a properly explaining tutorial related to Power BI in office 356. I am having following confusions in Power BI for Office 365.
What is the different between Power BI in Office 365 and MS Office Excel.?
What is the connection betweer Power BI in Office 365 and MS Office Excel.?
Can I create a Power BI report in Office 365 without my locally installed Office Excel?
Is Q & A feature already included in Power BI or is it something else?
Can a Power BI view included in a website component?
What is the different between Excel Web services and Power BI?
Would like know resources for examples of how to ?
Is the following idea correct?
Power BI has the same visualization power as Office Excel Application. We create Visualizations using Power BI in locally using Office Excel and then we upload it to Office 365 and we can Interact with the visualizations as the same in the web?
Is it that everything has to be done in the local Office Excel file noting has to be done in Office 365?
Even though there are data sources configuration for Power BI in Office 365. That is to create Odata?
Thanks in Advance :)
This help document should cover most of these questions: http://office.microsoft.com/en-001/office365-sharepoint-online-enterprise-help/power-bi-getting-started-guide-HA104103589.aspx
In short, Power BI for Excel contains the tools to build and create insights: Power Query to discover and mash up data Power Pivot to create a analytical model Power View to visualize
Power Bi for office 365 is for collaboration and consumption ofe the workbooks created in Excel.
Your assumptions are correct, only change is that for the data sources you can use that to refresh your on premise data.