|
via Udemy |
Go to Course: https://www.udemy.com/course/microsoft-365-power-bi-desktop-intermediate/
Certainly! Here's a detailed review and recommendation of the Coursera course "Microsoft 365 Power BI Desktop - Intermediate": --- **Course Review: Microsoft 365 Power BI Desktop - Intermediate** The "Microsoft 365 Power BI Desktop - Intermediate" course is an excellent next step for those who have completed a beginner Power BI course and wish to deepen their understanding and skills. Taught by instructor Eric Brockway, this course effectively bridges foundational knowledge with advanced techniques necessary for building modern, interactive reports and dashboards. **Course Content & Learning Outcomes** This course focuses on critical aspects of data visualization and analysis, including: - **Data Refresh and Source Management:** Understanding how to keep data up-to-date by managing data refreshes and connecting to multiple sources. - **Data Modeling:** Covering essential topics such as table relationships, cardinality, row-level security, and referential integrity, empowering learners to create more reliable and secure data models. - **Calculated Columns:** Demonstrating how to add calculated columns to enrich datasets, enabling more comprehensive analysis. - **Advanced Visualizations:** Introducing new visuals like donut charts, tree maps, line and stacked column charts, maps, and filled maps, along with guidance on selecting appropriate visuals for specific use cases. - **Filtering and Interactivity:** Teaching various filtering techniques, including filters at different report levels, cross-filters, Top N filters, and relative date filters, to make reports more dynamic. - **Slicers:** Covering different types of slicers, especially date and numeric range slicers, which enhance dashboard interactivity. The course emphasizes practical use cases, offering demonstrations that reinforce when and how to use different visuals and filters effectively. **Strengths** - In-depth coverage of intermediate Power BI functionalities. - Practical demonstrations and use cases. - Focus on creating interactive, real-time dashboards. - Clear explanation of complex topics like data modeling and security. - Suitable for professionals looking to enhance their reporting capabilities beyond the basics. **Recommendations** This course is highly recommended for data analysts, business intelligence professionals, or managers who want to leverage Power BI for more sophisticated reporting. No prior experience beyond the beginner course is required, but familiarity with basic Power BI concepts is beneficial. **Conclusion** If you're looking to upgrade your Power BI skills, especially in creating interactive dashboards with multiple data sources, advanced visualizations, and better data management, "Microsoft 365 Power BI Desktop - Intermediate" is a valuable investment. It enriches your toolkit, enhances your ability to produce actionable insights, and prepares you for more complex data analysis tasks. --- Let me know if you'd like a shorter summary or additional details!
Modern reports and dashboards are highly interactive and use data from multiple sources. Managers want real-time information for analysis and decision making. This course builds on the beginner course and enables dashboard creators to support these requirements.Data is only as up to date as its latest refresh. The location of data has refresh implications, as does the feature used by Power BI Desktop to connect to that data. This course covers the issues that must be addressed to determine the freshness of an organizations reporting data.Data often comes from different sources. When all that data together must be used for visualizations and analysis, the data must be modeled. Data modeling includes the topics: Table Relationships, Cardinality, Row-level Security, and Referential Integrity.Sometimes a data source does not have all the information that is required for reporting or forecasting. Calculated columns may be added to produce the data required for further analysis. Calculated columns are covered in this course.Visualizations that are not covered in the beginner course are covered here. This course includes: Donut Charts, Tree Maps, Line and Stacked Column charts, Line and Cluster Column charts, Maps, and Filled Maps. Perhaps mostly importantly, use cases that determine when each of these visuals is the best one to use are explained and demonstrated.Filters are introduced as a technique for interactively analyzing data. Filters may be applied to single visualizations, pages, or entire reports. Each has its place. Special filters are also included such as: Include / Excluded filters, Cross filters, Top N filters, and relative Date filters.Slicers are visual filters that enhance interactivity, especially on dashboards. There are various types of slicers, and this course covers date slicers, time slicers, numeric range slicers, and others.Even though dashboards are covered in the beginner course, there is so much that can be done with them! In this course, dashboards are created the use the new visualizations and that also incorporate filters and slicers!Instructor: Eric Brockway