Welcome to the Managility Smart Insights Blog

Keep up to date with the latest tricks & tips for planning, reporting and analysis.

Easy Sentiment Analysis for Twitter

In this post we are covering how the new Microsoft Flow can be used to insert data from Twitter with sentiment analysis into a Power BI streaming dataset. Create streaming dataset in PowerBI: Go to PowerBI.com -> Then “Streaming dataset” --> Create streaming...

USING PROFESSIONAL DEVELOPMENT TOOLS WITH JEDOX

In this post I would like to share my view on few challenges I faced  by embarking on a large project powered by Jedox, which incorporated writing of several thousand lines of code (macro): Challenges: 1. Editor Simplicity: Jedox is more geared towards business users...

SUCCESS FACTORS FOR PLANNING AND BUDGETING SOLUTIONS

Key Criteria For Effective Processes Planning is typically a dreaded activity, often involving inefficient convolutes of spreadsheets and related maintenance nightmares.  Managility specialises in the implementation of effective solutions to run as much as possible...

REALISING POSTAL CODE SHAPES IN GOOGLE MAPS IN JEDOX WEB

Hi, hope you enjoy my first post. I am a Senior Consultant at Managility specialising in the ETL, report development and custom visualisations. Recently I faced an interesting challenge at a Managility client who was looking to visualise sales employee performance...

THE POWER OF WIDGETS

Jedox Widgets One of my favourite features in Jedox Web are widgets. Widgets are an option to integrate Third party web services and functionality easily in your report. The start is very easy: Just Create a new workbook and choose Tools>Widgets>Custom Widget:...

EXCEL A BUSINESS INTELLIGENCE TOY

Over the years I have lost count how many times I have heard the mantra “Excel is just a toy you can’t use for serious Business Intelligence”. Typically from “IT experts” that never had to work with a BI solution from an end user perspective. In part this statement is...