PowerBI

How to set up and configure a forecasting system in just a few clicksImage by the Author.Time-series forecasting has become a ubiquitous tool for businesses, governments, and individuals alike. It is nowadays being applied in almost every domain imaginable: in finance to predict stocks and interest rates, in healthcare to predict hospital bed capacity, in transportation to plan routes and traffic patterns, in energy to predict power supply and demand, and the list goes on.Consequently, there exists a need for a…

How a complex and cutting-edge approach, creatively borrowed from computer vision, can be implemented in just a few clicks.Image by the Author.IntroductionWith an ever-increasing number of applications and services deployed worldwide, time-series anomaly detection has become a ubiquitous and indispensable tool for capturing metric regressions.However, setting up an anomaly detection system is certainly not straightforward and often requires a fair amount of domain expertise. In PowerBI, the set-up can be done in just a…

A step-by-step guide/demonstration using public income and digital boundaries dataImage by authorPowerBI is a popular business intelligence reporting tool for most companies. In addition to the common use case of visualizing structured tabular data, it’s also able to read in geospatial data and turn them into interactive visualizations where reference layers such as average income for a particular region can be added to understand potential demographic patterns and relationships.Digital boundaries divide maps into…

Tips to improve PowerBI performance (Part 1)Photo by Campaign Creators on UnsplashCreating a report is simple. Anyone can do it. However, what distinguishes professionals from others is the report’s performance. Performance is crucial when delivering the report. Improving the performance of Power BI can have several benefits. First, it can make the tool more responsive and easier to use, which can improve user satisfaction and productivity. Second, faster performance can allow for more complex and data-intensive…

After failing many times to create a Gantt Chart using existing visuals, I decided to build one myself using a matrix visual in PowerBIThere was actually a PowerBI visual that I was already using for creating Gantt charts. However, when I tried to share it, I realized it was impossible without getting a paid subscription. You need a subscription not only for yourself but also everyone else that needs to see your Gantt Chart.Photo by Bich Tran: https://www.pexels.com/photo/photo-of-planner-and-writing-materials-760710/I…