kohera-logo-regular.svg

What to expect from Datazen

One of the latest acquisitions of Microsoft is a Dashboarding company called Datazen. Datazen originally started in 2002 as ComponentArt, a developer tool vendor, building original UI and data visualisation technology.

With a decade of experience in building data visualisation technology they then decided to create the next-gen mobile BI product. Datazen was launched in 2013, and with a constant stream of releases improving the product it gained recognition among customers and partners. Till one of the partners, Microsoft, bought it in April 2015.

But what to expect from this tool? Here are some of the features that make Datazen a great and enterprise ready application:

150828b

Desktop & Mobile: Both are supported. For desktop you can use the web browser to visualize the dashboards. Windows 8 users can even use the Datazen app to open and consume the dashboards. Also for Mobile devices the 3 major OS-es are supported: iOS, Android and Microsoft.

Integrated Security: Several types of security are available. You can use the Datazen security, Active Directory or Active Directory Federation Services Authentication. Moving data around from Secure Device to Server can go through SSL. The data is also encrypted at REST on Datazen Server and on the client device.

Enterprise data sources: Datazen can connect to the major available enterprise data sources:

  • Microsoft SQL Server
  • Microsoft Analysis Server
  • Microsoft SQL Azure
  • Generic ODBC data Sources
  • Excel documents in network shares

Data anywhere: Data can be cached on the server for optimal performance, or locally on the device for offline use. As a third option you can also have the dashboards run on real time data queries. This also gives the possibility to make the dashboards more personal and get personalized data.

150828c

Dashboard and scorecard design: Easy to use design studio with rich interactive visualisations that give a perfect rendering in any screen Form-factor. It also give you the possibility to filter dashboards and drill-down or drill-trough to another dashboard or custom URL.

150828d

Team collaboration: Every KPI and dashboard has activity streams. Next to creating and update messages these streams also contain user comments that appear in chronological order.

Custom Branding: When it comes to custom branding, Datazen goes well beyond simple logo placement. All aspects of the app chrome are customized. The result is a fully-branded experience that looks and feels like custom mobile apps were created for your BI deployment.

Application integration: Next to applying your own branding, you can also integrate the dashboard in your existing web based applications. By adding a simple IFRAME to your web application you get all the Datazen functionalities.

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had...

Creating maps with R and Power BI

The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let...

Sending monitoring alerts through Telegram

What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you...

Send mails with Azure Elastic Database Jobs

The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options,...

Sorting matrices in Power BI

Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report...

The world of data is evolving

The data landscape has changed dramatically over recent years. In the past, we mainly heard that we needed to do as much as possible “cloud-only”—but this trend has become more...