shailesh S.

1

PowerBI
Project

About Me

I am an aspiring Data analyst who loves to solve problems regarding the business use cases.

My Projects

Business Insight 360

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/sshaileshbhat/

Call Me

+91 8072105695

PowerBI Project

Business Insight 360

Business Insights 360 is a dashboard created using Microsoft Power BI. This multi-functional dashboard has been customized to provide Datajanya Hardware with valuable insights into their different departments such as Finance, Sales, Marketing and Supply Chain.

Finance View

Executive View

Project Details

Problem statement:
Datajanya is a fast-growing hardware company that sells various products to customers in many countries through various channels, including retail, direct sales, and distributor networks, both online and in brick-and-mortar stores. To support its growth and make data-driven decisions, AtliQ needs a data analytics team.
Tech stacks:
• SQL
• Power BI
• Excel
• DAX Studio
• Languages- DAX
Workflow steps:
1. Project planning and scoping.
2. Project Charter
3. Data collection and exploration, create a Date table in Power Query
4. Soft skills associated with project management
5. Data load to Power BI and initial validation.
6. Data Transformation in Power Query.
7. Data Modelling and creating calculated columns.
8. Creating measures using the DAX language.
9. Build Finance View, Sales View, Market & Supply Chain View.
10. Data validation set up like creating user acceptance test report.
11. Implementing stakeholder feedback.