OiData Specialist
Apr. 2019 - Nov. 2021Rio de Janeiro e Região, Brasil• Participation in PowerBi Implementation Project: Engaged in a pivotal role within the PowerBi implementation project for the respective business area, contributing to the successful integration and utilization of PowerBi for enhanced data analytics. • SQL Server Development for PowerBi Data Consumption: Played a key role in developing Views and Procedures within SQL Server, facilitating efficient data consumption in PowerBi for comprehensive business intelligence. • Strategic Dashboard Development and Daily Information Dissemination: Orchestrated the creation of pivotal Views and Procedures in SQL Server for optimal data consumption in PowerBi. Led the daily dissemination of crucial information to the entire sales team, spearheading the construction of the most accessed dashboard in the company, comprising nearly 1,000 reports. • Utilization of On-Premises Data Gateway for Automation: Implemented on-premises data gateway to automate daily data refresh processes, ensuring seamless and up-to-date information accessibility. • Diverse Data Source Connectivity in PowerBi: Successfully established connections in PowerBi with a variety of data sources, including SQL Server, MySql, Local Folders, Web URL, REST API, .xls, .csv, Google Analytics, among others. • Creation of "Cradle to the Grave" Processes: Developed end-to-end data processes, where information originating from MS Excel was coded for importation into SQL Server tables. Constructed views to align with PowerBi requirements, ensuring a seamless flow of data from its inception to consumption. • Advanced Application of DAX Language: Demonstrated proficiency in the advanced application of DAX language, incorporating Virtual Tables, Iterating Functions, Time Intelligence Functions, and other sophisticated techniques to enhance the analytical capabilities of PowerBi.