Exciting new BI features in Excel

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Yesterday during the Microsoft’s Worldwide Partner Conference we announced some exciting new Business Intelligence (BI) features available for Excel. Specifically, we announced the expansion of the BI offerings available as part of Power BI–a cloud-based BI solution that enables our customers to easily gain insights from their data, working within Excel to analyze and visualize the data in a self-service way.

Power BI for Office 365 now includes:

  • Power Query, enabling customers to easily search and access public data and their organization’s data, all within Excel (formerly known as “Data Explorer“).  Download details here
  • Power Map, a 3D data visualization tool for mapping, exploring and interacting with geographic and temporal data (formerly known as product codename “Geoflow“).  Download details here.
  • Power Pivot for creating and customizing flexible data models within Excel. 
  • Power View for creating interactive charts, graphs and other visual representations of data.

Head on over to the Office 365 Technology Blog, Office News Blog, and Power BI site to learn more.

  1. Silly question. These features look great, I am wondering if these features are found in the cloud version as well as the desktop app. I am stuck with XP at work but would love to use these new features, but I would have to use the cloud version. I know that these features along with Access are not found in the Mac desktop version, which is puzzling to me but accepted by the community. If these features are not available in the cloud apps how far away are we (time) from them being available in the cloud?
    Thank you in advance,
    Mike K.

  2. Niraj Jha

    Hello to all,

    I am having a problem which i am unable to resolve. I have an excel sheet which contains images and text (Basically a quiz paper). I have to Read the content of the excel and put it in the database.

    • Loading the text would be drag and drop into Access, but the pictures may not find their way into the DB. Set up an attachment field in the table and manually bring in each picture.

  3. Feeling a bit stupid, but i cant figure out how to re-use the power queries i create, i can only use them in the workbook i create them.

    There has to be a way to re-use the queries i configure ?

Comments are closed.