Power BI, Excel Automation & Kali -- 2
Budget: ₹12,500 – ₹37,500 INR
I have a small bundle of tasks that all feed into the same goal: transforming raw information into clear sales-performance insights while polishing my toolset along the way.
Power BI
You will receive an Excel workbook that already contains the raw data. I want it cleaned in Power Query, modelled, and then visualised in an interactive dashboard. A prominent pie chart should showcase the key sales breakdowns, yet if a bar or line view tells the story better I’m happy to discuss it. Filters, KPI cards and a short narrative of high-level findings need to sit on the canvas. When you hand the work back, I expect the .pbix plus a brief “how-it-was-built” note so I can tweak it later.
Excel
Inside the same file, formula-driven cleaning is required (classic VLOOKUP/XLOOKUP, IF logic, pivot tables, etc.). I’d also like a light macro that automates the repetitive data-cleaning steps so future refreshes happen with one click.
Kali Linux (beginner)
Finally, I’m setting up Kali in a virtual machine and need guided help: installation walkthrough, basic terminal commands, and a starter explanation of networking concepts. Think of this as a quick mentoring session that leaves me confident enough to poke around on my own.
Deliverables (within 7–10 days)
• Power BI .pbix file with documentation
• Cleaned Excel workbook, formulas intact and macro for data cleaning
• Step-by-step Kali setup notes plus a short Q&A session
If this mix of dashboarding, Excel wizardry, and light Linux guidance fits your skill set, let’s get started.
Power BI
You will receive an Excel workbook that already contains the raw data. I want it cleaned in Power Query, modelled, and then visualised in an interactive dashboard. A prominent pie chart should showcase the key sales breakdowns, yet if a bar or line view tells the story better I’m happy to discuss it. Filters, KPI cards and a short narrative of high-level findings need to sit on the canvas. When you hand the work back, I expect the .pbix plus a brief “how-it-was-built” note so I can tweak it later.
Excel
Inside the same file, formula-driven cleaning is required (classic VLOOKUP/XLOOKUP, IF logic, pivot tables, etc.). I’d also like a light macro that automates the repetitive data-cleaning steps so future refreshes happen with one click.
Kali Linux (beginner)
Finally, I’m setting up Kali in a virtual machine and need guided help: installation walkthrough, basic terminal commands, and a starter explanation of networking concepts. Think of this as a quick mentoring session that leaves me confident enough to poke around on my own.
Deliverables (within 7–10 days)
• Power BI .pbix file with documentation
• Cleaned Excel workbook, formulas intact and macro for data cleaning
• Step-by-step Kali setup notes plus a short Q&A session
If this mix of dashboarding, Excel wizardry, and light Linux guidance fits your skill set, let’s get started.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Data Visualization
Data Analysis
Power BI