Nivash Ramaiah
Lead Data Analyst | Food, IT and Healthcare
About Me
Hi, I'm Nivash Ramaiah and I'm a data analyst.I have led analytical projects at food tech and IT businesses.I have provided solutions for problems that were faced by CXO's as well as the team members.I expertise in automation tasks, dashboarding and business intelligence.
Skills
Power BI | Metabase BI | SQL | Python | R Studio | Hevo ETL
SQL and reporting - 3+ years
Python Automation - 3+ years
Project Management - 2+ years
Data Engineering - 1+ years
Projects
SQL | CLICKHOUSE | Metabase BI
Executive Revenue Dashboard
Unified different brands data into a single repository in Clickhouse and created an interactive revenue dashboard that informs CXOs of revenue updates.
Executive Revenue Dashboard
Business Problem
CXOs had to navigate multiple reporting platforms—including Metabase dashboards, Python-generated reports, and Excel files—to track the performance of 10+ brands, leading to inefficiencies and an increased risk of reporting errors.
Business Question
How can we provide CXOs with a centralized, accurate, and real-time view of business performance across all brands to support strategic decision-making?
Process 1: Business RequirementsSpoke to the different business vertical heads and noted down the data requirement.Process 2: Data ModellingUsing the techniques such as Snowflake schema modeling, I modelled nearly 10 tables.Process 3: Data ValidationAfter the data provider team configured the end point connections and the data started flowing, I started with validating the data integrity by cross checking it with the ground truth.Process 4: Metabase BI IntegrationI configured the database to the Metabase BI tool and handled the data governance.Process 5: DashboardingUsed SQL in Metabase BI to create the executive revenue dashboard of all our brands, with multiple views and charts.