Niharika Jogi

• Calculated and analysed data using statistical formulas. Generated customised reports and conducted analytical studies on ASI data, contributing to the formulation of government policies and programmes through report writing and publishing.
• Contributed to the compilation of State Index of Industrial Production (IIP) and collaborated with various government departments.
• Played a key role in Urban Planning Atlas (GIS-based Decision Support System) project, contributing to the development of Urban Profile portal.
• Collaborated with BISAG in atlas preparation for Gujarat's Municipalities and Municipal Corporations.
• Worked with Employees’ State Insurance Scheme, Ahmedabad.
• Worked with the Commissionerate of Tribal Development, Gandhinagar and prepared progress reports for various tribal development schemes implemented to monitor the progress of all tribes.

Processed, analysed, tabulated, and visualized ASI (Annual Survey of Industries) data for Gujarat using Advanced Excel and analytical tools.
Calculated and analysed data using statistical formulas.
Generated customised reports and conducted analytical studies on ASI data, contributing to the formulation of government policies and programmes through report writing and publishing.
Contributed to the compilation of State Index of Industrial Production (IIP) and collaborated with various government departments.
Played a key role in Urban Planning Atlas (GIS-based Decision Support System) project, contributing to the development of Urban Profile portal.
Collaborated with BISAG in atlas preparation for Gujarat's Municipalities and Municipal Corporations.
Worked with Employees’ State Insurance Scheme, Ahmedabad.
Worked with the Commissionerate of Tribal Development, Gandhinagar and prepared progress reports for various tribal development schemes implemented to monitor the progress of all tribes.

Analysed and gathered data from Excel and MS SQL.
Designed and created interactive and informative Power BI reports and dashboards using diverse range of graphs, charts, and techniques such as line graph, pie chart, area chart, tree map, bar chart, Matrix, drill-through functionalities, geospatial visualizations, and DAX features.
Created interactive dashboards and published them online to share, learnt how to connect to different data sources such as Excel, created variety of charts including stacked bars, side-by-side bars, line chart, maps, text table to visualize the insights.
Utilized Advanced Excel to compute recency, frequency, and monetary value metrics for each customer.
Derived the overall RFM score based on the ratings, segmenting customers into distinct groups.
Computed the percentage of customers in each segment.
Calculated retention periods for individual customers.
Computed customer lifetime value (CLV) and conducted regression analysis to explore the relationship between months and CLTV.
Enhanced the understanding of customer behaviour and long-term value.
Delivered a robust prediction model to make informed decisions regarding CTC offered to prospective employees.
Employed Advanced Excel to build a Logistic Regression model for loan default prediction.
Constructed a Confusion Matrix to assess the model's predictive performance.
Calculated the Accuracy Score to quantify the model's ability to correctly predict loan repayment and default.
Enhanced the loan approval process by developing a predictive model to identify potential defaulters.
Performed EDA, filtering & ordering data, joined multiple tables to collate information, aggregated data on single and multiple tables using joins by group statement, used Rank and Dense Rank Functions along table expressions.
Created visual representations of sales trends, top-performing products, and customer behaviour.
Utilized geographical data visualization techniques for plotting state wise Sales and Profits.
Visualized sales density and identified high-performing store locations.
Gained hands-on experience in transforming raw data into actionable insights using EDA and Data Visualization techniques.