Before organising a course or seminar, we listen to the real needs and objectives of each client, in order to adapt the training and get the most out of it. We tailor each course to your needs.

We are also specialists in 'in company' trainings adapted to the needs of each organisation, where the benefit for several attendees from the same company is much greater. If this is your case, contact us.

Ponemos a disposición también plataforma Cloud con todas las herramientas instaladas y configuradas, listas para la formación, incluyendo ejercicios, bases de datos, etc... para no perder tiempo en la preparación y configuración inicial. ¡Sólo preocuparos de aprender!

Ofrecemos también la posibilidad de realizar formaciones en base a ‘Casos de Uso’

Se complementa la formación tradicional de un temario/horas/profesor con la realización de casos prácticos en las semanas posteriores al curso en base a datos reales de la propia organización, de forma que se puedan ir poniendo en producción proyectos iniciales con nuestro soporte, apoyo al desarrollo y revisión con los alumnos y equipos, etc…

En los 10 últimos años, ¡hemos formado a más de 250 organizaciones y 3.000 alumnos!

Ah, y regalamos nuestras famosas camisetas de Data Ninjas a todos los asistentes. No te quedes si las tuyas

1  2  3  4  5

Intensive Sugar-Suite CRM

Intensive Sugar-Suite CRM

Goal

SugarCRM is a system for managing the customer relationship ( CRM ) based on LAMP (Linux -Apache -MySQL - PHP), developed by the company SugarCRM, Inc. located in Cupertino, California.

It has five editions, one free and four other issues with non-free components and a cost per user. SugarCRM is a complete CRM application for businesses of different sizes. It is designed to facilitate sales management, opportunities, business contacts and more. From version 4.5 lets you use SQL Server as a database; and the company has signed agreements with Microsoft to expand its market on Windows servers.

In Stratebi we specialize in implementing integrated CRM and Analytics Solutions, integrating Sugar CRM, CRM Suite, etc... with Pentaho.

Target audiences

Information technology professionals, IT managers, business analysts, systems analysts, Java architects, system developers, database administrators, developers and professionals in relation to the area of technology, marketing, business and financial.

Observations

Certification

All students receiving the course will be given a certificate of attendance.

Syllabus

First day

Introduction to SugarCRM - CRM Concepts
Installation and initial configuration
  • Preparing web server
  • MySQ server configuration
Introduction to administration
  • Admin page
  • Basic System Configuration
System users
  • Defining roles and permissions
  • Creating Users
Company Hierarchy

Second day

Sugar Studio
  • Tags
  • Campos
  • Views
  • Relations
  • subpanels
Module Loader
  • Themes, language
  • Other modules
  • SugarForge
Imports and exports
Best Practices

Curso de PowerBi Avanzado

Curso de PowerBi Avanzado

Goal

¡Aprende con los mejores, Stratebi es Partner Oficial de Microsoft Power BI en España!

Power BI es un conjunto de aplicaciones de análisis de negocios que permite analizar datos y compartir información. ¡Es la solución perfecta destinada a la inteligencia empresarial!

Conoce casos de uso y ejemplos de lo que podrás hacer.

Con Power BI podrás crear potentes informes utilizando diferentes fuentes de datos: SAP HANA, MySQL, Teradata, IBM DB2, Dynamics Navision, CRM, SQL. Archivos de Excel, .CSV, JASON o descargar datos procedentes de servicios en línea como Facebook, Google Analytics, CRM de Salesforce, Marketo, MailChimp...

Stratebi es Partner de Microsoft PowerBi en España

¡Aprende a usarlo siempre estés donde estés!

Formación totalmente práctica 100% con profesores

PowerBI

 

Target audiences

Profesionales de las tecnologías de información, gestores de TI, Analistas de Negocio, Analistas de sistemas, arquitectos Java, desarrolladores de sistemas, administradores de bases de datos, desarrolladores y profesionales con relación a el área de tecnología, marketing, negocio y financiera.

 

Videotutoriales y Manuales publicados por Stratebi

  1. ALM Toolkit para PowerBI
  2. Tabular  Editor con PowerBI
  3. PowerBI Embeded – Buenas Prácticas
  4. PowerBI Tips (vol I)
  5. PowerBI Tips (vol II)
  6. Buenas prácticas con Dataflows en PowerBI
  7. Integracion SAP - PowerBI
  8. Futbol Analytics, lo que hay que saber
  9. Dashboard de medicion de la calidad del aire en Madrid
  10. Como funciona Microsoft Power BI? Videoturial de Introducción
  11. Big Data para PowerBI
  12. Como integrar Salesforce y PowerBI
  13. Videotutorial: Usando R para Machine Learning con PowerBI
  14. Las 50 claves para aprender y conocer PowerBI
  15. PowerBI: Arquitectura End to End
  16. Usando Python con PowerBI
  17. PowerBI + Open Source = Sports Analytics
  18. Comparativa de herramientas Business Intelligence
  19. Use Case Big Data “Dashboards with Hadoop and Power BI”
  20. Todas las presentaciones del Workshop ‘El Business Intelligence del Futuro’
  21. Descarga Paper gratuito: Zero to beautiful (Data visualization)
  22. Aprender DAX Studio para Power BI
  23. Power BI Report Builder

Syllabus

Curso de PowerBi Avanzado

  •  Online

Fecha: Del 17 de feb. al 18 de feb. de 2021

Horario: 15:00 h - 21:00 h ( CEST - Madrid)

Lugar: Plataforma web con profesor

Precio: 95 € (iva no incluido)  / persona 

Pago: PayPal o Trans. Bancaria (Consultar)

Certificado: Entrega a todos los asistentes

 

 

1. Lenguaje DAX (2-3 jornadas)

  • Contextos de evaluación en DAX
  • Medidas y columnas calculadas
  • Creación de tablas
  • Operaciones de filtrado
  • Operaciones lógicas
  • Operaciones matemáticas y estadísticas
  • Operaciones de inteligencia de tiempo
  • Operaciones con cadenas de texto
  • Otras funciones DAX
  • Seguridad a nivel de fila (RLS)
  • Dax Quiz
  • Ejercicios

2. Dataflows (2-3 horas)

  • Introducción a Dataflows
  • Conceptos de Dataflows
  • ETL con Dataflows
  • Buenas prácticas
  • Lenguaje M
  • Ejercicios

3. External Tools (2-3 horas)

  • Tabular Editor
    • Introducción a Tabular Editor
    • Grupos calculados
    • Perspectivas
    • Advanced Scripting
    • Ejercicios
  • DAX Studio
  • ALM Toolkit

4. Conceptos avanzados (1 jornada)

  • Data Gateways
  • Agregaciones
  • Modelos duales
  • Machine Learning en Power BI
  • Python en Power BI
  • R en Power BI
  • Microsoft Teams con Power BI
  • Power BI Report Builder

5.- Buenas prácticas Microsoft Power BI (menos de 1 hora)

6.- Ejercicios (opcional)


ETL Kettle Pentaho

ETL Kettle Pentaho

Goal

Extraction, transformation and loading (ETL) of data is the key to success in a BI system for managing the quality of the data properly.

In this course you will have some of the best practices that we recommend for the design of ETL processes such as:

Centralization of procedures so that the coherence and consistency of the exchanged data from different sources is ensured.

Avoid redundancy calculations: if there is data previously calculated in the operational databases should not return to the calculation performed in the extraction. This premise aims to achieve a double objective.

Establishment of points of "quality control" and validation.

Implement processes charging information for possible errors in the initial information.

Consider the possibility of using intermediate tables with the most atomic level of information to be treated.

In addition, we will review the most important and used ETL tool Pentaho elements: Pentaho Data Integration and Kettle.

Target audiences

Professionals information technology, IT managers, business analysts, systems analysts, Java architects, system developers, database administrators, developers and professionals in relation to the area of technology, marketing, business and financial.

Observations

Data Quality and Integration with Pentaho

Syllabus

Introduction Open Source Business Intelligence Platforms
  • Architecture and features of Pentaho, SpagoBI , BIRT , Mondrian , Kettle , Talend , etc ...
  • Development Tools.
ETL (Kettle)
  • Good practices for ETL process definition.
  • Functional Overview (work, Transformations, flow control)
  • Parameterisation
    • Environment Variables
    • Parameterization of connections to databases. Shared connections.
    • Parameterization of loads and load types
  • Jobs
    • Overview
    • Steps types (Mail, File Managament, etc ...)
    • Description of Steps
    • Steps examples of more useful and common
  • Transformations
    • Overview
    • Steps types (Input, Output, Tranform, etc ...)
    • Description of Steps
    • Steps examples of more useful and common
  • Practical examples

Dashboards and Scorecards

Dashboards and Scorecards

Goal

Dashboards are fully open and can integrate all kinds of external components : Google Maps, RSS news, Twitter, Facebook info, external sources, etc.

Dashboards are the great strategic tool for managers and analysts today.

They have become the most powerful to follow the progress of the company and the market competitive weapon , and react quickly and effectively.

In addition , by identifying the KPI (Key Performance Indicators) keys corporate organization Scorecards are implemented, following the methodology of Norton and Kaplan.

The aim is to teach students to build advanced methods Reporting and Dashboards data mining resources of a system on Pentaho Business Intelligence to analyze data from various sources and systems.

Target audiences

Professionals information technology, IT managers, business analysts, systems analysts, Java architects, system developers, database administrators, developers and professionals in relation to the area of technology, marketing, business and financial.

Observations

Os incluimos las principales claves para construir potentes Cuadros de Mando, del Curso de creación de Dashboards Open Source:


<iframe class="col-offset-xs-2" frameborder="0" height="485" marginheight="0" marginwidth="0" scrolling="no" src="//www.slideshare.net/slideshow/embed_code/key/wb7K1ZIwm6iBe" style="border:1px solid #CCC; border-width:1px; margin-bottom:5px; max-width: 100%;" width="595"></iframe><br />

Syllabus

Introduction Open Source Business Intelligence Platforms
  • Architecture and features of Pentaho, SpagoBI, BIRT, Mondrian, Kettle, Talend, etc.
  • Development Tools.
Introduction to Scorecards
Good practices in Dashboards
ScoreCards and Scorecards
Dashboards custom (Different technologies and examples)
CDF technologies and CDE
installation CDE
Working with CDE
  • Understanding Layouts components
  • Data Extraction (CDA Technology)
    • File structures
    • Kettle origin
    • Source Definition (JNDI)
    • MDX and SQL queries
  • Graphic elements
  • Parameterisation and dependencies
  • Interaction between graphical elements
  • advanced elements
    • Xactions
    • Integration of external graphics libraries
  • Applying CSS Styles
  • Javascripting
  • Export Dashboards
  • Dashboards for mobile devices
  • Advanced exercises

Contacto

Ajustamos cada curso a sus necesidades.

Nuestra oficina en Madrid