Andhika Warisa D.

Collaborate with me and let the data tell you more! Greetings, my name is Andhika. As a data analyst (company job position : Business Strategy and Performance Manager) with 10+ years of experience in data processing, analytics and visualization using tools such as Excel, Spreadsheet, SQL, and Power BI, I specialize in crafting tailor-made reports and visualizations. My work adheres to industry best practices, ensuring not only clarity but also presenting information through visually appealing and effective visualizations. Additionally, I provide post-project support. Here is a comprehensive overview of my capabilities: ✔ Excel: Proficient in Advanced Array Formulas, Data Entry, Data Validation (dropdown lists), Conditional Formatting, Various Charts, Pivot Tables, Pivot Charts, Mail Merge, Email through Outlook, Spreading Data across multiple sheets or files, and adept at resolving various errors or cleaning messy data. ✔ Excel Automation: Skilled in developing Customized Forms & Reports, Interactive Dashboards, Calculators, Tracking Reports, and Macros. ✔ Google Sheets: Expertise in Advanced Formulas, Various Charts, Customized Reports, Google Forms, and Google Data Studio. ✔ SQL (MySQL, pgAdmin): Proficient in Database Management, Querying, Importing databases, and Extracting databases. ✔ Power BI (Certified by Microsoft): Competent in Power Query, Data Transformation, Data Modelling, DAX Expressions, and creating Interactive Dashboards. ✔ Data Storytelling: Expert in crafting insightful strategies by combining deep analysis, precise charts visualization, providing valuable insights for business enhancement, and creating professional-looking presentations and documentations. ✔ PowerPoint: Proficient in business presentations, infographic slides, slide animations & transitions, and slide master/template (cover, font style, color theme). ✔ MS Word: Skilled in crafting business proposals, research writing, data entry, mail merge, converting to PDF and PowerPoint. ✔ PDF: Expert in converting to other formats (Excel, image, PowerPoint, Word), compressing file size, creating fillable forms, adding signatures, merging pages, and splitting & extracting pages. Let's collaborate and propel your business forward with informed decisions based on factual data!