Tallan's Technology Blog

Tallan's Top Technologists Share Their Thoughts on Today's Technology Challenges

Posts Tagged "Power BI"

Here’s How Microsoft Executives are Using Power BI

Tallan Partner

The Customer Data and Analytics (CDnA) team at Microsoft enables strategic data insights that shape the entire organization, from high-level leadership policies to small product decisions. At its core, CDnA creates and monitors indicators, known as “Power Metrics,” for some of the key divisions and businesses in Microsoft. CDnA delivers Power BI dashboards to several teams, including the Windows and Devices Group (WDG), Office, Bing, Cortana and Microsoft CEO Satya Nadella’s Senior Leadership Team (SLT). The SLT leverages the Power BI dashboards to monitor progress on strategic initiatives at the company.
Both CDnA and the Power BI product have mutually benefited from a close relationship since the Power BI public preview in 2015. In fact, the early and ongoing input from this internal Microsoft team and its users has helped make Power BI the “enterprise ready”, robust, and feature-rich platform it…

Sports Performance Platform Puts Data into Play – and Action – for Athletes and Teams

Tallan Partner

Seattle Reign players, coaches and staff celebrate a win over the Portland Thorns.
Sports ignite peoples’ passion like nothing else. Standout athletes become legends through their performance on the field. But what sets them apart often comes down to decisions made off the field, such as diet, mental and physical preparation and the frequency or intensity of practice. The difference between a win or a loss can be decided by an extra five minutes of wind sprints, levels of hydration or getting to bed 30 minutes earlier the night before.
At Microsoft, they believe sports provide a tremendous opportunity to use technology to transform how individual athletes and teams push the limits and gain the edge they’re looking for in the most challenging of circumstances. Imagine making clutch decisions that are based on insight, rather than gut. And what if coaches could…

The Associated Press Takes its Data Storytelling to the Next Level with Microsoft Power BI

Tallan Partner

The Associated Press delivers 2017 Virginia gubernatorial primary results with Microsoft Power BI publish to web.

For more than 170 years, The Associated Press (AP) has told the world’s biggest and most important stories, from the assassination of Abraham Lincoln to the fall of the Berlin Wall, and more recently Brexit and the 2016 U.S. presidential election.
Today, when news is frequently accompanied by massive quantities of data, reporting means making sense of all that data, and AP continues to lead the way in data journalism. The news agency, with locations in more than 100 countries, provides newsrooms worldwide with data-driven reporting on everything from politics, business, environmental science and public safety to sports, education and more. Recent AP data journalism efforts uncovered water quality issues in public and private water systems, analyzed the history of refugees from the seven countries included…

Microsoft Accelerates Modern BI Adoption with Power BI Premium

Tallan Partner

Power BI was first made generally available in July 2015. Since then, Microsoft’s driving vision for Power BI has been to enable users across roles, disciplines and industries to sign up for the service in seconds and get business value by drawing insights from their data within minutes. Microsoft’s relentless focus to drive access to insights at scale has helped Power BI reach more than 200,000 organizations, and the breadth of this global community continues to directly contribute to Power BI’s evolution – to date more than 400 features have been added to the service as the result of input from more than 50,000 users.
Introducing Power BI Premium
Today Microsoft is taking the next step in its commitment to empower people and organizations with access to critical intelligence: introducing Power BI Premium. Power BI Premium builds on the existing Power BI…

Quick Measures Preview

Tallan Partner

Quick measures, a new feature Microsoft released in their April Power BI Desktop update, lets you quickly create new measures based on measures and numerical columns in your table. These new measures become part of your model and can be used in any of your charts, just like manually created DAX calculations. You can also see the underlying DAX, and edit it if you need to tweak the results.
You can create measures based on 19 different calculations across five different categories. Let’s take a look at those five different categories.
Aggregate within category
These calculations let you apply different aggregates at different levels in your data. For example, you can sum revenue up to the month level, and then take an average of that total to display at the year level.

The result would look something like this:

The calculations included in the Aggregate…

How Microsoft Treasury uses Power BI

Tallan Partner

 
The Microsoft Treasury group manages $158 billion in assets, including cash and investments, account receivable, equity, and other investments. They act as an in-house bank for operations in over 190 countries, monitor thousands of bank accounts, and provide just-in-time cash management on a global basis. With a preview this large, Microsoft Treasury relies on vast amount of data in order to make fast, accurate, and actionable decisions to keep their operations running smoothly.
In the past, Treasury used a combination of Excel, PowerPoint, and third-party services to analyze and present their data, but Corporate VP, Treasurer George Zinn saw the future in the integration of a different product: Microsoft Power BI.
Power BI is a cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information, and share insights. It features easy drag-and-drop…

Driving Power BI Adoption in your Organization – Learn how Microsoft does this at Scale

Tallan Partner

At Microsoft leaders across the company have committed to fostering a data culture and are often asked how to drive this type of change. An internal program designed to drive adoption of Power BI internally has been at the center of this cultural shift.
Through a combination of training, a comprehensive communication strategy, and user-centric features and design, BI@Microsoft drives adoption of Microsoft data culture with Power BI. This program enables Microsoft employees to use data visualization, business intelligence and statistical analysis in their day-today jobs. Employees were previously limited by a mindset that they didn’t have the technical skills or time necessary to model data. Or they thought the data was not available or accessible. The BI@Microsoft program has proven that data driven decisions are possible at every level of the organization, while also creating loyal fans that influence their…

Introduction to adding Datasets using Power BI API

Iu-Wei Sze

Introduction:
I recently worked on a POC using the Power BI API. The purpose of the POC was to be able to add a dataset from a SQL database into my Power BI workspace through the use of a console application instead of manually having doing it from the GUI in Power BI. The goal was to make it abstract enough so that we can use it for any database in SQL by simply adjusting a few parameters inside an app.config file.
To get an example of how one would use the Power BI API in visual studio, I referred to this github repository to be a base for my application. There are some things that the example doesn’t show you which is what I’ll be focusing on in this article.
Since the purpose of this article is to go over lesser known features…

Announcing the Preview of the Office 365 Adoption Content Pack in Power BI

Tallan Partner

Understanding how your users adopt and use Office 365 is critical for you as an Office 365 admin. It allows you to plan targeted user training and communication to increase usage and to get the most out of Office 365. The usage reports in the new Office 365 admin center are a great starting point to understand usage. However, many of you have shared feedback with us that you want the ability to further analyze your data to understand how specific departments or regions use Office 365 or which products are used the most to communicate.
To provide you with richer and more personalized usage insights, Microsoft is combining the intelligence of the usage reports with the interactive reporting capabilities of Power BI. The new Office 365 adoption content pack enables you to visualize and analyze Office 365 usage data, create…

Building a Real-time IoT Dashboard with Power BI: A Step-by-Step Tutorial

Tallan Partner

Last month, Microsoft released a set of features in preview designed to make it easier than ever to display real-time streaming data in your Power BI dashboards. Check out the announcement if you haven’t already. Today, Microsoft wants to show you just how easy this can be.
Many of you have expressed interest in using Power BI to display real-time sensor data. In this tutorial, Microsoft will walk you step-by-step through the entire process of setting up a Raspberry Pi weather station, and showing the resulting temperature and humidity data in real-time with Power BI. Here’s a sneak peek of the end result:

Have other use cases in mind? Don’t have access to the materials below? No sweat. The lessons and sample code in this tutorial are broadly applicable for a wide range of IoT scenarios. And, as always, please let Microsoft know if you have…

\\\