Category Archives: Power BI reporting

Power BI is the upcoming game-changer in the area of Business Intelligence. In this section, you will find a Power BI blog. There are many information not just about this exceptional business intelligence tool for free (basic version for sure), but also about useful tools, which are used as add-ins in MS Excel.

These tools are Power pivot, Power Query and Power View. They are useful for creating a full business intelligence solution... List of Articles in category »

Sales Report in Power BI and Direct Query into SQL Database

Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second option. That is connection using direct query which secures live connection to data source. We will prepare simple Sales report by few clicks. (as in video).… Read More »

Power BI Gateway – Introduction Into Tool For Report Refresh/Update

It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update the cloud data when the source file is located on your PC/server and “the cloud service does not see the data”? One of the ways is to… Read More »

FILTER Functions for Power BI in DAX – Overview

FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions as is nested parameter and enable dynamic calculations. They often serve as a value filter for function  CALCULATE. Mostly it is the case of typical member… Read More »

Aggregation in DAX – How Aggregations Work? + Function Overview

Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into more simple and reportable form using aggregation. We can for example sum up (SUM, SUMX) some financial metrics by individual category or express maximal/minimal (MAX, MAXX,… Read More »

Function DAX CALCULATE – Aggregation With a Condition in Power BI

CALCULATE is an important function for a large number of calculations and for those of you who actively do DAX formulas in Power BI or PowerPivot. Understanding of how the function works and how it is used does not look simple at first glance. And that is why this article is here. Syntax function: CALCULATE(… Read More »

DAX RELATED Function for Power BI – Lookup Into Table

Function REALTED is very frequent and useful in DAX language. We can use it for example when we need to search table (A) for value from other table (B). And finding the according value is the exact task of this function. Syntax is very simple: How Come RELATED Function Needs Only 1 Parameter? Data organization… Read More »

DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI

You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing. Some aggregate functions have another similar function ending with X – for example SUM and SUMX or COUNT and COUNTX. These functions often give same results… Read More »

DAX Difference Between Measure and Column + Example on Report

We can create two types of new values using DAX in Power BI or PowerPivot. They are calculated measures and columns. Difference between measure and column and its understanding is another major step in order to understand DAX language for Power BI. New measure or column in Power BI is added by clicking right mouse… Read More »

DAX language – Introduction into DAX for Power BI and Powerpivot

DAX language (Data Analysis Expressions) servers for data management and editing prior reporting in Power BI or Powerpivot, similarly to function set in Excel. This language is able to return values based on use of functions. We can either enrich, add or analyze data prior reporting in Excel, and DAX enables us to do the same.… Read More »

Parameters in DAX – Introduction into DAX Expressions

DAX language haves its standards as does any other language. This article sums up and describes how look the parameters of formulas. In other words, this article is about function arguments overview.  It is good to know parameter categories appearing in this language to effectively use parameters in DAX. What is Function Parameter in DAX?… Read More »

MS BI Developer Skill Set – List of Knowledge and Abilities

What I have for you here today is a different kind of stuff. We will take a look at what should BI developer working on Microsoft technologies be able to do. I put up together a list of knowledge and abilities which I consider important for this job. I gave each skill rating (1-10) according… Read More »

Power BI Report (Dashboard) Tutorial Step By Step

This article is meant to be some kind of a tutorial. After going through it, it should be clearer to you how to create Power Bi report like this on your own. Following this, you can create basically any report you want – company operation report (timesheets, wages, investments), financial analytics (balance sheet, income statement,… Read More »

Power BI Custom Visuals – Additional Visualizations to Power BI Desktop

Were you ever creating a report and did not find a feature in your Power BI Desktop that would enable you to visualize data according to your needs? What are Power BI Custom Visuals? Custom Power BI visuals were created by members of power BI community – programmers, users, and fans of this wonderful tool.… Read More »

Power Query, Power Pivot and Power BI – What’s the Difference?

Best way to understanding of the differences between individual Power BI tools is to realize that every tool has some role in the whole processing of the final report. In standard MS Business intelligence we have tools by which we ensure data transformations (SSIS), processing of data model with data storage in relation structure (SQL… Read More »

Microsoft Power BI – 10 Reasons to Use It

1 Zero Investment Power BI uses so-called freemium model strategy. This means you can use Free version with some limitations but this will not be any problem for the majority of use cases. 2 Visually Perfect Reports Reports look good and can be made fast and easily. Take a look at some of the reports… Read More »

Getting Started with Power Pivot – Data Modeling in Excel

Powerpivot is an excel add-in enabling data modeling and analysis in familiar Excel environment which is certainly an advantage. Import big amounts of data through Power Query and connect them to each other using PowerPivot One of the upsides of power pivot is possibility to connect multiple data sources into one excel. It even do… Read More »