Data Analysis & Visualization
Ann Njuguna
Reporter: Sales Manage
Value Of Change: Visual dashboards and sales reporting
Necessary Systems: Power BI, CRM System
Other Relevant Info: Budgets data has been shared in excel documents for the year 2021
View Interactive Dashboard: Business Performance Dashboard
Data was stored in an SQL Server database. I wrote queries to clean and retrieve data needed for the analysis.
I then created a model of the data with the required relationships in preparation for further data processing using DAX.
Wrote DAX to process the data based on the project requirements.
The last step was creating an interactive visual dashboard and giving access to people in different departments and regions based on only the data that is relevant to them.
