Business Process Management and Process Mining within a Real Business Environment: An Empirical Analysis of Event Logs Data in a Consulting Project

Il presente elaborato esplora l’attitudine delle organizzazioni nei confronti dei processi di business che le sostengono: dalla semi-assenza di struttura, all’organizzazione funzionale, fino all’avvento del Business Process Reengineering e del Business Process Management, nato come superamento dei limiti e delle problematiche del modello precedente. All’interno del ciclo di vita del BPM, trova spazio la metodologia del process mining, che permette un livello di analisi dei processi a partire dagli event data log, ossia dai dati di registrazione degli eventi, che fanno riferimento a tutte quelle attività supportate da un sistema informativo aziendale. Il process mining può essere visto come naturale ponte che collega le discipline del management basate sui processi (ma non data-driven) e i nuovi sviluppi della business intelligence, capaci di gestire e manipolare l’enorme mole di dati a disposizione delle aziende (ma che non sono process-driven). Nella tesi, i requisiti e le tecnologie che abilitano l’utilizzo della disciplina sono descritti, cosi come le tre tecniche che questa abilita: process discovery, conformance checking e process enhancement. Il process mining è stato utilizzato come strumento principale in un progetto di consulenza da HSPI S.p.A. per conto di un importante cliente italiano, fornitore di piattaforme e di soluzioni IT. Il progetto a cui ho preso parte, descritto all’interno dell’elaborato, ha come scopo quello di sostenere l’organizzazione nel suo piano di improvement delle prestazioni interne e ha permesso di verificare l’applicabilità e i limiti delle tecniche di process mining. Infine, nell’appendice finale, è presente un paper da me realizzato, che raccoglie tutte le applicazioni della disciplina in un contesto di business reale, traendo dati e informazioni da working papers, casi aziendali e da canali diretti. Per la sua validità e completezza, questo documento è stata pubblicato nel sito dell'IEEE Task Force on Process Mining.

Diagnosis of Student’s Attitudes towards Mathematics in the First Year of Three Graduate Programs in Business Administration

The objective of this research was to determine the student’s attitudes towards Mathematics at the beginning of their graduate studies in Business Administration. The study used an exploratory, non-experimental, cross-sectional design. The instrument used was a questionnaire based on willingness, confidence, utility, motivation and anxiety with Likert questions. The study concluded that students have a negative attitude towards Mathematics; it is considered as a useful but difficult discipline and, for that reason, students show anxiety and lack of confidence when applying mathematical procedures.

The role of spreadsheets in an investigation of Fibonacci numbers

We introduce a function Z(k) which measures the number of distinct ways in which a number can be expressed as the sum of Fibonacci numbers. Using a binary table and other devices, we explore the values that Z(k) can take and reveal a surprising relationship between the values of Z(k) and the Fibonacci numbers from which they were derived. The article shows the way in which standard spreadsheet functionalities makes it possible to reveal quite striking patterns in data.

Letters and numbers in Excel : fostering student engagement in fundamentals of maths & computing

The television quiz program Letters and Numbers, broadcast on the SBS network, has recently become quite popular in Australia. This paper considers an implementation in Excel 2010 and its potential as a vehicle to showcase a range of mathematical and computing concepts and principles.

Colour by numbers in Excel 2007 : solving algebraic equations without algebra

This is an update of an earlier paper, and is written for Excel 2007. A series of Excel 2007 models is described. The more advanced versions allow solution of f(x)=0 by examining change of sign of function values. The function is graphed and change of sign easily detected by a change of colour. Relevant features of Excel 2007 used are Names, Scatter Chart and Conditional Formatting. Several sample Excel 2007 models are available for download, and the paper is intended to be used as a lesson plan for students having some familiarity with derivatives. For comparison and reference purposes, the paper also presents a brief outline of several common equation-solving strategies as an Appendix.

Fun with Fibonacci

We introduce a function which measures the number of distinct ways in which a number can be expressed as the sum of Fibonacci numbers. Using a binary table and other devices, we explore the values that can take and reveal some interesting patterns. The article shows how standard spreadsheet functionalities make it possible to reveal quite striking patterns in data, and is intended to be used in the classroom.

The slumbarumba jumbuck problem

The potential for simple linear relationships arising from a computer game to build student modelling and "world problem" skills is explored. The fundamental capability of the spreadsheet to tabulate and graph possible solutions is used to lay bare the problem structure for the students.

Exploring the fundamental theorem of arithmetic in excel 2007

This paper discusses how fundamentals of number theory, such as unique prime factorization and greatest common divisor can be made accessible to secondary school students through spreadsheets. In addition, the three basic multiplicative functions of number theory are defined and illustrated through a spreadsheet environment. Primes are defined simply as those natural numbers with just two divisors. One focus of the paper is to show the ease with which spreadsheets can be used to introduce students to some basics of elementary number theory. Complete instructions are given to build a spreadsheet to enable the user to input a positive integer, either with a slider or manually, and see the prime decomposition. The spreadsheet environment allows students to observe patterns, gain structural insight, form and test conjectures, and solve problems in elementary number theory.

Basic finance made accessible in Excel 2007 : "the big 5, plus 2"

The basic principles and equations are developed for elementary finance, based on the concept of compound interest. The five quantities of interest in such problems are present value, future value, amount of periodic payment, number of periods and the rate of interest per period. We consider three distinct means of computing each of these five quantities in Excel 2007: (i) use of algebraic equations, (ii) by recursive schedule and the Goal Seek facility, and (iii) use of Excel's intrinsic financial functions. The paper is intended to be used as the basis for a lesson plan and contains many examples and solved problems. Comment is made regarding the relative difficulty of each approach, and a prominent theme is the systematic use of more than one method to increase student understanding and build confidence in the answer obtained. Full instructions to build each type of model are given and a complete set of examples and solutions may be downloaded (Examples.xlsx and Solutions.xlsx).

Insight into the fractional calculus via a spreadsheet

Many students of calculus are not aware that the calculus they have learned is a special case (integer order) of fractional calculus. Fractional calculus is the study of arbitrary order derivatives and integrals and their applications. The article begins by stating a naive question from a student in a paper by Larson (1974) and establishes, for polynomials and exponential functions, that they can be deformed into their derivative using the μ-th order fractional derivatives for 0<μ<1. Through the power of Excel we illustrate the continuous deformations dynamically through conditional formatting. Some applications are discussed and a connection made to mathematics education.

Revisiting Polya's summation techniques using a spreadsheet : from addition tables to Bernoulli polynomials

Recurrence relations in mathematics form a very powerful and compact way of looking at a wide range of relationships. Traditionally, the concept of recurrence has often been a difficult one for the secondary teacher to convey to students. Closely related to the powerful proof technique of mathematical induction, recurrences are able to capture many relationships in formulas much simpler than so-called direct or closed formulas. In computer science, recursive coding often has a similar compactness property, and, perhaps not surprisingly, suffers from similar problems in the classroom as recurrences: the students often find both the basic concepts and practicalities elusive. Using models designed to illuminate the relevant principles for the students, we offer a range of examples which use the modern spreadsheet environment to powerfully illustrate the great expressive and computational power of recurrences.

Gestão do conhecimento

Dissertação para obtenção do Grau de Mestre em Assessoria de Administração

La gestion des ressources humaines et le succès des projets : le cas des pays en voie de développement

Les spécialistes de la gestion de projet sont partagés entre ceux qui défendent l’importance des pratiques de la GRH dans le succès global des projets et ceux qui demeurent sceptiques quant à l’existence d’une telle relation. Notre étude a pour objectif d’enrichir ce débat en tentant de confirmer ou infirmer l’existence d’une relation entre la GRH et le succès des projets dans les pays en voie de développement (PVD). La réalisation d’une étude dans les PVD, où les conditions (économiques, sociologiques, politiques, et cultuelles) sont différentes des pays industrialisés, permettra de savoir si la relation entre la GRH et le succès de projet varie en fonction des pays où le projet est implanté. Le choix de ce sujet de recherche est d’autant plus justifié que les études portant sur les facteurs de succès des projets dans les PVD, et en particulier sur la relation entre la GRH et le résultat de projets dans ses pays, sont plutôt rares. Nos résultats ont révélé que, bien que la GRH ait une relation significative avec le succès des projets dans les PVD, elle présente la corrélation la moins forte avec ce succès par rapport aux autres facteurs de succès étudiés. Ce résultat surprenant peut être expliqué essentiellement par les caractéristiques des PVD qui affectent la gestion de projet et la gestion des ressources humaines dans cette catégorie de pays. Il pourrait s’expliquer également par les caractéristiques spécifiques à la GRH dans le contexte de projet. Afin de mieux comprendre la relation entre les pratiques de GRH et le succès des projets dans les PVD, les recherches futures devraient accorder une attention particulière aux caractéristiques de la GRH propres au contexte de projet en général et au contexte de projet dans les PVD en particulier.

L’implication du syndicat dans la gestion de la prestation des services municipaux : une comparaison Québec-Écosse

Pour devenir plus flexible, le secteur public a ouvert la voie à de nouveaux principes inspirés de la gestion propre aux firmes, soit la marchandisation des services (Fairbrother et Poynter, 2001). Notre recherche souhaite mieux comprendre les facteurs qui peuvent influencer l’implication du syndicat lorsque la marchandisation est introduite dans la gestion de la prestation des services municipaux. Pour se faire, nous avons choisi de comparer des cas des municipalités dans deux pays, la Ville de Québec et Edinburgh en Écosse, afin de nous aider à comprendre davantage les interactions entre les influences nationales et locales. Nous proposons que les ressources de pouvoir du syndicat local et la stratégie patronale influencent l’implication du syndicat dans la gestion de la prestation des services municipaux, peu importe le contexte national. Les résultats de la recherche nous indiquent que les ressources de pouvoir et la stratégie patronale influencent directement l’implication syndicale. Alors que les ressources de pouvoir donnent un rapport de force au syndicat face à l’employeur, la stratégie patronale peut encourager ou freiner l'implication syndicale. Nos résultats ont aussi soulevé certaines différences entre les contextes nationaux de l’Écosse et du Québec affectant l’implication syndicale: les législations de « Best Value » au Royaume-Uni et celles encadrant les conventions collectives et relations de travail au Québec. Ainsi, des recherches futures sont nécessaires pour mettre à l’épreuve les modèles nationaux couramment utilisés en relations industrielles pour contribuer à la création d’une nouvelle théorie comparative.