All eazyBI for Jira eazyBI for Confluence Private eazyBI

Training videos on specific topics

Here we have gathered video recordings from past eazyBI Community Days, prepared by eazyBI support consultants and developers.
Use them for shaping your eazyBI skills. Most of the training sessions are based on data from Jira; however, the concepts remain the same for other data sources.

Get Started

Jira Admin’s Journey to eazyBI

Time required: 20 minutes

When Jira admin becomes an eazyBI team member, it is so obvious to look at everything through the Jira admin “eyes”. Find out how did it go and what happened next on the journey. SMARTEN UP

Slides: Jira Admin’s journey to eazyBI.pdf

 

DEMO: How to Create Smart Reports without MDX

Time required: 30 minutes

When you are a master of MDX, no report is impossible. Now, using eazyBI new features, smart reports with trends, averages, and other seemingly hard calculations are just a few clicks away! Get familiar with eazyBI hidden gems - standard calculations, drilling into measures and others. SMARTEN UP

Slides: How to create smart reports without MDX.pdf

 

DEMO: eazyBI + Confluence: The First Date

Time required: 20 minutes

Get to know the new member of the eazyBI family. Did you know that collaboration could be measured? You will have a date with eazyBI for Confluence and a few use-cases for dinner. SMARTEN UP

Slides: eazyBI for Confluence the first date.pdf

Create Reports and Charts

Don’t Re-Invent the Wheel! Discover Sample Reports

Time required: 20 minutes

Have a quick start with eazyBI by re-using sample reports. Import reports from eazyBI demo accounts and save time. Learn more about key features for easy reporting. SMARTEN UP

Slides: Dont-re-invent-the-wheel.pdf

Paint With Your Data in eazyBI

Time required: 20 minutes

Create nice-looking and insightful reports in eazyBI using improved features–cell formatting, sparklines, and others. Use them wisely and your reports may become pieces of art with different layers of information. SMARTEN UP

Slides: Paint-With-Your-Data-in-eazyBI.pdf

Help, My Reports Are Too Slow

Time required: 30 minutes

There are different ways to build eazyBI reports. While it gives you flexibility, some of the methods tend to be better optimized for performance than others. We’ll share the ways how to reduce report performance problemsSMARTEN UP

Slides: Help-My-Reports-Are-Slow.pdf

It’s About Time

Time required: 30 minutes

Without time, everything would happen at once. Witness how you may integrate the Time dimension in your everyday reporting. SMARTEN UP

Slides: eazybi-about-time.pdf

Filter Data: How to Translate JQL to eazyBI

Time required: 30 minutes

Do you speak JQL? We speak eazyBI. There is a way to translate JQL to eazyBI report, and during this session, Zane will show how to find the subject, use a dictionary and deal with past tense.  SMARTEN UP

Slides: Translate JQL to eazyBI.pdf

Data visualization: How to pick the right chart type

Time required: 30 minutes

How to turn your numbers into knowledge? Your job is not only to separate noise from the data but also to present it the right way. How do you choose the right chart type and how to use different charts effectively? The do’s and don’ts or data visualization. SMARTEN UP

See also a blog post on this topic: How to Pick the Right Chart Type?

Slides: 21-data-visualization.pdf

 

How to Lie With Reports: Tips to Improve Your Data Literacy

Time required: 30 minutes

Information can be easily manipulated. How to read, understand, create, and communicate data correctly, to avoid misinterpretation and bad decisions. SMARTEN UP

Slides: How to Lie With Charts.pdf

Things to Know about the Burn-Down Chart

Time required: 30 minutes

The burn-down looks like the trend in progress tracking. A lot of different variations of this chart appear. Let us have a look at how those can be covered with eazyBI and dig deeper into how to make your burn-down charts even more flexible. SMARTEN UP

Slides: Things_to_know_about_burn-down_charts.pdf

 

Statistical Insights: From One-Click Solutions to Advanced Calculations

Time required: 30 minutes

Your company or project has grown over time, and trends become more important than separate facts. Then average, deviation, median, and other statistical measures come in help. Learn with Janis about different options eazyBI has on its sleeve to create statistical reports. DIG DEEPER

Slides: Statistical Insights.pdf

 

Where Did the Time Go: Discover Issue Cycles

Time required: 20 minutes

Time is a valuable asset, and the answer to the question “where did the time go?” helps to understand flaws in a business process. If you can measure it - you can improve it! In this presentation, you will learn about measuring issues traveling through time, defining and using Issue cycles, and building reports that allow you to take back ownership of your time. DIG DEEPER

Slides: eCD2023_Issue Cycles.pdf

 

Calculations with MDX

MDX ABC: Let’s start at the very beginning

Time required: 30 minutes

How to wrap a head around MDX calculations if you are not born as a developer? Start by recognizing MDX building blocks — sets, expressions, aggregations, and take time to understand eazyBI default measures. SMARTEN UP

Slides: 14-mdx-abcs.pdf

 

MDX debugging: How to see through calculated measure

Time required: 30 minutes

Do you ever wonder how calculated measure works and gets to the result? You will learn principles on how to disassemble the calculation to see the results of each step and how to find a faulty part in a formula to fix it. SMARTEN UP

Slides: 26-how-to-debug-mdx.pdf

MDX: Going Beyond 3D Reporting in Multi-Dimensional Data Cube

Time required: 20 minutes

Before diving into the creation of complex reports and calculations, it's essential to understand the concept of a multi-dimensional data cube and its building blocks. Start by warming up with the basics of retrieving data from a multi-dimensional data cube. SMARTEN UP

Slides: eCD2023_MDX.pdf

MDX: Understanding tuples

Time required: 30 minutes

A tuple is one of the calculated measure cornerstones. What exactly is Tuple in a multidimensional cube? How and when to use tuples in MDX formulas? Come to see some real-life examples in eazyBI. DIG DEEPER

Slides: 25-understanding-tuples.pdf

MDX: Handling sets in calculated measures

Time required: 30 minutes

Writing custom MDX calculations that work requires knowledge of basic concepts. A "SET" is one of them. Have you ever wondered what is inside the curly brackets, what means Members and Descendants? The presentation will explain how to construct and use sets in MDX formulas. DIG DEEPER

Slides: 23-handling-sets.pdf

Journeying with an MDX

Time required: 30 minutes

Do you ever get that feeling of confusion - seeing your measure returning one result while expecting a different one? Getting lost in the multi-dimensional cube is as easy as in real life! Let’s learn principles on how to disassemble the calculation to see the results of each step, so you know where you are and can get to the desired destination. DIG DEEPER

Slides: Journeying_with_MDX.pdf

 

MDX the Easy Way: Build Your MDX Calculations Gradually

Time required: 30 minutes

When you learn a new language you start by putting together two simple words, then adding an adjective as a third, and soon you have said a meaningful first sentence. Follow Ilze on how to create a new calculation from a scratch putting together elements gradually and adding more and more sense to the sentence in MDX. DIG DEEPER

Slides: Build Your MDX Calculations Gradually.pdf

Hidden Gems of MDX

Time required: 20 minutes

When it comes to writing MDX calculations, knowing your data and understanding measures and dimensions is crucial. However, some of those measures and dimensions are nowhere to be seen. Let me show you the hidden side of the data cube. DIG DEEPER

Slides: Hidden-gems-of-MDX.pdf

 

Flexible MDX formulas: How to Use VisibleRows and VisibleColumns

Time required: 30 minutes

Let’s continue mastering your calculation toolbox! eazyBI has introduced new functions to cover additional use cases when designing your custom formulas. Let us have a closer look on how VisibleRows and VisibleColumns functions work and what new horizon those functions unleash. Discover how to take your custom formulas to the next level and optimize your reporting with eazyBI. DIG DEEP

Slides: eCD2023_Visible_Rows.pdf

MDX vs JavaScript: Behind Complex Filters

Time required: 30 minutes

There might be different ways how you set up each project in Jira. And yet you still would like to see those projects side by side and analyze their performance. In Jira, you reach out to some complex JQL queries. In this session, I will talk about how eazyBI can help you analyze those cases. DIG DEEPER

Slides: Behind complex filters.pdf

 

Advanced MDX: Recipe to Change Report Context

Time required: 20 minutes

In this training session we’ll learn about relationships in eazyBI. Measures are at the center of it all, with unique relations to all dimensions. Sometimes, to answer your question, you need to redefine those relationships. Let me show you how to create new relations and connect measures with dimensions differently when defining new custom measures. DIG DEEPER

SlideseCD2023_Context_change.pdf

 

Advanced Training Video on Calculated Members and Measures

Time required: 1 hour

This video demonstrates different examples of calculated measures and explains how to create and use them in custom reports. DIG DEEPER

 

Data Mapping from Other Data Sources

Power-Up Reports With Additional Data Import

Time required: 30 minutes

Calculated members can be used for grouping and reorganizing data, but it may be easily overused. There’s a way to power up your reports, improve performance and save a lot of time and effort by adding a bit of external data from Google Sheets, Excel files, Rest API or creating custom hierarchies. DIG DEEPER

Slides: Power-up-reports-with-additional-data-import.pdf

 

All Paws on Deck: Discover Data Mapping

Time required: 30 minutes

At eazyBI, we use our apps daily to analyze data from our Jira backlog and Confluence documentation. However, what do we do when the data we want to explore is stored somewhere else? How can we bring them into eazyBI? Let’s explore data mapping through eazyBI pets and see if we are more of a cat or a dog company and what other surprises are hidden in the eazyBI pet back office. DIG DEEPER

Slides: eCD2023_Discover_Data_Mapping.pdf

 

Building Reports on Different Data Sources

Time required: 20 minutes

The presentation covers an introduction to how to get three separate data sources working together to create a joint perspective for your reports. DIG DEEPER

Slides: Building_reports_on_different_data_sources.pdf

 

Data from Jira and apps

Sprint reports with eazyBI

Time required: 50 minutes

Learn how to use Jira data to build insightful sprint reports with eazyBI. Understand the differences between Jira and eazyBI sprint reports, analyze multi-team and cross-project sprints, use time tracking, and more. SMARTEN UP

Slides:  eazyBI Sprint webinar 2021 sept.pdf

 

Tempo Planner reports using eazyBI

Time required: 60 minutes

Webinar recording on the integration between eazyBI and Tempo Planner as well as several useful use-cases. SMARTEN UP

Blog article: https://eazybi.com/blog/tempo-planner-reports-in-jira

 

Explore Insight Asset Management data with eazyBI

Time required: 60 minutes

Webinar recording covering the integration between eazyBI and Insight and several useful use-cases. SMARTEN UP

Blog article: https://eazybi.com/blog/explore-insight-asset-management-data-with-eazybi

 

I Want My Custom Fields, and I Want Them Now!

Time required: 20 minutes

Creating reports based on Jira custom fields is a fundamental cornerstone of eazyBI reporting: custom fields often contain answers to your unique business questions. Getting custom fields to the final reports is not always a stroll in the park. Learn how to get your custom fields into eazyBI the easy way. DIG DEEPER

Slides: eCD2023_Custom_Fields.pdf

 

Making Sense of Unstructured Data: Using JavaScript in eazyBI

Time required: 20 minutes

You can import and analyze Jira data based on measures, dates, users, teams, and other identifiable attributes. However, how can we uncover and analyze the data that may be hidden in plain sight? Let’s explore various techniques for modifying data to make it suitable for analysis. DIG DEEPER

Slides: eCD2023_Making_Sense_of_Unstructured_Data.pdf

 

Administration

Planning and maintaining eazyBI accounts

Time required: 40 minutes

How many accounts do you have? Are there too many or not enough? Right account setup is a cornerstone to get smooth reports for the right users. And did you know that you can analyze eazyBI with eazyBI? SMARTEN UP

Slides: 24-eazybi-account-management.pdf

eazyBI at Scale: Manage eazyBI in Large-Scale Jira Instances

Time required: 30 minutes

Keeping things in order is helpful in all organizations, but critical for large ones. Structure your eazyBI household giving freedom to your teams and overview for management, and spend less time maintaining. Daina will show how to scale your eazyBI using account management, customized settings, options to organize data, and much more. DIG DEEPER

Slides: eazybi scalability.pdf

Usage Statistics: Analyze eazyBI Report Performance with eazyBI

Time required: 30 minutes

Have you ever wondered what you can do to keep a good track of your reporting health? Which reports and dashboards need some optimisation or which accounts are more active and reports - most frequently used? In this video, Jānis will show you how to analyze eazyBI performance using eazyBI Usage statistics and what valuable information you can get out of it. SMARTEN UP

Slides: eCD 2022 Usage Statistics.pdf

Administration of eazyBI for Jira Server

Time required: 30 minutes

Overview of eazyBI infrastructure and configuration options. Built-in monitoring features and good-to-know things for running eazyBI. Some advice for configuration. SMARTEN UP

Slides: Administration of eazyBI for Jira Server JBA.pdf

 

eazyBI for Jira Cloud, Server, or Data Center: Where’s The Difference

Time required: 20 minutes

eazyBI works on all platforms–Cloud, Server, and Data Center. What can you expect when migrating from one platform to another? While the core functionality is identical on all platforms, there are some differences. Let’s compare them side to side. SMARTEN UP

Slides: eazyBI-for-Cloud-Server-DC.pdf