I will create excel dashboards using power query and pivot tables

India

I speak English, Bengali, Hindi

Excel Data Analyst

Specialization in Excel Data Analysis, Power Query ,Power Pivot, Pivot Tables, Dashboard Development, and business reporting. Cleaning Messy Data, Transform Raw Datasets, Automate repetitive tasks, Bu...
About this Gig

 Inventory & Financial Control Dashboard

Description of Project: Developed an excel based Inventory & Financial control Dashboard for a retail hardware business. 

Integrated sales, purchaser, stock, payment and receipt data using Power query and power pivot. Built KPI cards, Pivot table, charts, 

and slicers to provide real-time insights into sales, inventory, cash flow, debitors and creditors, helping improve business monitoring

and decision making

Technology:

Excel

Power BI

VBA

Analysis type:

Quantitative analysis

Statistical analysis

Expertise:

Business Insights

Trends

Statistics

Programming language:

SQL

DAX

Other