• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: BI Dashboard

On object interaction in Power BI
Power BI

Enhance Your Power BI Experience with On-Object Interaction

March 19, 2023March 21, 2023 PKComments Off on Enhance Your Power BI Experience with On-Object Interaction
In this article, we will discover the benefits of using on-object interaction in Power BI, learn how to enable this feature, and understand the limitations and known issues. What is
Read More
Simple Dashboard in Excel
Dashboard

One Pager KPI dashboard in Excel

February 15, 2023February 17, 2023 PKComments Off on One Pager KPI dashboard in Excel
Excel is a widely used tool for businesses and individuals for data analysis, tracking, and visualization. Excel Dashboard is an effective way to present complex data in a simplified manner,
Read More
3D Glass Chart in Power BI
Power BI

Power BI dashboard with 3D Glass Chart

January 23, 2023March 5, 2023 PKComments Off on Power BI dashboard with 3D Glass Chart
Data visualization is an important part of modern businesses. It helps companies to make decisions based on data-driven insights. Microsoft Power BI is a business intelligence tool Which provides the
Read More
Sparklines in Power BI
Power BI

Sparklines in Power BI

May 17, 2022May 17, 2022 PKComments Off on Sparklines in Power BI
Sparklines are the small charts that can be created in the Table/Matrix cell to show the trend of over the period. We can use the sparklines in the Power BI report also. It
Read More
Profit Analysis using What if Analysis
Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PKComments Off on Profit Analysis Dashboard using What-if Parameter
In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard.   [caption id="attachment_57629" align="alignnone" width="1920"]
Read More
Daily Sales Dashboard
Dashboard

Daily Sales Dashboard in Excel

April 5, 2022April 5, 2022 PKComments Off on Daily Sales Dashboard in Excel
In this article, we have created a Daily Sales Dashboard to analyze the Daily Sales trends. We have displayed 4 metrics in this dashboard- # Of Calls: The number of
Read More
Energy Consumptions Dashboard
Power BI

Energy Consumptions Dashboard in Power BI

March 1, 2022March 1, 2022 PKComments Off on Energy Consumptions Dashboard in Power BI
We have crated this Energy Consumption Dashboard in Microsoft Power BI. We have explained step by step data transformation in Power Query, Creation of the Relationship between fact & dimension
Read More
Time Series Forecast and Anomaly Detection in Power BI
Power BI

Time Series Forecast and Anomaly Detection in Power BI

November 25, 2021November 25, 2021 PKComments Off on Time Series Forecast and Anomaly Detection in Power BI
In this article, we have created the Time Series Forecast and Anomaly Detection in Microsoft Power BI. You can use this for Data Analysis, Sales Forecast, find Outliers in your
Read More
New Navigation Pane
Excel Tips and Tricks

New Navigation Pane in Microsoft Excel

November 14, 2021November 14, 2021 PKComments Off on New Navigation Pane in Microsoft Excel
New Navigation Pane is very useful feature to see and understand the different elements like - Worksheets, Shapes, Charts, Ranges, Pivot Tables, Tables etc. in a workbook. How to Open
Read More
Sales Calendar in Excel
Dashboard

Annual Sales Calendar for Sales Dashboard in Excel

September 5, 2021February 15, 2023 PKComments Off on 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
Read More

Posts navigation

1 2 Next
  • Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT