post

Get a sneak peek of June 10-11 Microsoft Business Applications Summit 2019

Get ready to flex your business applications skills – and pick up some new ones – at Microsoft Business Applications Summit. Coming to Atlanta, Georgia June 10 – 11, 2019, this is the place to dive deep with the tools you use every day, get a sneak peek at what’s new and next, and connect with our amazing community. Registration is open – secure your spot today!

We’re gearing up for an incredible event this year, with 150+ total-immersion sessions and workshops (plus 16 pre-days!) filled with demos, hints, and hacks that will help you unlock next for your business.

Session catalog preview

The first look at the session catalog is live! This is just the beginning. We’ll be rolling out the full lineup of sessions over the next couple months, but we couldn’t wait to share. Check it out to see what’s in store for this year’s event and start getting excited!

5 more reasons you can’t miss this conference

  1. Power better decisions with even better data. Learn how to get the most from your favorite tools: Dynamics 365, Power BI, Excel, Mixed Reality, PowerApps, and Microsoft Flow. Build new skills, get tips and tricks, and check out the latest trends and product roadmaps.
  2. Plan your perfect learning path. Get hands-on with 16 pre-day workshops and 150+ demo-rich sessions led by industry experts.
  3. Ask your toughest questions, and get answers at the source. Go one-on-one with engineers and product experts.
  4. Collaborate with our vibrant community. This is the premier conference for power users, analysts, developers, solution architects, and more. Build your network, share ideas and strategies, and pick up best practices.
  5. See the future of business applications before anyone else. From keynotes with visionary leaders to a multi-stream viewing lounge, you’ll get an exclusive look at the latest technologies.

Better data, stronger solutions, bigger transformation – don’t miss it! Hope to see you there. Register today!

post

Microsoft a Leader in Gartner’s Magic Quadrant for Analytics and BI Platforms for 12 consecutive years

We’re very grateful to our customers, our community members, and our partners for making Power BI what it is today.

Thank you.

The Power BI Team

Get the 2019 Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms report* to learn more.

 

*This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Microsoft. Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

 

post

Forbes: Microsoft’s Power Platform aims to ‘make other people cool’

A selection of PowerApps built by London Heathrow Airport, UK.Microsoft

Microsoft has always had to straddle an arguably difficult position in the software trade. The company has always needed to appear technically intricate, granular and powerful in the eyes of hard-core software developers. At the same time, the company has always had to present its software to market with a user-friendly ‘anyone can use it’ out-of-the-box style and approach.

There’s a little of that duality in the firm’s latest power play, which is a combination pack of technologies wrapped up under the Microsoft Power Platform brand.

This is all about presenting a selection of heavyweight backend technologies to hard-core developers and data scientists, but also to would-be so-called citizen developers who are typically businesspeople with an interest in getting applications and data to work the way they want them to work.

CEO Satya: be cool (to others)

Microsoft CEO Satya Nadella has tried to explain to his developer team that it’s not always about being the most amazing software engineer that creates the next big thing. Instead, it’s about creating amazing software power and putting that power in the hands of people who need it.

“You join here [Microsoft, the company itself], not to be cool, but to make others cool,” said Nadella, in a comment that has been widely reported internally and officially referenced here on c|net.

What Nadella meant was: build something so amazing that it empowers other people. This, of course, is a platform play, not a product play i.e. he wants people to use Microsoft technologies to create something great, rather than use an existing Microsoft technology to be great per se. It’s a logical enough strategy i.e. software products come and go, but platforms are more foundational and expansive… and so (typically) form a better long term business bet.

Microsoft Power Platform

The component parts of the Microsoft Power Platform have all previously existed as more distinct entities. This is essentially a coming together of Microsoft Power BI, Microsoft PowerApps and Microsoft Flow as a more unified offering available on top of Microsoft Azure cloud services.

“Our Power Platform – spanning Power BI, PowerApps and Flow – enables anyone in an organization to start building an intelligent app or workflow where none exists. It is the only solution of its kind in the industry – bringing together no-code/low-code app development, robotic process automation and self-service analytics into a single, comprehensive platform. And it enables extensibility across Microsoft 365 and Dynamics 365 as well as the leading third-party SaaS business applications,” said Microsoft CEO Nadella, in a press statement.

So just looking at the component parts again and explaining their functions, we have Microsoft Power BI, Microsoft PowerApps and Microsoft Flow.

Microsoft Power BI is self-service Business Intelligence (BI) app that works to connect and analyze business data and present a graphical visualization of it on screen. It supports 43 languages and the data it ingests can come from an Excel spreadsheet or SharePoint list, an Oracle database or from an SAP or Salesforce application. Nearly 10 petabytes of data are uploaded to the service each month with more than 10 million report and dashboard queries executed against that data every hour.

Microsoft PowerApps forms the company’s citizen application development platform. Theoretically ‘anyone’ (says Microsoft) can use PowerApps to build web and mobile applications without writing code. There’s also a natural connection between Power BI and PowerApps so that users can put insights (from Power BI) in the hands of maintenance workers and others on the frontline in apps built using PowerApps.

Lastly here there is Flow. This is Microsoft’s user interface that allows users to work with Robotic Process Automation (RPA), a technology designed to help automate simple tasks (and reduce operational errors) through automated workflows.

Data flows, everywhere

Corporate vice president in Microsoft’s business applications group James Phillips explains that the team’s vision for Microsoft Power Platform started from the recognition that data is increasingly flowing from everything, and a belief that organizations that harness their data – to gain insights then used to drive intelligent business processes – will outperform those that don’t.

“We also recognize there aren’t enough programmers, data scientists and tech professionals to go around. So our goal was to build a platform not targeting these technology experts but for [ordinary] people – and the millions of other frontline workers who see opportunities every day to create something better than the status quo, but who’ve never been empowered to do anything about it,” wrote Philips, in a lengthy Microsoft cloud blog.

Philips and team say that the guiding vision for Microsoft Power Platform was a framework they called the ‘Triple-A Loop’ i.e. a closed-loop system allowing users to gain insights from data (Analyze) used to drive intelligent business processes via apps they build (Act) and processes they automate (Automate).

Why play platform games?

We might stand back and ask why Microsoft is so focused on its new and wider approach to platform games of this kind — and there are three fairly reasonable suggestions we can make here.

First, Microsoft has always done platforms i.e. Windows was and still is a platform and you run other things (apps, databases and other computing services) upon it.

Second, Microsoft has invested heavily in its own Azure cloud platform (which features as a key element of Microsoft Power Platform) and, over and above that, the firm has for a long time now been working to make large portions of its stack (such as Office as a platform, which we detailed here in 2015) big enough to be considered platforms in their own right.

Third, Microsoft (under CEO Nadella at least) appears to understand the power of platforms both inside the Microsoft universe and outside of it. Be that other platform Linux, be it Android or be it a major vendor’s data platform suite from the likes of SAP, Salesforce, Oracle and so on.

This is a world where data comes first — sometimes from databases, sometimes from AI computations, sometimes from the Internet of Things (IoT) and its devices and sometimes from actual users — even before the actual software applications that will feed on that data. That core fact very arguably makes any platform play strategically smarter for long term success… if perhaps not just a little cool too.

 

post

Power BI’s top 5 releases from 2018

Happy New Year !

With over 150 features released, 2018 has been a prolific year for Power BI Desktop!

To cap off this successful year, our team put together a fun video, showcasing our pick for the 5 favorite releases of 2018:

  1. Report page tooltips [March]
  2. Web by example [May]
  3. Composite models [July] + aggregations [September]
  4. Expand + collapse [November]
  5. New filter experience [November]

We’ve also added an Honorable Mention for the Accessibility features released this year, which include the improved formula bar, adding filters from the context menu, and more!

We hope you enjoy the video and would love to hear about your favorite five!

This month we will have a Power BI Report Server update only, but starting February, Power BI Desktop will continue our monthly ship cadence. Looking forward to an even more impactful 2019!

post

Eyes on Europe: Giving voters new insights through technology

By Ben Rudolph, Managing Director of Modern Journalism, Microsoft Corporate HQ

Today, in collaboration with Microsoft, industry leader POLITICO Europe launched the next wave of its 2019 European Parliamentary election coverage featuring 27 new interactive data visualizations created with Microsoft Power BI. The latest Elections hub content follows last month’s launch of an interactive homepage visualization and includes new country-level pages sharing important information and the latest news about each of the European member states participating in the election.

Ireland in the EU election

“Each member state has its own electoral system, its own voter turnout and its own unique political landscape. At POLITICO Europe, we’ve built a European Election hub that reflects this national dimension” said Johannes Boege, Chief Product Officer at POLITICO Europe. “With these country pages, we are again combining our leading journalism with state of the art data technology. Enabled by Microsoft Power BI, our product provides comparisons of 2014 results with the latest projections, linking national parties, their European parliamentary groups, voter turnout and key information on the voting process. At a glance, our readers can get a very detailed and up-to-date overview of the EU elections in their country and compare it with the situation in other member states.”

At Microsoft, we’re thrilled to collaborate with POLITICO Europe to deliver on our commitment to empower the news industry to discover and tell impactful stories in engaging ways.  Recognized as the most influential publication on European affairs for two of the three years since it launched, POLITICO Europe is on a mission to bring nonpartisan education and insight to the European electorate as they navigate the complicated election process, which spans thousands of candidates and hundreds of parties.

To help achieve this goal, the new country pages enable POLITICO Europe readers to interact with reports to see the country-level seats by party as well as voter data from 2014, comparing it to the current predictions for 2019. The reports showcase the breakdown of party seats and affiliated groups, information on the voting system and process and past voter turnout stacked against population. Behind the scenes calculations make it easy for readers to interact with the report to understand the impact their vote could have in the upcoming election. Because the visualizations are built it Power BI, updates can be made in real-time as new data becomes available or news stories emerge.

This new content builds on the success of the homepage visualization that shows the projected composition of the next EU Parliament.

PowerBI seat to country transition

Microsoft is thrilled to continue collaborating with POLITICO Europe to launch new content formats that bring discussion about the future of the EU to new and existing readers.

Find out more about how Power BI is being used to build the solutions on the Power BI blog.

Tags: ,

post

Power BI Desktop adds dataflows, enterprise reporting and more

As organizations embrace a data culture to drive business decisions, they need an enterprise business intelligence platform that can meet their sophisticated needs – from self-service BI to full enterprise governance, from paginated reports to full interactive data exploration, and from small data sets to petabytes of data.

In July, we laid out the roadmap for Power BI to help organizations unify modern and traditional BI on one enterprise platform, and empower business analysts by expanding self-service data prep for big data.  Since then, we’ve shipped a number of capabilities that deliver on this roadmap: Premium multi-geo allows customers to address data residency requirements, aggregations enable data analysis over petabyte sized datasets with trillions of rows of data, and the new Power BI Home landing page and dashboard commenting make it easier to get to your most important content and collaborate across the enterprise.

Today, we’re announcing the availability of several new capabilities that we laid out in our July roadmap.

Dataflows expand self-service data prep in Power BI

Power BI already includes robust self-service data preparation capabilities in Power BI Desktop through the familiar Power Query based experiences that are used by millions of users worldwide. We are excited to announce the public preview of dataflows in Power BI, taking self-service data preparation to the next level.

  • Dataflows enable business analysts to create data preparation logic that can be reused across multiple Power BI reports and dashboards.
  • Dataflows can be linked together to create sophisticated data transformation pipelines that enable business analysts to build on each other’s work. A new recalculation engine automatically tracks dependencies and recomputes data as new data is ingested.
  • Dataflows can be configured to store the data in the customer’s Azure Data Lake Storage Gen2 instance, fueling collaboration across roles. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage, taking advantage of its scale, performance, and security. Meanwhile, data engineers and data scientists can extend insights with advanced analytics and AI from complementary Azure Data Services like Azure Machine Learning, Azure Databricks, and Azure SQL Data Warehouse.
  • Dataflows support the Microsoft Common Data Model, giving organizations the ability to leverage a standardized and extensible collection of data schemas (entities, attributes and relationships)

dfblog_08

Columbia Sportswear uses Power BI to empower a broad group of employees to self-discover, share and monitor insights across a diverse range of data sources in the cloud and on-premises. Dataflows unlocks new possibilities for their analysts leveraging large datasets.

“Dataflows are one of the more exciting additions to Power BI,” said Chris Weis, Senior Analytics Product Manager at Columbia Sportswear. “It amplifies Power BI’s ability to handle large datasets. Our analysts can now scale large data transformations beyond the resources of their PC, and accelerate PowerQuery performance in a big way.”

For more background on dataflows, check out Adi Regev’s blog.

SQL Server Reporting Services technology now in Power BI

A modern, compliant and unified enterprise BI platform for business analytics is easier than ever with our latest enterprise operational reporting capabilities.

Our popular SQL Server Reporting Services technology is now part of Power BI and available in public preview, providing a unified, secure, enterprise-wide reporting platform accessible to any user across devices. Pixel-perfect paginated reports can now be included alongside Power BI’s existing interactive reports.

“The availability of paginated reports in the Power BI service removes the last technical barrier to running all types of reports in the cloud,” said John White, Power BI MVP and Chief Technology Officer of Tygraph. “The choice of on premises or in the cloud no longer needs to be a feature decision. Customers with a significant investment in reporting services can now move to Power BI knowing that their reports can move right along with them.”

For more background on Paginated reports in Power BI, check out Chris Finlan’s blog.

Power BI Desktop November Update

We continue to innovate at a rapid pace with weekly updates for the Power BI service and monthly updates for Power BI Desktop. The November update for Power BI Desktop, shipping next week, includes several features the Power BI community has asked for:

  • Follow-up questions for Q&A explorer. You can now ask follow-up questions inside the Q&A explorer pop-up, which means the question will take into account the previous questions you asked as context. For example, you can ask “List customers in London” and then ask the follow up question “What did they buy” and the result for that second question will only be for London customers.

  • New modeling view makes it easier to work with large models. You can now have multiple diagram layouts, customize and save them, leverage display folders, and several additional enhancements that improve performance and experience – available in preview.

  • Expand and collapse matrix row headers.  Row headers on the matrix visual now work like Excel PivotTables, with the ability to expand and collapse individual row headers.

  • Copy and paste between PBIX files. You can copy and paste visuals between PBIX files, greatly improving usability and speeding up the process of creating new reports.

Learn more about the public preview of dataflows and SQL Server Reporting Services technology in Power BI during the PASS Summit at the day 1 keynote. For a deeper dive, please join our session Power BI: the Future for Modern and Enterprise BI on November 8th.  Attendees will see the new capabilities in action and hear more about what’s coming.

We have other fantastic content at PASS that you also won’t want to miss, including sessions covering our latest announcements with Introducing Advanced Data Preparation using Power BI Dataflows and Modern Enterprise Reporting with Power BI Report Server and the Power BI Service.

post

‘Near-futurist’ Rohit Bhargava scours data for hidden clues about how the world works

Mark Mobleywritten by

Mark Mobley

A ’near-futurist‘ scours data for hidden clues about how the world works

How does self-described “Trend Curator” Rohit Bhargava navigate the future? By shredding magazines and planting sticky notes. Throughout each travel-packed year of international speaking and teaching, he collects untold piles of periodicals, then skims, tears and screens their editorial and advertising content for clues to what’s now, what’s new and — most of all — what’s going to be influential in the years to come.

“The trends,” Bhargava said, “really explain how the world works.”

Using what he calls his “haystack method,” Bhargava sorts and sifts and shifts the material he and his team have found. Gradually, connections are made, combinations arise, synchronicities emerge and trends appear. He compiles what he gleans in an annual series of books called “Non Obvious: How To Predict Trends And Win The Future,” which have been published in more than a dozen languages. These have schooled more than a million businesspeople and interested civilians about the cultural currents, jet streams and eddies that shape our lives.

Rohit reading a magazine in front of post-it notes.

“You’ve got to look somewhere other than where everyone else is looking,” said Bhargava at his airy home, where visitors are welcomed by photo collages of his two young sons, in a leafy suburb of Washington, D.C. “I tend to pick up a lot of stuff about things I otherwise would never have picked up because the media here are so U.S.-centric.”

His omnivorous media diet includes everything from legacy magazines like The Atlantic and Variety to city magazines (Washingtonian), alumni magazines (Emory magazine), specialty publications (USA Philatelic, Adweek), foreign in-flight magazines and periodicals definitely not published with him in mind (Teen Vogue, Modern Farmer).

The irony of a “near-futurist” relying so heavily on paper in the digital age is not lost on him.

The irony of a ‘near-futurist’ relying so heavily on paper in the digital age is not lost on him.

“I think that people are more surprised about that than I am,” Bhargava said. “What you see is the paper. What you don’t see is my Feedly account, where I read hundreds of stories each week.” He also relies on conversations at conferences and interviews by his associates. But Bhargava sees a certain tactical advantage in scanning a vast amount of information in physical form.

Bhargava siting at a desk working.

“There’s a reason every James Bond villain looks down on that diorama of the world they’re trying to conquer,” he says. “Hopefully I’m not doing that for evil.”

He smiled and added, “Maybe there is some evil, because I want people to think for themselves and a lot of people don’t want that.”

Bhargava was born in India and came to the United States at 6 months old. After studies at Emory University he moved to Australia in 1998 and began his career at a company called Dimension Data, where he worked for three years before joining the Sydney office of advertising agency Leo Burnett. He returned to the U.S. in 2003 and started working the following year in Washington at Ogilvy. He stayed at that advertising agency until 2012, when he left to start his own consultancy.

Conference and convention planners appreciate the experiences Bhargava himself provides — he speaks at upward of 50 events a year, in addition to consulting with individual companies and teaching smaller groups. “My goal is to give them something they can do, not just inspire them,” he said. He wants to help his audiences find interesting ideas in unexpected places.

While he may appreciate tradition and rigorous methodology, he is anything but a stickler for doing things the way they’ve always been done.

“Our habits are really hard to unlearn,” he told an audience at a recent construction software convention in San Antonio. “The things that we know, the best practices, are really hard to abandon.

If we are going to be innovators, we are going to have to leave some things behind.

“If we are going to be innovators, we are going to have to leave some things behind.”

That’s why one of his five rules for Non-Obvious thinking is to “be fickle” — in other words, keep it moving. The others are “be observant,” “be curious,” “be thoughtful” and “be elegant.” That final command is the guide for the pithy names he likes to assign to the trends he observes.

For example, ”brand stand” is his term for how corporations can make themselves more attractive by backing up their work with socially conscious messaging and actions. (“The job of marketing is not to sell a car, it’s to get people to come into the dealership,” Bhargava explained.) “Predictive protection” is what he calls device makers working to anticipate and defend user vulnerabilities. And “approachable luxury” is the idea that experiences and objects that evoke authenticity and sincerity are now sometimes considered as valuable as high-end products from legacy makers.

In addition to isolating 15 trends for each edition of the Non Obvious books, he also looks back at previous years to reassess the accuracy of his own predictions. Take two from 2013: ”precious print” and “branded inspiration.” While consumers’ fondness for books and print media in general hasn’t waned (Bhargava still gives that trend an A five years later), brands are less willing to stage dramatic one-off events to stand out (today he gives that one a C).

While reevaluating trends, Bhargava realized he could also present them in new ways. He is increasingly using data visualization as a storytelling tool. The Microsoft Power BI platform allowed him to create The Non-Obvious Trend Experience, a periodic table of elements-style dashboard that shows how trends connect across years, industries and areas of interest.

The playful, informative Power BI dashboard is yet another product of an ever-expanding Non-Obvious universe. He’s planning what he calls “the most Non-Obvious thing to do,” a short-form podcast about the past hosted by a futurist. And he and his wife, Chhavi, are co-owners of the publishing imprint Ideapress, which has published 22 books and has another 12 coming soon. His own contribution to the series will be a volume on running a small business.

“I think any of us can be more innovative, more creative,” he told his San Antonio audience. “We just have to give ourselves permission to do it.” He demonstrated that the following morning by leading a workshop of about two dozen executives and staffers. They gathered around tables piled high with magazines.

He opened with a drawing exercise and soon the group was on to Bhargava’s haystack method, scouring the magazines before them for new ideas and things they hadn’t seen before. “I know it’s uncomfortable for some of you, but these magazines are for ripping,” he said. “I want to hear you ripping things out of these magazines. It might be an ad, it might be a story. Feel free to collaborate with your table.”

Curation is the ultimate method for transforming noise into meaning.

Rohit buried in post-it notes.

Two tables pulled the same story about new leashes for walking with children. Another person landed on a makeup line from Crayola. Yet another found an under-the-desk bicycle apparatus that generates power through pedaling. “That’s like next-level LEED certification,” Bhargava joked. “You can power your own building.”

In under an hour, the participants caught a glimpse of what is for Bhargava a year-round process producing mounds of material that gain more meaning with age and comparison.

“Sometimes we have to give ourselves a little bit of time,” he said. He thinks of his haystack method as akin to collecting frequent flyer miles. The ideas are there, mounting over time, ready be cashed in when they’re needed.

Frank Di Lorenzo Jr., a participant from Sacramento, California, called the session “excellent.”

“It got me to think a little more creatively,” Di Lorenzo said. “It’s like taking a step. If I always start on my right foot, this was my left. For an hour, he accomplished a lot.”

“I never saw anybody present this kind of topic before,” added Mary Cunningham of Jupiter, Florida. “It helps you think beyond the obvious. Don’t take things at face value. It allows you to open your mind to other ideas. The way he presents the material, it’s very easy to comprehend and allows the ideas to sink in easily.”

“Curation,” as Bhargava writes in “Non Obvious” and shared in his seminar, “is the ultimate method for transforming noise into meaning.”

Even if the noise is as much the shredding of magazines and riffling of sticky notes as it is the rising, roaring tide of cultural chatter.

Originally published on 8/14/2018 / Photos by Brian Smale / © Microsoft