D i o g o D A T A
  • Home
  • About
  • Skills
  • More
    Professional background Education Recent Projects Accomplishments
  • Posts
  • EN
    EN PT-BR
  • Dark Theme
    Light Theme Dark Theme System Theme
  • Tags
  • Bash (Unix Shell)
  • Cron
  • Data Visualization
  • EDA
  • ETL
  • Numpy
  • Pandas
  • Power BI
  • Python
  • Shell Script
  • Streamlit
Hero Image
The impact of implementing a Power BI dashboard on sales and returns analysis

In a highly competitive sector such as electronics, efficient analysis of sales and returns data is essential for improving processes and boosting store performance. For a fictitious chain of stores, I created a Power BI dashboard with the aim of providing a clear and dynamic view of this data, helping to make more strategic decisions. The main task was to transform raw sales and returns data into valuable, strategic information. To do this, I used Power Query in the ETL (Extract, Transform and Load) process from files in XLSX format. This work included detailed cleaning and normalization of the data, structuring it efficiently for analysis.

  • ETL
  • Power BI
  • Data Visualization
Thursday, February 20, 2025 | 2 minutes Read
Hero Image
ETL simplified: unified data

In today’s dynamic business environment, integrating and analysing data from multiple sources is essential for making informed decisions. In many industries, such as finance, logistics or marketing, it is common to receive data files in a variety of formats, including CSV, XML and JSON. These files can contain valuable information, but their dispersion and variety of formats make processing and analysis a significant challenge. One of the challenges in this scenario is the need to consolidate information from multiple files into a single format that can be easily imported into a database, for example. The task becomes even more critical when considering the need to maintain data integrity and consistency during this compilation process.

  • ETL
  • Python
Friday, September 20, 2024 | 2 minutes Read
Navigation
  • About
  • Skills
  • Professional background
  • Education
  • Recent Projects
  • Accomplishments
Contact me:
  • diogo.dantas@live.com
  • diogo-dantas
  • Diogo Dantas

Liability Notice: This theme is under MIT license. So, you can use it for non-commercial, commercial, or private uses. You can modify or distribute the theme without requiring any permission from the theme author. However, the theme author does not provide any warranty or takes any liability for any issue with the theme.


Toha Theme Logo Toha
© 2020 Copyright.
Powered by Hugo Logo