logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Magic of Flash Fill
October 4, 2019
Cut and Paste Using Spike
October 23, 2019

Spare 30 Seconds and get Insight to 6 Amazing Features of POWER BI!

October 18, 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

1
2

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.

3

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

4

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.

5

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.

6

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.
Shreya Gadia
Share
4

Related posts

May 19, 2021

5 POWER BI TRICKS THAT WILL BLOW YOUR MIND


Read more
December 13, 2019

November 2019 update


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'