CODIVY CONSULTING'S DATA ANALYTIC INTERNSHIP PROGRAM
TASK: Data Analysis focuses on leveraging Power BI to enhance data visualization and analytical capabilities.
Monthly Crude Oil Production Trends: Use Power BI to create an interactive dashboard that visualizes monthly crude oil production trends over the last ten years. Ensure the dashboard allows for drill-down capabilities to view trends by year and month.
LPG Imports and Exports Comparison: Create a comparative analysis of LPG imports and exports by country and year using Power BI. Include visualizations that highlight the top importing and exporting countries, and provide insights into significant trends.
Refinery Output Growth Analysis: Calculate the Compound Annual Growth Rate (CAGR) of total oil products' refinery output over a decade. Visualize the refinery output growth using Power BI and include a detailed analysis of the growth trends.
Correlation and Regression Analysis: Perform a correlation and regression analysis between refinery intake and production output. Use Power BI to create scatter plots and regression lines, and provide an interactive analysis of the results.
Seasonal Variation Cluster Analysis: Conduct a cluster analysis on the seasonal variation in the stock change of gas/diesel oil. Use Power BI to create visualizations that identify and differentiate between clusters, highlighting seasonal trends.
Geographic Visualization of Crude Oil Stocks: Rank and visualize the top ten countries with the highest closing stocks of crude oil using Power BI. Include interactive maps and charts to showcase the geographic distribution of crude oil stocks.
Naphtha Direct Use Analysis: Perform a comparative analysis of the direct use of naphtha across multiple regions and different timeframes. Use Power BI to visualize the direct use trends and provide a comprehensive analysis.
Statistical Differences Analysis: Conduct an in-depth analysis of statistical differences in crude oil data submissions. Use Power BI to create detailed statistical summaries and highlight significant differences.
Scenario-Based Demand Forecasting: Develop a scenario-based forecast model for the demand of total oil products over the next five years. Use Power BI to create interactive forecast models that allow for scenario analysis.
Kerosene Type Jet Fuel Trends: Conduct a dual-axis analysis of the trends in imports and exports of kerosene type jet fuel over the past 15 years. Use Power BI to create dual-axis charts that illustrate the import and export trends.
