📁 Company Portfolio 2024–25

Affordable
Digital Brilliance.
Global Impact.

RonTech Services is a full-service digital agency & data analytics firm helping businesses worldwide — from social media design to Power BI dashboards.

🎨 Client Work 🌐 Visit Website
2
Active Clients
125+
Posts Designed
13+
BI Dashboards
9+
Clients Served
What We Do

Full-Stack Digital Services

From data to design to digital marketing — everything your business needs under one roof.

📊
Data Analysis & BI
Power BI dashboards, DAX measures, KPI design, and actionable business intelligence.
🎨
Graphic & Web Design
Brand visuals, social media creatives, UI/UX, and stunning websites that convert.
📱
Social Media Marketing
Content, campaigns, and community building across Facebook, Instagram, and beyond.
🔍
SEO & SEM
Get discovered by the right audience. Organic growth and paid search that converts.
📣
Google & Meta Ads
Laser-focused ad campaigns that maximize ROI on Google, Facebook, and Instagram.
🎬
UGC & Content Creation
Authentic user-generated content and ad creatives that feel real and build trust.
Graphic Design · Client Work

Social Media Creatives

Facebook & Instagram posts designed for clients across healthcare, F&B, brand photography, and more.

🍕

Food On Fire

Catering service brand based in Indore. RonTech designed social media creatives covering catering services, special menu items, festive posts, and product drop campaigns for Zomato & Swiggy.

Catering / F&B9 PostsFacebook · Instagram
📷

Brandixio

Premium visual storytelling & CGI brand photography studio. RonTech created product photography compositions for health supplement brands (OnlyVital, Vitamuch), hair care (Koffeco), and luxury tile/surface brands.

Brand Photography · CGI13 PostsProduct ShootsMulti-Brand
🦷

Complete Care Dental Clinic

Dr. Shilpa Hansranjani’s dental clinic in Indore. RonTech designed treatment awareness posts, patient education content, and festive greetings for Facebook & Instagram.

Healthcare · Dental9 PostsFacebook · Instagram
👂

Vertigo & ENT Care Clinic

Dr. Vishal Hansrajani’s ENT specialist clinic in Indore. RonTech designed medical awareness posts covering ear, nose, throat conditions, thyroid clinic services, and festive greetings.

Healthcare · ENT17 PostsFacebook · Instagram
🦴

Dr. Anand Gupta — Bone & Joint Clinic

Robotic Joint Replacement Specialist & Arthroscopic Surgeon at Bombay Hospital, Indore. RonTech designed orthopaedic awareness posts, surgery information, patient education, and festive greetings.

Healthcare · Orthopaedic20 PostsFacebook · Instagram

Impulse

CA & compliance services firm. RonTech designed social media creatives covering corporate compliance services (ROC filings, director changes, share transfers) and payroll compliance (PF, ESI, professional tax) for Facebook & Instagram.

Finance · CA Firm17 PostsFacebook · Instagram
👶

Kidz Clinic — Dr. Isha Singh

Paediatric clinic run by Dr. Isha Singh. RonTech designed health awareness posts covering child nutrition, adolescent habits, disease symptoms, parenting tips, and festive content for Facebook & Instagram.

Healthcare · Paediatric19 PostsFacebook · Instagram
🏗

Maruti Tiles & Fittings

Full-service tiles showroom and bathroom fittings provider. RonTech designed product showcase posts for premium tile collections, bathroom renovation campaigns, kitchen sink dealership, and festive greetings.

Tiles · Home Decor18 PostsFacebook · Instagram
🍕

DIV Kitchen

Restaurant & cloud kitchen offering quick-service food delivery. RonTech designed food promotion posts for their pizza menu and event invitations, distributed via Zomato & Swiggy.

Restaurant · Cloud Kitchen3 PostsZomato · Swiggy
Web Development & SEO

Websites Built & Optimised

Full websites designed, developed, and SEO-optimised for clients across industries — from professional services to e-commerce.

📊
Finance · CA Firm
Impulse
Professional website for a Chartered Accountant firm — services, expertise, and client trust-building with full on-page SEO.
Web DesignSEOCA / Finance
🔗 Website no longer active
✈️
Travel & Tourism
Sangam Travels
Travel company website showcasing tour packages, destinations, and booking information — with SEO targeting travel-intent keywords.
Web DesignSEOTravel
🔗 Website no longer active
🚀
Digital Agency · Own Company
RonTech Services
RonTech’s own company website — built in-house to showcase services, portfolio, and generate inbound leads, with full SEO implementation.
Web DesignSEOAgency
🔗 rontechservices.com
🎓
Education
TalentForge Academy
Education firm website covering courses, faculty, and admissions — designed to build credibility and drive enrolment with targeted SEO.
Web DesignSEOEdTech
🔗 talentforgeacademy.com
🛍️
E-Commerce · Fragrance
Perfume Store
E-commerce website for a perfume brand — product catalogue, cart, and checkout flow with product-focused SEO for fragrance keywords.
E-CommerceSEORetail
🔗 Website no longer active
📣
Digital Marketing Agency
MD Arena
Digital marketing agency website — services, case studies, and contact flow designed to convert visitors into leads, with full SEO setup.
Web DesignSEOAgency
🔗 mdarena.in
💡
Digital Marketing Agency
Deccan Digital Services
Website for a digital marketing firm — positioning, service pages, and brand identity built for credibility with full on-page SEO.
Web DesignSEOAgency
🔗 Website no longer active
Data Analytics Portfolio

Power BI Dashboards

13 Power BI projects spanning retail, e-commerce, sports, and operations — built by Anshul Ramsinghani.

🛋
Complete
E-Commerce · Multi-Page
Online Orders 2019–21
8-page report — sales trends, customer behaviour, product KPIs, salesperson & location analytics.
📃 Index💹 Dashboard🛋 Products📊 Salesperson+3 more
DAXTime Intelligence8 Pages
🏓
Complete
Sports Analytics
IPL Auction Analysis
4-page drill-down across team-wise, player-wise, and player-type auction bid analysis.
Team & PlayerTeam WisePlayer NamePlayer Type
Drill-DownSlicers
🌍
Complete
Retail · Global
Global Superstore
Executive 2-page dashboard covering global performance, segment profitability, and regional trends.
DashboardDashboard 1
Global SalesKPIs
🍫
In Progress
FMCG · Retail
Chocolate Sales
Sales performance dashboard for confectionery — revenue tracking, top products, regional distribution.
Page 1
FMCGProduct Mix
🍪
In Progress
FMCG · Retail
Cookies Sales Analysis
3-page analysis of cookie product lines — category trends, top SKUs, seasonal patterns.
Page 1Page 2Page 3
Trend Analysis
🎮
In Progress
Entertainment
Gaming Sales
2-page gaming market dashboard — platform performance, genre breakdowns, publisher revenue.
Page 1Page 2
Market Analysis
🚲
In Progress
Retail
Bike Store
Retail performance dashboard — inventory movement, product categories, customer purchasing.
Page 1
RetailInventory
💼
In Progress
Business Intelligence
Business Data Dashboard
2-page executive BI dashboard with core KPIs for management decision-making.
Page 1Page 2
ExecutiveKPIs
🔧
In Progress
Field Operations
Work Orders
Field service analytics — technician performance, service types, warranty claims, cost vs fee P&L.
Page 1
P&LDAX Calcs
📦
In Progress
E-Commerce · V1
Online Order (v1)
Earlier iteration — foundational report structure with product, salesperson & location pages.
IndexDashboard+5 more
V1 Draft
🏆
In Progress
Sports · V1
IPL Auction (v1)
Initial version — player type overview before full 4-page expansion.
Page 1Type Wise
V1 Draft
🧁
In Progress
FMCG · V1
Cookies Sales (v1)
Early-stage single-page cookie sales report — before the expanded 3-page version.
Page 1
V1 Draft
📈
In Progress
BI · V1
Business Data (v1)
Single-page draft — foundational metrics and data model setup.
Page 1
V1 Draft
Work Orders · In Progress

Field Service Data Model

🔧

Work Orders Analysis

13 source fields → 11 DAX calculated columns to build

📥 Source Fields (13)
WOUnique Work Order ID
DistrictGeographic area of work
LeadTechHead technician
ServiceAssess / Deliver / Install / Repair / Replace
RushRush job? Yes / No
ReqDateDate work order was entered
WorkDateDate work was completed
TechsNumber of technicians required
WtyLbrLabour under warranty?
WtyPartsParts under warranty?
LbrHrsActual labour hours
PartsCostCost of parts required
PaymentAccount / C.O.D / Credit / P.O. / Warranty
⚙️ Calculated Columns (11)
WaitWorkDate − ReqDate (days)
LbrRateHourly rate based on Techs count
LbrCostLbrRate × LbrHrs
LbrFeeLabour cost if NOT under warranty
PartsFeeParts cost if NOT under warranty
TotalCostLbrCost + PartsCost
TotalFeeLbrFee + PartsFee
MonthMonth & Year from ReqDate
ReqDay3-letter weekday from ReqDate
WorkDay3-letter weekday from WorkDate
P/LProfit or Loss indicator
— Sample DAX —
Wait = DATEDIFF([ReqDate],[WorkDate],DAY)
LbrFee = IF([WtyLbr]=“Yes”,0,[LbrCost])
P/L = IF([TotalFee]>[TotalCost],“Profit”,“Loss”)
Month = FORMAT([ReqDate],“MMM YYYY”)
Toolkit

Skills & Technologies

📊
Power BI
⚡
DAX
🔄
Power Query
🗃️
SQL
📋
Excel
🎨
Graphic Design
📱
Social Media
🔍
SEO / SEM
📣
Meta & Google Ads
⏳
Time Intelligence
🗺️
Geo Analytics
🌐
Web Design

Ready to grow
your business?

Let’s build something remarkable together.

📩 Get A Quote 🌐 Visit Website
© 2025 RonTech Services · 897, Scheme No. 114 Part 1, Indore, India
Portfolio by Anshul Ramsinghani