Project

Creating burndown charts for Project using Power Pivot and Power Query

When you are managing a project and tracking the work done versus the work planned or the remaining time left, it is common to use a burndown chart. In this article, we show you how to create a report of all tasks for the last 90 days, using Excel 2013 and oData streams. This example will also introduce you to some key Power Query and Power Pivot functions.

Office 365

What’s New: February 2014

February has been filled with updates for the entire Office family.  Two services have been renamed and enhanced:  Office Web Apps is now Office Online; and SkyDrive Pro is now OneDrive for Business.  This has also been a big month for security and compliance related updates with improvements to authentication for Office 365 and Yammer, anti-spam and anti-malware enhancements, new email encryption options with S/MIME and Office 365 Message encryption, and…

Project

Try Power BI for Office 365 for a better reporting experience

With the new availability of Power BI for Office 365, Project users now have the ability to schedule workbook refreshes. For example, set it to update the data early in the day, so that your team can see fresh data instantly. Among the other project management features introduced by Power BI, you will also find the ability to add your workbook to the self-service Q&A to allow querying your data…

PerceptivePixel (PPI)
Image from webinar

Webinar: How Office works on an 82-inch touch screen

The webinar is over. Check back in a few days to see the video. Like working on your tablet or smartphone? Imagine one bigger than your TV. Perceptive Pixel by Microsoft delivers exceptional, multi-purpose touch devices for brainstorming, collaboration, and interactive presentations. In this week’s webinar, we’ll show you how Excel, PowerPoint, and OneNote work on a 82-inch screen. Click the…

Power BI
PowerBI_GA_02_summary

Power BI for Office 365 now available to do more with business insights in Excel

Today we’re happy to announce that we’re making Power BI for Office 365 generally available to a billion Office users. Since announcing and previewing Power BI for Office 365, we’ve been continually adding new features and with today’s general availability customers can now make more informed decisions by discovering, analyzing, and visualizing their data in Excel and sharing through Power BI for Office 365.

Office 365

The Garage Series: Unleashing Power BI for Office 365

In this week’s show, host Jeremy Chapman is joined by Michael Tejedor from the SQL Server team to discuss Power BI and show it in action. 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 and services that enable ease of data discover and information…

Excel

Power Map for Excel earns new name with significant updates to 3D visualizations and storytelling

We are announcing a significant update to Power Map Preview for Excel (formerly Project codename “GeoFlow” Preview for Excel) on the Microsoft Download Center. The new capabilities include an improved getting started experience, regions visualization, flat map, and create video tour. Power Map is a part of Microsoft Power BI in Excel and supplements the visualizations of Power View for Excel.

Office 365

How Power Map for Excel helps Opower visualize and present energy-saving messages

Ever wonder how you as a homeowner or renter can reduce your utility bills despite rising energy costs? How can utility companies capitalize on this customer motivation while smoothing demand away from peak usage times? Read on to learn how Opower, a global leader in customer engagement solutions for the utility industry, confronts both of these questions with their exciting new Behavioral Demand Response (BDR) solution announced today and some help from…