PWC-Internship - Power BI Data analyst

Introduction to Organisation

pwc India teams has extensive experience and competence in implementing the SAP Treasury solution across Various sectors and industries.

Position and Roles

I had done a Virtual Case Experience at pwc, my role was to find Insights from a Large Dataset and Visuvalize that using powerBi.

Tools I used

*1.Microsoft Excel

Microsoft Excel, spreadsheet application launched in 1985 by the Microsoft Corporation. Excel is a popular spreadsheet system, which organizes data in columns and rows that can be manipulated through formulas that allow the software to perform mathematical functions on the data.

Raw Dataset

Cleaned Dataset

*2.*PowerBI Desktop *

Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform. Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Data may be input by reading directly from a database, webpage, or structured files such as spreadsheets, CSV, XML, and JSON.

Power BI – Tools and Functionalities

1.Import/Export .csv files 2.Views in Power BI There are 3 different types of views in Power BI. You can switch between the 3 views using Navigation Pane.

Report View is a section of Power-BI where you can create any number of report pages with visualizations. This view provides a designing environment where you can move visualizations around, copy and paste, merge, and so on. Data view is a section of Power-BI that helps you inspect, explore, and understand data. It’s different from how you view tables, columns, and data in Power Query Editor. *Relationship View (Model View)* shows all of the tables, columns, and relationships in your model. This view can be especially helpful when your model has complex relationships between many tables. #####3.Various tools and Pannel

3.Microsoft Word

Microsoft word is a word processor software developed by Microsoft in 1983. It is the most commonly used word processor software. It is used to create professional quality documents, letters, reports, resumes, etc and also allows you to edit or modify your new or existing document. The file saved in Ms Word has .docx extension. It is a component of the Microsoft Office suite, but you can buy it separately and is available for both Windows and macOS.

4.Microsft PowerPoint

Microsoft PowerPoint is great presentation software designed by Microsoft sometimes abbreviated as PP or PPT. PowerPoint is well utilized to create a slideshow of valuable information through charts, and images for a presentation. It is commonly practiced in business and school presentations

Practical Task I Completed During a VirtualCase Experience

1.Call Centre Trend

for more information please visit my repository In details

2.Customer Retention

I.)Insights From Dataset

II.)Customer analysis Reports and dashboards

III.) Customer Risk Analysis

At the completion of This task I awarded with the certificate

Thank You #pwc and #forage for your Guidence.

For more information please Visit My Repossitery in detail.