Author: Peter Pandey (Bala Marimuthu)
Project for: Codebasics Resume Project Challenge
The final findings of this project were presented in a video format.
The video walks through the complete data story — from the initial problem to the final, data-driven diagnosis.
Below is a snapshot of the final, single-page executive dashboard created in Power BI.
The full, interactive .pbit file is included in this repository.
Bharat Herald, a legacy newspaper with a 70-year history, is facing a severe crisis. Print circulation has dropped by over 50% (2019–2024). The company’s 2021 digital pilot failed, and it is now on the brink of bankruptcy.
My task, as the data analyst Peter Pandey, was to conduct a comprehensive analysis of the company’s operational and financial data to diagnose the root causes of this decline.
My analysis of the data revealed a powerful and counter-intuitive story: the company’s crisis was not simply a revenue problem but a story of a dying business model and a failure of strategic adaptation.
Key findings proved the following hypotheses:
-
Lost the “Digital Land Grab”
While the market was rapidly shifting to digital (supported by rising internet penetration in key markets), Bharat Herald failed to capture this new audience, allowing faster competitors to dominate. -
War on Two Fronts
The company was simultaneously “losing the traditional land” (older print audience decline) while failing to compete in the digital world. -
Dangerous Decoupling of Revenue and Circulation
Readership collapsed, but advertisers were charged more to survive — a classic, unsustainable model of a dying platform. -
Self-Inflicted Wound
Cost data revealed the “digital strategy” was not a sustained effort but a one-year experiment that was quickly abandoned.
- SQL (MySQL): Data extraction, cleaning, complex analysis, and answering the 6 ad-hoc business requests
- Power BI: Final interactive executive dashboard and all data visualizations
- PowerPoint & Clipchamp: Creation of the final video presentation
| File / Folder | Description |
|---|---|
Media_Survival_Analysis.pdf |
Full detailed PDF report explaining the entire analysis, key findings, and recommendations |
Ad-Hoc_Request_Report.pdf |
Screenshots/results of all 6 SQL-based business requests |
All_Combined.sql |
Single SQL file containing all final working queries for the 6 business requests |
power_bi_dashboards.pbit |
Complete Power BI template file (open in Power BI Desktop to view full interactive dashboard & underlying data models) |
- Clone this repository
- Open
Media_Survival_Analysis.pdfto read the full report - Open
Ad-Hoc_Request_Report.pdfto review ad-hoc SQL results - Import
power_bi_dashboards.pbitinto Power BI Desktop to interact with the dashboard
For any questions or collaboration opportunities:
LinkedIn | Email