Business Intelligence Purple Frog Systems Business Intelligence - - PowerPoint PPT Presentation

▶

Mar 14, 2023 667 likes •882 views

Business Intelligence Purple Frog Systems Business Intelligence Consultancy Alex@PurpleFrogSystems.com Hollie@PurpleFrogSystems.com www.PurpleFrogSystems.com @PurpleFrogSys @PurpleFrogIT Introduction Welcome

SLIDE 1

Business Intelligence

Purple Frog Systems Business Intelligence Consultancy

Alex@PurpleFrogSystems.com Hollie@PurpleFrogSystems.com

www.PurpleFrogSystems.com @PurpleFrogSys @PurpleFrogIT

SLIDE 2

www.PurpleFrogSystems.com 2

Introduction

Welcome
Overview of Session

– Problems with data – The BI Solution – Demo – Summary

Who are Purple Frog

SLIDE 3

Purple Frog Systems

Business Intelligence Consultancy

Data Warehousing Data Quality OLAP Cubes Reporting Systems Data Mining Web Design Group of individual experts in their field

SLIDE 4

www.PurpleFrogSystems.com 4

Common Database Problems

Reports impacting server performance
Multiple sources of data
Inconsistent data/terminology

SLIDE 5

www.PurpleFrogSystems.com 5

Common Database Problems

SLIDE 6

www.PurpleFrogSystems.com 6

Data Growth

SLIDE 7

www.PurpleFrogSystems.com 7

The BI Solution

SLIDE 8

www.PurpleFrogSystems.com 8

The BI Solution

Move reporting to separate system
Consolidate, standardise & simplify data
Pre-define and standardise terminology

SLIDE 9

www.PurpleFrogSystems.com 9

What does BI involve?

ETL

Customer Sales Product Date Region Promotion

SLIDE 10

www.PurpleFrogSystems.com 10

BI In Action

SLIDE 11

www.PurpleFrogSystems.com 11

SLIDE 12

www.PurpleFrogSystems.com 12

Load data from CSV Perform data updates Clean empty/incorrect data Lookup postcode to Lat/Long for mapping – data downloaded from internet Fuzzy group the employer to match different spellings Depending on the level of fuzzy match, perform different functions Group the results together Save into a data warehouse

SLIDE 13

www.PurpleFrogSystems.com 13

SLIDE 14

www.PurpleFrogSystems.com 14

SLIDE 15

www.PurpleFrogSystems.com 15

SLIDE 16

www.PurpleFrogSystems.com 16

SLIDE 17

www.PurpleFrogSystems.com 17

What We Didn’t Cover

BI Architecture

– Kimball Vs Inmon

Data Mining

– Predictive modelling – Cluster Analysis – Basket Analysis

Self Service BI

– Report Builders – PowerPivot

Data Cleansing
Dashboards

– KPIs

Unstructured Data

SLIDE 18

www.PurpleFrogSystems.com 18

Summary

Not a product, but a process
Not reports, but a reporting ability
Driven by the business, not IT
Makes staff more efficient
Can provide a greater insight into the business
Don’t do it all at once
Does not have to be expensive

SLIDE 19

www.PurpleFrogSystems.com 19

SQL Server User Group

The First Midlands SSUG Talks / Demos / Q&A for SQL Server Send us your E-Mail address if you’re interested

SLIDE 20

Business Intelligence

Questions.......

Alex@PurpleFrogSystems.com Hollie@PurpleFrogSystems.com www.PurpleFrogSystems.com

@PurpleFrogSys @PurpleFrogIT The Frog-Blog: www.PurpleFrogSystems.com/blog