Microsoft Power BI

Experience what's coming next

What is Power BI?

Power BI is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device.

Learn moreSee it in action

Do More with Excel

With Excel 2013 Discover, Analyze and Visualize your data like never before.

Learn moreTry Excel with Office 365

What’s New

Leader in Agile BI

Microsoft named a leader in Agile Business Intelligence by Forrester.

See the report

Power BI Newsletter

Sign up for our Power BI newsletter to get updates on everything Power BI.

Sign up

Webinars

Get Started with the Power BI preview attending our next webinar

Register

Power BI Blog

  • Viva la Data! See you at Gartner BI and Analytics Summit in Vegas

    Are you at the Gartner BI and Analytics Summit? So are we! Join us at these various events throughout the Summit, and follow along at @MSPowerBI to hear the latest news from the event.

    • Microsoft Booth #311 in the Expo Hall: Stop by the booth in the expo hall to chat about any BI and analytics questions with members of our engineering team, see the latest demos of Power BI, as well as Microsoft Azure’s big data and IoT capabilities, and of course win some cool swag.
    • Solution Provider Session with James Phillips, Corporate Vice President of Power BI – Tuesday 3/31, 10:45am in Augustus I: You’ll hear about the latest BI offerings from Microsoft and get a chance to see them in action. 
    #Gartner BI and Analytics Summit

    Mon, 30 Mar 2015 17:03:00 GMT byPower BI Team0 Comment

    Read post
  • 7 New Updates to the Power BI Designer Preview

    Try what's coming next for Power BI!

    We’re very glad to announce a new update for the Power BI Designer Preview. This month’s update includes new features and improvements across all major areas in the product: connectors, transformations, modeling and reports. We have also addressed lots of bugs and improved performance and stability of the Power BI Designer.

    What’s New in the Power BI Designer

    These update includes the following new features:

    You can see these features in action in the following video, or read below for more details.

     

    Google Analytics Connector

    The first item on the list is a new connector to import data from Google Analytics. We’re adding this connector not only to the Power BI Designer, but soon also to the Power BI Dashboards service. Stay tuned for upcoming service update announcements that will bring this feature.

    In the Power BI Designer, this connector can be found in the “Get Data” dialog, under “Other Sources” category (or “All”).

    After signing in with a Google Analytics account, users will be able to browse analytics data for all sites registered with the account. Users can pick dimensions and measures in the Navigator dialog to construct a single-table output.

    Users can see the table output preview building up as they select items in the Navigator tree.

    Finally, they can click Load to land the entire dataset directly in the Report view, or select Edit to land a small sample of the data in the Query view.

    In the Report view, users can directly start building visualizations for this data. In the Query view, they will be able to apply several data transformations based on preview data that will run against the underlying service, and they can also leverage special operations available only to Multi-Dimensional sources, such as Add or Remove items.

    There are lots of interesting analytics scenarios that open up with this new connector. Think about all other data sources supported in the PBI Designer and how easy it is now to combine data from any of them with Google Analytics data to build Power BI reports.

    Additional Operators for Date filtering in the Query view

    We have added a few additional filter options for Date/Time columns in the Query view:

    -  Is in Year to Date.

    - Today

    - This Week

    - This Month

    - This Quarter

    These options show up under the respective dropdown menu in DateTime Filters.

    Note that all of these filters are dynamically calculated, so for instance, “Year to Date” means between Jan 1st 2015 & March 25th 2015 today, but it will mean a different Year and Date when we refresh our query or report in the future.

    Automatic Relationship Detection

    In this update, we are adding automatic relationship detection for tables loaded in the model. We’re applying this detection in the following cases:

    - Initial load of the table to the model.

    - Refresh

    - Auto-Detect button.

    This is a very powerful feature, which is now also enabled automatically and will allow users to correlate data from different tables and build rich visualizations without having to worry about manually defining these relationships. This relationship detection works for all data sources supported in the Power BI Designer that do not have an underlying schema (such as Text, CSV, Web, HDFS, etc.).

    You can learn more about how to create and manage relationships in the Designer by reading this Help article.

    Enhanced “Add Relationship” dialog…

    The “Add Relationship” or “Edit Relationship” dialog has been improved to include inline previews of the tables/columns being selected.

    Within the “Manage Relationships” dialog, we can click “Add Relationship”… The dialog now gives us two table/column selectors with inline previews of data. This enables us to easily identify which tables/columns to use for the new relationship.

    Reorder Report Pages

    Last but certainly not least… We’re adding the ability to reorder pages in the Report by drag & dropping within the Report Pages pane… This will definitely make it much easier for you to iterate on the content of your reports and move it around as needed.

    Performance Improvements

    We have improved performance for loading queries that do not contain any filters or transformations by ~40-50%. You should see such queries take half of the time to load or less, compared to last month’s Designer bits.

    Bug Fixes and Quality Improvements

    As with every update, we’ve also fixed lots of bugs and issues reported by many of you via “Send a Frown”. We encourage you to continue sending us feedback about the product and reporting any issues that you may find while working with the Power BI Designer.

    We hope that you enjoy this update. Stay tuned for more updates coming soon… 

    #Power BI#Business Intelligence#data visualization#model#power BI Designer#Microsoft#Google Analytics#Relationship

    Thu, 26 Mar 2015 14:30:00 GMT byMiguel.Llopis9 Comments

    Read post
  • Better Insights into your Zendesk customer support with Power BI

    An important part of good customer service is ensuring that your customer needs are being met quickly and efficiently. This means not only hearing from your customers, but analyzing how your customers and your team are interacting. This is where Power BI and Zendesk come in. Zendesk allows companies to build better relationships with their customers. Power BI allows users to import data a variety of sources to quickly gain insights into their data.

    When connecting to Zendesk, Power BI gives users an even easier way to explore and monitor their Zendesk data with an out of box content pack. This content pack not only brings in the data, but also offers a dashboard and set of reports to get you started.

    In this post we’ll cover how to get better insights to your Zendesk data using Power BI. For additional details on how to connect and get started, jump to the Connecting to Zendesk section below.

    Exploring your Zendesk data

    Power BI offers an out of box content pack that connects to Zendesk and brings in a variety of important data for you to monitor.

    As soon as you connect to your data, you'll see information about your tickets, agents, organizations and more. For example, at a glance you can see the number of Tickets created, solved and closed over the last 7 and 30 days. Your dashboard can be customized however you like, ensuring you have the data that is most important to you.

    There are even more insights are behind each tile, in the 5 page report that comes with the dashboard. These pages include insights about Tickets, Agent Performance, Recent Activity, Activity by Agent/Group, and Ticket Activity.

    Selecting the top left tile brings you to the Ticket Summary report page - showing a breakdown of tickets by status, group, channel and more. More details about interacting with reports are available here.

    Selecting a visual will bring up options to change the visual type, to pin the visual or to remove it from the report. Pinning a visual will add it to your dashboard, and is a quick way to customize your dashboard with information that's important to you.

    Select a value on the report to cross filter the other visuals. For example, selecting "open" in the top left, will filter the page to all the open tickets. You can also use the filter pane on the right hand side, to change the range of tickets you see based on when they were created.

    Use the navigation at the bottom to browse the other pages of the report, including Agent Performance, Recent Activity, Activity by Agent and Group, Ticket Activity.

    You can also chose to edit the report, which allows you to customize your reports and dashboards based on the underlying dataset. Select Edit Report in the top left corner. The view will switch to show you the field list, allowing you to access any of values and calculations included in this out of box data set – such as additional information about Users, Tickets etc. and customized calculations like Average Reply Time or Average Resolution Time. More details about editing reports can be found here.

    Back on the dashboard, you can also ask questions about your data using the question box. More details about Q&A can be found here.

    You can ask specific questions about your Zendesk data, such as “tickets by status” or one specific to your agents, such as “number of open tickets for Josh”. The results of the questions can also be pinned to your dashboard.

    Connecting to Zendesk

    To access Zendesk data in Power BI, you’ll need to provide your Zendesk company URL and your credentials. Get started by navigating to www.powerbi.com and sign in with your work account. If you don't already have an account, it's quick and free to sign up!

    Once in Power BI, you can connect to Zendesk through the Get Data link in the top right.

    From the list of sources you can search for and select Zendesk. The landing page describes some of the details of the connector, to continue click Connect.

    You've now started the import flow to view your Zendesk data in Power BI!

    Next, enter your Zendesk company URL - this will be in the form "https://company.zendesk.com". You can find more details about what to specify at https://www.zendesk.com/login

    When prompted, enter your Zendesk credentials.  If you have pop-ups allowed you may automatically be prompted. If not, select oAuth 2 as the Authentication Mechanism and click Sign In.

    Follow the Zendesk authentication flow. Note that these credentials must be an Admin for your account.  (If you are already signed in to Zendesk in your browser, you may not be prompted for credentials.) After signing in, click Allow to allow Power BI to access your Zendesk data.

    Click Connect to begin the import process. Once completed, a new dashboard, report and model will appear in the Navigation Pane. Your data is now in Power BI for you to monitor and explore!

     

    #Power BI#Business Intelligence#data visualization#Zendesk#Connector#Customer Interaction#Customer Support#Customer Service#Content Pack

    Tue, 24 Mar 2015 15:30:00 GMT byPower BI Team4 Comments

    Read post