New collaborator

We welcome a new consultant to the team: Mahdi. A senior consultant specialized in the Microsoft suite (Power Bi, Power Automate, Power Forms, Sharepoint…), he has also worked on data-science projects developed in Python. We welcome him among us!

An idea of some of the projects we have been working on this past quarter

• Evaluation of a Qlik Sense migration project to the Power BI suite.
• Development of Qlik Sense reports on data coming from the SAP ERP, on the modules: SD, AR, FI
• Migration from Qlik On-Premise to Qlik SaaS
• Custom SSO: JSON Web Token (JWT) authentication.
• Adaptation of Qlik Sense reports following an ERP migration, from Wings to Sage 100.
• Qlik GeoAnalytics type analyses with QS SaaS thanks to GeoOperations, which is included by default in Qlik Sense SaaS. For those who don’t know it yet, Qlik Sense GeoOperations allows geographic calculations and functions such as route or travel zone calculation. It also allows you to load geographic data from a wide variety of data sources and solve geographic problems with your data.
• Set up a single sign-on (SSO) between Microsoft Azure and Qlik Sense Enterprise on-premise.
• Implementing a data quality/reliability monitoring and alerting solution in case of discrepancies.
• Construction of dashboards where the data is refreshed at high frequency (live data).
• Construction of dashboards for customer satisfaction management.
• Production of a report that presents the annual accounts according to the accounting headings of the NBB format. A huge time saving for a group with multiple companies.
• Qlik Sense report for a purchasing department to manage orders according to the stock status and open orders.
• Development of a project with Power BI and SSIS + Power Automate

Qlik News

Qlik Cloud :

Qlik Sense Saas, also known simply as Qlik Cloud, continues to be updated regularly. In the new features of October, November and December, we will retain the following elements:

• Reports written on Qlik Application Automation can now include elements from different applications.
• For added security, you can bring your own encryption keys to Qlik Cloud to ensure control over your data.
• ODBC connector performance has been improved with Bulk Reader functionality for faster database loading.
• Better customization of donut charts: Choice of border size / color / thickness
• You can now create reports in PowerPoint format with Qlik Application Automation. More freedom on the placement and aesthetics of the elements.

To see all the new Qlik Cloud features released in the last quarter, check out our article on the subject.

Qlik Sense On-Premise :

The latest release in November 2022 includes the following new features:

• Additional stylization (fonts, colors and icons) on a number of graphic objects.

• Handling of reloading tasks in the hub (for users with appropriate permissions).

• Users can now add bars on the secondary axis in a combined chart.

• Customizable background color for KPIs (replacing some cases where an extension was required).

• Empty streams (for security reasons or simply because there are no applications in them) are now hidden.

• Added an object for playing videos.

To know all the latest features released in November 2022, go see our article on this subject.

Power BI:

In the last quarter, Power BI updates have brought the following features:

• The y-axis can now be separated and made independent for each multiple graph. This allows for a more intelligible scale of values.
• You may be using highlighting of items in your analysis? Now you can pin the highlighting status (Bookmark)
• Added five new DAX functions that make comparison calculations easier: INDEX, OFFSET, WINDOW, PARTITIONBY and OREDERBY.
• Users can now personalize their subscriptions by including the changes they have made to the filter selection. This way, they receive the most relevant information directly by e-mail.

See our article for our complete release note and details of all the new features.

Our latest articles

• Over the past few months we’ve been reviewing the latest software releases from Qlik. This includes the August 2022 update to Qlik Sense On-Premise and the latest features added to Qlik Cloud in November.
• We also had the opportunity to talk about how BI is used in the retail industry. Qlik’s interface helps to collect data from product locations on the shelves. This allows for quick analysis of the collected data.
• Did you know that you can easily integrate content from Qlik Sense into Microsoft Teams? In a short article, we explain how to share your sheets / applications / elements from your Qlik Sense projects in Teams.

The magic of Christmas comes to the office

Maybe some of you don’t recognize our offices anymore ? Yes, we have recently moved to a bigger space at 4 Avenue des Eaux Vives, in Genval ! We are looking forward to welcoming you there !

Conclusion

WeQan would like to thank you for your trust throughout this year. Thanks to you, it has been a year full of multiple and enriching projects and it has allowed us to extend our expertise to new solutions and technologies.

We hope to have met your expectations and we are looking forward to continuing and even intensifying our collaboration in 2023.

Our ambition will remain to help you better exploit the potential of your data. In this perspective, WeQan will continue its growth by welcoming new collaborators in 2023.

We wish you a Merry Christmas and a Happy New Year, full of exciting and rewarding opportunities for you and your loved ones.

PS. Follow us on LinkedIn and Facebook to get the latest news about WeQan in 2023: our projects and solutions, our offers, our technical ‘Tips and Tricks’ but also our team building activities.