work samples of charles balmes (linkedin)
TRANSCRIPT
![Page 1: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/1.jpg)
Charles C. Balmes
---
Data Analytics &
Business Intelligence
Work Samples --------------------------------------------------------------------
Strategic Advantages for Data-Driven
Cultures
![Page 2: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/2.jpg)
The following tools were
placed in service and
generated ROI
![Page 3: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/3.jpg)
Predictive Analytics*
Multi-Variant Linear
Regression Predicting
Market Value * R Statistical Programming, SQL, and Excel
![Page 4: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/4.jpg)
Predicting Sell Prices Using Analytics*
Predicted Sell = Intercept(a) + yrs_since_model(b) +
days_in_fleet(c) + DaysOnRent(d) + TotalCost(e) +
hourmeter(f) + ModelSize(g) + FleetType_YN(h)
Predictive Accuracy: Within 1% of Actual Sell Prices
* using multi-variant linear regression analytics
![Page 5: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/5.jpg)
Predictive Analytics*
Logistic Regression and
Poisson Distribution
Predicting Sales Potential * R Statistical Programming, SQL, and Excel
![Page 6: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/6.jpg)
CRM Basic Probabilities: Desire to buy (%) and desire to buy from us (%).
PROBABILITY % THAT THE
CUSTOMER WILL BUY NEXT YEAR
(POISSON DISTRIBUTION). 94%
PROBABILITY % THAT THE
CUSTOMER WILL BUY FROM US
(LOGISTIC REGRESSION). 78%
COMBINED PROBABILITY 73%
![Page 7: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/7.jpg)
Predictive Analytics*
Classification Algorithms
Discovering Market and
Customer Characteristics
* R Statistical Programming and InkScape
Graphics
![Page 8: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/8.jpg)
Decision Tree of Who Buys Your Product -
Classification Analytics
The decision tree, below, was created via a machine-learning algorithm. It identifies market niches and basic
facts.
ALSO: Classification Analytics can be used to predict customer churn.
![Page 9: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/9.jpg)
Storytelling / Data
Visualization
Using R Statistical Software and InkScape
Graphical Software
![Page 10: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/10.jpg)
Storytelling Using Data Visualization
![Page 11: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/11.jpg)
Data Visualization*
Animated Motion
Trending * Using Google Visual Motion Charts, R Statistical Programming, and SQL
![Page 12: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/12.jpg)
Data Visualization: Trend Analysis Using Google Motion Charts
![Page 13: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/13.jpg)
Text Analytics*
Summarize
Conversations, Emails,
Chat Threads, Logs, Etc. * R Statistical Programming
![Page 14: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/14.jpg)
Text Analytics: Summarizing What People Are Saying About You Source: Conversations between telemarketers and prospective customers
![Page 15: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/15.jpg)
Predictive Analytics*
Market Basket
Discoveries
(e.g., “People who have purchased this
book, have also made these purchases”) * Association Algorithms Found in R Statistical Programming
![Page 16: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/16.jpg)
Suggested Selling Tools
![Page 17: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/17.jpg)
Account Retention Tools
Data Visualization
and Real-Time Web
Reports
Using Microsoft SQL
Server Reporting Services
(SSRS)
![Page 18: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/18.jpg)
Data Visualization: Geo Mapping of Real-time
Business System Revenue Rendered in SharePoint
![Page 19: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/19.jpg)
Data Visualization: Geo Mapping of Market Data (Us
versus Competitors)
![Page 20: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/20.jpg)
Predictive Analytics*
Financial Forecasting and
Trending
* R Statistical Programming (ARIMA
Algorithm). Results Rendered in SharePoint
![Page 21: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/21.jpg)
Predicting Trends Using Time Series Analytics
* Autoregressive Moving Average Using R statistical programming and data Visualization rendered in SharePoint
![Page 22: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/22.jpg)
KPI and Metric
Storytelling
Using Microsoft SQL Server Reporting Services
(SSRS)
![Page 23: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/23.jpg)
Data Visualization - Various Examples
![Page 24: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/24.jpg)
Text Search Analytics
XML and SharePoint
Built-in Functionality
![Page 25: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/25.jpg)
Text Analytics: Google-Style Text Search of All
Historical Work Orders and Quotes
![Page 26: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/26.jpg)
Drill-Down, Drill-Through
Financial Web Reports
Using Microsoft SQL
Server Reporting Services
(SSRS)
![Page 27: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/27.jpg)
Business Intelligence: Parameterized Drill-Down and
Drill-Through Report Technology
Drill-Down
Drill-Through to view detail
![Page 28: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/28.jpg)
Dashboard Reporting
Using Microsoft SQL
Server Reporting Services
(SSRS)
![Page 29: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/29.jpg)
Business Intelligence: Dashboard KPI’s and Metrics
![Page 30: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/30.jpg)
System Resource
Improving Human
Resources
Using Microsoft SQL Server Reporting Services
(SSRS)
![Page 31: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/31.jpg)
System Solutions Streamlining Human Solutions –
Example #1: The Dispatcher’s White Board
Purpose: From Workorder Header, renders scheduling for all to see via web.
![Page 32: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/32.jpg)
Web-Designed Tools:
Systems Resources
Improving Human
Resources
Using Microsoft ASP.NET (Visual Studio)
and SharePoint Publishing
![Page 33: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/33.jpg)
System Solutions Streamlining Human Solutions –
Example #2: Technician Time Sheet Website
Purpose: Auto loads Tech’s time and notes into business system.
![Page 34: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/34.jpg)
Recurring Data
Extraction,
Transformation &
Loading (ETL)
Using Microsoft SQL Server Integration
Services (SSIS)
![Page 35: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/35.jpg)
![Page 36: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/36.jpg)
Microsoft SSIS at the Core
![Page 37: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/37.jpg)
Online Analytical
Processing (OLAP)
Dimensional Cube Built
Using Microsoft SQL
Server Analysis Services
(SSAS)
![Page 38: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/38.jpg)
Business Intelligence: Dimensional Inquiry Using 3D
Data Cube (aka (OLAP) Using Microsoft Office and SQL
Server Analysis Services
* Microsoft SQL Analysis Services rendering data in MS Excel.
![Page 39: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/39.jpg)
Analytics: Dimensional Inquiry Using 3D Data Cube
Using Microsoft SharePoint*
* Microsoft SQL Analysis Services rendering data in a SharePoint website via Excel Services.
![Page 40: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/40.jpg)
Data is the New Oil.
- Meglena Kuneva, European Consumer Commissioner
![Page 41: Work Samples of Charles Balmes (LinkedIN)](https://reader034.vdocuments.us/reader034/viewer/2022051523/5875e5af1a28ab7d5a8b6329/html5/thumbnails/41.jpg)
High Watt Solutions is my company used to invoice contracted work.