The Datalion Blog

Version 1.10.6 relased – A new DataLion version packed with bug fixes, improvements and new features.

You will find the following new features in the latest DataLion version:

New features :

  • Custom stylesheet for login page
  • Send notification per mail
  • Create support for executing custom features
  • Admin – delete old <label> values
  • PPTX export – calulcation variable in title
  • Table – rolling % as metric
  • Apply chart filter to multiple charts

Improvements :

  • Tables should be exported to PowerPoint as table
  • Securing AJAX chart calls
  • Use only one PPTX export method
  • Enable cache mechanism for timeline etc.
  • Set phantom options in .env
  • Add / modify ccalc parameter through chart menu
  • Add / modify rcalc parameter through chart menu
  • Admin backend – admin should be able to delete a join definition between two tables
  • Use calculation setting from charttype
  • Refactor chartTypes methods
  • Dropdown filter – should not display excluded categories from access profiles
  • Filters – Dragging a filter parent on a chart should not use excluded filters form access profiles
  • Multiselect should display only valid options according to filter dropdowns (and access profiles)
  • Table – change filters <-> subfilters in chart menu
  • Fix number formatting
  • Add chartsettings hierarchy to the ppt export
  • Navigation – use blade template
  • Table – formatting according to settings
  • Report – don’t save gfv global filters
  • Timeline – include window settings
  • Optimize tests
  • PPTX export – chart titles
  • Move methods from old to new ChartController
  • Terminate Laravel session when logging out

Bug fixes :

  • Creating polarity charts from unscaled / scaled multi charts gives different results
  • Report: Changes cannot be saved when using dropdown menu instead of tabs
  • Report tabs disappearing on resize
  • Timeline – moving sum calculation type
  • Timeline – percent with numeric values
  • Apply custom color scheme correctly
  • Table – Hiding base does not work
  • Switching from bar to timeline results in columns
  • Language settings don’t work all the time
  • Fix the calculation type handling
  • Increase spacing between columns and labels
  • Own created filtergroups cannot deleted
  • Charts overlapping in multipage PDF export
  • API – missing values handling
  • Excel export not working
  • Wordcloud – <label> root entry should not be displayed
  • Menu should be closed by default at smaller screens
  • Hide empty does not work consistently
  • Import data – error message
  • Image – fails with joins
  • PPTX export – doesn’t use filter
  • PPTX export – local changes not applied in export
  • Navigation – search box layout bug
  • Open text – IE UTF bug
  • Access profile – long excel export definition not saved
  • PPTX export – |*GFV*| not replaced
  • Timeline – stacked bars displayed as lines
  • Polarity – not working with combined questions
  • Custom CSS in report editor not visibla
  • Tab layout issues
  • Missing legend for filtered top 2 chart
  • Fix the global dropdowns when they are create from two different tables
  • Fix warning for empty report tab
  • Polarity – scale from chartsettings not used
  • PPTX export tweaks
  • Timeline – missing values not used when filters are active
  • Getchartdata – Format numbers as numbers
  • Importing data sometimes fails to calculate field widths
  • Donut – wrong precision
  • Colorschemes – fix warning
  • Wrong p_type set from charts
  • Non-existing categories are producing wrong JOINs
  • Multistack – Wrong percentuation with differing case numbers
  • Deviation chart – number format not applied
  • Nested table generates incorrect url when using the use as subfilter menu
  • PPTX export should exclude the data which is unticked in the charts multiselect
  • Hide empty not working
  • Fix warning if dynamic filter variables are present
  • Timeline – precision not correct
  • Removing a chart filter removes all filters with this ID
  • Table – fix row calculation on . combined vars
  • Table – SQL variables not working (calculation)
  • Charts not displayed in public project when not logged in
  • Open text – error

Visualizing space: The 5 most beautiful space and moon-related visualizations

In these days we are celebrating the 50th anniversary of the Apollo 11 moon landing and focusing on a possible new lunar conquest by 2023. But let’s dream a bit and look at the most beautiful visualizations of the universe the Internet can offer today!
For all skywatchers our there, here’s a list of the sites to visualize data related to galaxies, space and the world around us.

Apollo 11 traject :

Experience Apollo 11’s way to the moon

Apollo 11 lunar landing told through data :

Explore this landing through a comprehensive video

Lunar conversation graph :

A beautiful infographic of lunar conversations

Deep Space Network now NSA :

The real-time status of communications with our deep space explorers, updated every 5 seconds.

https://eyes.nasa.gov/dsn/dsn.html”>

Stuff in space :

Real-time 3D map of objects in Earth orbit, visualized using WebGL.

Asterank :

3D Interactive Asteroid Space Visualization

ISS Interactive :

3D visualization of the ISS in real-time

The Milky Way Halo :

Beautiful visualization of our galaxies and stars

Celestia space :

A beautiful free software simulation that lets you explore our universe in 3D

Github projects from Ofrohn :

Sky map, solar system map, asteroids and planets for D3.js & three.js !

BONUS: FlightRadar24

Realtime visualisation of all the planes above us

Version 1.10.5 released – Calculated columns and PowerPoints with several charts on one slide

You will find the following new features in the latest DataLion version:

  • Export as PowerPoint with several charts on one page (in some cases it may be necessary to call and save the export configuration in the administration backend)
  • Tables can now also contain calculated columns and rows (e.g. growth rates or rolling totals)
  • Nested tables can also contain calculated columns.
  • Number charts can now be formatted as percentages with different decimal places
  • Names of rows and columns can be customized
  • You can specify the lifetime in the cache setting
  • Administrators can send notifications to users by mail
  • Access profiles can also be based on dynamic questions
  • When you copy a report, copies of the chart settings and shows/hides are also created.
  • Table links can be set up in the backend by dropdown
  • The API backend can now also calculate mean values
  • Time series charts can now contain several characteristics and filters

Effective dashboards: these chart types are worth a thousand words

Dashboards are a great way to make sense of complex data. How effective a dashboard is, however, ultimately depends on the specific composition. In modern dashboard systems like Datalion, the compilation of charts is easy – but how to choose the right chart types?

First, ask yourself what messages and information you want to communicate with your dashboard and what kind of data is available for that purpose. Depending on whether you want to display distributions and shares or want to visualize trends and processes, different chart types are possible. Also, the target audience of your dashboard is important: A data analyst often expects a different level of detail than, for example, a marketing employee. You find more information about the basic approach here.

On the one hand, you should be brave and, in addition to common bar charts and line charts, use unusual chart types to inspire the target audience of your dashboard. On the other hand, you must always pay close attention to the clarity and meaningfulness, this should always be your priority. Offering added value through interactivity in the form of selection filters makes great sense, but also has an impact on the selection of appropriate forms of presentation and must be taken into account accordingly. In addition to deciding on the right charts, the definition of colors, fonts and dimensions is ultimately part of the optimal composition of a dashboard. The best diagram does not help if, for example, colors are hardly meaningful or do not match the corporate identity.

The easiest way to play and test different visualizations in the dashboard software is to step by step and select the best charts and graphs. Datalion offers more than 50 different chart visualizations that can be inserted and exchanged with just a few clicks. Here are some particularly important chart types.

Pie- and Donut Chart

The good old pie chart is a classic one and well understood for less data-savvy people. This graph type is suitable for representing relative frequencies within a category of data – all shares together are 100 percent. Classic example: age groups or genders and their proportions within a sample.

The so-called radial chart is also in great demand for design-oriented chart professionals. It looks like a speedometer and is very meaningful thanks to its simplicity. However, the range of applications is limited, since it is only suitable for the visualization of variables with only one expression. By the way, the donut chart is closely related to the pie chart: The hole in the middle loosens up the image, thus providing (at least) an optical treat.

Chart-Typen: Pie chart

Pie chart

Chart type: Donut chart

Donut chart

Column and bar chart

Column and bar charts are also part of the basic equipment of every dashboard artist. This is called a bar chart when the columns are vertical.If the columns, pardon bars, run horizontally, it is a bar chart. For charting relative and absolute frequencies and their comparisons, these chart types are great, making them one of the most popular chart types, whether vertical or horizontal.

Chart type: Column chart

Column chart
Chart type: Bar chartBar chart

 

Stacked bar chart

Chart type: Bar chart stacked
Stacked bar chart

An important special form of the bar chart is the stacked bar chart. It is suitable for displaying scaled data and, thanks to the compressed representation, provides a quick overview – even over extensive result tables. Stacked bar charts are often used when you want to put results into so-called item batteries in the dashboard. However, it is important to have a good color choice that intuitively reveals, for example, approval (green) or rejection (red).

Line chart

Another well-known classic is the line chart. For comparisons of features or trends, there is hardly a better choice. For example, the results of various image measurements can be displayed and important differences made easily visible. For the visualization of time series, Datalion offers a separate time series , which has already been optimized accordingly.

Chart type: line chartline chart Chart type: polarity chartPolarity chart

If you want to compare two or more features and highlight differences, the Polarity Chart is great. This type of chart is often used in the case of usage trends or awareness measurements, since the presentation is equally clear and easy to understand. In addition, it is ideally suited for the additional integration of filters.

Radar chart

Chart type: Radar chart
Radar chart

Somewhat fancier is the radar chart. Visually appealing and meaningful, even larger amounts of data can be displayed. Typically, this type of chart is used to represent several evaluations, such as brand awareness. The prerequisite is that the variables to be compared have the same scaling. Each value is entered on an axis and evenly distributed to 360 ° around the zero point, for each category there is an axis. Not only in marketing radar charts regularly meet with a positive response and have many fans.

Wordcloud

Chart type: Wordcloud
Wordcloud

The wordcloud is truly a special case in this article, but can not be used to represent quantitative results. For qualitative data, however, the Wordcloud is worth gold: terms that are particularly common are displayed in a larger or more prominent manner. Words that are rare, smaller. This gives open ended questions an easy form to display and looks good. Well, it’s not quite that easy: depending on the question and the response, the results have to be adjusted and the words such as “and” or “me” have to be removed. If you still use the matching colors for the presentation, the Wordcloud could definitely be an eye-catcher.

Funnel chart

Chart type: Funnel chart
Funnel chart

Especially sales professionals have their joy on this chart type, as they allow the different stages of a sales funnel simple and impressive. But also characteristics of other gradients or phases can be elegantly communicated herewith. An important added value of the chart is that potential problems between stages of a process or process can be identified quickly.

Multidimensional scaling

Chart type: Multidimensional scaling MDSMDS chart

Also very effective is the presentation of multidimensional scaling (MDS). This is used, for example, to identify certain buyer groups and to clarify their respective differences. The combination of two features is reflected in the coordinate system, whereby the corresponding scaling can be read on the x or y axis. This form of presentation is not for beginners, but a must-have for data professionals.

Chart type: Scatterplot
Scatterplot

Incidentally, this also applies to the scatterplot chart : Similar to the MDS chart, values of two dimensions are displayed in a coordinate system. However, this type of diagram deals with the depiction of relationships between two variables or characteristics. It is easy to see from the pattern of points whether variables correlate and to what extent they do so.

Bubble chart

Rather, something for design lovers are bubble charts. The circles used can be used to compare the expressions of a variable, for example, when comparing different age groups within the variable “age”. On the one hand, the radius of the circles represents the size of the portion, on the other hand colors can also be used to illustrate the differences. However, if you are not a fan of “bubbles”, you better use the tree map : It works like the bubble chart, but uses squares instead of circles. This looks a bit tidier and the differences can often be better interpreted.

Chart type: Bubble chartBubble chart Chart type: TreemapTreemap

Chord chart

Chart type: Chord chart
Chord chart

A true piece of art can be the chord chart – if you use the right data. From a design point of view, this chart type is out of competition, but experience has shown that interpretation is difficult for many people. It shows relationships and overlaps between data in a matrix. For example, different groups of buyers can be identified. Once you have understood the basic principle as a dashboard user, the added value is huge. However, as a dashboard designer you should provide an explanation for this to happen.

Further chart types

You haven’t found what you are looking for? No problem, because there are many more chart types. In our overview you will find information on numerous forms of presentation, which can be used within Datalion dashboards. Here is an overview in German of the Datalion chart types and how to use them.

DataLion in Amsterdam and Paris

DataLion at the IIEX in Amsterdam

We are on the IIEX Europe from 18.-19. February as an exhibitor in Amsterdam. The IIEX – Insight Innovation EXchange – is the premier fair for innovation in market research. Of course, we should not miss that, since the possibilities that DataLion offers at the press of a button for creating tables and reports – paired with KI algorithms – are certainly among the most exciting innovations in the industry right now.

DataLion auf der IIEX

The full program can be found here . We have our own exhibitor kiosk on site. As usually, there are the latest features in our software, our new DataLion brochure, postcards, adhesive tattoos < / a> and Lion . In addition, a nice raffle for anyone who is willing to stick our adhesive tattoo.

Klebe-Tattoo von DataLion

DataLion at the BigDataParis in Paris

From 11-12. March meet us as an exhibitor in Paris. We are part of the Startup Villages . With more than 17,000 visitors, BigDataParis is the central European trade fair for big data. You can still sign up for free here . We would be happy to meet you there!

BigDataParis

DataLion in Amsterdam und Paris

DataLion auf der IIEX in Amsterdam

Wir sind auf der IIEX Europe vom 18.-19. Februar als Aussteller in Amsterdam. Die IIEX – Insight Innovation EXchange – ist die wichtigste Messe für Innovationen in der Marktforschung. Da dürfen wir natürlich nicht fehlen, da die Möglichkeiten, die DataLion auf Knopfdruck zur Erstellung von Tabellen und Reports bietet – gepaart mit KI-Algorithmen – sicherlich zu den spannendsten Innovationen der Branche aktuell gehört.

DataLion auf der IIEX

Das komplette Programm kann hier nachgelesen werden. Wir sind mit einem eigenen Aussteller-Kiosk vor Ort vertreten. Es gibt am Stand wie immer die neuesten Features in unserer Software, unsere neue DataLion-Broschüre, Postkarten, Klebetattoos und Lion. Außerdem noch ein nettes Gewinnspiel für jeden, der sich unser Klebetattoo stechen lässt.

Klebe-Tattoo von DataLion

DataLion auf der BigDataParis in Paris

Vom 11-12. März treffen Sie uns als Aussteller in Paris. Wir sind Teil des Startup-Villages. Die BigDataParis ist mit mehr als 17.000 Besuchern die zentrale europäische Messe rund um das Thema Big Data. Noch können Sie sich als Besucher für die Messe kostenlos hier registrieren. Wir würden uns freuen Sie dort zu treffen!

BigDataParis

Unfolding the full power of KPI dashboards

Key performance indicators or KPIs are not just a big issue in most companies since the growing importance of business intelligence software. However, it is very controversial which KPIs actually lead to success. Which are superfluous? Which indicators are more misleading than help? Even dashboard solutions are an indispensable part of KPIs, as they are the only ones that develop their full potential here. Imagine you are still late in the office finishing your presentation for the next morning’s board meeting. That’s where it helps if you can easily pull up the real-time KPI dashboard in BI system.

DataLion KPI Infoscreen

 On the one hand, the up-to-dateness and availability of the data can be continuously ensured by means of dashboards. On the other hand, the development of indicators over the course of time can also be presented in an attractive and supportive manner. Many KPIs perform their purpose much better, especially in marketing and market research, but also in management and sales. The sole use of static reports increasingly loses its right to exist in times of “real-time data”.

Targets are the foundation for every performance indicator

But which KPI should you choose for managing your business? This question is difficult to answer as the choice depends on several factors. It is worthwhile, however, to answer this question in principle for the company, as it simplifies internal discussions immensely. Otherwise, you waste a lot of time discussing different key figures, which may show different trends. Rather than better thinking about what the company needs now.

The right set of KPIs is essential

A key point in choosing adequate KPIs is the objective you pursue with your dashboard and the KPIs shown. A KPI should basically map what its business or a specific department wants to achieve, e.g. contacts with new customers (leads), reach or customer satisfaction. For example, sales operations should be supported in generating new customers as efficiently as possible. By contrast, marketing should achieve the highest possible return on investment (ROI) with regard to the use of the advertising budget. And in customer service, the number of complaints should settle to a low level.

Use of indicators is not an end in itself

Even this small discussion shows how different the goals of KPIs dashboards are. A key success factor is therefore that the use of indicators does not become an end in itself. The chosen KPIs must fit exactly to the objective and be able to represent the appropriate level of target achievement. Another mistake sometimes made is that the KPI chosen is the measure that is easily available or easiest to measure. An example would be e.g. use the number of demo account registries as KPI for leads, without checking if and how much the demo was actually used. In addition, it must be clear to all persons involved what the key figures and their characteristics mean and what blurriness is associated with the corresponding indicator. Even if one speaks frequently of hard numbers, you will be usually amazed, how much blur is also in seemingly “hard” controlling numbers.

KPI Dashboard

Customized KPIs can make more sense

No matter which KPIs you choose: Make sure that the key figures are actually relevant for you and all stakeholders are involved. Sometimes a meaningful indicator only results from the combination of two key figures. And in most cases, individual KPIs make more sense than popular indicators such as the Net Promoter Score (NPS). Everyone benefits, but their informative value can still be low for your concrete goal achievement. In any case, it pays to invest time in planning and to coordinate this with all stakeholders.   Another important success factor is the appropriate presentation of the key figures. By mapping past values ​​in the form of progressions, KPI developments can be presented very effectively. Good dashboard solutions offer extensive design options and make positive and critical developments visible at a glance. For time series the database must be updated regularly. The best is a real-time connection to the database via an interface, if one exists. Such a link has the additional advantage that the cost of maintaining the dashboard in the future is very low. In general, the more up-to-date the KPI is, the greater the informative value.

Customized views

KPI dashboards become even more effective if the possibility of filtering exists within the figures and gradients. Thus, the knowledge gain is often greater, if users can spend depending on the topic personalized KPI developments over certain periods, target groups, cost types, etc. Also the possibility to compare the filter selections usually brings a considerable added value. Last but not least, the motto “less is more” undoubtedly also applies to key performance indicators. A good dashboard, only features KPIs that are actually relevant to users. Even though there is no general rule on numbers, more than ten indicators and time series are more likely to confuse rather than achieve goals. Here are some examples of KPIs from business practice:

Sales KPIs

Net income

The net profit is the difference between revenues and total costs. It can be calculated for the entire company or even for individual products and is not only an important key figure in sales, but also a must in the management dashboard. It symbolizes the success or failure of the entire enterprise.

Growth

Being able to see graphically how much the company is growing (or even shrinking) in terms of its sales and revenues is an important support for decision-makers. Do processes have to be changed or optimized? This metric is also a must-have for businesses, but only if it’s always up-to-date. The revenue growth rates should be configured in the dashboard so that you can individually change the period for calculating the rate.

Customer acquisition costs (CAC)

Customer acquisition is a painful and expensive topic in many companies. Keeping an eye on the specific costs is also essential and says a lot about the long-term success of the company. Properly presented in a dashboard, acquisition costs regularly provide for wholesome surprises, as they are often underestimated.

Market research oriented KPIs

Customer Loyalty & CX

In customer-centric organizations, an up-to-date customer satisfaction KPI should be prominently placed on each employee’s dashboard. One challenge, however, is the meaningful measurement of customer satisfaction and its dimensions. Not only in large service departments representations in dashboards help to detect and eliminate grievances.

Net Promoter Score (NPS)

The Net Promotor Score (NPS) is a common measure of the likelihood of a customer recommending a company or brand. In some industries, this metric correlates with business success and is therefore standard on many market research dashboards.

Customer Lifetime Value (CLV)

Often used is the so-called Customer Lifetime Value (CLV). The CLV describes the value of a customer for a company, throughout the life of the customer relationship. What revenue is expected of the customer, what is his potential? By means of the CLV one can e.g. justify why you give different customers different care.

Brand Image

Just as important and challenging in measurement as customer satisfaction is the brand image. How well or badly is your brand perceived among your potential customers? The perception within the individual target groups plays a decisive role in purchasing decisions. With the help of a dashboard solution, you can identify important developments easily and early.

Data visualization: Six tips to build a perfect dashboard

Dashboard Oldtimer

In the age of big data, business intelligence and artificial intelligence, data plays an increasingly important role for companies. Dashboards are now widely used, bringing data to the point and thus becoming an important basis for decision-making.

But the optimal visualization of data still is a challenge. With the following six tips you will be able to build a great dashboard and save time.

1. Have a clear goal in mind

What sounds trivial is a common reason for overburdened and meaningless dashboards. First of all, ask yourself the following questions:

  • What do you want to achieve with your dashboard?
  • Who is the target audience for the dashboard?
  • What data do you need to display to get your target audience attracted?
Beispiel für KPI-Chart

It makes a huge difference whether you create a dashboard for your finance department, consumer research or marketing team. Although the database may be the same, users’ interests and priorities can vary a lot. Market researchers usually want details and with many drill-down options, whereas marketing colleagues often have more interest in central KPIs. A dashboard for the management board usually needs a lower level of detail than a dashboard for special departments.

It’s better to create different versions of a dashboard instead of trying to make everyone happy with one view. In modern dashboard tools you can quickly and easily adapt existing visualizations and then offer different versions separately.

2. Create stories with your data

Data and results have a special impact when told as a story. Focus on the questions your target audience will have and visualize the data in a logical and thrilling order. A dashboard needs a leitmotif. The order of charts should be based on the interest of the target group.

How should the user proceed from result A to result B? What data must be shown first to set the context for the following data? Storytelling within reports and dashboards is a very powerful way to get your target audience attracted. Further useful may be e.g. appropriate headings, interpretations and explanations. Pictures can help to clarify your story.

3. Focus, focus and focus

A very common mistake derives from the idea to provide as much data and results as possible. Overloaded dashboards with unattractive information for the target person, have no right to exist. The added value of a good dashboard lies precisely in bringing important information to the point. Simplicity and clarity are king. And if the user wants more information, you may provide him with some drill-down options.

But usually, it’s much more difficult to get things straight to the point than to get lost in details. Unfortunately, this applies to dashboards as well as to all other forms of data visualization.

4. Not only bar plots: choose an appealing design

Example: Aster diagram. This chart type is suitable for a comparison of different brands. In the center a benchmark value can be displayed.

Undoubtedly one of the most important success factors of good dashboards is a clear and appealing design. First of all, it’s about choosing the right visualization: bar charts can be very useful, but there are many other types of graphs to present data. Depending on the topic and objective of the dashboard, it could also make sense to use pictures or text elements. In addition, the corporate identity should be clearly visible.

Don’t worry: you don’t have to reinvent the wheel, there are many templates and examples of good dashboards out there.
Even with dashboards, orient to visual standards that users are already familiar with. Use known icons and navigation elements. A good UX design is key for making the dashboard an important tool in the company. Therefore, test the dashboard to some users before going live. But don’t worry: you don’t need a complex usability test scenario. But go out and watch your target audience during use and take the feedback to improve the dashboard.

5. Let the user play

A major benefit of online dashboards is that they are interactive, not static as PowerPoint reports or Excel spreadsheets. Provide users with the opportunity to delve deeper into data by offering filters or different target groups to choose from. So users can customize the dashboard for their purposes and “play” with data. This interactivity increases the added value of a dashboard and ensures greater use.

Keep in mind, however, that the more possibilities of analysis and customization you provide, the more you have to train users beforehand. Otherwise there is a risk of mis-interpretation. Finding the right balance between too much and too little data in a dashboard is an art.

6. Choose the right dashboard tool

Using a good dashboard software the key factors mentioned above should be implemented easily. But there are also some technical requirements to consider. Of course, the dashboard should also work on a smartphone or tablet device. And ideally in all common browser versions. Since data volumes are getting bigger and the time of your target group ever shorter, loading times must also be as short as possible. Flexibility in data sources is another feature that can decide between success and failure.

It is also good if a dashboard offers export interfaces to Powerpoint and Excel, so that results can be quickly compiled for Executive Board / offline reports as needed. And last but not least: most data is sensitive. Data security should be guaranteed and data protection rules have to apply.

Datalion’s dashboard solution provides the perfect tool to build good and successful dashboards.

DataLion 1.9 released

Experience more lion power – Embrace our new features!

There’s exciting news from DataLion: we released version 1.9 which includes numerous new features we’ve developed in close cooperation with clients & users. We have incorporated your feedback and suggestions gathered in the past months. Among new features like visualizations and export functions, we have also implemented several optimizations (e.g. loading time) and bug fixes.

In short, DataLion is faster, more flexible and more productive than ever. We hope you will love it!

Let’s have a closer look at some highlights:

Yes, more chart types!

Stacked column chart with option to display the mean or the sample size (Example):

Stacked bar chart with mean values

Extended donut chart e. g. for the comparison of Key Performance Indicators (Example):

Nested donut with arrows

New exports, New interfaces! Let’s check out the new export functions

Export of a dashboard or a report with more than one dashboard and charts as PowerPoint or Excel document

Export options

Export of an excel report with multiple tabs in an individually defined format:

Excel report exported with DataLion

Overview of our new features

Data Visualization

  • New chart type: stacked column chart with means and case numbers
  • New chart type: extended donut chart with means e.g. to compare KPI Values
  • Sort charts by mean value
  • Reverse order of stacked column chart segments
  • Top5, Top10 etc. for time series charts
  • Hide empty values and categories in time series charts
  • Separate filter dropdowns for each tab of a report
  • Export of wordclouds as image

Reports and Dashboards

  • Placeholder element in report/dashboard title
  • Read-only mode for read-only access profiles
  • Selected global filter remains across tabs
  • Automatic selection of comparison operators depending on the selected report filter
  • Individual dropdown-menus per dashboard

Settings

  • Adjustable precision of average values
  • Back-end definition of missing values
  • Set alignment and spacing in chart settings

Export features

  • Back-end configuration of pptx-exports and masters
  • Export of an entire report with multiple dashboards and charts as PPTX
  • Export of an entire report with multiple dashboards and charts as Excel
  • Export of an excel report in a pre-defined format

Metadata and import

  • Add of text fields via codebook
  • Automated incremental data update (e.g. backfill of last month, week)
  • Export of the codebook including special fields and text elements
  • Back-end function to delete and replace entire codebook

Various bug fixes and optimizations (load time, exports, imports)

Get started now and try our new version 1.9! We are looking forward to your feedback!

Rooaaarrr
DataLion