Tag Archives: Visuals

5/29 Webinar: Building Spectacular Power BI Dashboards with Zebra BI visuals

During Matt Allington’s webinar: Time intelligence for retail and wholesale industries with Power BI the request was made to have a webinar on the best practices for visualizing business data particularly Time On Time like YOY changes.   Next week we have Andreje from Zebra BI to come show how many of the internal teams at Microsoft are doing this with Zebra BI visuals.

Building Spectacular Power BI Dashboards with Zebra BI visuals

We will present advanced data visualization methods for building insightful Power BI dashboards. This lecture will demonstrate how to implement popular datavis techniques like the small multiples and the IBCS® semantic notation by using the Zebra BI custom visuals. We’ll also take on the challenge of presenting the P&L statements in Power BI.

In our presentation, we will build a real-life sales and financial dashboard from the scratch and reveal practical tips&tricks for designing advanced, mobile ready and fully responsive dashboards.

When: May 29th 2018 10AM PST

Where: https://www.youtube.com/watch?v=r3Dh6aBOO7A 

 5/29 Webinar: Building Spectacular Power BI Dashboards with Zebra BI visuals

About the Presenter: Andrej Lapajne

Andrej Lapajne is the founder of Zebra BI and a founding member of the IBCS Association. In his 20 years of experience as a consultant, Andrej has implemented reporting systems and BI dashboards across a wide range of industries including pharma, telco, retail, FMCG, manufacturing, insurance, banking, energy, media, public sector and the high tech industry. His experience includes helping Coca-Cola bottlers, Swarovski, Bayer, Roche, Danfoss and many other international companies achieve consistent and efficient reporting. 

In the last 5 years, Andrej has led the Zebra BI team in developing fully IBCS-compliant custom visuals for Power BI as well as the popular Zebra BI Excel Add-In. 

As a speaker, Andrej has lectured at McKinsey&Co. in NYC, the AFP Annual Conference in Denver, several IBCS annual conferences and at many other international conferences and events. He is a guest lecturer at Faculties of Economics and Computer Science and Informatics in Ljubljana.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Excel announces new data visualization capabilities with Power BI custom visuals

Custom visuals have become a key part of Power BI allowing users to tap into hundreds of different visualizations. It is hard to believe that a little over two years ago we announced the availability of the first batch of custom visuals in Power BI Desktop and the Power BI Service. But custom visuals go far beyond the world of Power BI users. Today, as part of Build, we announced that Power BI Custom Visuals will be rolling out in Preview to Office 365 subscribers enrolled in the Office Insiders program soon, extending Excel charting capabilities and more than doubling the data visualization options for the most widely used data analytics tool in the world.

2051210e e17b 4320 b2bb cb4bbf391563 Excel announces new data visualization capabilities with Power BI custom visuals

Developers around the world are able to extend Power BI through visuals using the Power BI developer tools, the Power BI Visuals repo and standard Open Source technologies, like JavaScript and D3. This highlights Power BI’s commitment to user driven innovation and listening to feedback from our users and community.

Amir Netz, Technical Fellow and Chief Architect of Power BI, said in 2015, “I believe this one new capability [custom visuals] trumps all of the features released … Why? Because with custom visuals we are simply blowing past every limit of what is possible in data visualization and business intelligence.” As of today, more than 150 visuals are available in AppSource ranging from Infographics to R powered visuals that do not require R code at all!

0482a65b e398 40c9 83c4 1bf88b60bedc Excel announces new data visualization capabilities with Power BI custom visuals

Developers will now be able to reach millions of users with their own custom visuals while current Power BI developers will be able to reach a wider audience.

Here are some of the benefits that custom visuals will bring to Excel users and developers:

  • Insertion Experience side-by-side with existing charts

  • Tailored and Familiar Store

  • Intuitive and Familiar UI Controls within Excel

  • Enterprise Ready support for in house organizational visuals

  • Develop once and make available to users on both Excel and Power BI

f7c3d80c 19b6 4184 90d7 7c53241e6e2b Excel announces new data visualization capabilities with Power BI custom visuals

Finally, this announcement reinforces the benefits that Excel and Power BI users get from using both tools together in the context of Office 365.

Learn more about this announcement in the Office Dev Center blog.

Resources

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Move or Resize #PowerBI visuals with the arrowkeys

April 4, 2018 / Erik Svensen

Move or Resize #PowerBI visuals with the arrowkeys

You might already know that you can move one selected visual with the arrow key – one point and if you hold down the SHIFT key it will move 8 or 9 pts when you click the arrow key.

See this example – move the visual with the arrow keys


But can you also resize multiple visuals !!!

Until today I didn’t think it was possible to resize visuals using the arrow keys – but it can be done – and even when you select the more than one of the same type of visuals.

So, if you want to make all your cards or bar chart – you can simply select them and then switch to the Format tab of the visual – under General you will find the width and height of the selected visuals.

You can enter new values OR use the magic of the arrow keys !!!!!!! – if you use Arrow up or down you can actually change the number 1 point at a time

Check out this video

This will naturally also make your visuals exactly the same size.

It will save me and hopefully also you a lot of mouse clicks in alignment and resizing.

Let’s block ads! (Why?)

Erik Svensen

Dynamically switching axis on visuals with Power BI

An interesting visualization pattern I have seen is that some customers want to be able to switch the axis on the chart dynamically using a slicer.

Let’s take a simple model like this:

 Dynamically switching axis on visuals with Power BI

where I want to be able to dynamically change the axis of my chart to be Currency, Country or Region using a slicer. Today that is not possible out of the box because you cannot have a single slicer crossing different table. Now one option here is to use bookmarks to switch the chart based on a label (but that is cheating  Dynamically switching axis on visuals with Power BI)  but I rather fix it in the model. What we need to do is bring all slicer values and their keys into a single table to be used in the slicer, for this use a DAX calculated table like this:

Table =
var currencyt = CROSSJOIN(ROW("Type","Currency"), VALUES(DimCurrency[CurrencyName]))
var country = CROSSJOIN(ROW("Type","Country"), VALUES(DimSalesTerritory[SalesTerritoryCountry]))
var region = CROSSJOIN(ROW("Type","Region"), VALUES(DimSalesTerritory[SalesTerritoryRegion]))
return UNION(UNION(currencyt,country), region)

First we use 3 variables to create 3 tables that each joins with the name we want on the slicer with the key values of that dimension. Finally we join all of them into a single table, i also rename the CurrencyName column to Values.

This gives us a single table:

 Dynamically switching axis on visuals with Power BI

Now we can create a slicer based on the type and create a chart based on the Key column

 Dynamically switching axis on visuals with Power BI

Now finally I write a measure that joins the names of the axis with the values on the dimension using TREATAS.

Measure 2 = 
if(HASONEVALUE('Table'[Type]),
          SWITCH(VALUES('Table'[Type])
                 ,"Country", CALCULATE(SUM(FactInternetSales[SalesAmount])
                                      ,TREATAS(VALUES('Table'[Values])
                                      ,DimSalesTerritory[SalesTerritoryCountry]))
                 ,"Currency",CALCULATE(SUM(FactInternetSales[SalesAmount])
                                       ,TREATAS(VALUES('Table'[Values])
                                       ,DimCurrency[CurrencyName]))
                 ,"Region",CALCULATE(SUM(FactInternetSales[SalesAmount])
                                      ,TREATAS(VALUES('Table'[Values])
                                      ,DimSalesTerritory[SalesTerritoryRegion]))
)
)

This calculation pushes the filtered down onto the dimension based on the slicer, it is using the filtered values from the  values column into each column of the dimension. This is as if the filter was placed on the dimension instead of the table we just created.

This finally gives us the ability to slice on a dimension:

 Dynamically switching axis on visuals with Power BI

 Dynamically switching axis on visuals with Power BI

You can download the PBIX file here.

Let’s block ads! (Why?)

Kasper On BI

1/11/2018 Webinar: Integrating R Script and R Script Visuals with Power BI by Ginger Grant

[unable to retrieve full-text content]

Power BI is a great tool for providing in-depth analysis of your data. In this webinar we are going to add R to Power BI to provide not only some R visualizations which are not available in Power BI, but also to analyze the data using statistical methods. We will take a look at what answers Power BI can glean from the data and those which remain unknowable. This webinar will show you how to take your Power BI reports to the next level using analysis you can use in your next project.

Microsoft Power BI Blog | Microsoft Power BI

Interactive R custom visuals support is here!

R is a strong and popular language, enabling developers to create great analytics on data, as well as visualization.

Developers can already create R custom visuals that plugs into Power BI reports, to enable report authors to use those custom visuals without known R. This is a powerful capability to extend the visualizations of Power BI.

We are proud to announce that R custom visuals can now also be interactive, by generating HTML as the visual (instead of the static image that was supported until now), R custom visuals are capable of supporting tooltips and selections.

Here is an example of a time series forecast chart with tooltips, selection and zoom:

ad83fa59 749e 47b4 80bd e622981113de Interactive R custom visuals support is here!

We already have interactive R custom visuals in the store. Try them out:

Forecasting chart

Clustering

Spline

Forecasting with ARIMA

We are working to add more of them soon, and waiting for you, the developers community, to add your own!

The interactivity is enabled thanks to Plotly R library and htmlwidgets library, which are supported in Power BI service and Desktop.

Interested in creating interactive R custom visuals? Learn more.

Need help? check the community site, or contact pbicvsupport@microsoft.com

Check out all R custom visuals in the store.

Get updates and join the developer discussion in the community site.

Learn how to develop custom visuals on GitHub.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Custom visuals now available in the Office store

Custom visuals have come a long way since they were announced as part of the GA of Power BI back in July 2015. From best visual contest, to a new and improved version of the platform and the developer tools, to the recent announcement for the new custom visuals community site, it was always about the community.

The community is the force that drives the success of custom visuals. Developers have contributed more and more custom visuals to the visuals gallery, which now has more than 80 visuals! Report creators embraced custom visuals and made some awesome reports. Also, your focus and passion has helped to improve the platform and make custom visuals what they are today. It was heartwarming to see how much you care and enjoy custom visuals! Thank you!

Custom visuals in the Office store

We are very excited to announce, that as of today, custom visuals are available to discover and download within the Office store.

What is the Office store? Simply put – it is the place to find apps (known as add-ins) for your Office 365 software.

The Office Store connects millions of users of Office 365 to solutions that help them get work done more efficiently, more insightfully or more beautifully than before.

What is changing?

Power BI is now a product in the Office store, listing all Power BI custom visuals. Searching and filtering by categories are available for easy navigation.

68d00abb ef26 4a05 8ec6 78466bacbbf7 Custom visuals now available in the Office store

The custom visuals gallery is moving to the Office store. Many visuals are already listed in the store, and we are working to onboard the rest of the visuals within a few weeks. The Office store will be the place to discover custom visuals and download them, as well as the place for developers to submit and manage their custom visuals in the store.

The visuals gallery will still be available until we finish moving all of the visuals to the Office store, however new submissions will only go to the Office store. All custom visuals that were ever downloaded from the gallery will continue to work as usual even after the gallery will be deprecated.

Better for users

If you use custom visuals, here is what the integration with the Office store will mean to you.

  • An easy navigation experience using categories and search. We created a set of categories just for custom visuals.
    3cb4d5e0 a8f1 47dc 8b40 2afda33952cd Custom visuals now available in the Office store
  • A details page for each visual with high quality screenshots and videos to introduce you to the visual.
    98c8c070 d5f3 4ef0 8796 18fb1a82b851 Custom visuals now available in the Office store
  • Reviews and ratings are available as a feedback channel to the developer and also a way for you to help others gauge quality of a visual.

For more information about how to discover and use custom visuals in the office store, see Download and use custom visuals from the Office store.

Better for developers

For you custom visual developers, you will be able to use the Office developer center which will bring the following.

  • Submit your custom visuals in an easy to use web portal.
  • Manage your custom visual submissions.
  • Track how many people visited your custom visual page in the store and downloaded it.
  • Get direct feedback from users through the review system to help you improve the visual.

In addition to that, you will get broader exposure to a larger user base in the Office store.

For more information about how to submit visuals to the Office store, see Publish custom visuals to the Office store.

Get started with custom visuals

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Webinars Jan 10-17: Power BI Custom Visuals, Flow Administration, PowerApps Custom APIs, and Building a PowerApps App

The holidays have come to a close, which means we’re back with more webinars! Over the next two weeks we have four fantastic webinars for your viewing pleasure, covering Power BI, Microsoft Flow, and Power Apps.

Walking through the development process for creating custom visuals for Power BI

Power BI has recently revamped the entire experience for Developers who want to use and create extensions that target this exciting new platform. In this webinar, Microsoft’s Tzvi Keisar will walk through this new developer experience. Also, dev lead Jon Gallant will take us through the process of taking a 3D graphic, and turning it into one of the Power BI visuals on the Visual Gallery. The session will end with a look at some of the upcoming short term roadmap enhancements.

Tuesday, January 10, 2017, 10 a.m. PT
Register now!

About Jon Gallant

Jon Gallant is a Principal Development Lead at Microsoft. He has 16 years of experience in web, mobile, hardware and cloud services development using a combination of open source and Microsoft technologies.

Microsoft Flow administration, SharePoint integration, and best practices by Merwan Hade

Microsoft Flow entered general availability a month ago, and it already has over 100,000 active users! Flow is a new automation tool for business users, empowering them to create workflows to receive notifications, synchronize files, transfer data, and automate approvals. This webinar will look at common support issues and best practices to help you get started. Join Merwan Hade, Program Manager on the Microsoft Flow team, as he walks through SharePoint integration, administration, and all round best practices for using Microsoft Flow.

Wednesday, January 11, 2017, 10 a.m. PT
Register now!

About Merwan Hade

Merwan is a Senior Program Manager on the Microsoft Flow team, leading the the user experience for the workflow designer, driving the integration between SharePoint Online and Microsoft Flow, and managing the data governance story. He previously worked as a PM on the Microsoft PowerApps and Visual Studio Azure Tools teams. Merwan’s mission is to deliver the very best user experience possible.

PowerApps custom APIs, gateways, and data sources by Archana Nair

Join Archana Nair and Charles Sterling for a look at building PowerApps solutions that can connect to various cloud and on-premises sources. This webinar will cover best practices on using the Application Gateway, shared by PowerApps, Microsoft Flow, Azure Analysis Services, and of course Power BI. We’ll finish with a drill down into custom APIs, and a demo by Charles Sterling on how to create a custom API that calls the Power BI REST API to insert Rows into a Power BI dataset.

Thursday, January 12, 2017, 10 a.m. PT
Register now!

About Charles Sterling

Charles Sterling came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

How to build a production-ready event application in less than a week with PowerApps

One of the Azure MVPs, Vishwas Lele, was asked to create an fully functioning cross-platform event application that would integrate with Outlook, share images, and run on the main stream platforms including web browsers, Android, and IOS in less than a week. This webinar will show how Vishwas used PowerApps and Microsoft Flow to make this project a reality. For more information, you can also visit the PowerApps Blog on this topic.

Thursday, January 17, 2017, 10 a.m. PT
Register now!

About Vishwas Lele

Vishwas serves as CTO at Applied Information Sciences, Inc. He is responsible for assisting organizations in envisoning, designing, and implementing enterprise solutions related cloud and mobility. Mr. Lele brings close to 27 years of experience and thought leadership to his position, and has been with AIS for 22 years. A noted industry speaker and author, Mr. Lele serves as the Microsoft Regional Director for Washington D.C. and is currently an Azure MVP.

This article passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
Recommended article: The Guardian’s Summary of Julian Assange’s Interview Went Viral and Was Completely False.

Microsoft Power BI Blog | Microsoft Power BI

What is New and Exciting in Power BI, Power BI Visuals in R and ESRI Deep Dive Webinars Dec 8, 13 and 15

What is new and exciting in Power BI

With weekly and monthly releases, there are a lot of fantastic new features to explore. In this session, we will cover an overview of what has been released in Power BI. We will be covering the new collaboration features in the cloud-based business analytics service the new authoring and modeling features of Power BI Desktop, extend your reach to mobile applications, new Power BI resources and finally what is new for developers leveraging the Power BI platform.  In this webinar we are also going to try something new exciting…field all the question as an AMA on the community site….

This way not only will you get to see all the questions everybody asks there will be a historical log of the answers that you easily go back and refer to later!

December 08, 2016 10:00 AM – 11:00 AM

https://info.microsoft.com/US-PowerBI-WBNR-FY17-11Nov-29-newandexciting274899_01Registration-ForminBody.html  

 PBI 342 AMA Promotion What is New and Exciting in Power BI, Power BI Visuals in R and ESRI Deep Dive Webinars Dec 8, 13 and 15
About the presenter:
Charles Sterling came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as the Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

Deep Dive into the ArcGIS Maps for Power BI by Esri

ArcGIS Maps for Power BI offers enhanced mapping capability, demographic data, and even more compelling map visualizations so you can tell your best story.  In this webinar the Development team from ESRI will join up with the Microsoft Power Team to do a deep dive on how to use the ArcGIS Maps for Power BI, Best Practices and what the future will bring in exciting new area.

December 13th, 2016 10:00 AM – 11:00 AM

<Link Pending>

ESRI What is New and Exciting in Power BI, Power BI Visuals in R and ESRI Deep Dive Webinars Dec 8, 13 and 15

Extending Power BI with R Visuals by Ginger Grant

With R Script you can amazingly sophisticated visuals, leverage a huge and growing library of Visuals written in R, and customize those existing libraries to solve your business needs. In this webinar, Microsoft MVP, Ginger Grant, will show you how to get started with R Visuals including getting started from scratch and leverage existing libraries to Visualize your Power BI data.

December 15, 2016 10:00 AM – 11:00 AM

https://info.microsoft.com/US-PowerBI-WBNR-FY17-11Nov-29-Rvisuals274893_01Registration-ForminBody.html

ginger What is New and Exciting in Power BI, Power BI Visuals in R and ESRI Deep Dive Webinars Dec 8, 13 and 15

About the presenter:

Ginger has years of experience with many versions of SQL server as an MCSA on a variety of different projects for industries including vehicle telemetry systems, construction materials distribution, call center routing, financial services, healthcare management and insurance processing. Ginger is continuing her SQL Server experience as consultant for Pragmatic Works. When not working, she can be found speaking at the Arizona SQL Server Users Group, PASS Business Intelligence Virtual Chapter, SQL Saturdays and Desert Code Camp.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Tech Tip Thursday: Get started with R Visuals

social default image Tech Tip Thursday: Get started with R Visuals

Microsoft’s Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on his YouTube channel since 2014. Every Thursday we highlight a different helpful video from his collection.

There’s been a lot of Power BI news lately around R Visuals, but if you’ve never used them before you may not be sure how to get started. This week, Guy in a Cube shows you how to take advantage of the R Script showcase to get started interacting with your data through R.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI