Category: Power BI

Power BI Tutorial: Get data from SQL, Excel, CSV, Web and Facebook, integrate everything into your model, create stunning DAX calculations and analytical reports. I created a new video «Power BI tutorial: learn with practical examples» that I want to share with you. Power BI tutorial As usual, this Power BI video tutorial is in…

Financial dashboards in Power BI are essential for analyzing the financial performance of companies. They provide a clear view of indicators such as actual performance, EBITDA, sales mix, liquidity ratio and debt ratio. These dashboards allow you to make informed strategic decisions and optimize costs and profitability. Additionally, there are other types of relevant dashboards,…

The Power BI Sales Dashboard makes it easy to visualize and analyze your business data. It offers advanced features for the segmentation of KPIs and descriptive elements (stores, spots, customers, products…) and global and detailed in-depth analyses. In this video I will show you a specific case of a commercial dashboardwhere you can navigate through…

In the previous post I presented my new book on Power BI, available in paper format and in ebook for Amazon Kindle: Impact with Power BI Bring value and control to your business by applying the fundamentals of BI. Transform your data into valuable insights and impactful presentations. This Power BI book includes a COMPLETE…

First of all, I present to you my new book on Power BI, available in paper format and in ebook for Amazon Kindle: Impact with Power BI Bring value and control to your business by applying the fundamentals of BI. Transform your data into valuable insights and impactful presentations. This Power BI book includes a…

I present to you the Books about Power BI which I think is more interesting. In fact, they are part of my personal library and I recommend you include them in yours too. They are books that you should read and put into practice everything they indicate. Furthermore, it is advisable to always have them…

In Power BI, SUM and SUMX functions have specific differences and applications. SUM performs a total sum of values ​​in a column, while SUMX performs row-by-row calculations and sums the results. SUM is recommended for adding values ​​from a single column, while SUMX is more flexible and allows you to perform operations on each row.…

Would you leave your finances in the hands of someone who knows accounting software (Contaplus, sage or any other), but who does not have the minimum financial and accounting fundamentals? Surely not. Why then do you use Power BI without the minimum basics of dimensional modeling? Power BI is a data model-based tool, but it’s…

Power BI in the cloud, but why not on-premise? …And why not, partly at your premises and partly in the cloud? …And why not be able to change the location of the various elements of your architecture as your needs and requirements change? Here you have the solution. In this article I want to show…

Loading budgets into Power BI is one of the most frequent tasks we apply in our Business Intelligence solutions. There are many ways to do this, but there are some more optimal ones to simplify the transformation and loading process. To do this, I recommend you follow these 3 steps: Edit some elements in Excel…