New Navigation Pane in Microsoft Excel
New Navigation Pane in Microsoft Excel is very useful feature to see and understand the different elements like - Worksheets, Shapes, Charts, Ranges, Pivot Tables, Tables etc. in a workbook.
Tag: BI Dashboard
Annual Sales Calendar for Sales Dashboard in Excel
In this article, we have created an Annual Sales Calendar for Sales Dashboard in Excel. You can use this Sales Calendar in your sales dashboard. We have used the Combo
KPI Dashboard with Tooltip in Excel
In this article, we have created Chart Tooltip in KPI Dashboard in Microsoft Excel. You can use this trick to show the details of a number with the chart. We
Comparative Analysis Dashboard in Excel
This is the Excel version of the Comparative Analysis Dashboard. We have used Power Pivot to create this dashboard. We have used Current Year Sales Vs Previous Year Same Period
3 Ways to use the Drill Through in Power BI
In this article, you will learn 3 different ways to Drill Through in Power BI. Drill through is used to navigate different pages within the report with the filter of
Infographics in Power BI dashboard
In this article, you will learn how to use Infographic Designer Visual in Power BI. This Visual can improve the beauty of your Power BI Dashboards. Using this Visual, we
Dynamic Hourly Project Planner (Gantt chart)
Using Gantt charts for project management is not a new concept. Still, with the advent of advanced Excel features, creating a dynamic hourly Gantt chart has become more accessible than
Daily Sales Report – Data Extraction from multiple PDF files
In this article, we have created a Daily Sales Report (DSR) in Microsoft Power BI. We have extracted and consolidated the data from multiple PDF files using Power Query. After
Static and Dynamic Row Level Security in Power BI
Row level security with Power BI is used to restrict data access for particular users. Filters restrict data access at the row level, which are defined within roles in Power
Quality Analysis Dashboard in Power BI
In the article, we have created a beautiful Quality Analysis Dashboard in Microsoft Power BI. We have used sample data to create this dashboard. In this dashboard, we have displayed