In the previous part titled ETL | Keboola Free – Creating a Project, Basics, we did a basic introduction to the application. We went through the process of creating a project and also briefly explored the Keboola structure and menu. Today, I’d like to show you how easy it is to create a Keboola flow.… Read More »
Before, it was a common practice that the management and access to corporate data for internal customers (employees from different departments) were exclusively under control of the IT department. If you wanted to request any report or data set, you had to contact IT. Then you waited for a few days until your turn came,… Read More »
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 »
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 »
What I have for you today is not an article but a questionnaire focused on GDPR (General data protection regulation), that is directive in force since 25/5/2018. This directive cancels Law no. 101/2002 Coll on personal data protection and brings many new obligations. I recommend to start elsewhere in case you do not know GDPR… Read More »
Dixons start new Business Intelligence project. Dozens of systems integrated, work in MS Parallel DWH, the biggest ecommerce solution in CZE. Would you like to participate on complex end to end BI solution?
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 »
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 »
SQL Server 2016 Reporting Services SSRS have changed significantly since their strongly outdated predecessors. Report manager is no longer present and has been replaced by visually attractive web portal thanks to which users are able to define KPI quantities. Mobile report publisher enables user to create reports compatible with mobile phones and tablets and it… Read More »