The “Microsoft Forms Fundamentals” course is designed to equip participants with the essential skills and knowledge required to proficiently utilize Microsoft Forms for streamlined data collection and survey creation. Throughout the course, participants will delve into the foundational features of Microsoft Forms, gaining hands-on experience in designing surveys. The curriculum covers key topics such as form customization, question types, sharing, and result analysis.
Overview
COURSE DIFFICULTY
COURSE DURATION
2h 28m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Design efficient data models with proper relationships
Transform and shape data using Power Query
Create and analyze data with PivotTables
BI Developers, Data Analysts, Excel Power Users, Business Analysts
None
01. Class Introduction
02. Analytics in Excel (Overview)
03. Analytics In Excel (Lab 01A - Using Power Query In Excel)
04. Analytics In Excel (Understanding Data Models)
05. Mapping Learning to Power BI (Overview)
06. Mapping Learning to Power BI (Lab 02A - Import to Power BI Desktop)
07. Mapping Learning to Power BI (Working with Power BI Desktop)
08. Mapping Learning to Power BI (Lab 02B - Using Power BI Desktop to Build a Data Model)
09. Power BI + Excel Better Together (Overview)
10. Power BI Excel Better Together (Lab 03A - Creating an Excel Report Using a Power BI Dataset - Analyze in Excel)
11. Power BI + Excel Better Together (Lab 03B - Creating an Excel Report Using a Power BI Dataset - Insert PivotTable)
12. Power BI and Office Better Together
13. Questions and Wrap Up (What's Next?)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Design efficient data models with proper relationships
Transform and shape data using Power Query
Create and analyze data with PivotTables
WHO SHOULD ATTEND
BI Developers, Data Analysts, Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Class Introduction
02. Analytics in Excel (Overview)
03. Analytics In Excel (Lab 01A - Using Power Query In Excel)
04. Analytics In Excel (Understanding Data Models)
05. Mapping Learning to Power BI (Overview)
06. Mapping Learning to Power BI (Lab 02A - Import to Power BI Desktop)
07. Mapping Learning to Power BI (Working with Power BI Desktop)
08. Mapping Learning to Power BI (Lab 02B - Using Power BI Desktop to Build a Data Model)
09. Power BI + Excel Better Together (Overview)
10. Power BI Excel Better Together (Lab 03A - Creating an Excel Report Using a Power BI Dataset - Analyze in Excel)
11. Power BI + Excel Better Together (Lab 03B - Creating an Excel Report Using a Power BI Dataset - Insert PivotTable)
12. Power BI and Office Better Together
13. Questions and Wrap Up (What's Next?)
