Power BI Desktop has a native support for creating and rendering R visuals using various libraries supported and R script visual. ggplot2 is one of them and the most widely used package in R to build custom graphs & visuals. ggplot2 is based on the grammar of graphics, the idea that you can build every … Continue reading Develop Custom Visuals in Power BI using R (ggplot2)
Modern self-service BI products like Power Pivot in Excel and Power BI Desktop are often used to mash up data from different sources. Once multiple tables are imported into the model, users can create relationships among them to create a data model so that they can easily slice and dice data using any column from related tables as long as … Continue reading Modelling Complex Relationships in Power BI Desktop
Scatter plots allow us to place points that let us see possible correlations between two features of a data set. Let's see how we can create them with ggplot2 in Power BI. The standard ggplot2 syntax for creating scatterplots is outlined below and require different sets of input commands than shown in the previous blog … Continue reading Create Multiple Scatterplots using ggplot2 in Power BI – Part 1
There are several functions in M (the query editor language in Power BI) that can be used to merge/joins two tables of data. In today's blog post, we will explore how you can join different tables in Power BI Query Editor using Mashup language. The syntax pattern for joining two tables is similar for all the … Continue reading SQL Joins/Merging in Power BI using Query Editor
Microsoft has finally released the September 2017 Update for Power BI Desktop with a ton of exciting features added in the Reporting area. There are five major features contain in this release which makes Power BI strong enough to choose over other self service BI vendors. We will discuss each of these one by one. … Continue reading Power BI September 2017 Update
DAX (Data Analysis eXpressions) introduces the functions RELATED and RELATEDTABLE for following & navigating through the chain of relationships in Power BI, Power Pivot & SSAS Tabular and It is used to retrieve related data from another table. Both of these functions are more powerful than VLOOKUP in Excel in a couple of ways. First, … Continue reading The Magic of RELATED & RELATEDTABLE functions in DAX
Traditionally, business intelligence projects tend to use a star (Kimball) or snowflake(Inmon) schema; a design approach that has become the de facto design standard for data warehouses and cubes over the last few decades. Below is an example of a star schema: The center of the star is called the fact table. It describes the … Continue reading How do relationships work in Power BI?
In today's post, we will learn two new techniques to load the Power BI Desktop data to the SQL Server or any other ODBC database. Technique 1 : Using R Script in the Query Editor Window In this technique, we will leverage the power of R in the Query Editor. You can use R script … Continue reading Export Power BI tables to SQL Server database using R
Power BI Team has finally released the August 2017 update for Power BI Desktop and It came up with the balance of few essential features which was pending since the long time to fill the visualization customization gaps & few new features to enhance the data modelling experience. It's good to have updates every month! … Continue reading Power BI August 2017 Update
