Ayodeji Olawoye
Data Analyst @Colaberry
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Colaberry
Power BI Desktop – using DAX to Create calculated columns and measures, troubleshooting report performance, troubleshoot slowly running reports and Dashboard elements to improve report performance, Creating data Visualization in Power BI Service, building dashboard, and customizing to meet the needs of the clients/end-users.• SQL-Server, T-SQL experience in creating tables and Temp Tables, Table variables, stored procedures, views, indexes, triggers, joins, User defined functions (UDF), CTE, Database Models, and integrity in all SQL version platforms. • SSIS – Designed and developed SSIS packages, Validated/cleaned data using various transformations, and used XML development and XML file parsing. Worked on data flow transformations like XML Source, Flat file source, Excel source used functionalities for error handling by giving precedence constraints, breakpoints, checkpoints, logging, and data viewers. • SSRS – Created both shared datasets and package-level datasets, developed parameterized reports with drill-down and drill-through, developed a report with various charts, Table, Matrix, and gauge used Sub-report to develop a dashboard. Configure and deploy dashboard to report server.
EDUCATION
Heavy Construction Academy
Diploma of Education
Colaberry School of Data Analytics
Data Analytics Certification , SQL Server/Power BI
Osun State Polytechnic, P.M.B. 301, Iree, Osun State Nigeria
National Diploma in Marketing - Associate Degree in Marketing
Amota Community High School, Ororuwo, Osun State, Nigeria (1998 - 2003)
Senior High School Certificate, Art/Art Studies, General
ABOUT AYODEJI OLAWOYE
I am a seasoned Power BI developer with extensive experience in data visualization, database management, and ETL processes. Proficient in Power BI, DAX, and SQL Server, I excel in creating dynamic reports, optimizing performance, and developing comprehensive SSIS and SSRS solutions.My expertise includes handling complex data transformations, ensuring data integrity, and generating actionable business insights. With a strong background in Marketing and Management Administration, I am dedicated to leveraging data to support strategic decision-making and drive business success.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.