Luiza Atamova
Power BI Developer | Business & Financial Analytics
New to Contra
Luiza is ready for their next project!
QuickBooks Cleanup & Reconciliation Services
I help small businesses clean up and organize their books, reconcile bank and credit card accounts, correct bookkeeping errors, and prepare accurate financial reports.
Services include catch-up bookkeeping, account reconciliation, transaction review, error correction, and preparation of clean, audit-ready books.
Focused on accuracy, clear reporting, and reliable financial records for day-to-day business management.
0
17
Pharmacy Sales & Profitability Analytics | Power BI
Developed an interactive Power BI dashboard to analyze the financial and operational performance of a pharmaceutical sales business from January to September 2026.
The dashboard tracks key KPIs including Revenue, Gross Profit, Gross Margin, COGS, Units Sold, and Unique Customers. It also analyzes monthly revenue and profitability trends, product category performance, supplier-related COGS, brand-level revenue and gross profit, and revenue distribution by customer type.
A key focus of the analysis is inventory efficiency, using Inventory Turnover and Days Inventory Outstanding (DIO) to show how quickly inventory moves over time and how long products remain in stock.
The dashboard also includes a P&L view, connecting sales performance with COGS, operating expenses, EBITDA, EBIT, taxes, and Net Income to provide a consolidated view of profitability.
Built in Power BI using Power Query, data modeling, and DAX measures, with interactive date filtering for period-based analysis.
0
19
Interactive Financial Dashboard for Beauty Retail Business | Looker Studio
I'm excited to share one of my completed projects — an end-to-end interactive financial and operational dashboard designed for a beauty retail business.
The main goal of this project was to answer critical business questions: Where is the cash tied up? Which products or categories are affecting liquidity, and how efficiently is working capital being managed?
The report connects financial performance with working capital, inventory management, and operational efficiency across multiple analytical views:
Financial Performance Overview: Tracks Revenue, Net Income, EBITDA, Free Cash Flow, and a multi-tier profitability funnel (Revenue → Gross Profit → EBITDA → EBIT → Net Income).
Liquidity & Working Capital Analysis: Provides a detailed view of Accounts Receivable (AR) and Accounts Payable (AP) aging by customer and supplier, helping identify collection and payment patterns.
Inventory Turnover & Stock Liquidity (DIO): Analyzes inventory turnover by product and category to identify slow-moving items and reveal where cash may remain tied up in stock.
Operational & Financial Efficiency: Combines the Cash Conversion Cycle (CCC), liquidity and leverage ratios, profitability metrics, expense structures, and custom traffic-light indicators for key financial benchmarks.
Tools & Stack:
• Looker Studio
• Google Sheets
• Financial Analysis & Working Capital Metrics
A full video walkthrough demonstrating the interactive filters and drill-down capabilities is available via the link in the comments for those who want to explore the dashboard in more detail.
#LookerStudio #FinancialAnalytics #FinancialAnalysis #WorkingCapital #InventoryAnalytics #BusinessAnalytics #DataAnalytics #RetailAnalytics #DataVisualization
1
43
Emerald Ridge Estates — Power BI Development Analytics Dashboard.
Developed an end-to-end Power BI analytical model connecting construction progress, financial performance, forecasting, project risk, and development scenarios. Designed the data model, DAX calculations, business logic, interactive navigation, and report interface from the ground up.
0
62