Visualizing Data and Building Dashboards in Excel & Power BI
Dive into a comprehensive video tutorial on data visualization and dashboard creation in Excel and Power BI, led by Excel MVP and Highline College Professor Mike Girvin. Learn the fundamentals of data visualization, including Edward R. Tufte's principles, table formatting rules, and conditional formatting. Master various chart types such as column, bar, line, and scatter charts. Explore advanced techniques for creating dashboards using PivotTables, Power Query, and DAX formulas. Discover how to build dynamic dashboards with array formulas and PivotTables in Excel, and leverage Power BI Desktop for sophisticated data modeling and online sharing. Gain practical tips on formatting, updating, and optimizing your dashboards across different platforms. Download the provided files to follow along and apply your new skills to real-world data visualization challenges.