Archive - January 2020

For ensuring the top performance of your Power BI dashboard, you need to pay particular attention to data modeling. Here are the most recommended practices that you need to take into account:- Do not use wide tables – There a lot of issues that can crop up because of the use of wide tables. The most common issue is simply performance. In a wide table, you are adding redundant values, again and again, so you are not making the most optimum use of your memory. In case your dataset keeps growing you can simply run out of memory Other issues that can crop up due to wide tables is building relationships between two wide tables, you can end up with bi-directional and M-N relationships that can be difficult to work with. To overcome these issues, it is recommended highly to use a star schema or a constellation schema for the[…]

Power BI is an excellent tool for data visualization. The tool enables the user to connect it to external API’s. This power is especially useful as these days a lot of apps and websites have API’s to use for BI purposes. For the sake of this tutorial, let’s work with the twitter API. Similar can be done for other API’s you just have to change the first step which is related to creating tokens necessary to access an API Important Note:- The method I am going to discuss in this article only works with API’s that do not have a redirect URL or it is optional. For example, the API for twitter fits this description. If an API has a redirect URL, for example, that of Spotify has a redirect URL so in that case a custom connector needs to be built. That is covered in a separate article on[…]

Power BI is an important tool and famous tool for business intelligence, In this article, we will go over some basics of how to use Power BI, which will include. Connecting Power BI to google analytics Connecting Power BI to an external API Connecting Power BI to a SQL Database Connecting Power BI to google analytics Step 1 Connect Power BI to google analytics by clicking on the Get Data icon in the top bar, and in the list of available sources select google analytics as a source. Integrate GA and then select the different metrics/ desired chart time and filters for the report Step 2– Change dates  Then going forward you can change dates to get the report for the desired time frame Steps 3 Add the required reports to a dashboard CONNECT POWER BI TO API STEP 1 – Get Data  Click the Get Data icon and select[…]