Power BI

Every company, regardless of size, is always thinking about creating and delivering the best products and services. This is a laudable position, but especially in today's world, it is unacceptable not to have data analysis as a routine. It is not enough to develop optimal products or services and even focus solely on attracting new customers.

Today, it is necessary to have a critical vision and, through data analysis, to extract the maximum amount of information to be useful in business decision making. Thanks to data analysis, companies can access the specific information they need to facilitate their decision making and business strategies based on rigorous criteria. However, data analysis is not only used to facilitate segmentation.

Power BI allows us to connect to the world of data, create basic and compelling reports, and share efforts with other users. It allows us to access data from hundreds of on-premises and cloud-based sources, such as Dynamics 365, Salesforce, Azure SQL DB, Excel, and SharePoint. And it also enables you to gain practical, detailed insights for a wide variety of scenarios. It analyzes data in depth and finds otherwise overlooked patterns that lead to actionable conclusions.

Projects

Customer segmentation

It is intended to investigate a database of customers with the objective of identifying groups with similar characteristics or behaviors within the dataset with some variables such as: age, gender, location, status, etc.

Bank churn prediction

The objective is to provide a bank with information about the bank's situation, in particular about the number of new customers they have, the possible cancellations that may occur, the variables that affect this group of people.

Breakdown of an IT company

This dashboard compares performance against budget and finds out if costs have an adverse variance when actual or forecast costs are higher than budget.

Covid 19 Analytics

With the data published by Johns Hopkins University available on GitHub and after having manipulated the data with Python, build a dashboard of the Covid 19 spread.

Gross Domestic Product Worldwide Forecast

Time series are processed with Python for the purpose of forecasting the Gross Domestic Product per capita of all the countries we have in our dataset for the next 3 years and displaying our models in a Power BI application.

XBit Company Performance Summary

In this dashboard you can search for specific information among this organization. It includes a summary of transactional fields by fiscal month and highlights revenue versus target budget, as well as segment and product breakdowns.