Data Analytics
As a Business Analyst I was responsible for making analytical reports from our day to day interactions, regarding orders, transactions, inventory managements, profits and make the reports available inside a dashboard with the help of Redash.
With Redash I only used MySQL, PgSQL and AWS Redshift queries to Generate Reports for our management.
With Redash I only used MySQL, PgSQL and AWS Redshift queries to Generate Reports for our management.
I can write complex MySQL and PgSQL queries involving window functions (Lead, lag, Partition), with syntax, case, complex joins, grouping, date formatting, string manipulations, list tags (Redshift or PgSQL).