Microsoft Power BI Launched – Bring Your Data to Life

Atidan is pleased to be a part of the business intelligence revolution – for over ten years we have worked with powerful visualization tools starting with the early versions of SQL Server and many third party tools. Now, it is even easier than ever to collect data from almost ‘anywhere’, create ‘stories’ from your data, create insights with simple drag-and-drop gestures, and share your dashboards and metrics internally and externally. Contact us today to see the latest release of Microsoft Power BI.
Microsoft Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. There are two experiences now available for Power BI: the new experience, generally referred to as Power BI, and the previous experience which is referred to as Power BI for Office 365.Power BI

The new experience is centered on PowerBI.com, an online service where you can quickly create dashboards, share reports, and directly connect to (and incorporate) all the data that’s important to you. The new experience also introduces the Power BI Desktop, a dedicated report authoring tool that enables you to transform data, create powerful reports and visualizations, and easily publish to Power BI. The new experience extends to all your mobile devices, too.

Note   If you were using the previous experience and want to migrate to the new experience, you can download this migration guide to understand and prepare for the migration process.

The following sections provide an overview of the new experience, along with introductions and links to learn more about the details and capabilities of each offering.

Power BI – the new experience

In the new experience, Power BI displays dashboards on the Power BI service that are interactive, and can be created and updated from many different data sources. Three elements are primary to the new experience:

In the new experience, you create dashboards that keep you informed about what’s most important about your business. Just like a dashboard in your car displays important information about your vehicle, such as its speed, its fuel level, or how healthy the engine is, dashboard in Power BI display important information about your business.

Dashboard in Power BIIn Power BI, dashboards display tiles that represent important information about your business. Tiles are based on reports (just like gauges are based on vehicle data from the engine, the fuel tank, or the battery). You can select a tile to explore more information from the underlying report.

Power BI - dashboard to reportThe new experience also introduces a dedicated report authoring tool:

With Power BI Desktop, you get a powerful and dedicated report authoring tool that enables you to connect to and combine data from lots of different sources, using Power BI Desktop’s Query Editor. From the datasets you build with Query Editor you can create rich reports and visualization within Power BI Desktop. And when you’re done, publishing to the Power BI service is easy.

Power BI DesktopThere’s a lot more to learn about the new experience, and plenty of content to help you . The following links provide information about the new experience, and start with overview information (to get your familiar, oriented, and comfortable) then move into specifics. A separate section is dedicated to the Power BI Desktop, and those links also go from overview to specifics.

Getting Started – the new experience

The following links provide guidance on the new experience in Power BI.

Using Power BI Desktop

The following links start with an overview of Power BI Desktop, then describe common tasks and capabilities that Power BI Desktop provides.

Microsoft Power BI Business Intelligence for Office 365 – 40% Subscription Discount Offer

Microsoft’s Power BI or Business Intelligence for Office 365 is now out of Alpha testing and for subscribers of Office 365, we are offering subscriptions at 40% off until June 30, 2014 for E3/E4 subscribers.  Contact Atidan for demonstration, demo accounts and additional information.  Text below is copied from Microsoft http://www.microsoft.com/en-us/powerBI/default.aspx#fbid=gzgsPZaTNLd 

Power BI consists of the following features and services:

Excel Features

  • Power Query – easily discover and connect to data from public and corporate data sources
  • Power Pivot – create a sophisticated Data Model directly in Excel
  • Power View – create reports and analytical views with interactive data visualizations
  • Power Map – explore and navigate geospatial data on a 3D map experience in Excel

Power BI for Office 365

  • Power BI Sites – share, view, and interact with reports in these collaborative Power BI sites
  • Power BI Q&A – use natural language queries to find, explore, and report over your data
  • Query and Data Management – share and manage queries and data sources, and view query usage analytics
  • Power BI Windows Store App – view reports on the go, with the Power BI app

IT Infrastructure Services for Power BI

  • Provision Power BI for Office 365 – create a tenant, and get Power BI for your organization
  • Power BI Admin Center – manage your organization’s Power BI infrastructure from a site
  • Data Management Gateway – connect on-premises data to the cloud, seamlessly and securely

 

 
Choose the right option based on what you already own:
 
If you own a subscription to Office 365 E3 or E4 plans you have access to SharePoint Online Plan 2 and Excel and require the following additional components:
If you subscribe to Office 365 ProPlus, or own a license of Office 2013 Professional Plus, you require the following additional components:
If you do not currently have access to SharePoint Online Plan 2 and the latest version of Excel you will need the following:
 

Power BI

Add-on for E3/E4 Subscribers

Power BI

Standalone

Power BI

Standalone + Office 365 ProPlus

Price

$33 $20* user/month

(billed annually $396 $240/year)

Preview Sign up

$40 user/month

(billed annually $480/year)

Preview Sign up

$52 user/month

(billed annually $624/year)

Preview Sign up

Power BI Office 365
BI Sites
Scheduled Data Refresh
Enterprise Data Search
Data Stewardship
Mobile BI
SharePoint Online Plan 2  
Excel      
Data Discovery & Access    
Data Modeling    
Data Visualization    

* 40% off promotion for Office 365 E3 or E4 customers. Offered through June 30 2014. Pricing Shown is US Commercial ERP through the Microsoft Online Subscription Program

 

Updates to Power BI for Office 365 – From Microsoft BI Team Blog

One Step Closer to Simplifying Data Analysis and Visualization, New Features Added to Power BI for Office 365 and Power Query Add-in for Excel Preview

13 Dec 2013 9:00 AM

Today we’re pleased to announce the addition of significant new features to both the Power BI for Office 365 and the Power Query add-in for Excel previews. Introduced in July and currently in preview, Power BI for Office 365 is a cloud based solution that reduces the barriers to deploying a self-service Business Intelligence environment for sharing live Excel based reports and data queries as well as new features that enable data discovery and information access from anywhere and from any device.

One of the Power BI features users have been most interested in is Q&A, which takes data exploration to a whole new level. With Q&A, users type ad-hoc questions and the system provides them with answers in the form of interactive charts and graphs.  The search like experience is instantaneous and uses natural language query, interpreting the semantics of question the user is typing. We’ve received great responses from customers who have tested this capability on the preview sample data. Today we enable the ability to explore your own data with Q&A. You can add your own models to Q&A and begin to explore them with natural language query.  

Try Q&A today by uploading your workbook to your Power BI Site. Do this by clicking on the add link and selecting “Upload file”. This will upload and enable your workbook for use in the Power BI site. 

 

After your workbook has been enabled, click on the three dots on the thumbnail for your workbook and select “Add to Q&A”: 

 

One you’ve completed these steps you can navigate to the Q&A question by clicking the “Search with Power BI Q&A” link in the upper right hand corner of your Power BI site: 

 

Also, keeping in line with our goal to make Excel the only tool you need for data analysis and visualization, we are also excited to announce updates to the Power Query add-in for Excel preview, introducing new data source support and usability enhancements.

Connectivity to New Data Sources

  • Exchange: We add support for connecting to your Microsoft Exchange account and retrieving information about your Mail, Calendar, People, Tasks and Meeting Requests.
  • Dynamics CRM Online: We enhance Power Query’s OData support to consume OData feeds from Dynamics CRM Online.
  • JSON light support: We enabled consumption of JSON light OData feeds via the “From OData” experience.
  • Sybase IQ: We add Sybase IQ to our list of supported databases.

Below is an example of a simple visualization created by connecting to your exchange account.

  

Automatic Detection of table relationships:

  • Last month we improved how you connect to databases by providing navigation to the list of databases and tables and providing import of multiple tables. This month we add relationship detection between these tables automatically creating the relationships in the model for you.

 Transformations in the Query Editor:

  • New additions to the Query Editor ribbon include:
    • Number Transformations: If you have used the “Transform” menu in the ribbon or context menus, you will have noticed transformations for Text and Date/Time/Timezone columns. In this update, we have added new transformations that can be applied to Number columns.
    • Fill Down: You can now use the “Fill Down” button in the ribbon to fill values down within the selected column(s), filling empty cells in the column with the value of the first non-empty cell above them.
    • Sort Ascending/Descending: Easily define a sort criteria for selected column(s) by using Sort Ascending/Descending buttons in the ribbon.

 

Improvements to Search:

  • Search for Certified results: Last month we introduced Certified Shared Queries. We now add an option to the Search ribbon to allow you to narrow your search to only certified results if you choose.
  • Enabling copy of Name and Description on Search results: We thank you for your preview feedback! A consistent request has been for the ability to copy the name and description of a Search result into your clipboard. This is now possible by right-clicking on these two fields in the Search results fly-outs.

Finally, the Power BI team is excited to announce the launch of our updated website www.powerbi.com. The new site has a fresh new look and was designed with you in mind.

 

Here’s a quick look at what’s different:

  • New user-friendly navigation
  • Easy access to the Power BI blog
  • New support sections
  • New content about features
  • New social and sharing capabilities

We hope that you enjoy these new features and usability improvements. Don’t hesitate to let us know your thoughts through the forums and through the Smile/Frown feature. 

Helpful links: