Advanced Data Visualisation using Power BI
About This Course
At the end of this module, learners will be able to:
• Apply Advanced Data Visualization via Power Query Editor
• Analyse Data Patterns, Trends and Correlations in Advanced Data Visualization
• Implement DAX Techniques in Dashboard and Scorecard Development Process
• Develop Custom Visuals in the Form of Tables, Graphs and Dynamic Data Displays
• Determine Storytelling Techniques to Support Presentation of Data Analysis
This course will equip learners to exercise judgment on the suitability of the technique for illustrating patterns, trends, and correlations. Learners will also delve into advanced DAX for Power BI, enabling them to design and review dashboards and reports for key stakeholders. Additionally, they will learn to strategically enhance the user experience, facilitating navigation and insight extraction from the visuals.
This course is suitable for learners at advanced level.
What You'll Learn
LU1: Power Query Editor Deep Dive
• Advanced data transformation
• M language fundamentals for custom data manipulation
• Appraising error handling and data quality checks
LU2: Beyond Basic Charts
• Waterfall charts, funnel charts, gauges, and other advanced visuals
• Formatting and customizing visuals for impact
• Interactive elements and user experience consideration
LU3: DAX Advanced Techniques
• Calculate columns and measures
• DAX syntax and common functions
• Filtering and aggregation with DAX
• Time intelligence functions
• Utilizing advanced filtering and calculated tables
• Creating complex KPIs and performance metrics
LU4: Custom Visuals and the Power BI Marketplace
• Identifying and integrating custom visuals for specific needs
• Evaluating and selecting appropriate custom visuals
• Leverage custom visuals for unique data storytelling
LU5: Storytelling with Data
• Designing dashboards and reports with a narrative flow
• Engaging users with visuals and data insights
• Best practices for layout, hierarchy and user interaction
Entry Requirements
Learners are expected to have a minimum of:
• Upper secondary level education
• At least 1 year working experience
• Able to read, write, speak and listen to English at WSQ WPL level 5
• Able to manipulate numbers at WSQ WPN level 5
• Able to operate a computer
• Must have knowledge in Power BI at its intermediate level