July 2023 Newsletter

09/08/2023

Dear WeQan Reader,

Discover our summer newsletter: trending articles, in-depth topics, and a recap of past events.

Don’t miss out our upcoming events for those who couldn’t attend the last ones 😉.

Also, enjoy a mini-article on ‘Monitoring the Data Extraction Process’.

So, let yourself be carried by the wind and dive into our world of Business Intelligence.

Our trendy articles

Qlik Sense GeoAnalytics

Geographical data is valuable for understanding geo-spatial data patterns. At WeQan, we utilize Qlik Sense GeoAnalytics, a powerful extension that enables mapping, visualization, and analysis of geo-spatial data. With these tools, businesses can make informed decisions and conduct strategic planning based on clear and accurate geographical information about their business set-up, including the flows of products and services between their different sites. and those of their customers and suppliers.

Read the article: here

Where to Find Information on Qlik Updates as a User?

WeQan - où trouver les informations sur Qlik Sense

Are you struggling to stay informed about the latest updates in QlikSense Cloud or Qlik Sense on Windows? Or perhaps you want to be up-to-date with the latest features in NPrinting, Qlik Alerting, or Replicate?

We’ve got you covered with the main sources (YouTube, Qlik Help) and any additional supplementary sources.

Read the article: here

Monitoring the data extraction process

Many customers have made significant progress in utilizing their data and creating dashboards. They are creating more and more dashboards and are connecting an increasing amount of data sources, which is wonderful!

However, there is a downside to this progress. With the proliferation of data sources and applications using this data, how can we be certain that they always use the correct and up-to-date data? How can we ensure that no one is accessing outdated or unused data? It was not simple so far to answer these questions. This was a missing link in Qlik’s suite of monitoring applications.

We have updated an application that was circulating within the Qlik community and have taken it a step further to provide BI solution managers with a comprehensive overview of the data being used: when, where, how often, and by whom are data extractions being used. BI manager can detect duplicates, stop obsolete processes, streamline extractions, harmonize data usage, identify potential anomalies, and finally ensure that the right data always reaches the right people.

We are finalizing its development and beginning to install it where multiple applications are deployed.

Our expertise in action: focus on our customer projects

Here’s an overview of the latest customer projects we’ve worked on:

Installation of a connector on SSIS for data extraction from Team Leader and creation of a Data Warehouse on SQL Server.
Migration of Power Query transformations to SSIS for important tables. Analysis and optimization of performance and data loading times with SSIS.
Development of an application to standardize, automate, and backup reports sent to clients via email. (Technologies used: Microsoft Forms, Power Automate, Outlook)
Implementation of a self-assessment and skills tracking application with automatic reminders. (Technologies: Qlik Sense SaaS, Automation, SharePoint & Teams)
Monitoring of data connections via REST on the Qlik Sense Repository (QSR).
Implementation of Business Central extractions via REST.

Implementation of an analytical connector.
Python application connected to Qlik Sense for geocoding addresses into GPS coordinates.
Creation and implementation of security rules to grant access to specific sheets and/or visuals within a Qlik application.
Development of a Qlik Sense application serving as a trigger for an Nprinting task (via Rest Connection). The task will create a folder and sub-folder structure containing personalized sales reports based on the user.
Development of a financial tracking and management application, previously in Qlik, now migrated to Power BI. This includes Revenues and Expenses analysis, Profit & Loss and Balance Sheet, Receivables, Payables, and more.

Could they be an inspiration source for your future projects? 😊

Summary of our latest events:

From May to July, we presented the latest innovations in Qlik Sense, organized a dedicated Power BI workshop, and shared the benefits of Power Platform.

These events were unique opportunities to share our knowledge, interact with all of you, get to know each other, and strengthen our connections.

A heartfelt thank you to all the participants, speakers, and partners for making these events memorable!

Season II of WeQan events

For those who couldn’t attend, a new series of morning events and workshops on Qlik and Power BI are now available:

🗓️ 08/09/2023: Qlik Sense – Special User Session

🗓️ 15/09/2023: Power BI – Beginner’s Workshop: Explore the Power BI environment

🗓️ 28/09/2023: Power Platform: Discover the Power Platform

Book now, as seats are limited!

PS: Feel free to invite one of your colleagues.😉

Register

WeQan training

We believe that continuous learning is crucial throughout one’s professional journey.

At WeQan, we offer Qlik and Power BI training tailored to your specific needs, catering to all skill levels!

Do you want to advance your knowledge and skills? Don’t hesitate to contact us!

Register

What a sensational quarter it has been, filled with rewarding events, training sessions, and fun team buildings, essential for relieving stress. It has truly been a vibrant and colorful quarter, just as we predicted!

As always, we are excited to continue this journey with all of you. Your trust in us is invaluable, and we are deeply grateful for it. We look forward to meeting you at our upcoming events to engage in discussions about your B.I. projects or questions. But until then, have a great holiday!

See you soon!

The WeQan Team