Ask the Expert: Dashboards and DataFrames

Dynamic Dashboards and Modern Browser Experience.  Development tends to take place in WinApp what are the considerations/tips architects should consider when adding the MBE layer for client use? Tips/Gotchas?

Hi all, I would be interested in the best practice of nested dynamic dashboards, e.g. imagine, you want to create a dashboard, that allows you to dynamically list the Workflows a user has access to with the steps in the workflow and the current status. We’ve build something like this (see screenshot), but we aren’t sure, whether it is the best/recommended approach from the performance perspective.Would be nice if you could elaborate on this a bit. ThanksMarkus

Can you give architects guidance as to when to utilize Data Frames with Dashboard development use cases and talk about whether this provides performance benefits balancing with Data Unit “physics”.  What are the opportunities/limitations we should keep in mind with respect to the use of Data Frames with Dynamic Dashboards?   

Can you use dataframes to join data from multiple sources or join multiple dataframes into one? For example, a mapping table in an external database that we’d like to join to a custom table in the OS application database, before doing additional processing (grouping, aggregation, etc) on the joined data.

Is there a way to work with / add fdx data in a dataframe?

DataFrame question: Today we use DataTables and LINQ to perform operations such as multi-column GroupBy, aggregations (Sum, Count, Average), joins, filtering, and calculated columns. Do DataFrames support these types of data-shaping operations natively, and if so, are they generally more efficient than DataTable + LINQ for in-memory transformations? For example, replacing a multi-column GroupBy + Sum pattern like the one below: // Group by Entity, ProductType, ProductLine, Account, Channel, sum(LOCALAMOUNT)DataTable result = dt.AsEnumerable()    .GroupBy(r => new    {        ENTITY = r.Field<string>("ENTITY"),        PRODUCTTYPE = r.Field<string>("PRODUCTTYPE"),        PRODUCTLINE = r.Field<string>("PRODUCTLINE"),        ACCOUNT = r.Field<string>("ACCOUNT"),        CHANNEL = r.Field<string>("CHANNEL")    })    .Select(g =>    {        DataRow row = dt.NewRow();        row["ENTITY"] = g.Key.ENTITY;        row["PRODUCTTYPE"] = g.Key.PRODUCTTYPE;       

What are the prerequisites for using DataFrames e.g minimum platform version and what are some use cases for using DataFrames; instead of DataTables, for example?