Welcome!

@CloudExpo Authors: Yeshim Deniz, Liz McMillan, Pat Romanski, Zakia Bouachraoui, Carmen Gonzalez

Related Topics: @CloudExpo, Microsoft Cloud, Agile Computing

@CloudExpo: Blog Feed Post

Doing BI in the Cloud Using PowerBI for Office 365 | @CloudExpo #Cloud

PowerBI allows the companies to include the cloud as an arena in which they can share and colloborate

Early last year Microsoft announced the general availability (GA) of PowerBI for Office 365. Office is the most used office program and PowerBI brings in great value by providing a self-service means to discover, analyze and visualize data leading to deep insights.

Using PowerBI for Office 365 one can easily deploy a cloud-based BI application for sharing insights; collaborating and accessing reports from practically anywhere.

Power BI for Office includes the following Microsoft 'Power' tools:

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

What are the main capabilities?

PowerBI allows the companies to include the cloud as an arena in which they can share and colloborate. The DataCatalog; Q & A with natural language support; mobile connectivity are unbeatable capabilities.

  • Quickly create collaborative BI sites – enable anyone to quickly create a collaborative BI site to share workbooks containing data and insights.
  • Keep reports up to date with scheduled data refresh – reports that have been saved to the cloud can now connect back to on-premises data sources to refresh the data and stay up to date.
  • Manage data queries for the team – share not only workbooks but also the data queries created in Power Query for Excel. Team members can now build and manage data queries for others to use when creating their own reports.
  • Maintain a Data Catalog of searchable data – IT departments can now use the Data Catalog feature to make it easier for everyone to find and connect to corporate data by searching for it from within Excel.
  • Ask questions of your data in natural language – with the Q&A features people can type questions they have of the data in natural language and the system will interpret the question and present answers in the form of interactive visualizations.
  • Stay connected with mobile access to your reports – stay connected from anywhere with new HTML5 support and the Power BI windows app.

How much does it cost?

First of all you should be Office 365 Enterprise E3 or E4 customers and it was promotional $20 per month per user for the existing customers. Access this link here for reduced new prices.

However you could sign-up for a free-trial of PowerBi for Office 365 here and you will also get a 30 day trial of Office 365 Pro-plus.

I do not have the Enterprise edition but just a $10 month subscription and I get only 'Power Map' add-in in my Office 365's Excel application.I have not figured it out how I may be able to use this without the other tools.

Note: Text in italic taken directly from Microsoft sites.

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.

CloudEXPO Stories
Big Switch's mission is to disrupt the status quo of networking with order of magnitude improvements in network e ciency, intelligence and agility by delivering Next-Generation Data Center Networking. We enable data center transformation and accelerate business velocity by delivering a responsive, automated, and programmable software-dened networking (SDN) fabric-based networking solution. Traditionally, the network has been viewed as the barrier to data center transformation as legacy networking architectures hinder IT organizations with brittle, complex and cumbersome switch-by-switch management paradigms and in exible, proprietary hardware choices that are increasingly unable to keep up with the pace required of businesses today.
Lori MacVittie is a subject matter expert on emerging technology responsible for outbound evangelism across F5's entire product suite. MacVittie has extensive development and technical architecture experience in both high-tech and enterprise organizations, in addition to network and systems administration expertise. Prior to joining F5, MacVittie was an award-winning technology editor at Network Computing Magazine where she evaluated and tested application-focused technologies including app security and encryption-related solutions. She holds a B.S. in Information and Computing Science from the University of Wisconsin at Green Bay, and an M.S. in Computer Science from Nova Southeastern University, and is an O'Reilly author.
Digital Transformation (DX) is a major focus with the introduction of DXWorldEXPO within the program. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throughout enterprises of all sizes. We are offering early bird savings on all ticket types where you can save significant amount of money by purchasing your conference tickets today.
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the technological advances and new business opportunities created by the rapid adoption of containers. With the success of Amazon Web Services (AWS) and various open source technologies used to build private clouds, cloud computing has become an essential component of IT strategy. However, users continue to face challenges in implementing clouds, as older technologies evolve and newer ones like Docker containers gain prominence. He explored these challenges and how to address them, while considering how containers will influence the direction of cloud computing.
Daniel Jones is CTO of EngineerBetter, helping enterprises deliver value faster. Previously he was an IT consultant, indie video games developer, head of web development in the finance sector, and an award-winning martial artist. Continuous Delivery makes it possible to exploit findings of cognitive psychology and neuroscience to increase the productivity and happiness of our teams.