BI & Data Analitics; Data Analytics Portfolio

Project 1: DataBase & BI reporting: Project Overview

• BI REPORTING STRUCTURE: Create a system of BI reporting which allows a display of data and reporting system, to track the performance of the program.

1. Definition of reporting tool
2. Definitions of KPIs
3. Definition and elavoration of the dashboard, regular reporting, and ad-hoc reporting

• DATABASE STRUCTURE: Design and create a solid database which contain structural data, easy to retrieve which allows answer simples queries.

1. Data gathering porcess and normalization
2. ETL procces
3. Database estructure: variables – dimensions, define transactional tables, schemas (star)- data types
4. Data base Wharehouse – site – back up - testing
5. Data Visualization on Qlick View and PowerPoint

Project 2: Analysis of trends and metrics for La.Radio.live

For this project I have select and define a series of metrics, relevant to analyze the performance of the Facebook site for the company, LaRadio.live

Gathering all this information I was able to summary the performance of the Facebook site, estimate by linear regression the future like level. Through this analysis I have generated actionable conclusions and extraction of actionable insights, in order to calibrate the marketing strategy of the company.

Broadcasting Performance:

Project 3.1 (Tableau): Support Function Cost Automation: Objetives, Estructure & Dashboards

• OBJECTIVES:

1. To improve collection, preparation and display of data to promote a change in financial analysis department.
2. Automatization of process that it is been build from different sources (SAP ERP, ORACLE, manual settings, local files)

• ESTRUCTURE:

• DASHBOARDS:

Project 3.2 (PowerBI): Support Function Cost Automation + Sales: Objetives, Estructure & Dashboards

• OBJECTIVES:

1. To improve collection, preparation and display of data to promote a change in financial analysis department.
2. Automatization of process that it is been build from different sources (SAP ERP, ORACLE, manual settings, local files)

• ESTRUCTURE:

• DASHBOARDS:

Mobile expenses by Business Unit.

Sales by Business Unit

Project 4: Finances BI Report: Project Overview

• OBJECTIVES:

1. Provide to the finances department a BI solution in order to improve the collection and display of data
2. Improve data visualization and analytics through Tableau softwares

Note: WIP

Project 5: Deploying BI solution & Advanced analytics with IDS - AWS + Tableau

• BI REPORTING ESTRUCTURE: Create a system of BI & Advance analitic reporting which allow to cover Business use case (bussines analitics demands)

1. Definition of Use case (Agile / kanva methodology)
2. Business/Data Analysis + prioritization: How to solve the use case and how we prioritize the backlog
3. Data Architecture: What is the data architecture I need to resolve this problem
4. Definitions of KPIs, business rules, data quality rules, Critical data elements
5. Deploy data governance: to guarantee that the technical solution is in compliance with the company data strategy (Dat quality, tools, data security)
6. Development part: Coding (Scrum master methodology) + UAT + delivering the model
7. Definition of the dashboard, regular reporting, and ad-hoc reporting

• DATABASE STRUCTURE: Design and create a solid database that contains structural data, easy to retrieve which allows answer simple queries + live data connection

1. Data gathering process and normalization
2. ETL process + data ingestion
3. Database structure: variables – dimensions, define transactional tables, schemas (star)- data types
4. Database Wharehouse – site – back up - testing

• Process automation by DDBB deployment: Data flow

• Data Architecture + data ingestion for data model customization

Note: WIP

Project 6: Deploying Data Governance base on DCAM approach

• What is the right strategy to develop a solid data analytic environment in an organization
• Customizing DCAM based on the particularities of your organization
• Active data security: Virtuous data quality circle
• Active data security: Data attack surface - Data breach map - Deploy of the control point of access

Note: WIP

Project 7: Data Architecture for quotation model

1. Data research to create a quotation model based on SAP
2. Data ingestion and analysis
3. JOIN STATEMENT identification on SQL code
4. Data architecture to be programming on a ETL software (Power Center/ Informatica Cloud /SnapLogic)
5. Designing the data schema nad architecture

Target Tables - Source tables - SQL JOIN STATEMENT

Project 8: Machine Learning model- recommendation system for the sales team

1. Scoping and flameworking the problem statement: use case elaboration
2. Data Reserach and exploration: exploring the data available on the database level and data sources
3. IT architecture for scalable machine learning models: what is the right IT architecture to scale models?

Note: WIP