Scored 4/5 by Smals colleagues
Course duration: 2,38h
Power BI Desktop—the powerful data analysis and visualization software from Microsoft—can help you get more insights from your data, whether that data is stored on your computer or in the cloud. In this course, discover how to leverage this easy-to-use tool to model and visualize data more efficiently. Learn how to connect various data sources, including Excel, databases, and web data sources like Wikipedia. Explore how to search and transform your data using the built-in Query Editor. Plus, instructor Gini von Courter shows how to build and arrange visualizations, create interactive reports, share your work, manage your published files in the Power BI service, and more.
Topics include:
- Learning Objectives (Based on Bloom's Taxonomy)
- 1. Remember & Understand (Knowledge/Comprehension)
- Identify and describe the components of the Microsoft Power BI ecosystem, including Power BI Desktop, Power BI Service, and their respective roles in the business intelligence workflow.
- Measurable Outcome: Learners will correctly identify at least 4 different Power BI tools and explain their primary functions in a written assessment.
- Key Concepts: Power BI Desktop interface, data source types, connection methods, DirectQuery vs. Import modes
- 2. Apply (Application)
- Connect to and import data from at least 5 different data source types (Excel files, CSV files, databases, web sources, and SharePoint lists) using Power BI Desktop's Get Data functionality.
- Measurable Outcome: Learners will successfully establish connections to multiple data sources and demonstrate proper data import techniques in hands-on exercises.
- Key Skills: File connections, database connections, web data extraction, SharePoint integration, data source management
- 3. Analyze (Analysis)
- Transform and clean raw data using Power Query Editor to prepare datasets for visualization by applying filtering, data type corrections, column transformations, and data reduction techniques.
- Measurable Outcome: Learners will take a messy dataset and apply at least 6 different transformation techniques to create a clean, analysis-ready dataset.
- Key Skills: Data filtering, unpivoting columns, replacing values, adding custom columns, merging and appending data, index creation
- 4. Evaluate & Create (Synthesis/Evaluation)
- Design and build comprehensive interactive reports that include multiple visualization types (cards, tables, matrices, charts), implement effective filtering systems (slicers, page filters, Q&A), and apply professional formatting and conditional formatting.
- Measurable Outcome: Learners will create a complete business intelligence report containing at least 5 different visualization types with proper formatting, interactive filters, and conditional formatting elements.
- Key Skills: Visualization creation, report design, conditional formatting, slicer implementation, Q&A setup, visual arrangement
- 5. Create & Evaluate (Advanced Application)
- Develop and deploy complete business intelligence solutions by creating relationships between multiple data tables, building comprehensive data models, and publishing reports to Power BI Service for organizational sharing and collaboration.
- Measurable Outcome: Learners will build a multi-table data model with proper relationships, create a professional report, and successfully publish it to Power BI Service with appropriate sharing permissions.
- Key Skills: Data modeling, table relationships, report publishing, Power BI Service integration, Microsoft Teams integration, version management
This course is in French only. If this is not a problem for you, by all means go ahead and apply.