Olukayode Akinrimisi

Power BI/ SQL

DATA ANALYST/POWER BI/SQL Developer, 09/2021 to Current Colaberry Inc Created applicable dashboards, Tabular reports, Matrix reports, Charts, and Graphs as per customer requirements using Power BI and SSRS • Identified the Key Performance Indicator (KPI) measures in accordance with requirements • Cleaned and validated imported client data from SQL Server DB, CSV Files, XML files, and EXCEL files inside Power BI Desk • Prepared dashboards using calculated fields, parameters, calculations, groups in Power BI • Developed business logic using DAX to provide custom functionality in Power BI Applications • Used Power BI to develop data analysis prototype and used Power View and Power Map to visualize reports to assist with and troubleshoot data related issues • In SSRS I have built a reporting system for an organization that involves creating reports from multiple data sources, designing visually appealing and informative reports using SSRS components, and managing the deployment and distribution of the reports • In SQL I have used different left and right joints, use of temp table, user-defined function (UDF), common table expression(CTE), Stored Procedure, creating and troubleshooting table • Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients and mobile apps • Built and implemented scalable solutions that aligned to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions • In SSIS I have built an ETL process for an organization that involves extracting data from various sources, transforming it as per business requirements, and loading it into a target system using various SSIS components • Utilized Power Apps to retrieve, sort, and organize data from Sharepoint Classic, various data sets and sources (data warehouses), including ATTIC and Prism