skills for tomorrow etc.download.microsoft.com/.../learning_analytics.pdf · 2018-12-05 · will...
TRANSCRIPT
Welcome to Building Skills for TomorrowDoors Etc.
1
Introducing MeSenior consultant Wardy IT SolutionsDelivery Enterprise Business Intelligence and Data Warehousing solutionsMicrosoft Certified TrainerMicrosoft Certified Technology Specialist (Business Intelligence)VirgoWant to help you see how easy and how rich and powerful BI capability
Introducing You
Introducing Microsoft SQL Server AnalyticsMicrosoft Business Intelligence Solutions
B.I. since 2000Bigger, Smarter, Prettier, More PowerfulReal offering Self Service B.I.
Introduce the Customer John Paul College – Real Life Case StudyPain PointsMade a PlanHow BI made a difference
2
3
4
If this is sounding all too familiar
You are not alone
John Paul College case study
Suffering from a number of problems
They have a Josh in I.T., Leslie, Henk, Brad and Mike
Run through problems
5
Introduce B.I. stack
Introduce dating room example
Each one fits a purpose.
6
Not going to give up any time soon
Do you think they will ever let up
Do you think they will eventually get frustrated and give up
Not going to stop
Continue collecting structured and unstructured data required to make decisions
Strategic
Analytic
Tactical
Operational
People change, schools change, external factors change
7
Introducing Leslie
Works in Admin
Processes Student admissions, request and other adhoc duties
Constantly works in the student admin system
Despite IT system low confidence and skills in IT
No desire to work with Excel
But needs information to make daily decisions
Problem – School admin designed for in not outLeslie needs to screen hop in a big way to collect the information she needs to
support decisionSome basic reports in the system but they run all too slowand don’t have all the information she needsSome of the data is in the system is also dirty – low confidence
If only there was a better way
8
Introducing Henk
Big Boss man
Leadership
Incremental I.T.
Understands I.T. is the sort of thing that help transform his organization
Doesn’t know how to work his blackberry
He understands the organisations key performance indicators
Needs adhoc trends and scorecards but usually not within timeframes that support the decisions
Wouldn’t it be good to have a collaboration portal for all your information needs
9
Meet Brad
All‐round nice guy
Did Fortran and Cobol at Uni then went on do to accountancy and CPA
Uses Excel for daily decisions
Knows Excel like back of his hand
Knows how to write queries and will perform ad hoc queries any time of day
Needs info for daily decisions
Needs forecasting and trending to analysis dollars over time
Not afraid to get his hands dirty
Believes creating an army of spreadsheets is necessary to support decision making and automation
10
Mike heads of the property department
Makes daily decisions from a wide various of different department areas
Dependencies to assist in planning maintenance
Organising external contractors
Planning around day to day school activities and events
Cost and Budget constraints
Keep the kids, parents, teachers and school department happy
Not an I.T. bug but Mike taught him how to write queries and he gets what he needs from transaction systems as he doesn’t want to bother I.T.
Makes decisions in spite of I.T. because of inaccuracy and incompleteness
11
Link worker bees to information workers
Information to support daily decisions
12
I.T. systems optimised for getting data in not out
Have inherent anomalies or quirks
Information workers and decision makers know how to work around and live with these anomalies to get the information they need within the time and resource constraints they have.
13
Will make decisions even if they don’t have the data or don’t have the confidence in the data they have.
This picture shows a team making decisions at the commencement a P&C meeting.
Use of a pen, paper, an IPhone calculator, a bar to lean on and a glass of beer
14
Introducing Josh (Jose)
By the smiles, I can tell You have one of these
Quick learner
Great attitude
Loves his Mum and loves helping with People
Keen to learn new skills
Problem – way too busy to help everybody
Josh is a bottleneck
Responding to new business requests is much slower
But wouldn’t it be good if we could show the business
Leaving Josh to control, manage and secure that environment
15
Explain what happens when two highly motivated query writers attempt to draw information out of the database while Leslie is trying to enter data into the system during peak hours.
16
Explain how Mike and Brad
Can get different sets of figures
Because of different ways of writing queries
17
Need to make decisions faster than information provided
18
Poor data
Poor decisions
Incomplete data, inaccurate data, ineffective use and interpretation can ultimate lead to time and cost pressures
19
Introduce why John Paul College chose to use Microsoft Business Intelligence solutions
20
Introduce organisational approaches to business intelligence.
Use pain points to build discussion on how business intelligence systems evolve
How different approaches produce different yields.
21
Products are aligned with a business intelligence methodology
22
Sooner or later I.T. are going to be dragged into this BI thing
Highlight the typical startup activities and cover off any ongoing activities and commitments
Here would be a good slide to explain the explosion of I.T. – are you ready.
23
Introduce and ask questions about Self Service check in
Figure out how to creation actions
24
25
26
27
28
29
30
31
32
33
34
35