BI Bash
Anna Lee Munns
Created on September 12, 2023
More creations to inspire you
Transcript
Climb to New Heights
2023
BI BASH
nrl source databases
users
113
usa units
global accounts
hours
2,261
participants
242
collaborationpoints
1,993
projects
19
users
2,139
applications
480
nrl source databases
users
113
usa units
global accounts
hours
2,261
participants
242
collaborationpoints
1,993
projects
19
users
2,139
applications
480
ARCHITECTURE
WHY SNOWFLAKE?
DATA MODELING
REAL TIME VISUALIZATION
TARGET LOCATION FOR TRANSFORMATIONS AND DATA SCIENCE MODELS
NEAR REAL TIME REPORTING DEMANDS
MARKET INTELLIGENCE INTEGRATION
FEED DATA SCIENCE PIPELINES DYNAMICALLY
DATA SHARING WITH JBS PARTNERS
REPLACE NEED TO HIT TRANSACTIONAL DATABASE DIRECTLY
DATA SHARING ACROSS JBS BUSINESS UNITS
AD HOC DATA DISCOVERY
Risk ManagementHRProcurement
Projects
Global
PilgrimsHRProcurement
Volur Carcass Optimization
Shop FloorCPS BeefECSKronosM-Tech Poultry
Sharing
Data
Transformation
Raw
Business
Data
global hr project
MIX OPTIMIZATION
Change Price and LimitsUpdate/show results in Qlik
“What-if” analysis
Unsold items optimization All items optimization
Optimized use cases
Baseline Commodity only Solver with production constraints Solver with no production constraints
Compared scenarios
Sales Volume Price Yields Limit
Considered variables
MIX OPTIMIZATION: Dataiku
MIX OPTIMIZATION: Front End
budget project
Introducing the
Repair &Maintenance
Property Taxes
R&D
Postage
Employee Relations
Insurance
Supplies
Telephone
Taxes
Payroll
Travel & Entertainment
Telecom
ComputerExpense
Transportation
Utilities
Lease & Rent
how we used to do it
06
round 1 review, spend less money, repeat steps 2-6
05
reload bpc, email again
04
make changes based on summary report, email again
03
load aggregated data into bpc,email back summary report
02
fill out template, be sure not to share sensitive data, email back
01
create template by cost center, email to owner
cost centers
786
users
355
simplified
"Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper"
Lorem ipsum dolor sit amet, cons ectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper
Andrea Riva