I am well-versed in the disciplines of data modelling, data analysis and data visualization . I have years of experience analyzing data, creating user-friendly visualizations and providing actionable insights. My skillset includes Excel, Power BI, Tableau, SQL, R, Adobe Suite. I hold a Master of Arts degree, and Google Data Analysis certification.
I've utilized Excel extensively to organize, clean, and present data in efficient and easily digestible reporting. I'm proficient in all basic creation of formulas, Pivot Tables, Power Query, DAX and Data Modelling in Excel.
I'm versed in using Microsoft SQL Studio, Google BigQuery and MySQL. I'm experienced with creating queries utilizing joins, subqueries and utilizing datasets with many output paths.
Power BI is an amazing tool for taking complex data and allowing it to make sense at a glance. It is my favorite visualization tool. I'm fluent in creating relational data models utlizing data from multiple tables with star schema format, creating live-updating and interactive dashboards and reporting to be accessed securely on mobile devices like phones or tablets.
R Programming a "quick and dirty" go to for fact finding fast. It may not be as visually pleasing or interactive as a Power BI dashboard, but it is extremely useful in finding answers to questions quickly. I'm familiar with using standard R Programming libraries like tidyverse and ggplot.