Power BI, Excel and other BI tools provide unparalleled power to gain insight, these tools though, do not necessarily prevent grave information design mistakes that are at best misrepresentations at worst plain lies. I recently came across a post where a self-proclaimed “Excel/Power BI Dashboard Trainer” was criticizing concepts -presented in a webinar by very […]
Welcome to the Managility Smart Insights BlogKeep up to date with the latest tricks & tips for planning, reporting and analysis.
I love discovering and exploring wines (within healthy limits) and recently came across a Kaggle data set with 150k wine reviews by professional wine tasters
Watching an interesting video on data science trends by a Google data scientist who recommended this data set as good practice, I recorded a video that documents my process
The Acterys product of our sister company utilizes large database pools with hundreds of customer databases. It is crucial for them to always be in control of current resource consumption levels
Excel is still the tool of choice for most planning & forecasting processes but are new technologies like Power BI a better option?
In this overview we are comparing analytics & planning options for cloud based accounting applications (QuickBooks, Xero, Myob)
Power BI offers fantastic ways to integrate data from online sources. Often it is useful to just use parts of that and extend your own data set with details from an online API.
In this blog we cover how you can automatically load Power BI activity logs (or any other Office365 activity) into a database for detailed analysis across all workspaces in your tenant.
Planning, forecasting & simulation are some of our key focus areas. Recently, we did some benchmarks what the optimal configuration
A requirement that we face very often in our projects is to be able to easily re-use multiple measures particularly when dealing with similar data models