1. Working on data preparation leveraging various Excel functions and tools (SUMIFS, LOOKUP, MATCH, INDEX, Pivot Tables, PowerPivot, text to columns, remove duplicates, etc.)
2. Working on Google Sheets to compile, clean, and sanitize data and make it available to the team for further computation
3. Understanding master and transaction tables
4. Working on manufacturing analytics & dashboard which includes calculating and tracking key business metrics with a focus on manufacturing (key performance indicators (KPIs), ratios for overall equipment effectiveness (OPE) i.e. availability, performance, quality, machine downtime, turnaround, etc.)
5. Monitoring factory performance on an hourly, daily, weekly, monthly or quarterly basis
6. Building data ETL pipeline, data transformation, warehousing, mapping data-points from business requirements, and forming relationships in the data model
7. Leveraging MS PowerQuery, SQL for data transformation to derive final outputs and formats based on the business need
8. Working on PowerBI or Tableau codings like creating calculation measures, building visual reports and interactive dashboards for dynamic reporting for business performance
9. Researching and understanding the use of predictive analytics and techniques to leverage artificial intelligence (AI)/machine learning(ML)/deep learning for automation in processes
Ruby Consulting has become one of India's fastest homegrown financial and management consulting firms working with small and mid-sized companies. We are the partners of choice for some of the most talented and gritty business leaders wanting continuous solutions for the challenges they face in scaling up. Our high-impact service offerings include CFO services, new market entry, and set-up, transaction advisory, etc., and are vouched by strong client credentials and success stories.