Project Details

AtliQ Technologies, a fast-growing hardware company specializing in peripherals, faced significant challenges in Latin America. My project, Business Insights 360, was crafted to help them overcome these challenges through data-driven decision-making.

Project Highlights:

➡ Finance View
➡ Sales View
➡ Marketing View
➡ Supply Chain View
➡ Executive View

Learning Journey:

▶ Project Planning and Scoping.
▶ SQL Connector to Power BI.
▶ Power BI Tool Introduction.
▶ Power Query & M Language
▶ DAX (Data Analysis Expressions)
▶ Data Modeling
▶ Bookmarks & Page Navigation
▶ Excel Integration

Business Terms Covered:

Gross price | Net sales | Net invoice sales | Pre-invoice deductions | post-invoice deductions | Manufacturing cost | Freight cost | Cost of Goods Sold (COGS) | Gross Margin | Operational Expenses | Net Profit | FY - Financial Year/Fiscal Year | YTD - Year to Date | YTG - Year to Go .

Live Dashboard: