In a time where information is ever present and in large quantities, it becomes of extreme importance to organisations to find a way to store and analyse all this information in order to maintain their position on the market. One way to deal with this, which has been adopted by large company groups as well as smaller organisation, is the use of business intelligence, BI. This feature helps organisations to store and analyse information and provide analytical reports to support decision making. Despite the fact that BI has been around for a couple of decades it is still a rather new phenomena with a couple of problem areas which has been highlighted by several international studies and articles. Sweden as a market has been considered as somewhat of a pioneer when it comes to IT-development in general and early usage of business intelligence as well as the emerging trend in the business intelligence market; self-service BI. This solution aims to make business intelligence more user friendly in order to increase the amount of users and ease the pressure on IT-departments within organisations. The purpose of this study is to identify these problems and investigate whether they can be applied to decision makers on the Swedish market and if self-service BI is affecting these problems. The study was done by using a survey with 46 respondents from different organisations located in Sweden. The result shows that the problem areas were not recognised by the majority of the respondents and there were correlations between user-friendliness and how often the respondents used self-service BI.

Conselho Nacional de Desenvolvimento CientÃfico e TecnolÃgico / FundaÃÃo Cearense de Apoio ao Desenvolvimento Cientifico e TecnolÃgico / Neste texto, à mostrado que conjuntos definÃveis bi-Lipschitz homeomorfos tem cones tangentes bi-Lipschitz homeomorfos. AlÃm disso, no caso de conjuntos analÃticos complexos, regularidade Lipschitz ou regularidade topolÃgica forte implica em regularidade analÃtica. TambÃm à feito um estudo regularidade de conjuntos analÃticos reais. Ademais, à dada uma classificaÃÃo completa para curvas analÃticas complexas no espaÃo e sÃo apresentados alguns resultados sobre invariÃncia da multiplicidade. Em especial, à mostrado que a multiplicidade mod 2 de conjuntos analÃticos reais à invariante por difeomorfismos. / In this paper, it is shown that definable sets bi-Lipschitz homeomorphic have tangent cones bi-Lipschitz homeomorphic. Furthermore, in the case of complex analytical sets, Lipschitz regularity or strong topological regularity implies analytical regularity. It is also done a complete study on regularity of real analytic sets. Furthermore, it is given a complete classification for complex analytical curves in space and are shown some results about invariance of the multiplicity. In particular, it is shown that the multiplicity of real analytical sets is invariant mod 2 under diffeomorphisms.

Coordenação de Aperfeiçoamento de Pessoal de Nível Superior / An efficient method to obtain pyrimidinones and pyrimidines trialomethylated from the cyclocondensation reaction of compounds of methyl 7,7,7-trihalo-4-methoxy-6-oxoheptenoate with urea and differents amidines providing the series of compounds pyrimidines and pyrimidinones trifluoromethylated and trichloromerthylated is reported.Some compounds of the series were selected and brought to reaction with hydrazine monohydrate obtaining the series of new 6-(trifluoromethyl)pyrimidin-4-propanehydrazide, of which two were later brought to reaction with a series of β-alkoxyvinyltrifluoromethyl ketones giving the new series of bis-heterocyclic 4-[(5-(trifluoromethyl)-5-hydroxy-4,5-dihydro-1H-pyrazol-1-yl)-1-propan-1-one-3-yl]-6- (trifluoromethyl)pyrimidine compounds. The structures of all synthesized compounds were confirmed by 1H and 13C NMR data, and two-dimensional NMR techniques like HETCOR and COLOC, ans mass spectrometry data. / Este trabalho descreve um método eficiente para a obtenção de pirimidinonas e pirimidinas trialometiladas a partir da reação de ciclocondensação [3+3] dos compostos (7,7,7-trialo-4-metoxi-6-oxo-4-heptenoatos de metila com uréia e diferentes amidinas fornecendo a série de pirimidinas e pirimidinonas 6-trifluormetil substituídas e 6-triclorometil substituídas. Alguns compostos da série de pirimidinas trifluormetiladas foram selecionados e levados à reação com monohidrato de hidrazina obtendo-se a série de novas 6-trifluormetilpirimidina-4-propanohidrazida, das quais, duas posteriormente foram levadas à reação de ciclocondensação com uma série de β-alcoxivniltrifluormetil cetonas alquil e aril substituídas dando a nova série de compostos bi-heterocíclicos 4-[(5-(trifluormetil)-5-hidroxi-4,5-diidro-1H-pirazol-1-il)-1-propan-1-ona-3-il]-6-(trifluormetil)pirimidinas. As estruturas de todos os compostos sintetizados foram confirmadas por dados de RMN 1H, 13C e técnicas de RMN bidimensionais como HETCOR e COLOC, além de dados de espectrometria de massas.

This diploma thesis deals with an analysis of SAP Business Intelligence platform (SAP NetWeaver BI 7.0) and compares its chosen tools with Microsoft SQL Server BI. The main aim of the thesis is to evaluate SAP BI system in a comprehensive way whereas extra attention is paid to certain areas, such as a data warehouse. One of the goals is the comparison of approaches and methods of the creation of the data warehouse with MS SQL Server BI solution. The thesis consists of theoretical insight into Business Intelligence, which is focused on the architecture of data warehouse, and OLAP technologies. There is an evaluation of the role of SAP in the BI market followed by the introduction of SAP NetWeaver, an application and integration platform. Included is also an analysis of the architecture of data warehouse, methods of storing data, ETL process and other chosen functions and tools (including presentation tools) in next sections. A sample application in the final part provides the reader with better understanding of different ETL approaches, which are analyzed into detail and evaluated. There is the comparison of OLAP technologies in the end and the comparison of basic reporting tools, as well.

The thesis describes implementation of Business Intelligence solution in mid-sized company which produces and sells animal nutrition products. Currently the company uses basic tools for reporting, mostly Excel application. Considering the data growth, that solution is about not to be sufficient. In the first part of the thesis, the Business Intelligence principals are introduced to the reader, so one is provided with enough knowledge to understand the issue of data processing, transforming and storing. Basics of data visualization used for decision making in the company are introduced as well. At the end of the chapter, there is a list of general rules for creating a dashboard. The secord part describes the Trouw Nutrition Biofaktory s.r.o. company, where the implementation of new Business Intelligence solution is going to take place. The reader will learn about the company size, structure and history. The last part contains a new procedure how to process data for reporting purposes. The design includes data loading to MS SQL 2012 database server and further processing for analytical purposes. In addition, OLAP cube is created as well as three monthly dashboards.

The thesis covers the term for specific data analysis called Big Data. The thesis firstly defines the term Big Data and the need for its creation because of the rising need for deeper data processing and analysis tools and methods. The thesis also covers some of the technical aspects of Big Data tools, focusing on Apache Hadoop in detail. The later chapters contain Big Data market analysis and describe the biggest Big Data competitors and tools. The practical part of the thesis presents a way of using Apache Hadoop to perform data analysis with data from Twitter and the results are then visualized in Tableau.

This thesis addresses current topic of self-service business intelligence solutions. The main goal is to create a dimensional model and pilot applications for retail used for Management of Business Informatics (MBI). In order to achieve it is main goal there are four steps, to be taken. During fulfilling of these steps minor and practical goals are achieved as well. Minor goal focuses on comparison of the advantages and disadvantages of current business intel-ligence approaches. Practical goal is to create reports and dashboards for Management of Business Informatics (MBI). The first step is to introduce the issue of classic and self-service BI concluded by comparison of both variants. The second step is the definition of retail and identification of potential indicators. The third step is the introduction of Mi-crosoft´s self-service BI technologies and tools. The fourth step is to create applications for retail in MBI using tools PowerPivot and Power View. The main contribution of this work is to create reports and dashboards that are able to support processes of general retail mod-el. Reports and dashboards will serve as pilot applications for MBI. Another contribution is to acquaint readers with the possibilities of tools PowerPivot and Power View.

Submitted by Nadir Basilio (nadirsb@uninove.br) on 2015-07-27T13:39:57Z No. of bitstreams: 1 Renata Mara Bueno Aguiar.pdf: 3052806 bytes, checksum: 7fc933a7df31cf76bd53ddfab6dc00d3 (MD5) / Made available in DSpace on 2015-07-27T13:39:57Z (GMT). No. of bitstreams: 1 Renata Mara Bueno Aguiar.pdf: 3052806 bytes, checksum: 7fc933a7df31cf76bd53ddfab6dc00d3 (MD5) Previous issue date: 2013-12-11 / Objective: To analyze the mammographic radiologic findings during screening campaigns of a Brazilian Oncology Center. The mammographic radiologic findings, the complementary diagnostic tests eventually requested and the patient’s adherence to the screening recommendations were studied. Methods: A retrospective study was conducted including all 771 patients that participated in the stimulated and gratuitous screening program of the A. C. Camargo Cancer Center, São Paulo, Brazil, during 2008. The patient’s records were analyzed in order to obtain result from mammography tests, breast ultrasonography, biopsies and surgeries. Results: The women`s age varied from 24 to 107 years old. (average: 55 years old), 259 (34%) under 50 years old, 423 (55%) between 50 and 69 years old and 89 (11%) older than 69 years old. The mammography results were classified as follows: BI-RADS 0 =186 (25,1%), BI-RADS 1 = 114 (14,8%), BI-RADS 2 =395 (51,2%), BI-RADS 3 =50 (6,5%), BI-RADS 4 = 16 (2,1%) e BI-RADS 5 =2 (0,3%). Complementary ultrasonography exam was performed in 184 (24%) of all patients. Thirty three (4%) lesions were submitted to histopathological analyses revealing 6 (8%) cases of cancer. They were 3 invasive ductal carcinomas, 2 in situ ductal carcinomas and 1 lobular carcinoma in situ. Five of those cancers were surgically classified as Stage 1 disease and One as Stage 2 disease. After 4 years 87 (15%) patients returned for new screening exams. Conclusion: There was a meaning ratio of patients out of Brazilian National Cancer Institute (INCA) recommendation for breast cancer screening. The rates of complementary ultrasonography were high. The number of patients diagnosed with cancer and the rates of diagnoses in initial grades are in consonance with the literature. The opportunistic screening model revealed low return rate for new screening tests. / Objetivo: Analisar durante uma campanha de rastreamento para câncer de mama realizada em um Centro Brasileiro de Oncologia. Foram estudados os achados radiológicos das mamografias e as eventuais recomendações de testes diagnósticos complementares e a adesão das pacientes a essas recomendações. Metodologia: Esta foi uma análise retrospectiva incluindo todas as 771 pacientes que participaram das campanhas estimulada e gratuita de rastreamento para câncer de mama do A. C. Camargo Cancer Center, em São Paulo, Brasil, no ano de 2008. Foram avaliados os resultados de mamografias, ultrassonografias, biópsias e cirurgias de mama realizadas. Para os diagnósticos de câncer registramos a histologia e o estadiamento clínico da doença. Resultados: A idade das mulheres variou de 24 a 107 anos (média: 55 anos), 259 (34%) com idade inferior a 50 anos, 423 (55%) com idade entre 50 e 69 anos e 89 (11%) com idades maiores que 69 anos. A classificação segundo o BI-RADS do resultado das mamografias foi: BI-RADS 0 186 (25,1%), BI-RADS 1 114 (14,8%), BI-RADS 2 = 395 (51,2%), BI-RADS 3 = 50 (6,5%), BI-RADS 4 =16 (2,1%) e BI-RADS 5 = 2 (0,3%).O exame ultrassonográfico complementar à mamografia foi realizado por 184 (24%) da amostra. Foram realizadas 33 (4%) investigações anátomo-patológicas identificando 6 (8%) casos de câncer, 3 Carcinomas ductais invasivos, 2 carcinomas ductais in situ e 1 carcinoma lobular in situ. O estadiamento cirúrgico dessas neoplasias foi Estadio 1 para 5 pacientes e Estadio 2 em uma paciente. A revisão dos registros realizada após 4 anos identificou 87 (15%) pacientes que haviam retornado ao serviço para novos exames de rastreamento ao menos uma vez. Conclusão: Uma proporção significativa das pacientes de campanha está fora da faixa etária de recomendação do Instituto Nacional do Câncer do Ministério da Saúde (INCA) para rastreamento do câncer de mama. As taxas de complementação com ultrassonografia foram elevadas. O número de cânceres e a taxa de diagnósticos em estádio inicial estão em consonância com os índices preconizados. O modelo de rastreamento oportunístico mostrou baixa taxa de retorno periódico ao mesmo serviço.

The goal for this thesis work was to develop Business Intelligence (BI) for an IT consultant company. LexiConsult is an IT consultant company in the Lexicon-group which offers expertise within Office (templates, database, spreadsheets, Outlook etc.) but also SharePoint development and services like support, documentation etcetera. We have investigated the functionality in SharePoint and MS SQL Server and have also evaluated which possibilities these platforms offer in terms of creating a BI-solution for LexiConsults needs. SharePoint offers a variety of different tools and services for BI but none of these where available in the Office365-version which LexiConsult uses. Another solution was therefore suggested where the reports should be published on a web hosting company. We have also studied critical success factors when implementing BI in an IT consulting company. The result is a set of BI-reports developed for SQL Server Reporting Services (SSRS), which the staff of LexiConsult can access via their SharePoint site. The reports are designed for monitoring and analysis of the economy with e.g. key performance indicators, drill-down of the revenue in different aspects such as by time period, per employee, per customer etcetera. The reports provides vital knowledge that can be used for decision support, e.g. which customers and which types of projects is the most profitable and should be given priority. Have the consultants had high occupancy rate lately and what is the forecast for the future? Should more consultants be hired? Some of the reports are restricted from access by others than management of the company, and some are accessible by all employees. Data is queried from the SQL-database to the company’s system for booking and invoicing as well as their SharePoint site. This data is transformed to information which should give knowledge about the company and its finances. The result of the thesis work is of interest both within the company and as a product targeting their customers. / Målet med detta examensarbete var att utveckla Business Intelligence (BI) för ett IT-konsultföretag. LexiConsult är ett IT-konsultföretag i Lexicon-gruppen som främst erbjuder expertstöd inom Office (mallar, databaser, kalkylmodeller, Outlook m.m.) men även utveckling och tjänster inom SharePoint, support, dokumentation med mera. Vi har undersökt funktionaliteten i SharePoint samt MS SQL Server och utvärderat vilka möjligheter plattformarna erbjuder för att skapa en BI-lösning som passar LexiConsults behov. SharePoint har stöd för ett antal olika verktyg, tjänster och tekniker för BI men inga av dessa fanns tillgängliga i den Office365-version som LexiConsult använder. Istället föreslogs en lösning där rapporterna skulle publiceras hos ett webhosting-företag. Vi har även undersökt vilka kritiska framgångsfaktorer som finns vid införandet av BI i ett IT-konsultföretag. Resultatet blev ett antal BI-rapporter utvecklade för SQL Server Reporting Services (SSRS) som LexiConsults personal kan ta del av via deras SharePoint-sajt. Rapporterna är utformade för uppföljning och analys av ekonomin med exempelvis indikatorer för viktiga nyckeltal, nedbrytning av intäkterna i olika synvinklar - per tidsperiod, per konsult, per kund och så vidare. Rapporterna ger viktig kunskap som kan användas för beslutstöd, till exempel vilka kunder och vilka typer av uppdrag som är mest lönsamma och ska prioriteras. Har konsulterna haft hög beläggningsgrad den senaste tiden och hur ser prognosen för framtiden ut? Ska ytterligare konsulter anställas? Några av rapporterna är behörighetsstyrda så att endast ledningen har åtkomst till dem, medan andra är tillgängliga för alla. Data till rapporterna hämtas från SQL-databasen till företagets boknings-, och faktureringssystem samt SharePoint-sajt. Detta data omvandlas till information i rapporterna, som ska ge kunskap om företaget och dess ekonomi. Resultatet av arbetet är intressant både för internt bruk inom LexiConsult och som produkt mot företagets kunder.

The purpose of this thesis is to examine racial socialization strategies and practices of white Czech mothers raising biracial black and white children. The research question is theoretically framed by critical race theory perspective. Data were obtained based on an exploratory approach through semi-structured interviews with ten mothers of underage children. Thematic analysis revealed some of the strategies, practices and concepts described in the Western societies. Also, distinct themes in the Czech context emerged, mainly due to the racial homogeneity of the Czech society. The main findings indicate an identification of specific racial socialization strategy connected to hypervisibility of the children, barriers mothers face in developing race related competencies and the absence of preparation for bias.