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)