Garage Series
elclasicogs

Garage Series: Power BI and Excel takes on El Clásico

This week the Garage Series comes from Barcelona, Spain on the heels of TechEd Europe. In this demo-packed show Jeremy puts the advanced analytics and visuals in Excel and Power BI to the test to expose data patterns within past matches between Real Madrid and FC Barcelona. By combining historical El Clásico and player data, outside forces like temperature, humidity and moon phases, Jeremy tries to predict the outcomes and puts these predictions to the test among fans in Barcelona.…

Garage Series
thake_gs

Calling all Office devs: What’s new, different and better with the new app model

Curious about the new app model for Office? This week, Jeremy Chapman is joined by Jeremy Thake to talk about the new app model. They explore the developer options for Office with the building blocks, the object model and application compatibility. Beyond what’s the same, they also explain what is different and demonstrate how new apps are built in Visual Studio. Prior to joining the Office team at Microsoft, I…

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…

Office 15-Minute Webinars
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.

Garage Series
PowerBI_Thumbnail

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.