Course Objective & Scope
Cluttered charts, misleading axes and dashboards without a clear message can turn even correct data into wrong decisions. The programme covers tool-independent principles such as chart selection, pre-attentive attributes, colour palettes, the data-ink ratio and accessible design.
Participants redesign sample reports taken from the organisation, build a data storytelling flow and finish with a visualization checklist the team can reuse. Exercises run in Power BI, Tableau or Excel, depending on the tool the organisation uses.
Who Should Attend?
- Reporting and business intelligence analysts
- Specialists in finance, sales and operations who prepare regular reports
- Project and product managers who build management presentations
- Prerequisite: basic experience creating tables and charts is sufficient
Key Takeaways
- Select the right chart type for the question and data type
- Detect and fix misleading axes, scales and colour use
- Design visual hierarchy and reading order in dashboards
- Present findings with a context–insight–action structure
- Apply colour-blind-safe, accessible palettes
Curriculum
Visual Perception and Design Principles
- Pre-attentive attributes and Gestalt principles
- Data-ink ratio and removing chart junk
Choosing the Right Chart Type
- Comparison, distribution, composition and trend charts
- Risks of pie, dual-axis and 3D charts
Colour, Labelling and Accessibility
- Sequential, diverging and categorical palettes
- Direct labelling and colour-blind-safe design
Dashboard Layout and Hierarchy
- KPI cards, reading order and grid layout
- Filter and drill-down design
Presenting with Data Storytelling
- Context–insight–action flow
- Narratives suited to executive summaries
Redesigning Organisational Reports
- Before/after transformation of an existing report
- Building the visualization checklist
Other Courses in This Category
-
Advanced Power BI
Advanced DAX patterns, calculation groups, row-level security, incremental refresh, composite models and performance tuning for experienced Power BI users building enterprise-scale reporting solutions.
- Live Course
- 6 modules
-
Data Modeling and DAX for Power BI
Star schema design, fact and dimension tables, relationships and filter direction, date tables and core-to-intermediate DAX measures, so analysts build Power BI models that return correct, maintainable results.
- Live Course
- 6 modules
-
Power Query for Data Preparation and Transformation
Importing from multiple sources, cleaning, merging, unpivoting, parameters, custom functions and M language basics in Power Query, so Excel and Power BI users automate manual data preparation.
- Live Course
- 6 modules
-
Microsoft Fabric Fundamentals
OneLake, Lakehouse, Data Warehouse, Data Factory pipelines, Dataflow Gen2, notebooks and Direct Lake Power BI, giving data and BI teams an end-to-end introduction to Microsoft Fabric components.
- Live Course
- 6 modules
-
Migrating from Power BI to Microsoft Fabric
Moving Power BI Premium/Pro environments to Fabric capacity, converting dataflows to Gen2 and sources to Lakehouse and Direct Lake, so BI teams produce a risk-controlled migration roadmap.
- Live Course
- 6 modules
-
Data Analysis with Excel
PivotTables, XLOOKUP, dynamic array functions (FILTER, UNIQUE, SORT), conditional aggregation, What-If analysis and Power Pivot, so business users perform fast and reliable analysis in Excel.
- Live Course
- 6 modules
Get in touch