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 »

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 »