TECH HAVEN, a fast-growing consumer electronics company, is struggling to compete with data-driven rivals because most of their reports are still managed in Excel. My objective was to deploy an advanced analytics solution using Power BI to help the company gain insights and make informed decisions. Live Report Link
- SQL
- PowerBi
- Excel
- DAX
- DAX studio (to optimize the report)
-Power Query (basic and advanced operations) -Basic and complex DAX formulas -Data modeling with over 10 tables -Selecting appropriate visuals and formatting -Dashboard design principles -Using bookmarks -Deploying reports in Power BI service -Implementing stakeholder feedback -Metrics for sales, marketing, finance, and supply chain
- Home Page
- Info Page
- Finance View
- Sales View
- Marketing View
- Supply Chain View
- Executive View
- Support
The data driven conclusions from the project can be used to navigate the future decision making scenarios for the company