# Advanced data analysis

Perform advanced analyses effortlessly with Inforiver in Power BI. 

(a) Use the Top N feature to filter the top/bottom 'n' across categories and show the rest as 'Others' 

(b) Leverage the advanced AND/OR filtering option to perform nested filtering including filter groups 

(c) Perform automatic grouping based on classification/segmentation rules 

(d) Export to Excel retaining all the formatting performed such as background, number formatting, in-cell annotations, footnotes etc. 

(e) Leverage other options like - Smart Analysis, Quick formulas, Insert Rows, Manage Columns 

... and more

{% embed url="<https://lumel.wistia.com/medias/ytmzmebpng>" %}

> ## **Related resources**
>
> #### User guide
>
> [Top N + others](https://docs.inforiver.com/working-with-inforiver/3.-basic-interactions/explore-and-filter-data/top-n)
>
> [Search and filter](https://docs.inforiver.com/working-with-inforiver/3.-basic-interactions/explore-and-filter-data/search-and-filter)
>
> #### Blogs
>
> [Dynamic and nested Top N + Others in Power BI](https://inforiver.com/blog/general/dynamic-and-nested-top-n-others-in-power-bi/)
>
> [5 ways to supercharge your Power BI conditional formatting](https://inforiver.com/blog/general/supercharge-power-bi-conditional-formatting/)