Most Ordered Product

Last Delivered Product

  • A multipage Power BI report with drill-through and navigation buttons is a dynamic data analysis tool. It provides an organized and engaging way to explore various data aspects. Drill-through capabilities allow users to dive deep into specific data points, while navigation buttons ensure seamless movement between report sections. This enhances the user experience and empowers data-driven decision-making, making the report a vital asset for comprehensive insights and interactive data exploration.

Dashboard in Dark Mode

  • This well-designed Power BI Dashboard with a dark theme features a clean, modern aesthetic look. 
  • The curved edges and simple geometric shapes demonstrate the modern feel. 
  • The background is a dark grey palette with minimal colors and fonts, allowing the focus to be on the user’s data. 
  • This same Dashboard is also available in Light color

Dashboard in Light Mode

  • The ULTIMATE Sales Summary dashboard.
  • Enriched with eye-catching colors and includes limited types of visuals for ease of understanding.
  • This simple-looking summary page holds more info than a three-pager dashboard.
  • This dashboard is also available in dark mode.

Interactive Work Samples

Nifty Tracker from Historic Data

Provided with Selection of Stocks and Investing Amount

DAX code for the trendline of the returns against each investment after the closing of each day. This DAX measure was coded keeping in mind that the client would be able to 

 - Select any number of stocks

 - Select the amount he/she is willing to invest

Then get the final outcome where they will be able to see how much money they would have gained or lost depending on the historical trading data

DAX Code Sample

                Interactive Work Samples

Sales and Growth Analysis

Sales and Growth Over Choosen Time-Period.

DAX Code used for Sales Point and Sales Line Visualization. These types of charts are perfect for SALES and GROWTH tracking and story telling while measuring the performance of different teams in an organization. 

Mostly used by Team-Leads and Senior Management. 

Top Ranking Visual Combo

Importance of Ranking Analysis

Top-ranking analysis of sales and profit by category and city in a sales dashboard is pivotal. It provides a clear roadmap for: 

  • Focused Strategy: It guides businesses to allocate resources and efforts effectively.
  • Performance Benchmark: Helps set clear benchmarks to measure the success of specific segments.
  • Strategic Growth: Identifies opportunities for targeted growth in thriving areas.
  • Risk Mitigation: Early recognition of underperforming segments allows for timely corrective actions, reducing potential risks to overall revenue and profit.

A well visualized Column chart made with the help of "Reference Line" and Conditional Color Formatting to compare and highlight the month with lower Unit sold count than the target 

Unit Sold Analysys Against Target Quantity

Unit sold Projection Against Target Value

DAX Code for Average Delivery Days

Concept of using multiple functions for complex calculations

Cumulative Delivery analysis

Cumulative Delivery analysis for online orders.

Weekly Product Analysis

Weekly Product Analysis with smart narratives. 

DAX Code for Last Saturday Sales

Usage of time parameters.

LIVE PROJECTS

LATEST PROJECTS


My Services

Power BI Reports & Dashboards

Report for

-Sales And Revenue Analysis

- Financial and Tax Analysis

-Crypto and Share Market Analysis

Custom DAX

-Time-Based Analysis

-Custom FIlters

-Dynamic Selection

-Color Formatting with DAX 

PowerApps

PowerApps-

 -Canvas App

-Model Driven App

Power Automate

Advanced Power Automate flow - 

-Cloud Flow

-Scheduled Flow

-MS Flow

Power BI Integration

Integration with

-SAP HANA

-CSV/Excel

-Google Sheet

-Azure Synapsys

-On-Premises Gateway

SSIS

Microsoft SQL Server Integration Service for ETL Process and data connectivity.


Skills & Tools

Power BI
DAX
SQL
Excel
POWER APPS
POWER AUTOMATE
Data Visualization
Business Solution
Built with Dorik