After sponsoring PASS BA Conference 2016 in US, we will fly to Liverpool and sponsor SqlBits 2016, the biggest SQL Server gathering in Europe and UK. It will be our pleasure to see you all there. We’ve previously announced that we will speak in this conference. So it would be great to see you either Read more about RADACAD sponsors SqlBits 2016[…]
It is great pleasure to announce that we will be sponsoring PASS Business Analytics Conference 2016 which happens between 2nd and 4th of May 2016 in San Jose, California, USA. This conference targets business and data analysts. There will be sessions in four main tracks in this conference which takes you through the Analyst’s Journey; Read more about RADACAD Sponsors PASS BA 2016[…]
Almost couple of weeks ago Power BI update added the new functionality in security. This functionality enables you to apply row level security to roles and add users under each role. This is really helpful when you want people from one branch, city, department, or store to be able to only see their part of Read more about Row Level Security in Power BI; Regardless of Data Source[…]
In every reporting solution you might feel KPI as a requirement. KPI or Key Performance Indicator is a measure for business to understand how they are acting in specific area that is very import for their business. Power BI supports built-in visualization for KPI, and there are also some good custom visuals that can be Read more about KPIs and Power BI; Visualization Aspect[…]
Power BI free allows you to have 1GB data per user, and pro 10GB. However in many organizations you have much bigger size of data than 10GB, sometimes you deal with Tera bytes, even Peta bytes of data. Is Power BI limiting you for the visualization? Short answer; No! In this post I’ll explain you Read more about Step Beyond the 10GB Limitation of Power BI[…]
Turning columns to rows, or rows to columns is easy with Power Query and Power BI. There are many situations that you get a name, value data source, and wants to convert that into columns with values underneath. On the other hand many times you get multiple columns and want to change it to name, Read more about Pivot and Unpivot with Power BI[…]
You can create relationships in Power BI between tables. Relationships are useful for some functions to work across multiple tables and produce the result. Relationship between tables also makes visualization and report elements more efficient, because result of selection in one chart can affect another chart from different table. However there is a limitation in Read more about Relationship in Power BI with Multiple Columns[…]
If you be familiar with Power Pivot you know that there is a functionality in Power Pivot for setting a table as a Date Table. This enables time intelligence functions such as year to date to work properly over your data model. However this option is not available in Power BI Desktop. There is no Read more about Secret of Time Intelligence Functions in Power BI[…]
Calculated tables first introduced in September 2015 update of Power BI Desktop. The name speak for itself; these are tables created by calculation. As these are in-memory tables their calculation is based on DAX (Data Analysis eXpression language). There are many benefits of using Calculated tables, such as using them for role playing dimensions (for Read more about Scenarios of Using Calculated Tables in Power BI[…]