Course Syllabus
zooyeacademy.zooyeinfo.com
Power BI & Data Analytics
Business Intelligence Master
Data Science Beginner to Intermediate 2 Months ₹4–12 LPA
Course Overview
Master Power BI, SQL & Excel for data analytics. Build executive dashboards, automate reporting & gain insights that drive business decisions at top companies.
What You'll Learn
- Power BI Desktop & Service
- DAX Formulas & Calculations
- SQL for Data Analysis
- Excel Advanced Analytics
- Data Modeling & Relationships
- Microsoft Fabric Basics
- R Visual Integration
- Dashboard Design Principles
AI Tools Covered
Power BI Copilot AIExcel AIChatGPT for AnalysisFabric AI
Detailed Curriculum
Power BI FundamentalsWeek 1–2
- Power BI Desktop setup
- Connecting data sources
- Data transformation (Power Query)
- Basic visualizations
DAX & Data ModelingWeek 3–4
- DAX calculated columns & measures
- Time intelligence functions
- Data model relationships
- Row & context filters
Advanced VisualsWeek 5–6
- Custom visuals & themes
- Drill-through & tooltips
- AI Insights in Power BI
- Mobile layout design
SQL & Excel AnalyticsWeek 7–8
- SQL queries for BI
- Excel pivot tables & Power Pivot
- What-if analysis
- Dashboard design best practices
Hands-On Projects
Sales Performance Dashboard
Executive dashboard tracking KPIs, revenue & regional performance
Power BIDAXSQLExcel
HR Analytics Report
Employee headcount, attrition & performance analytics dashboard
Power BIPower QueryDAXCSV/Excel
Financial P&L Dashboard
Profit & loss statement with trend analysis and forecasting
Power BIDAXSQL ServerExcel
Career Opportunities
BI AnalystData AnalystReporting AnalystBusiness Analyst
Zooye EduTech — Learn • Grow • Succeed
145, Mariyamman Kovil Street, Sathyanagar, Nambiyur, Erode, Tamil Nadu - 638458
📞 +91 63801 15548 · ✉️ zooyeacademy@gmail.com · 🌐 zooyeacademy.zooyeinfo.com