Category Analyst

Jira Course

The **Jira Course** covers basic to advanced concepts for Category Analysts in the Internet and E-commerce industry, including Jira navigation, project setup, issue creation, workflow management, Scrum and Kanban boards, sprint planning, backlog management, task assignment, JQL (Jira Query Language), dashboards, filters, automation rules, custom fields, reporting, SLA tracking, collaboration, category planning, product launch tracking, process monitoring, integrations, and agile project management techniques to improve category operations, streamline cross-functional collaboration, monitor project progress, and support efficient business execution.

Excel Course

The **Excel Course** covers basic to advanced concepts for Category Analysts in the Internet and E-commerce industry, including workbook management, formulas, functions, data validation, sorting, filtering, conditional formatting, Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Power Query, Power Pivot, category performance analysis, sales reporting, inventory analysis, pricing analysis, profitability tracking, statistical functions, dashboards, What-If Analysis, Solver, VBA automation, KPI reporting, demand forecasting, and interactive dashboards to evaluate category performance, optimize merchandising decisions, and support data-driven business growth.

SQL (Basic) Course

The **SQL (Basic) Course** covers basic concepts for Category Analysts in the Internet and E-commerce industry, including database fundamentals, SELECT queries, filtering, sorting, joins, aggregate functions, GROUP BY, HAVING, subqueries, Common Table Expressions (CTEs), CASE statements, views, indexing basics, query optimization fundamentals, transaction concepts, sales data extraction, product analytics, category performance reporting, customer behavior analysis, inventory reporting, data validation, and large dataset management to retrieve, transform, and analyze e-commerce data for category optimization and informed business decisions.

Confluence Course

The **Confluence Course** covers basic to advanced concepts for Category Analysts in the Internet and E-commerce industry, including workspace creation, page management, document collaboration, knowledge management, templates, meeting notes, requirement documentation, process documentation, project spaces, version control, comments, permissions management, workflow documentation, report publishing, integration with Jira, dashboard creation, team collaboration, content organization, search optimization, and documentation best practices to improve communication, maintain centralized business knowledge, and support efficient category management and cross-functional collaboration.