Power BI Desktop Introduction #2 - Import & Transform Data
In this video we will import and transform data from 3 different sources into Power BI Desktop. Download the exact files used by me in this video series here - https://www.computergaga.com/_excel/files/subscribers.zip Power BI Desktop includes an almost identical Power Query Editor experience to what you may be familiar with in Excel. There are tons of connections to common data sources, and an extremely powerful language and functionality to transform messy data. In the video, we will import data from a folder, from Excel and also from a text file. Some basic transformation are made and all the data loaded into Power BI Desktop. The fact table which is created from 2 files stacked together from a folder has over 900,000 rows of data. This is used as an example of how comfortable working with large data sets (they can be a lot larger) is in Power BI Desktop. You can find more information on Power BI Desktop here - https://powerbi.microsoft.com/en-us/desktop/ Check out the previous video where we discussed what is Power BI Desktop? And demonstrated how to download it - https://youtu.be/uGfx-FPtulA Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel