Logo Freelancer
Log Masuk Daftar
Siarkan Projek
MENJELAJAH
Data Processing
Excel
Python
Statistical Analysis
Statistics
Gambar muka depan profil
Anda kini mengikuti
Ralat mengikuti pengguna.
Pengguna ini tidak membenarkan pengguna untuk mengikuti mereka.
Anda telah mengikuti pengguna ini.
Pelan keahlian anda hanya membenarkan 0 mengikuti. Naik taraf di sini.
Berjaya menyahikut
Ralat tidak mengikuti pengguna.
Anda berjaya mengesyorkan
Ralat mengesyorkan pengguna.
Sesuatu telah berlaku. Sila segar semula halaman dan cuba lagi.
E-mel berjaya disahkan.
Avatar Pengguna

Aditya D.

@adityadarji1828

monthly-level-three.svgverified-v2.svgpreferred-freelancer-v3.svg
5.0
52
6.1
6.1
98%

Data Analyst | Dashboard | Python | Statistics

$50 USD / Jam
・
Bendera
India (12:12 PTG)
・
Menyertai pada Mac 14, 2021
$50 USD / Jam
・
I'm Aditya, with over 4 years of experience in data analytics and Power BI. I've helped more than 30 businesses leverage data to make better decisions and enhance their operations. My versatile skill set includes: - Advanced Excel: Crafting advanced formulas, automating tasks, and optimizing data workflows. - Python and SQL: Proficient in data manipulation, analysis, and database management. - Power BI/Tableau/Looker: Developing user-friendly, data-rich dashboards for visualizing complex information. - Data Visualization: Presenting data in a clear and visually appealing manner to facilitate decision-making. - AI and Machine Learning: Leveraging artificial intelligence and machine learning techniques to drive predictive analytics and enhance decision-making. - Natural Language Processing (NLP): Analyzing and processing human language data for sentiment analysis, text classification, and more. - Big Data Analysis: Handling and analyzing large datasets to uncover valuable insights and trends. Get in touch with me today to discuss your project needs.
Pengesahan
Tepat pada masa
100%
Mengikut bajet
100%
Kadar terima
100%
Kadar upah semula
22%
Freelancer Statisticians India
Lihat semua Statisticians dalam India

Portfolio

Portfolio

12386421
This dashboard tracks the onboarding of farmers, their landholdings, and crop data across states and districts. It provides insights for strategic planning and agricultural management. Steps to Build the Dashboard: Data Collection: Compiled data on farmers, landholdings, crop types, and geographic locations. Data Cleaning: Standardized the dataset, removed duplicates, and resolved inconsistencies. Data Modeling: Established relationships between state, district, and crop data to ensure seamless filtering. Visualization Design: Key metrics like Total Farmers Onboarded, Landholding in Acres, and Average Landholding displayed as KPIs. Bar charts for district-wise and crop-wise farmer statistics. Map visualization for onboarding distribution by location. Filters: Added filters for state, district, and crop type to enhance interactivity. Testing and Validation: Ensured data accuracy and visual clarity. This dashboard helps stakeholders analyze farmer onboarding trends and allocate resourc
Customer Onboarding Dashboard
12386399
Purpose: Provides an overview of sales, inventory, and vendor performance for decision-makers. Sales Dashboard Description Purpose: Provides an overview of sales, inventory, and vendor performance for decision-makers. KPIs: Displays key metrics such as total sales, quantity sold, excise tax, inventory, vendors, and profit after tax (PAT). Filters: Dynamic filtering by vendor, inventory category, and date range. Visuals: Top Vendors: Bar chart showing the top 5 vendors by sales. Top Stores: Bar chart of the top 20 stores by sales. Top Brands: Bar chart ranking brands by total sales. Sales Trends: Line chart showing monthly sales with a forecast. Steps to Build Import Data: Load sales, inventory, and vendor datasets into Power BI. Set Up Metrics: Create measures for KPIs like total sales, PAT, and excise tax using DAX. Enable Filters: Add slicers for vendor, inventory, and date range. Design Visuals: Bar charts for vendors, stores, and brands. Line chart for sales trends with forecast f
Sales Dashboard
12386435
This dashboard provides a clear snapshot of marketing performance, including costs, sales, and profitability. Key Features: KPIs: Shows Newspaper, Radio, TV Costs, Sales Volume, Total Sales, and Net Profit. Sales Distribution: Highlights sales spread across campaigns. Spending by Channel: Visualizes spending on TV, Newspaper, and Radio. Key Influencers: Identifies factors like TV and Radio spend driving sales. Scatter Plot: Displays the relationship between TV spending and sales. How It Was Built: Data Import: Loaded data from source files. Data Cleaning: Prepared and formatted the data. Metrics: Calculated costs, sales, and profit using simple formulas. Visuals: Created clear charts and KPIs for easy insights. Design: Arranged visuals for quick understanding. Perfect for monitoring campaign performance at a glance!
Marketing Dashboard
12386414
This dashboard provides insights into key operational metrics, including riders, services, payments, and parts usage. It is designed for easy tracking and decision-making. Steps to Build the Dashboard: Data Collection: Gathered data on riders, services, payments, parts changed, and financials from operational systems. Data Cleaning: Ensured the dataset was consistent and accurate, resolving missing or duplicate entries. Data Modeling: Created relationships between datasets in Power BI for seamless interaction. Visualization Design: Added KPIs (e.g., Total Riders, Avg KMs Driven, Amount Collected). Designed bar charts for aggregators and service types. Incorporated a donut chart for payment modes. Created a line graph to track daily collection trends. Interactivity: Added filters for service types, technicians, chassis numbers, and date range for user-driven insights. Testing: Validated calculations and ensured all visuals reflected accurate data. This dashboard helps businesses moni
Operations Dashboard
12386403
Purpose: Tracks project package progress, testing status, and completion rates for better project management. Steps to Build Import Data: Load project data, including package details, testing status, and client information. Calculate KPIs: Use DAX for metrics like packages completed, remaining, and readiness percentages. Add Filters: Enable filtering by client, priority, work type, and date range. Design Visuals: Gauge chart for goal tracking. Pie chart for completion by test type. Bar charts for client-wise and work-type breakdowns. Test & Publish: Ensure all filters and visuals interact seamlessly and are easy to interpret for stakeholders.
Project Progress Dashboard
12386426
This dashboard monitors onboarding and deboarding trends, stock distribution across cities, and payment collections by type, enabling operational efficiency and strategic planning. Steps to Build the Dashboard: Data Gathering: Collected data on onboarding, deboarding, city-wise stock, and payment collection. Data Cleaning: Ensured consistent formats, handled missing values, and standardized columns. Data Modeling: Established relationships between aggregators, cities, and timestamps for dynamic filtering. Visualization Design: KPIs (e.g., Total Onboarded, Total Deboarded) for overall and aggregator-specific metrics. Line chart visualizing monthly onboarding vs. deboarding trends. Bar charts showing total stock vs. hub stock by city and payment collections by type. Interactive Filters: Added slicers for aggregator, city, and timestamp to tailor the analysis. Testing and Validation: Verified accuracy of metrics and functionality of filters. This dashboard offers a comprehensive view of
Onboard/Deboard Dashboard
12386421
This dashboard tracks the onboarding of farmers, their landholdings, and crop data across states and districts. It provides insights for strategic planning and agricultural management. Steps to Build the Dashboard: Data Collection: Compiled data on farmers, landholdings, crop types, and geographic locations. Data Cleaning: Standardized the dataset, removed duplicates, and resolved inconsistencies. Data Modeling: Established relationships between state, district, and crop data to ensure seamless filtering. Visualization Design: Key metrics like Total Farmers Onboarded, Landholding in Acres, and Average Landholding displayed as KPIs. Bar charts for district-wise and crop-wise farmer statistics. Map visualization for onboarding distribution by location. Filters: Added filters for state, district, and crop type to enhance interactivity. Testing and Validation: Ensured data accuracy and visual clarity. This dashboard helps stakeholders analyze farmer onboarding trends and allocate resourc
Customer Onboarding Dashboard
12386399
Purpose: Provides an overview of sales, inventory, and vendor performance for decision-makers. Sales Dashboard Description Purpose: Provides an overview of sales, inventory, and vendor performance for decision-makers. KPIs: Displays key metrics such as total sales, quantity sold, excise tax, inventory, vendors, and profit after tax (PAT). Filters: Dynamic filtering by vendor, inventory category, and date range. Visuals: Top Vendors: Bar chart showing the top 5 vendors by sales. Top Stores: Bar chart of the top 20 stores by sales. Top Brands: Bar chart ranking brands by total sales. Sales Trends: Line chart showing monthly sales with a forecast. Steps to Build Import Data: Load sales, inventory, and vendor datasets into Power BI. Set Up Metrics: Create measures for KPIs like total sales, PAT, and excise tax using DAX. Enable Filters: Add slicers for vendor, inventory, and date range. Design Visuals: Bar charts for vendors, stores, and brands. Line chart for sales trends with forecast f
Sales Dashboard
12386435
This dashboard provides a clear snapshot of marketing performance, including costs, sales, and profitability. Key Features: KPIs: Shows Newspaper, Radio, TV Costs, Sales Volume, Total Sales, and Net Profit. Sales Distribution: Highlights sales spread across campaigns. Spending by Channel: Visualizes spending on TV, Newspaper, and Radio. Key Influencers: Identifies factors like TV and Radio spend driving sales. Scatter Plot: Displays the relationship between TV spending and sales. How It Was Built: Data Import: Loaded data from source files. Data Cleaning: Prepared and formatted the data. Metrics: Calculated costs, sales, and profit using simple formulas. Visuals: Created clear charts and KPIs for easy insights. Design: Arranged visuals for quick understanding. Perfect for monitoring campaign performance at a glance!
Marketing Dashboard
12386414
This dashboard provides insights into key operational metrics, including riders, services, payments, and parts usage. It is designed for easy tracking and decision-making. Steps to Build the Dashboard: Data Collection: Gathered data on riders, services, payments, parts changed, and financials from operational systems. Data Cleaning: Ensured the dataset was consistent and accurate, resolving missing or duplicate entries. Data Modeling: Created relationships between datasets in Power BI for seamless interaction. Visualization Design: Added KPIs (e.g., Total Riders, Avg KMs Driven, Amount Collected). Designed bar charts for aggregators and service types. Incorporated a donut chart for payment modes. Created a line graph to track daily collection trends. Interactivity: Added filters for service types, technicians, chassis numbers, and date range for user-driven insights. Testing: Validated calculations and ensured all visuals reflected accurate data. This dashboard helps businesses moni
Operations Dashboard
12386403
Purpose: Tracks project package progress, testing status, and completion rates for better project management. Steps to Build Import Data: Load project data, including package details, testing status, and client information. Calculate KPIs: Use DAX for metrics like packages completed, remaining, and readiness percentages. Add Filters: Enable filtering by client, priority, work type, and date range. Design Visuals: Gauge chart for goal tracking. Pie chart for completion by test type. Bar charts for client-wise and work-type breakdowns. Test & Publish: Ensure all filters and visuals interact seamlessly and are easy to interpret for stakeholders.
Project Progress Dashboard
12386426
This dashboard monitors onboarding and deboarding trends, stock distribution across cities, and payment collections by type, enabling operational efficiency and strategic planning. Steps to Build the Dashboard: Data Gathering: Collected data on onboarding, deboarding, city-wise stock, and payment collection. Data Cleaning: Ensured consistent formats, handled missing values, and standardized columns. Data Modeling: Established relationships between aggregators, cities, and timestamps for dynamic filtering. Visualization Design: KPIs (e.g., Total Onboarded, Total Deboarded) for overall and aggregator-specific metrics. Line chart visualizing monthly onboarding vs. deboarding trends. Bar charts showing total stock vs. hub stock by city and payment collections by type. Interactive Filters: Added slicers for aggregator, city, and timestamp to tailor the analysis. Testing and Validation: Verified accuracy of metrics and functionality of filters. This dashboard offers a comprehensive view of
Onboard/Deboard Dashboard
Perubahan disimpan
5.0 · 52 Reviews
Ulasan
T
Interactive Power BI Report for Website • Harga Tidak Didedahkan
Very happy with the dashboard Aditya created. He was very professional throughout.
Tony S.
@TourTips
•
Bendera
Wilpshire, United Kingdom
•
8 hari yang lalu
Kongsi
Avatar Pengguna
Power BI Developer for Sales Insights • Harga Tidak Didedahkan
I would rate Aditya very highly on both technical and interpersonal skills. He understand your logic, clearly communicates and gets on calls with you to discuss updates and receives feedback time to time to ensure the build is top notch.
Bharath S.
@IndianCPGGuys
•
Bendera
Hyderabad, India
•
1 bulan yang lalu
Kongsi
D
Advanced Excel Data Compilation & Analysis • Harga Tidak Didedahkan
Thank you for all the great work!
Dev K.
@Dev1303
•
Bendera
Ahmedabad, India
•
3 bulan yang lalu
Kongsi
Avatar Pengguna
NPS Impact Analysis on Travel Booking • Harga Tidak Didedahkan
Fantastic from the start. Asked great clarification questions and end result was exactly what was needed. Would definitely work with again.
Kris S.
@kriss63
•
Bendera
Harrogate, United Kingdom
•
4 bulan yang lalu
Kongsi
Avatar Pengguna
Project for Aditya D. • $200 USD
Great work. Highlight recommended
Dayana S.
@dayanamsalles
•
Bendera
London, United Kingdom
•
7 bulan yang lalu
Kongsi
Pengalaman
Reporting Analyst
Nov, 2022 - Sekarang
•
2 tahun
TATA AIG
Nov, 2022 - Sekarang
•
2 tahun
Tools used - SQL, Python, Excel Working on ETL Process. Automating reconciliation process. Creating Data Quality checks using SQL queries.
Nov, 2022 - Sekarang
•
2 tahun
Web Scraping and Database Management
Mac, 2022 - Jun, 2022
•
2 bulan, 30 hari
Freelance
Mac, 2022 - Jun, 2022
•
2 bulan, 30 hari
The goal was to create a database that had the following data country name - state/province - region - city - Pincode Using an online web scraper I scraped data from websites. The final part of the project was to club all these data into a single database and used Microsoft Access to dump all the country data into the database.
Mac, 2022 - Jun, 2022
•
2 bulan, 30 hari
Pendidikan
Mumbai University
2020 - 2023
•
3 tahun
Bsc. Data Science & Business Analytics
Bendera
India
2020 - 2023
•
3 tahun
Kelayakan
Data Analytics and Visualisation Virtual Experience Program
2022
Forage
Did Exploratory Data Analysis using Python (Matplotib, Seaborn, etc) and created a predictive model using machine learning techniques.
2022
Pensijilan
P
Preferred Freelancer Program SLA
Jemputan berjaya dihantar!
Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Logo Freelancer Malaysia / Bahasa Malaysia
Bantuan & Sokongan
 Pekerja bebas
Kategori ProjekPeraduanPekerja BebasEnterprise Pembangunan AIKeahlianProgram Pekerja Bebas PilihanPengurusan ProjekPekerjaan TempatanPhoto AnywherePameranAPI untuk PembangunDisahkanAplikasi Desktop
 Tentang
Tentang kamiBagaimana ia BerfungsiKeselamatanPelaburPeta LamanKisahDalam BeritaPasukanAnugerahSiaran AkhbarKerjaya
 Terma
Dasar PrivasiTerma dan SyaratDasar HakciptaTatakelakuanYuran dan Caj
 Rakan Kongsi
Escrow.comLoadshiftWarrior Forum
 Aplikasi
Logo Apple App StoreLogo Mainan Google
Salin ke papan keratan gagal, sila cuba lagi selepas melaraskan kebenaran anda.
Disalin ke papan keratan.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.