When creating a budgeting prediction, most of the time we are creating it on the higher granularities. Rarely we do it on a daily basis. But sometimes we are required to match budgets to actual sales on lower granularities than the one we previously set (e.q. the manager wishes to see how would the budget …
How to split budgets to lower granularity with DAX (PowerBI) Read More »
High cardinality columns are often the problematic part of the data modeling in most environments, including PowerBI. Since the PowerBI data model resides on a columnar database, having high cardinality columns impact both performance and the size of the model. This is especially the case with columns having more than 2 millions of distinct values. …
Optimizing distinctcount with reduced memory consumption in PowerBI (VertiPaq) Read More »
In this article, we will see how to combine different dimensions and facts inside a single matrix table visual. This approach helps us create fewer measures and tables, but at the same time, it provides us with greater design possibilities, like conditional formatting across the whole column even though there are different measures invoked inside …
PowerBI One Measure for Multiple Dimensions/Facts – DAX Read More »
In the report below, you can see how PowerBI is becoming more googled term than Microsoft Excel in most of Western Europe and Australia.
Regardless of the people job title, preparing and analyzing data becomes an integral part of their work. Most people for this purpose use Excel, because it is the fastest and most flexible tool for processing and analyzing data. But as the data sources and analysis needs increase with each day, traditional methods of processing and …
PowerBI has a lot of visuals that can help you visualize geo-data. I’ve used most of them, and I can guarantee that none of them come even close to the newly introduced Mapbox Visual. Even those that are pay to use like ArcGis has some flaws (slow rendering time, terrible Heatmap, limited lasso etc). Mapbox …
With the finals just around the corner, hope you will enjoy exploring the main statistics of the World Cup! 🙂 *The data comes from free online sources so I cannot guarantee 100% accuracy. If you access the report through mobile platforms, please switch to landscape or choose a full view. The report is not optimized …
World Cup Russia 2018 PowerBI interactive dashboard Read More »
ABC analysis is one of the most commonly used categorization techniques. This technique divides subjects of analysis (Products, Customers, Inventory, etc.) into different categories based on subject importance. The analysis is based on the Pareto principle which states that the most economic productivity comes from only a small part of the economy. It is mainly …
The Internet is full of valuable online free sources which, if used correctly, can bring great incremental value to company employees. One of those sources is Eurostat, the statistical office of the European Union. On the official pages of Eurostat, you are able to pull pretty much any statistical data about the Macroeconomic environment of …
EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard] Read More »
Data is stored everywhere around us. It depends on us to use all available sources to create a useful set of information which will help us drive our business forward. The data was around us since the expansion of the world wide web, but only recently did technology evolve enough to provide us with the …
Temperature Averages in Croatia (PowerBI Interactive Dashboard) Read More »
EXCEED Solutions d.o.o.
Drežnička 21, 10000 Zagreb, Hrvatska
OIB: 25417969805
MBS: 081124327
IBAN: HR6523600001102641074
info@exceed.hr
+385 98 9461 471
Ured: Modruška 2, 10000 Zagreb
Designed and powered by Adssential
