Workshop on Business Intelligence Reporting with Visualizations using MS-Excel and PowerBI
For Whom?
Employees / Business Owners / Management Students
What is taught?
Mail Merge
- Merging Ms. Excel with Ms. Word & OUTLOOK
Macros
- Record & Run Macros
X-LOOKUP
- XLOOKUP to Two-way data search & Wildcard functions
Power Query
- Data Management using multiple tables, sheets & files
Google Forms & Sheets
- Creating & Sharing Google Forms & Sheets
Excel and Power BI Integration
- DAX Measures and Formula
- Pivot tables and Slicers
- Data objects in Power BI
- Paginated Reports
- Publishing Power BI reports
When?
Duration: 8 hours (1 or 2 days)
Cost
Per Student: INR 1,000
Per Batch depending on batch size (with assured 20% discount for batch size of 20 and above)