This project delves into interactive Power BI dashboards and Transforming the Data Using Power Query. I mastered data prep, crafting insightful visualizations. This gave me an experience to create clear and engaging dashboards for complex data.
Learn more
This project involves interactive Power BI dashboards for recruitment data. The Requisition Report and the Candidates Report provide insights into job requisitions and candidate pipeline, respectively. The project enhanced my skills in data preparation, transformation, and visualization, enabling data-driven decision-making in recruitment processes.
Learn more
This project showcases my expertise in data cleaning through SQL. I developed proficiency in techniques to identify and rectify data inconsistencies, duplicates, and formatting errors. This ensures data quality and facilitates further analysis for generating valuable business insights.
Learn more
This project harnessed SQL Server to dissect a COVID-19 dataset. I delved into global case and death trends, along with death percentages. For the Philippines, I analyzed infection rates relative to population. Furthermore, the exploration identified countries with the highest death rates compared to their population. Finally, I investigated the impact of vaccination on a global and country level.
Learn more
This project delves into interactive Excel dashboards. I mastered data prep, crafting insightful visualizations (like Map chart and Line chart). This empowers me to create clear and engaging dashboards for complex data.
Learn more
The COVID-19 project involves analyzing and visualizing data related to the pandemic's global impact. Using Tableau, we track key metrics such as total cases, vaccination rates, and death tolls compared to population sizes.
Learn moreHere are some of the certifications I have acquired through my journey as IT and Data Analyst Professional
Through this certification, I have gained proficiency in prompt engineering and leveraging AI models such as Google Bard, ChatGPT, and BingChat. I have developed skills in creating compelling content, marketing prompts, and engaging social media content. Additionally, I have acquired basic knowledge of HTML, CSS, and JavaScript for website development, as well as expertise in summarizing diverse content types for better comprehension.
Through this comprehensive course, I have gained proficiency in Excel VBA programming, advancing from a complete beginner to an advanced level. I have learned to record and edit macros, write and execute VBA code for manipulating worksheets and cells, and implement control structures, loops, and conditional statements. Additionally, I have developed skills in creating user forms, handling errors, and debugging code. The course has equipped me with advanced techniques such as working with arrays, files, and external data sources, and optimizing code for better performance. I am now capable of automating complex tasks, boosting productivity, and enhancing efficiency in Excel.
Through this course, I have learned to quickly create desktop applications using Python. The course covers making GUIs with various frameworks like PyQt, Tkinter, wxPython, and web-based interfaces, allowing easy switching between them. I have gained skills in creating and theming GUIs, interacting with them in Python, and understanding the basics of GUI app development. With just basic Python skills, I am now equipped to develop simple yet effective desktop apps.
Through this comprehensive course, I have mastered essential Microsoft Azure skills needed to excel in cloud computing. The training covers cloud infrastructure management, utilization of Azure services, and fundamental Azure principles. I have gained practical experience in cloud deployment strategies, robust security practices, and cloud management techniques. This course has equipped me with hands-on abilities to navigate and manage resources on the Microsoft Azure Portal. With no prerequisites required, I have advanced my knowledge in cloud computing, positioning myself as a valuable asset in today's competitive job market.
This course provided a deep dive into integrating Lean Six Sigma and Agile Methodology in project management. I gained skills in waste reduction, process improvement, and iterative development, along with proficiency in Lean tools like value stream mapping and Agile practices such as Scrum and Kanban. Through practical exercises and case studies, I learned to develop tailored project management approaches and establish performance metrics. Now equipped with the expertise to drive sustainable improvement initiatives and foster continuous improvement cultures, I'm ready to navigate the dynamic challenges of modern business environments.
Through the course, I mastered essential SEO components, learning to optimize websites for search engines effectively. I gained insights into leveraging ChatGPT for tasks like keyword research, content creation, and competitor analysis, enhancing my ability to drive organic traffic and improve website rankings. Additionally, I developed strategies for content creation, link building, and mitigating potential AI-related SEO risks, equipping me to navigate the evolving landscape of digital marketing with confidence and proficiency.
Throughout the course, I honed my skills in fundamental SEO practices, adeptly optimizing websites for search engine visibility. Harnessing ChatGPT, I delved into keyword research, content crafting, and competitor analysis, augmenting my capacity to bolster organic traffic and elevate website standings. Furthermore, I formulated tactics for content generation, link establishment, and preemptive measures against AI-driven SEO hazards, empowering me to adeptly traverse the dynamic realm of digital marketing with assuredness and mastery.