I wrote a Python program which gets financial data of companies from an api , performs financial analysis using ratios and then saves the results to an Excel file using openpyxl python package. Had a lot of fun doing this…
PowerBI Sales Analysis Dashboard showcases comprehensive sales insights, including total sales, product-specific sales, top 5 sales performers, and products with the lowest sales. Users can apply filters using a region map to refine their analysis. Learning : Visual Level Filters
Link to Github I use the Kindle reader for my reading, and I often highlight key points in the ebooks. There’s a website, , that sends daily Kindle highlights if you upload your Kindle highlight file to the platform. Previously,…
This is sales forecast made using python package known as prophet . It analyze past trend and forecast according to this . This method is also known as time series forecasting .
This is a variance analysis dashboard which compares Actual vs Budget vs Forecast made using PowerBI Dashboard.
I came across population density maps of different countries on LinkedIn, but I couldn’t find one for my own country, INDIA . This inspired me to take on the challenge. After many trials and errors, I’m excited to share the…
This is a dynamic 12-month rolling forecast created on excel that adapts in real-time as per the current date and actual input figures.
I put together this Sales Dashboard using pivot tables and pivot charts. It’s like a super handy tool to look at the sales data from different angles.
I created a dynamic variance analysis dashboard in Excel following a YouTube tutorial. This dashboard changes dynamically according to the selection on a pivot slicer and is made using pivot tables, pivot charts, and sparklines.
