|
The Winter School on Hands-on Experience with Power BI aims to equip participants with practical skills to transform raw data into interactive visualizations, reports, and dashboards for informed decision-making. Key Focus Areas
This objective supports skill development for beginners to intermediates, fostering data-driven insights without prior experience.
|
What you'll learn
Days 1-3: Foundations
- Day 1: Introduction to Power BI components, installation, and interface exploration; connect to basic data sources like Excel.
- Day 2: Data loading and initial transformations using Power Query Editor; clean and shape datasets.
- Day 3: Basic visualizations (charts, tables, maps); explore canvas, fields, and simple reports.
Days 4-7: Modelling and Visualization
- Day 4: Data modelling essentials, relationships, and creating measures with DAX basics.
- Day 5: Advanced DAX functions (calculated columns, time intelligence); format visuals and add interactions.
- Day 6: Dashboard design, slicers, drill-downs, and conditional formatting.
- Day 7: Report publishing to Power BI Service; workspaces and sharing options.
Days 8-12: Advanced Features
- Day 8: Power Query advanced transformations, parameters, and M language scripting.
- Day 9: Data refresh scheduling, gateways, and troubleshooting.
- Day 10: AI visuals, anomaly detection, smart narratives, and sensitivity labels.
- Day 11: Integration with Excel, Python, or other tools; custom themes and tooltips.
- Day 12: Advanced analytics like forecasting and what-if parameters.
Days 13-15: Projects and Review
- Day 13: Real-world project kickoff with datasets (e.g., sales analysis); end-to-end report building.
- Day 14: Project refinement, peer feedback, and deployment to Power BI Service.
- Day 15: Capstone project presentation, revision of key concepts, and certification quiz.
|
Participants will master connecting to diverse data sources such as SQL Server, Excel, and JSON, while performing essential data cleaning and transformations via Power Query. They will build data models, apply DAX functions for calculated columns and measures, and create interactive reports and dashboards with advanced visualizations. |
What is the Winter School?
The Winter School on Visual Data Analytics with Power BI is a short-term intensive program designed for beginners and professionals to master data visualization using Microsoft's Power BI tool. It focuses on transforming raw data into interactive dashboards and reports for better decision-making. Participants gain hands-on skills in data cleaning, modeling, and advanced analytics.
Who should attend?
This program suits students, academics, business analysts, and e-commerce professionals interested in data-driven insights, such as those managing Shopify stores or academic metrics. No prior Power BI experience is required, but basic data knowledge helps. It's ideal for enhancing skills in health and wellness product analytics or administrative reporting.
What topics are covered?
Key modules include importing data from various sources, using Power Query for cleaning and transformation, building data models with relationships, creating visualizations like bar charts and KPIs, and advanced features such as DAX formulas, forecasting, and dashboard publishing. Practical exercises cover slicers, drill-throughs, and predictive analytics.
When and where is it held?
Typically offered during winter (December-January), this 5-10 day program runs online or at institutions like universities, with sessions from 2-4 hours daily. Exact dates for 2025 align with academic calendars, often including live demos and projects; check SAGE University or similar for India-based events.
How to register and what are the costs?
Registration involves online forms via the host institution's portal, with fees ranging from free (MOOC-style) to INR 5,000-15,000 for certified versions including materials and certificates. Early bird discounts apply; includes lifetime access to recordings for working professionals.
