Magic of Flash Fill
October 4, 2019
Cut and Paste Using Spike
October 23, 2019
File Size
Does your Excel file hang due to size? Excel takes an hour to open the file. The Solution to this is Power BI/ Power Pivot. Store your data in backend and reduce your file size to almost one-fourth.
File Size in Excel
File Size in Power BI
Connect your Data from Multiple Source
Power BI allows you get data from multiple sources. Moreover, the list of applications from where one can get data into Power BI is exhaustive. It includes applications like Excel, SQL, Text/CSV, Web etc.
Pivot- Unpivot
Power BI has an amazing functionality to pivot and unpivot columns. You have bulk of data and performing transpose in excel is difficult and cumbersome. Moreover, at times the excels transpose is unable to provide you with the desired result. Perform few simple steps and transform the data in form you want to with Power Query Pivot and Unpivot inbuild functionality. The Pivot functionality turns your rows to column while the reverse holds true for Unpivot.
Forecast Trends with Chart
The Power BI Charts come in with many in-build features. You want to forecast the value of stock prices based on current trend or sales, use Power BI Charts and it will do the same. You can even specify the confidence interval
Apply Conditional Formatting to your Charts
Want to use conditional formatting for your charts! Power BI is the solution for the same. Format your charts based on values, conditions etc. with the in-build filter feature in Power BI. The image below shows highest values highlighted with blue while the lowest ones are in red.
Card
Use cards in Power BI to represent major data like unit price, sales amount etc. One can also CONCATENATE text and amount using function CONCATENATEX and represent the same using CARD. EXCEL doesn’t have any in-build functionality for the same.
Contributor: Shreya Gadia
Qualifications: B.Com (Hons.), CA, CFA (US) Level III Candidate I am working as an Analyst at Leveraged Growth. I have experience in MIS and Automation, creating Excel & Power BI modules, preparing equity research reports and single handedly managing consulting and content development projects.
