Power BI is the game-changer in the area of Business Intelligence. In this section, you will find Power BI articles. There is not only information about this exceptional business intelligence tool (available for free in its basic version), but also about useful tools that are used as add-ins in MS Excel.
These tools are Power Pivot and Power Query (now natively in Excel). They are useful for creating business intelligence solutions in Excel (data imports, transformations, data modeling).
Update: Power Query and Power Pivot are now natively in Excel
Don’t miss out from category:
DAX language has 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. How do parameters work in DAX?… Read More »
Email from MS landed in my inbox few days ago. It states that Power BI introduces new product called Power BI Premium valid since 2Q 2017. Hand in hand with this announcement comes another one of quite high importance. It will not be possible to share dashboards in the Power BI free product. Some Pro… Read More »
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 »
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 »
Powerpivot in excel is an add-in automatically pre-installed in MS Office 2013 + (all you need to do is add it to the ribbon). It is not present in previous Office release therefore it is needed to download it, install and then allow. Enabling Power Pivot in Excel Download add-in from following URL (Windows 7… Read More »
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 »
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 »
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 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 »