Freelancer logo
Log In Sign Up
Post a Project

EXPLORE

Data Entry Data Processing Data Visualization Excel Visual Basic
Profile cover photo
User Avatar

Sartajullah B.

@subaigfalcon

annual-level-three.svg
5.0
7

3.4

3.4

91%

DataAnalyst║Adv.Excel║PowerBI║QBS║Finance║Research

$10 USD / Hour

・

Flag of

Pakistan (8:33 PM)

・

Joined on December 23, 2023

・

1 Recommendation

$10 USD / Hour

・

I’m Sartaj Ullah, a versatile Data Analyst with strong analytical and problem solving skills, passionate about turning complex data into clear, actionable insights. From cleaning messy datasets to designing dashboards and streamlining financial reports, I help businesses unlock the full value of their data. I bring a strong analytical mindset and solid experience in Data Visualization, Data Analysis, and Data Science. As a dedicated full-time freelancer, I excel at turning complex data into actionable insights. I create impactful dashboards that enhance decision-making, streamline operations, and drive financial success. ✅ Cloud Accountant and Bookkeeping Specialist ✅ Data Analyst (MS Excel, Power BI & Tableau) ✅ 10+ years of solid working experience ✅ MBA (Accounting & Finance) CERTIFICATIONS: Quick Books: ✅ QuickBooks Online Certified - Infruit Quick Books Microsoft Excel: ✅ Mastering in Data Analyses - Alison, Galway, Ireland ✅ Essentials of Data Visualization - Acacia University, Arizona, USA ✅ Certificate in Information Technology - Sindh Computer Training Institute, Karachi, Pakistan ⭐ AREAS OF MY EXPERTISE ⭐ ☛ Quick Books ☛ MS Excel ☛ Power BI ☛ Tableau ☛ R ☛ Data Visualization and Data Analysis for Actionable Insights ☛ Build Power BI report using DAX and Power Query ☛ Clean & prepare data ☛ Data Science ☛ Power Query ☛ Calculate metrics & KPI that define your business ☛ Fully Customized Excel & Google sheet Automation System ☛ Interactive Dashboards and Reporting I have a strong grasp on but I am not limited to, ☛ Annual Financial Reports ☛ Financial Planing ☛ Financial Models ☛ Forecasting & Budgeting ☛ P & L, CFS, BS ☛ AP & AR ☛ Bank/Account Reconciliations ☛ Inventory Management ☛ Payrolls ☛ Taxes ☛ Invoice/Receipts ☛ Billing My objective is to provide high quality services to my clients and 100% satisfaction is my core concern. If I am selected, I wish to do my best efficiently and accurately to fulfill the requirements as you wish. If this sounds like a good fit, let’s connect and build a long-term, profitable partnership. I’m confident I can deliver real value to your business. Thanks for visiting my profile — I look forward to working with you!

Verifications

On time

100%

On budget

100%

Accept rate

92%

Freelancer Excel Experts Pakistan
See all Excel Experts in Pakistan

Portfolio

Portfolio

12422767
Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

12427302
With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

12449479
Course Summary: 1- Sorting, Filters and Pivot Tables 2- V lookup, H lookup And Goal Seek 3- Data Analysis 4- Big Data Management 5- Pivot Tables 6- Data Validation

Mastering Data Analyses- Certificate

12427280
I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

12473812
I offers you with a variety range of services including but not limited to: • Excel Macros • Excel Formulas • Excel Dashboards • Excel Automation • Excel Models • Solver • User forms • VBA • Pivot Tables • Data Processing • Data Cleaning • Data Analysis • Data Validation • Data Analysis • Data Visualization • Data Manipulation • Power BI Dashboards Do not hesitate to send me message before placing an order to discuss scope, price, and output template desired. I will not charge you until you are completely satisfied. Hope you have a good day.

Formulas, Macros, VBA, & Automations

12531431
Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

12422767
Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

Data Scope 1- 2013-2014 Matrix Required 1- Total Gross Sales, COGS, and Profit View for four Products. 2- Cards to show the selected Product. View Required 1- Gross Sales View 2- COGS View 3- Profit View Key Factors of this dashboard 1- Custom Sorting 2- Bookmarks 3- Comparisons with Multi Products Objective Gross Sales Summary 1- Country wise Gross Sales Performance using Stacked Column Chart 2- Discount Band wise Gross Sales Performance using Ribbon Chart 3- Segment wise Water fall chart Monthly COGS Performance Stacked Bar Chart with four Products Comparison 1- Country wise COGS Performance 2- Discount Band wise COGS Performance 3- Segment wise COGS Performance using Donut Chart Profit Summary Monthly Profit Performance using Matrix Table with Product Comparison 1- Discount Band wise Profit Performance using Multi Row Card 2- Segment wise Profit Performance using Pie Chart

Finance KPI Dashboard in Power BI

12427302
With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

With my sleek & modern design sales dashboard is in a single page with maximum information has been covered. Product Level comparison section is very useful to analyses and compare month on month & yearly for different metrics. It provides an overview of key performance indicators such as sales volume, revenue, Profit, Order priorities, Continent wise segments, Top selling products, month & year wise product reports, & customer acquisition. The dashboard includes interactive charts and graphs that allow users to easily visualize & compare data across different time periods. It also allows users to drill down into specific data points for more detailed analysis. Insights and Key Functionalities using this Sales Dashboard 1. The dashboard is made up of three worksheets: Data base, Pivot table sheet, and Dashboard. 2. Use both Pivot table & advance formulations in pivot table sheet. Use Slicers to filter the data & analyse sales, revenue.

Dynamic Sales Performance Dashboard

12449479
Course Summary: 1- Sorting, Filters and Pivot Tables 2- V lookup, H lookup And Goal Seek 3- Data Analysis 4- Big Data Management 5- Pivot Tables 6- Data Validation

Mastering Data Analyses- Certificate

12427280
I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

I can make a dynamic dashboard that’s not only shows your sales data in a nice way but also allows for real time updates & easy interactions. The underline excels data base that I use for creating dashboard. This excels file comprises three sheets’ sales data, pivot, & dashboard. The sales sheet contains the entire data set I have worked with; the pivot sheet used for created pivot tables & on the dashboard sheet I have created sales dashboard. I have chosen a round rectangle. These shapes will serve as a background container for all other sections. In first four sections I have explored the total sales, profit in USD, Profit percentage, & units sold figures across different segments, products, and time periods. I have started with total sales matrix providing an overview of revenue generated. By using stacked column chart visualize sales & profit trends over the months.

Dynamic & interactive Sales Matrix

12473812
I offers you with a variety range of services including but not limited to: • Excel Macros • Excel Formulas • Excel Dashboards • Excel Automation • Excel Models • Solver • User forms • VBA • Pivot Tables • Data Processing • Data Cleaning • Data Analysis • Data Validation • Data Analysis • Data Visualization • Data Manipulation • Power BI Dashboards Do not hesitate to send me message before placing an order to discuss scope, price, and output template desired. I will not charge you until you are completely satisfied. Hope you have a good day.

Formulas, Macros, VBA, & Automations

12531431
Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

Hi, We handle everything from setting up employees to processing payroll, tax filings, and compliance, so you can focus on growing your business without worrying about the details. We can manage everything from multi-state payroll to varying pay rates for your employees, ensuring your payroll runs smoothly and accurately every time. • In Urban Textile I have successfully processed payroll for over 200 employees within a 24-hour record using an automated payroll system in Excel that reduces processing time by 30% and consistently meets tight deadlines without errors. • Achieved 99.9% payroll accuracy by developing audit procedures and cross-verifying data before submission. Our payroll services include: • Setting up and maintaining employee records • Time keeping and attendance tracking • Setup payroll and approve timesheets from hourly employees • Handling employee benefits and contributions. • Calculate gross pay, Payroll Taxes and Income Tax deductions • Preparing and filing payroll

Payroll Accounting in Excel

5.0 · 7 Reviews
7 Reviews
G
Flag of

Gabor N.

5.0

£50 GBP

7 months ago

Level 3 Warehouse Supervision Coursework

Quick and efficient writer with great communication skills.

Logistics
Inventory Management
Supply Chain
Operations Management

Share

User Avatar
Flag of

Ali A.

5.0

$30 AUD

9 months ago

Polish BI Dashboard Aesthetics

He was on time and delivered what was asked for. Would def consider working with him again,

Business Intelligence
Data Visualization
Power BI

Share

L
Flag of

lakshmir78

5.0

₹1,000 INR

9 months ago

Operational Process Flow Chart

I really appreciate the effort put into creating the flow chart. It was clear, well-structured, and made the concept easy to understand. Great work, and I’m glad to have collaborated with you!

Graphic Design
Excel
Matlab and Mathematica
Statistics
Business Analysis

+3 more

Share

User Avatar
Flag of

Mostafa H.

0.0

$20 USD

10 months ago

Annual Accounts Preparation

The project is not completed according to the dispute

Accounting
Excel
Finance
Intuit QuickBooks
Financial Analysis

+3 more

Share

N
Flag of

Nahed A.

5.0

$10 USD

1 year ago

Medical Data Visualization in Excel

He is dedicated and collaborative, he delivered the project on time with goal achieved.

Data Processing
Excel
Statistics
Data Mining
Statistical Analysis

Share

Experience

Owner | A Passionate Freelancer | Data Analytics, Accounting & Research Services

May, 2021 - Present

•

4 years, 11 months

S.U. BAIG & CO.

May, 2021 - Present

•

4 years, 11 months

Full time Remote Data & Operations Analyst (Finance, Research, Writing, Data Entry) • Serving international SME clients across industries • Support business owners by simplifying daily operations with data & cross team collaboration • Analyze sales, production & operations to improve decisions & performance • Build Excel dashboards, track KPIs, support forecasting, inventory & cost control • Ensure data accuracy via audits & deliver clear, timely reports

Flag of

Hunza, Pakistan

May, 2021 - Present

•

4 years, 11 months

Accounts, Data & Operations Analyst

Mar, 2019 - Apr, 2021

•

2 years, 1 month

Plas Packaging Industries

Mar, 2019 - Apr, 2021

•

2 years, 1 month

• Data & Operations Analyst: analyze ops, production & sales for planning & performance • Collaborate with inventory, logistics & sales to improve workflows & efficiency • Build Excel dashboards & KPI reports • Support forecasting, inventory & cost analysis • Ensure data accuracy via audits & reporting • Achievements: +25% reporting accuracy (Quick Books), -30% closing time

Mar, 2019 - Apr, 2021

•

2 years, 1 month

Accounts & Finance/Internal Auditor

Dec, 2015 - Feb, 2019

•

3 years, 2 months

Urban Textile

Dec, 2015 - Feb, 2019

•

3 years, 2 months

Maintaining following reports in MS Office & Excel; (Quick Books Online/MS Excel) Accurate Chart of Accounts • Profit & Loss/Income Expenses Accounts • Balance Sheet/Cash Flow • Monthly Bank & Credit Card Accounts Reconciliations. • Data analyses in Excel & Power BI Key Achievements: • Successfully processed payroll for 200+ employees within a 24-hour turnaround. Implemented an automated payroll system that reduced processing time by 30%, consistently meeting tight deadlines without errors.

Dec, 2015 - Feb, 2019

•

3 years, 2 months

Education

Master of Business Administration Specialization in Accounting & Finance

2010 - 2013

•

3 years

Flag of

Pakistan

2010 - 2013

•

3 years

University of the Punjab, Lahore

2006 - 2008

•

2 years

Bachelor of Commerce (B.Com)

Flag of

Pakistan

2006 - 2008

•

2 years

Qualifications

Essentials of Data Visualization

2025

Acacia University, Arizona, USA

1- Basics & Data Visualization Essentials 2- Dashboard Visualization 3- Use of Tables and Charts 4- Data Dashboard 5- Modifying Data in Excel 6- Creating Distributions from Data 7- Quantitative Data 8- Creating Distributions from Data 9- Histograms 10-Trends in Time Series Data 11- Linear Regression

2025

Mastering in Data Analyses

2025

Alison, Galway, Ireland

1. Data science 2. Cloud computing 3. Blockchain 4. Data visualisation 5. Data gathering & cleaning, data warehousing, data analysis & reporting techniques 6. Generate valuable insights through data warehousing, & evaluation, leading to informed decision-making & process improvement 7. Advance formulas and functions in Excel 8. Use the visualization & report capabilities of Power BI to create compelling reports & dashboards.

2025

Certificate in Information Technology- CIT

2015

Sindhi Computer Insitute, Karachi, Pakistan

Blockchain Cloud computing Data science Internet Operations Data Analysis Using Excel • Lookup Table • Data Analysis • Microsoft Excel • Pivot Table • Business Statistics & Analysis Specialization • Spread Sheet Functions & Organize Data • Introduction to some more useful functions such as the IF, nested IF, VLOOKUP and HLOOKUP functions in Excel. • Introduction to the Data Filtering, Pivot Tables, and Charts • Advance Graphing and Charting

2015

Freelancer logo US (International) / English
Help & Support

Freelancer

Categories Projects Contests Freelancers Enterprise Innovation Challenges AI Development Membership Preferred Freelancer Program Project Management Local Jobs Photo Anywhere Showcase API for Developers Get Verified

About

About us How it Works Security Investor Sitemap Stories News Team Awards Press Releases Careers

Terms

Privacy Policy Terms and Conditions Copyright Policy Code of Conduct Fees and Charges

Partners

Escrow.com Loadshift Warrior Forum

Apps

Apple App Store logoGoogle Play logo

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2026 Freelancer Technology Pty Limited (ACN 142 189 759)