Looking back: Data & Analytics Line Up 2022

Want to know what's on sale for dashboarding or data integration solutions? Want to compare data science solutions? Or would you like to see Low Coding platforms in action? This and more was discussed at the Data & Analytics Line Up 2022!

During this event Steven Koppenol, Manager IT & Data Analytics at Visma | Raet told his story:
How does Visma create business value through the smart use of data analytics and automation? What choices has Visma Raet made in its landscape, what have they learned from this and how will this develop in the future?

Keynote speaker Bas Nijhuis, top Eredivisie soccer referee took us through his great love for soccer and what goes on in the life of a top referee. In addition, Bas made connections between the world of top sports and that of business. The use of technology and innovation in making choices is a nice parallel between the world of top sports and our theme for this day.

Furthermore, this day was all about comparing the best Data & Analytics solutions. We are happy to share with you the presentations that were given.

We will take you through solutions like Tray.ioTimeXtenderAlteryxAzure Machine LearningAuto ML (Pycaret)Microsoft Power BITableau and SAP Analytics CloudMicrosoft Power Apps & Automate and Outsystems via the form below.

Would you also like to see the best Data & Analytics solutions side by side?

The slides below are interesting for anyone who wants to innovate but is not yet sure which tools are needed to do so or wants to experience and compare the capabilities of other solutions.

Tell us which slides you want to see and download them instantly!

Download your slides now!

Got inspired by the slides, or want to be invited for the next Data & Analytics Line Up? Contact Frank via frank.boudestijn@rockfeather.com!

Become a better admin with the Power BI Admin Dashboard

• Monitor your Power BI tenant
• Get an overview of report updates
• Gain insights of report usage

What is the Power BI Admin dashboard?

The Power BI Admin dashboard is a monitoring tool for people overseeing Power BI users. The dashboard gives you the ability to monitor everything that is going on in your organisation’s workspaces at once, all while making an accessible overview in a Power BI report. By using the data collected from the Office 365/Azure portal, a Power BI Admin can create a report using user statistics and log files.

What can it do?

  • Monitor Power BI tenant, across workspaces instead of focusing on one workspace
  • Monitor which Data Sources are being used on Dashboards
  • Know whether you’re overpaying for your Power BI licenses
  • Get insights into by whom/when/how your reports are being used
  • Know when there are Datasets refreshing errors and know the distribution of refresch times across the tenant
  • Get insights into how much a report is being used
  • Create a quick overview of user access for each workspace
  • See how many reports, dashboards, and datasets have been made

How is it different than Power BI Report Usage?

While Power BI Report Usage can only be used on a Workspace Level, the Power BI Admin Dashboard gives you full control of data on both a workspace, as well as, on a tenant level. Simply put, it gives you more insight into your organization. Additionally, the dashboard allows you to create clear visuals from table data, something you are unable to do in Power BI Report Usage. Furthermore, this dashboard gives you full insights on refresh schedules and statuses, giving you the average duration of a refresh and a detailed report about the reason why it failed. Lastly, the Power BI Admin Dashboard lets you analyse Activities from the moment you started using the dashboard, instead of only the last 30 days like in Power BI Report Usage.

What is a good use case of Power BI Admin Dashboard?

Every day at 9 in the morning you refresh a financial report and monitor its usage by members of your team throughout the day. By analyzing this, you notice two distinct peaks in activity, one at 10 in the morning and one at 9 in the evening. While the views at 10 in the morning is within normal working hours, the views at 9 in the evening certainly are not. Using the cross-filter functionality in the Power BI Admin Dashboard, you are able to check which team members are checking the financial report at which time of the day. From this view you also notice that certain team members have not been able to view the new data and you can help them out by fixing the issue. Essentially, the Power BI Admin Dashboard gives you the necessary insights for your team to perform at the top of their game.

Advantages of Power BI Admin:

  1. Can be managed on a tenant level
  2. Find clear connections between data to improve usage of the dashboards
  3. Shows historical data, helps to see trends
  4. See which users are using your reports and which users are not yet using it but do have access
  5. Create more insights from log files/user statistics

The tools that were used to create the dashboard:

  1. Graph APIfrom Azure
  2. Power BI rest API
  3. Logic Apps in Azure
  4. Azure SQL Server
  5. Power BI

Tools that we decided not to use:

While the above tools can result in a similar dashboard, the reason we choose to work with Logic Apps is because:

  • Logic Apps is better suited for extracting small datasets with up to 100 rows of data. Since we do API calls that generate these smaller datasets, in our case we do an API call for each Power BI dataset in the tenant. Therefore, using Logic Apps is more cost efficient compared to other tools like Azure Data Factory that are made for transferring larger sets of data.
  • Logic Apps is a low code tool, meaning that it is both easier to read and use for citizen developers compared to writing code for other tools, like Azure Functions. Additionally, understanding the logic, flow of data, and debugging/troubleshooting is easier in Logic Apps.

You can achieve the same goal of extracting data with almost every ETL tool, however Rockfeather works with Azure Cloud because of its ease of use and native integration with Power BI.

Rockfeather & The Power BI Admin dashboard

While working with customers we’ve noticed that Power BI admins were not happy about limitations in monitoring their Power BI tenant. The Power BI Admin dashboard gives Power BI admins the options to go around these limitations. First, we’ve been able to give Power BI admins the option of analyzing data from an extended period of time. Secondly, by showing non-essential licenses, we’ve been able to help Power BI admins cut down on costs. Lastly, by being able to get an overview of who was able to access reports that they shouldn’t have access to, we could improve on data security.

Within Rockfeather, we use Power BI as our BI-tool and we have several different reports published on our tenant. Using the capabilities of the Power BI Admin Dashboard we are able to check whether our data was refreshed successfully, look at the activity on different reports, and check which of our dashboards are used most often. This way, we don’t have the hassle of checking five different dashboards throughout the day, we are now able to spot which reports are most important for our team members, and we can see how our dashboards are being used over a longer period of time.

An architectural overview of the Power BI Admin Dashboard can be found below:

the archetecural structure of a Power BI Admin Dashboard

Or if you want to try our anonymized Power BI Admin Dashboard yourself and see which cross insights we created? You can click around in our published report:

If you want to know more about the implementation of this, please reach out to us and we’ll help you with the implementation process. We use templates and/or solutions that are easy to deploy.

Preventing churn - rockfeather

Artificial Intelligence is ready!

In this interview, Jonathan Aardema talks with Prof. Eric Postma (professor of Cognitive Science and Artificial Intelligence at the University of Tilburg) about the why, how, and what of artificial intelligence applications. What do we see in practice, and what does science say about it? 

Read more
Tableau Partner Executive Kick-Off 2020

Visiting London for the Tableau Partner Executive Kick-Off 2020

Every year Tableau invites its most valuable partners to kick off the new year together. The theme for this year was Accelerate, so let’s get right to the point. This exciting event was focused on three main areas.

Read more
Mastering DAX

Mastering DAX

Keeping your skills up to date is crucial when you work with the newest technology. At Rockfeather, we challenge each other to be the best version of yourself. That’s why I attended the mastering DAX course. DAX (Data Analysis Expressions) is a formula expression language. Next to Power BI, DAX is applied in Excel Power Pivot and tabular models in SQL Server. Learn it once, use it tomorrow.

Read more
All posts

The Future of Data & Analytics 2022

The Future of Data & Analytics 2022 took place on June 14. During this yearly event, passionate speakers inspired us by shedding a light on how they implemented a successful data & analytics strategy.

What were the key take aways from the event?

The three focus areas of this edition were:

  • Learning how your organisation can use the most recent trends in terms of digital transformation and the adoption of data and analysis.
  • Discover how you can maximize your marketing efforts through the power of data driven marketing, completely based on facts.
  • Become inspired by the best practices of different speakers’ that share their stories on how to successfully implement a data & analytics strategy.

Keynote speakers

Deborah Nas, keynote speaker, author and C-level sparring partner in the field of technology and innovation.

Deborah knows how to entral her audience with her inspiring presentation filled to the brim with surprising and relatable examples. During her presentation, she places technological developments in both a societal, as well as a business context. This gives the audience an understanding of what these developments mean in the here and now, but also in the future.

On top of that, is Deborah the author of Tech Innovator’s Guide “Design Things That Make Sense”, a manual for innovators that want to maximize the chance of success for their innovations and implement technology in a useful way

Tom Coronel, Speaker, Entrepreneur & FIA WTCR en Dakar Rally driver
Tom has many years of experience in international motorsport and won races in multiple disciplines in the sport. Additionally he runs multiple very successfull webshops.

During the event, Tom shared his experiences with innovation and having to trust technology in motorsport. Moreover he talked about the importance of working as a team in any discipline.

Organizations in practice:

Feyenoord – Edwin Suk, CIO – “A datadriven football organisation”

Edwin Suk, CIO of Feyenoord, talked us through how a professional football club uses data & insights in order to manage the organisation, both internally and as a  football organisation.

Stedin – Sophie de Kok, Lead Digital BI lab – “How does Stedin use technology to manage a complex business?”

Stedin uses different technologies on both the financial side and non-financial side of the business in order to make managing Stedin more insightful. Sophie shared how the best solutions in the field of Data Visualisation and Low Code help Stedin’s different departments to work more closely together.

Visma – Tom van Dael, CFO – “The digital transformation strategy at Visma | Raet”

Tom van Dael, as the CFO of Visma | Raet, oversees how Visma puts their digital transformation into practice. During his talk, Tom talked about the different steps Visma | Raet had taken during the process and what the company achieved as a result of these steps.

CB – Arjan de Jong, Manager Logistics Services – “Predict the demand for production planning”

CB as a large logistical business needs to continuously be able to predict the demand of books. The better CB can anticipate on the demand, all the better they would be able to match this demand in their storage facility. In his talk, Arjan spoke about the Data Science techniques that predict the demand for CB and how they can increase their surface level while lowering their costs.

Alexander Mik, Data Science Consultant Rockfeather, and Robbin van Wijk, EPM Consultant Finext – “De waarde van advanced forecasting modellen binnen Auping.”

There have been a lot of developments in the world of forecasting. For example, during the fourth Makridakis Competition in 2020, it was determined again that complex statistical models (machine learning and neural networks) perform better than more traditonal forecasting methodes. During their talk, Alexander and Robbin showed how  advanced forecasting models went up against traditional forecasting methods at Auping.

Interested in more?

The presentations from Sophie de Kok from Stedin, and Arjan de Jong from CB are watchable if you fill out this form below.

Are you interested in knowing more about the content of the presentations? Or are you inspired and want to know how you can use the latest trends on digital transformation and data analytics for your organization? Reach out to Paul Damen!

Take a look at the presentations!

Take a look at the presentations!

  • Presentation of Sofie de Kok: Stedin @ The Future of Data & Analytics 2022

    Download
  • Presentation of Arjan de Jong - CB @ The Future of Data & Analytics 2022

    Download

Related events

Test Drive TimeXtender

Wil jij jouw datawarehouse ook professioneel laten groeien? Meld je dan aan voor onze Test Drive en ervaar de voordelen van dé integratie-oplossing: TimeXtender!

Taal workshop: Nederlands.

Data Science Summer School

Rockfeather organiseert samen met de MOA de Data Science Summer School. Op drie achtereenvolgende vrijdagen (12, 19 en 26 augustus) maak je kennis met diverse Data Sciences methodes en technieken en leer je ze toepassen.

Meer weten?
All events
Low Coding for Marketeers

Deep Dive Power Apps and Outsystems

In this webinar our experts compare Power Apps and Outsystems for Low-Code on four aspects. In just over 10 minutes, you will learn the difference between the two solutions.  Don't miss out and watch this Deep Dive!

Language webinar: English.

Low-code is the modern approach to developing, deploying and managing applications. Develop a new application from scratch in a fraction of the time? Or create a faster, more intelligent version of an existing application? A Low-Code Application Platform makes it possible for all developers of different experience levels to easily and quickly create custom applications for web and mobile. But which platform is best for you?

To help you make better-informed decisions, our Power Apps and Outsystems experts developed a deep-dive webinar. In this webinar our experts compare Power Apps and Outsystems on four aspects. In just over 10 minutes, you will learn the difference between the solutions focusing on:

  • Data Connection
  • Front End Development
  • Integration of Business Processes
  • Use case for both solutions

Sign up below and view the webinar instantly!

Watch the webinar!

tableau-test-drive

Online Workshop Tableau

In deze gratis workshop leren we jou in anderhalf uur hoe jij data kunt laden en visualiseren met Tableau. 
Vul onderaan deze pagina je gegevens in en bekijk de workshop direct!

Ga aan de slag met Tableau in onze gratis online workshop. Leer in één middag hoe Tableau jou kan helpen om processen te optimaliseren met waardevolle analyses door gebruik te maken van jouw data.

In deze gratis workshop leer je hoe jij jouw data kunt laden en visualiseren met Tableau. De interactieve dashboards helpen je beter “data-gedreven” beslissingen te nemen en effectief te communiceren binnen jouw organisatie. De workshop is bedoeld voor nieuwe Tableau-gebruikers, maar ook als je al eerder met Tableau hebt gewerkt, kan het nuttig zijn om aan deze workshop deel te nemen.

De workshop richt zich op de volgende twee vragen:

  • Hoe kun je eenvoudig meerdere gegevensbronnen combineren, visualiseren en communiceren?
  • Hoe krijg je snel waardevolle inzichten uit deze data met behulp van Tableau?

Vul hieronder je gegevens in en bekijk direct de online workshop Tableau!

Bekijk de workshop!

rerun-webinar-churn

Online Workshop Power BI

In this online workshop, you will learn about several key features of the Power BI service. This introductory course is designed to teach you step-by-step how to create Power BI Desktop reports. Fill in your details to view this session!

Language workshop: Dutch.

Power BI is echt een onmisbare tool geworden. Talloze bedrijven gebruiken deze visualisatieoplossing uit de Microsoft-stack. Maak gebruik van deze mooie gelegenheid om Power BI te leren kennen met onze gratis online workshop. In slechts een paar uur tijd leer je hands-on wat deze oplossing voor jou kan betekenen.

Tijdens de workshop laten wij je de belangrijke functies van de Power BI-service kennen. De Test Drive is een inleidende cursus die bedoeld is om jou stapsgewijs Power BI Desktop-rapporten te leren maken. Het doel hiervan is dat jij na afloop voldoende kennis hebt opgedaan en over de volgende skills bezit:

  • Gegevens laden vanuit Microsoft Excel
  • Gegevens te manipuleren om ze voor te bereiden voor rapportage
  • Een rapport met verschillende visuals maken

Bekijk de workshop!