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 »

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 »

How to Connect to Google Analytics via Power BI Reporting Tool

What I will show you in this article is how to use Power BI to connect to your favorite web performance monitoring service Google Analytics. It is true that this service already has its own web interface but sometime you might want to edit your data prior to visualization or create your own reports. Connecting… Read More »

Power Query – Powerful Tool For Self Service BI – Introduction

MS Power Query is a very powerful business intelligence tool by Microsoft. As an Excel addin it can, together with Power Pivot, replace tools which were made only for experienced developers (SQL Server Integration Services etc.) The biggest advantage of this tool is the possibility to use a wide variety of connectors to data sources.… Read More »

Power BI Desktop – Powerful Report Tool Introduction

Power BI Desktop is a desktop app for report preparation. It is free and offers a user-friendly interface for data visualization and management. Reports and dashboards do look good in the Power BI. Data Visualization using Power BI Desktop Report making used to be a job mainly for IT developers. Regular business users were not… Read More »

How to Get Started With Power BI + BI Tools for Excel

Power BI is a cloud technology by Microsoft which enables user to analyze and visualize data easily. Creating reports is a task anyone can do. You do not have to be a programmer to use this tool. You will need just the basic user skills. Undeniable advantage is an ever-growing community, meaning that if a… Read More »