Author: nikilprabhakar

Power BI Tutorial: Transform data from folder data source

Data for the tutorial can be obtained by downloading CSV files from: https://www.census.gov/popest/data/intercensal/state/ST-EST00INT-02.html For the tutorial I downloaded data for Alabama, Alaska and Arizona into a folder. Open the CSV files, and notice that all of them have the same layout. In this tutorial we are going to: Read data from the folder data source

Continue reading

Power BI Tutorial: How to implement Currency Conversion Using Power Query and Power Pivot

Data for the tutorial can be obtained by downloading the following files:      Exchange Rate File Working with Currency File Step 1: Load Sales Data to Data Model Open workingwithcurrency.xlsx, highlight Sales Data table, pick PowerPivot from the ribbon and select Add to Data Model Step 2: Using Power Query to transform Exchange Rate data

Continue reading