Business Analyst Turning Into a Data Professional | Power BI • Excel • SQL • Python | Automating Workflows & Building Scalable Reporting Solutions
Hi, I’m Keegan Murphy — a Business Analyst with a passion for data and a growing focus on scalable, tech-driven solutions. With hands-on experience building interactive dashboards, automating reporting processes, and extracting insights from ERP systems, I’ve developed a solid foundation in Power BI, Excel, SQL, Power Query, and Python.
Now, I’m expanding into the broader data space — learning Python, deepening my knowledge of SQL, databases and cloud platforms, and actively building toward roles in business intelligence, data engineering, analytics and development.
This portfolio showcases the solutions I’ve built, the problems I’ve solved, and my commitment to turning business needs into technical solutions that make a real impact.
<aside>
<img src="/icons/postcard_gray.svg" alt="/icons/postcard_gray.svg" width="40px" />
Johannesburg, South Africa
</aside>
<aside>
<img src="/icons/binoculars_gray.svg" alt="/icons/binoculars_gray.svg" width="40px" />
LinkedIn
</aside>
<aside>
<img src="/icons/git_gray.svg" alt="/icons/git_gray.svg" width="40px" />
GitHub
</aside>
<aside>
<img src="/icons/mail_gray.svg" alt="/icons/mail_gray.svg" width="40px" />
Contact me by Email
</aside>
<aside>
<img src="/icons/phone-call_gray.svg" alt="/icons/phone-call_gray.svg" width="40px" />
Contact me by Phone
</aside>
<aside>
<img src="/icons/document_gray.svg" alt="/icons/document_gray.svg" width="40px" />
Keegan Murphy CV.pdf
</aside>
Key Projects & Achievements
- Sales Enquiries Dashboard
- Created an interactive, refreshable dashboard summarizing sales opportunities, tracking progress through different stages (Won, Lost, Pipeline).
- Improved decision-making speed for sales managers and executives ****by providing clear, drillable insights.
- Management Pack Development & Enhancement
- Built and continuously enhanced ISF Group Management Packs, incorporating financial reporting, forecasting, and departmental drill-down.
- Reduced manual data processing errors and reporting time by implementing automated refresh mechanisms.
- Project Pulse
- Developed a Power BI dashboard for tracking project financial performance, integrating budget vs. actual cost analysis.
- Provided leadership with a real-time overview of key business KPIs.
Portfolio
Skills & Expertise
- Data Analytics & Business Intelligence – Expertise in transforming raw data into actionable insights using Power BI, Excel, and Power Query.
- Financial & Business Reporting – Experienced in building interactive management packs, sales dashboards, and automated reporting solutions.
- Process Automation – Skilled in streamlining workflows and reducing manual effort using Power Automate and data modelling techniques.
- Database & ERP Systems – Proficient in Sage 200 Evolution with foundational knowledge of SQL for data extraction and transformation.
- Problem-Solving & Decision Support – Passionate about improving efficiency, ensuring data accuracy, and enabling informed decision-making.
Tools & Technologies
- BI & Analytics: Power BI, Power Query, DAX, Excel, SQL, Python
- ERP & Databases: Sage 200 Evolution, SQL (intermediate)
- Automation & Workflow: Power Automate, Excel Macros
- Visualization & Reporting: Pivot Tables, Power BI Dashboards, Financial Modelling
- Programming: Python (beginner), SQL (intermediate)
Education & Certifications
- IIE Bachelor of Commerce (BCom) – Economics (Completed with Distinction)