Data Visualization for Decision-Making: Power BI Step by Step | MG628

How does data visualization change the decisions managers make? This lecture answers that question and then builds the answer, step by step, in Power BI: from raw files to an interactive decision dashboard. Part of MG628 – Data Analysis for Managerial Decisions (Lecture A of 2; Lecture B covers Tableau). Instructor: Professor Fomba Kassoh. By the end of this lecture you will be able to: Explain the role of visualization in insight discovery, communication and strategic planning Navigate Power BI Desktop: Report, Table and Model views; the Data, Visualizations and Filters panes Prepare data with Power Query: import, clean and transform raw files Model a star schema and write DAX measures (COUNTROWS, AVERAGE, CALCULATE, DIVIDE, SWITCH, USERELATIONSHIP) Build and format KPI cards, gauges, bar, line, histogram, scatter, donut, stacked-column, matrix, treemap, map and decomposition-tree visuals Recognise threats to accuracy and relevance, and turn a dashboard into a recommendation Worked examples use a 100-customer segmentation dataset, a 663-customer master file and a 306-store list. Healthcare and public-administration models are presented at the level of method. CHAPTERS 0:00 Introduction: visualization and decision-making 1:06 Why a picture beats a table 2:01 Learning objectives 3:40 The Power BI workflow in five steps 5:16 Part 1 — Tour of Power BI Desktop 7:12 Part 2 — Preparing data with Power Query 9:08 Splitting, removing and profiling columns 12:48 Knowledge check 1 13:44 Part 3 — Modeling the data (star schema) 16:37 Creating and verifying relationships 17:31 Active and inactive relationships (USERELATIONSHIP) 19:13 Part 4 — Measures with DAX 21:15 CALCULATE and DIVIDE 23:12 Part 5 — Building the visuals: KPI cards and gauges 26:59 Bar and line charts 30:50 Histograms and scatter plots 34:41 Donut, stacked column and heat-map matrix 39:59 Treemaps and maps 43:54 The loyalty-tier paradox 44:44 Decomposition tree 46:31 Choosing the right visual 47:30 Part 6 — Formatting the visuals 51:51 Slicers, interactions and dashboard layout 53:46 Knowledge check 3 54:51 Part 7 — Accuracy, relevance and the decision 56:08 From dashboard to recommendation 57:06 Healthcare and public administration roadmaps 1:00:07 Summary and next steps RESOURCES Course data files and practice materials: [add course-site link] TOOLS: Microsoft Power BI Desktop · Power Query · DAX Narration is AI-generated with ElevenLabs from the instructor's script. #PowerBI #DataVisualization #BusinessAnalytics #DataAnalytics #DAX #PowerQuery