penser analytics - company profile
TRANSCRIPT
Meet Sherlock 2
Sherlock is an instantaneous integrated decision support system that addresses the basic need of rapid access to relevant data with advanced analytics backed insights to take business decisions
Our Value Proposition 6
Question Based AnalysisGet your toughest business questions answered
Effortless Advanced AnalyticsMachine learning algorithms; Random forest, Neural networks, Regression etc.
Rapid Hypothesis TestingTest various scenarios before taking decisions
Sherlock from Penser Analytics, real time decision support system with all advanced Machine leaning Algorithms
• An analytics platform that meets the needs of business (analytics and BI) and IT.
• Ensure one version of the truth (1VOT)• Enable Everyone in your organization with relevant
advanced analytics• All Analytics delivered within a minute
Our USP:
Pre-built Questions & Scenarios for all operations 7
We understand the KEY QUESTIONS in a retail environment
1
2
3
50+ Relevant business questions aligned to various retail operations
Advanced Search for power users opens various parameters and behaviors captured
All reports and business questions along with statistical analysis are available within seconds
Address all Strategic Needs 12
ALIGN every business operation, EMPOWER them with the right data to OUTPERFORM
Master data management for centralized data management
Optimize every operation from procurement to marketing
Integrate every business process from procurement to POS
to campaign management
Align everyone in the organization to one goal
Empower everyone with relevant analyses and reports
Monitor every process and operation
Reach your targets and outperform
1 Product Diverse Solutions
What products drive Omni-channel behavior?
Predict student success & content effectiveness
Predict purchase behavior based on emotions
Frauds Model & Scorecard Move Inventory
to complete set
Prospects for today for every stylist in every store
Inventory Aging Analysis to save 90 Lac INR
Our Data Integration Module 4
Our solution is system agonistic, that can be deployed on top of any IT solution.
DATA EXTRACTOR• DI through inbuilt or customized
connectors.• Real-time extraction of data
EMB (Enterprise mapping BUS)• Pattern based mapping of information
from various data sources
INVENTORY & CUSTOMER STITCHING, CURRENCY NORMALISATION• Stitching of SKUs or Customers from
different platforms to an uniqueidentifier
DATA CLEANSING• Missing value imputations, removing
unwanted characters and observations.
Our Architecture 11
Our solution is cloud agonistic, that can be deployed on any cloud provider as well as on premise
Analytical Dataset
Multi Dimensional Cube
Team Behind Sherlock 3
Co-Founder & CEO Co-Founder & CTO
A thorough professional fromthe Big Data & Analytics fieldwith over 12 years experience.Worked in various early stagecompanies with a passion toturn ideas into products.
An ex-IITian and a proventhought leader whoconsulted for over two yearsin the field of analytics forcompanies like GeneralMotors, Payback.
• The team behind Penser Analytics is fromleading universities like IIT KGP, IITMUMBAI, NIT etc.
• Our team comes with over 16 years ofanalytics experience, 20+ years experienceof working on various backend systems, 9+years of UI experience combined with overa decade of experience in sales.
• We have over 15 years of experience inleading analytics operations for retail CRM
• Our team has equal parts of sophisticatedexperience combined with the ‘frugalinnovation’ to fuel Sherlock
Penser Analytics was founded to helpclients take decisions faster withoutwaiting for analysts to come up withadvanced analytics or reports
“
“
Our Clients Speak
“Using Sherlock, our CRM team is able to access predictive analytics based target groups under 60 seconds saving precious time for me and my team. Sherlock has the potential to become a key corner stone in our Omni-channel strategy by seamlessly integrating both the online and offline businesses. Also, we find that the predictions from Sherlock are above 80% accurate”
- Abhishek Pillendla, Head – CRMBabyOye by Mahindra
“I have been in analytics and marketing research for 30 years. Early in my career, at the Kellogg Company, …. I have recently been introduced to a tool called “Sherlock”. Sherlock is a complete DSS system. This system is truly amazing and offers automated analytics modules (“analytics in a box”) and the most advanced “data visualization” that I have seen. In addition, the system is fast, comprehensive and is seamless and elegant in handling different & disparate forms of data. Overall, I see Sherlock as a potential “game changer.”
- Michael Wolfe, CEO & Founder Bottom Analytics(Past: Coca Cola, Kraft Foods, Kellogg etc.)
Investors Behind Sherlock 4
Brahma Vella Srinivas Sreeramaneni
Founded various IT companiesgot it acquired by Adobe.Recently had their companyUurmi Systems by Mathworks.Co-Owner of Telugu Titans.Started an agriculture basedsugar manufacturing industry
Founded Rofus Softwareand got it acquired byGlobalLogic. Invested in amultitude of companiesfrom education, Productcompanies. Started UnifyTechnologies
Penser Analytics was backed byseasoned and proven entrepreneurs.“ “
Sherlock among Competition 13
How do we rank among everyone else in the market
BI/ Visualization
ToolsSERVICE FEATURES
Analytics as a Service
HYPOTHESIS TESTING
ADVANCED ANALYTICS
QUESTION BASED ANALYSIS
QUICK TURN AROUND
INDUSTRY SPECIFIC SOLUTIONS
IBM Watson
REPORTS
UNSTRUCTURED TEXT/ PARAGRAPGH
Product Roadmap
• Create & Save Reports• Configure Analysis• Share & Comment
Partner & Self ServeV2V3• Total Integration into Business Process
• Platform for Analytics Teams• Bots
Analytics Teams
Customizable & Pre-defined Industry-Standard Analyses 17
Contextual Reporting Suite/ Configured Reports/ Management Information System (MIS)
Occupation : MerchandiserResponsibilities: Ensure right products in the right store in the correct quantities.
Analysis/ Reports provided:• Store Product wise performance• Forecast for each Product in every
store• Key drivers for sale of a product• Product Affinity Analysis
Occupation : BuyerResponsibilities: Decide what to buy from suppliers and stock
Analysis/ Reports provided:• Vendor Performance• Accurate demand forecast to avoid
stock-outs and dead stock• Buying Efficiency• Track performance of new products/
offerings
Occupation : MarketingResponsibilities: Increase Campaign Performance. Optimize price markdown
Analysis/ Reports provided:• MartetMix model: Individual ROI of
all campaigns• Suggested ‘Combo Offers’ to
promote slow moving products• Forecasted Impact of a campaign
Occupation : Store ManagerResponsibilities: Responsible for day-to-day operations of store
Analysis/ Reports provided:• Store Performance/ Potential• Employee productivity• Space productivity• Impact of in-store campaigns• Optimal Store Layout• Sales forecast
Omni Channel Operations 18
How to UTILISE information from different channels, ONLINE, MOBILE and PHYSICAL STORES ?
Brick & Mortar
Website
Mobile Apps
Various Platforms
UnifiedCustomer
View
80%
12%
6%2%
• 80-88% of Retail Transaction in 2020 will happen in Brick & Mortar, Physical Stores• 90+% of Retail Consumers will research online before buying offline
Sherlock for Omni-Channel 19
Does customer engagement of different platforms increase Customer Life Time Value?
Sales ProgressionTime series analysis of how the segments progressed through the months and years
Product Purchase PatternAppreciate the top products and different product purchase patterns of the segments
KPIs of Customers• Analyze the various KPIs of different customer
segments based on platforms• Identify customers who shopped on
combination of platforms
Sherlock at every stage of Customer Journey 20
Enabled with Sherlock understand the different segments of customers and entice them
New path to relationshipOld path to purchase
GET HERATTENTION
INTRODUCE THEMTO THE BRAND
GET TO KNOW THEMLEARN WHAT THEY LIKE
UNDERSTAND THEMSURPRISE THEM
REASSURE & BUILDCONFIDENCE INYOUR BRAND
ELIMINATE BARRIERSIN PURCHASING HERFAVORITE PRODUCT
REFRAIN FROM BEINGTOO PUSHY
OFFER A SUPPORTPLATFORM
ASPIRE TO BECOME A PARTOF HER LIFE
Sherlock for Customer Segmentation 21
Be sensitive to the needs of different types of customers
Sales ProgressionTime series analysis of how the segments progressed through the months and years
Store-wise ContributionKPIs of the segments across various stores
Product Purchase PatternAppreciate the top products and different product purchase patterns of the segments
KPIs of Customer SegmentsIdentify the various segments based on Recency, Frequency, Monetary (RFM) or Behavioral among other parameters
Sherlock for Personal Shopping Assistant 22
Be reactive in servicing the customers: Use predictive info along with factual info
• Lives in Central• New customer with more than 2 visits• Last purchase was done online
• Interested in YXY product• Potential to visit next Saturday• Medium Spend Capacity
Sherlock for Marketing 23
Be sensitive to the needs of different types of customers
Test/ ControlStatistically assess the impact of the campaigns by comparing it against a control group.
Campaign ROIIdentify the campaign ROI, through different stages of interaction with your promotional campaigns.
Click Through PatternIdentify and appreciate the differences in the click-through patterns for different campaigns and compare it with normal traffic.
MarketMix ModelStatistically identify the impact of marketing campaigns be it TV, Radio, PPC, SMS, e-mail.
Sherlock for e-Commerce 24
Track your customers on your site and integrate with the rest of your business
Landing page with internal search Internal search results Product description
and price
Review/ Payment Checkout Added to cart
Purchase confirmation page
Sherlock for e-Commerce 25
How do customers interact with your site
Link Click-through/ Heat-map for all pages
Visitors Overview
Traffic Sources & PPC/ Campaign ROI
Location Overview
Sherlock for Social Media 26
Be sensitive to the needs of different types of customers
Sales Performance Vs Engagement LevelsHow does the Sales contribution vary by the engagement levels. Understand the $ value of a positive comment
Influence of your audience on Social MediaGroup your audience based on how many of your customers are influenced by their content
Interaction on Social Media PagesSentiment Analysis and word cloud of most used words in comments
Distribution of Social Media ContentThe reach of your social media content, likes, tweets, fans and followers
Merchandising Solution 27
Stock the RIGHT product mix in RIGHT quantities
Identify the right products to stock in each store
Sherlock for Merchandiser Operations 28
Forecast demand and match inventory levels to avoid stock-outs
Sales ForecastSeasonality, trend and impact of campaigns are taken into consideration to provide an accurate forecast
Product AffinityUsing Association Rule Mining, identify the natural purchase patterns and grouping of products
Product Repeat Purchase DriversIdentify the key drivers behind the purchase of this productCustomer Lifetime value indicated by the color of bar
Product performanceIdentify the stores and geographic locations, the product is bought. Along with the type of customers interested in the product
Sherlock for Product Affinity Analysis 29
Forecast demand and match inventory levels to avoid stock-outs
Top Baskets• Top baskets with the product• Design relevant ‘combo offers’
Product AffinityUsing Association Rule Mining, identify the natural purchase patterns and grouping of products
Sherlock for identifying Best Selling Price 30
Fix the RIGHT price for the RIGHT product
KYC (Key Value Categories)KYI (Key Value Items)
Transaction Data
Price Perception Data
Merchant Judgment
Value Perception Drivers
Assortment perception drivers
Traffic drivers
Basket Drivers
User Reviews
Social Media
Click Stream Data
Bounce Rate
New Store/ Fulfillment center 31
What is the OPTIMAL new location for your business and target group of customers
"Careful determination of new sites is critical for most retail and consumer service businesses.” - Irene Dickey, Dayton's School of Business in Dayton, Ohio.
Trade Area Analysis
• Network Gap Analysis• Target Customer Analysis• Competitor Site Analysis• Cannibalization
Sherlock for Opening A New Location/ Store 32
Estimate ROI of opening a new store
New Store Analysis• Choose a point on the map and your trade
radius, • See the number of customers, total sales from
the area and other KPIs. • Get the purchase pattern of customers• Estimate probable ROI
Sherlock for Store Network Optimization 33
Be sensitive to the needs of different types of customers
Store Performance Vs Potential• Analyze all stores and identify the true potential• Identify the gap how to achieve true potential
Store Segmentation• Appreciate various types of stores• Also analyze various KPIs of these segments• Identify the difference in sales profile in each of
these segments
Store Layout & Operations 34
What is the OPTIMAL store layout? Are all stores SIMILAR? Are stores performing at OPTIMAL level?
Visitors
Store Traffic
Zone Traffic Dwell Times
Purchase
Conversion Rate
• Store Traffic to Zone Traffic
• Zone Traffic to Product Dwell Time
• Product Dwell Time to Purchase
Sherlock for Store Operations 35
Be sensitive to the needs of different types of customers
Product Repeat Purchase DriversIdentify the key drivers behind the purchase of a repeat visit
Customer SegmentationUnderstand the different types of customers visiting this store.
Product Purchase PatternIdentify the top products and the purchase pattern across product characteristics
Sales ForecastSeasonality, trend and impact of campaigns are taken into consideration to provide an accurate forecast
Data Security 36
Prevent data leaks of any type
Server – Private Cloud
• Electronic access control system• 24/7 monitoring of entrances and server rooms• Redundant internal networks• Multiple redundant connections to the largest German internet exchange point, DE-CIX, ensure smooth data transfer• There is a central back-up server to save backed-up data• Fire detection system, directly connected to the local fire department
Secure transmission and Sessions
• Connection to the App is via a cryptographic protocol, ensuring our users have a secure connection from their browsers to ourservice
• Individual user sessions are identified and re-verified with each transaction, using a unique token created at login
Network Protection
• Perimeter firewalls and edge routers block unused protocols• Internal firewalls segregate traffic between the application and database tiers• A third-party service provider continuously scans the network externally and alerts changes in baseline configuration• PCI DSS compliance ready