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.
- Definition of reporting tool
- Definitions of KPIs
- 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.
- Data gathering porcess and normalization
- ETL procces
- Database estructure: variables – dimensions, define transactional tables, schemas (star)- data types
- Data base Wharehouse – site – back up - testing
- 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:
- To improve collection, preparation and display of data to promote a change in financial analysis department.
- 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:
- To improve collection, preparation and display of data to promote a change in financial analysis department.
- 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:
- Provide to the finances department a BI solution in order to improve the collection and display of data
- 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)
- Definition of Use case (Agile / kanva methodology)
- Business/Data Analysis + prioritization: How to solve the use case and how we prioritize the backlog
- Data Architecture: What is the data architecture I need to resolve this problem
- Definitions of KPIs, business rules, data quality rules, Critical data elements
- Deploy data governance: to guarantee that the technical solution is in compliance with the company data strategy (Dat quality, tools, data security)
- Development part: Coding (Scrum master methodology) + UAT + delivering the model
- 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
- Data gathering process and normalization
- ETL process + data ingestion
- Database structure: variables – dimensions, define transactional tables, schemas (star)- data types
- 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
- Data research to create a quotation model based on SAP
- Data ingestion and analysis
- JOIN STATEMENT identification on SQL code
- Data architecture to be programming on a ETL software (Power Center/ Informatica Cloud /SnapLogic)
- Designing the data schema nad architecture
Target Tables - Source tables - SQL JOIN STATEMENT
Project 8: Machine Learning model- recommendation system for the sales team
- Scoping and flameworking the problem statement: use case elaboration
- Data Reserach and exploration: exploring the data available on the database level and data sources
- IT architecture for scalable machine learning models: what is the right IT architecture to scale models?
Note: WIP