Advanced training program "Business Analytics using Microsoft Excel and Power BI"

Program content:

Section 1. Advanced formulas and data analysis tools (8 training hours)

• Topic 1.1. Text functions, validation, and array formulas
• Topic 1.2. Dynamic structures and interactive visualization
• Topic 1.3. What-If Analysis and Optimization Problems

Section 2. Data preparation and modeling technologies: Power Query, Power Pivot and DAX (8 training hours)

• Topic 2.1. Power Query: Data Import and Transformation
• Topic 2.2. Power Query: Table joins and M-language basics
• Topic 2.3. Power Pivot and DAX: Modeling, Measures and Reporting

Section 3: Automating Analysis with VBA (4 hours)

• Topic 3.1. VBA Basics: Object Model, Editor, and Procedure Development
• Topic 3.2. Data management and user interfaces (UserForm)

Unit 4: Power BI Concepts, Connecting and Working with Data (8 class hours)

• Topic 4.1. Logic Power BI vs Excel
• Topic 4.2. Import and configure connections to data sources
• Topic 4.3. Advanced DAX for Banking and Statistics

Section 5. Creating dashboards, uploading reports and presentations based on data (8 training hours)

• Topic 5.1. Design of control panels
• Topic 5.2. Interaction mechanics
• Topic 5.3. Integration with Microsoft PowerPoint and data export
• Topic 5.4. Data-driven storytelling

Preliminary class schedule:

_______ (Mon) 9.00 – 16.00 (8 hours);
_______ (Tue) 9.00 – 16.00 (8 hours);
_______ (Wed) 9.00 – 16.00 (8 hours);
_______ (Thurs) 9.00 – 16.00 (8 hours);
_______ (Friday) 9.00 – 12.00 (4 hours) + test.