Analyse and Visualise Data with Power BI Masterclass.
Effective dashboard reporting and business intelligence for strategic insights.
Course overview.
POWER BI TRAINING MALAYSIAData is everywhere. With the explosion of data that businesses collect comes new challenges and opportunities. Business leaders at every level need to be data literate and turn complex datasets into actionable insights and make important business decisions.
Power BI can take advantage of huge volumes of data that most other platforms would struggle with. Power BI has impressive compression abilities which allow for analysis and visualisation of data. You can use Power BI to connect to hundreds of data sources, simplify data preparation, and drive ad hoc analysis. Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organisation. Power BI produces beautiful reports, then publish them for your organisation to consume on the web and across mobile devices. Everyone can create personalised dashboards with a unique, 360° view of their business and scale across the enterprise, with governance and security built-in.
We will show you how, without the need of former data analysis training, you can be analysing data, transforming information into meaningful insights and building actionable dashboards for better decision making.
Key takeaways.
POWER BI TRAINING MALAYSIA- Confidently & productively analyse large, complex datasets to gain actionable insights
- Have a competent foundation in Power Query to perform complex data cleaning and transformation
- Combine multiple data sources into one dataset, model it and build KPIs and metrics that answer specific business questions
- Understand basic data modelling and the difference between fact table vs dimension table
- Create stunning reports with interactive data visualisations, including slicers, filters and adhoc-highlighting
- Create custom tooltips and drillthrough pages for better context and data exploration
- In the 3-day programme, understand DAX functions, measures and calculation context
- Publish and share Power BI dashboards and reports with the appropriate security settings and permissions
- Learn to use Power BI AI-powered visualisations to identify what matters most in driving metrics (key influencers) and identify interesting segments (top segments) for further investigation
Who should attend.
This workshop is crucial for analysts, managers, reporting professionals, business owners, executives, and anyone who need to derive and share insights with business data. This training is highly recommended for:
- Directors
- General Managers
- Finance Managers
- Business Analysts
- BI Professionals
- Sales Managers
- HR Managers
- Data Analytics Manager
- Business Owners
- Anyone who deals with business, management and financial reporting
Prerequisites.
No prior knowledge of programming or data analysis is required.
The programme.
POWER BI TRAINING MALAYSIA3-Day Extended Programme
SESSION 1Data & AI
- Overview of training aim, objectives and agenda
- Using Power BI for business intelligence with self-service artificial intelligence (AI) capabilities
SESSION 2What Is Power BI?
- Features comparison between Power BI components:
- Power BI desktop
- Power BI service (PowerBI.com)
- Power BI mobile app
- Difference between Power BI and "normal" Excel
- Navigating Power BI desktop confidently: report view, data view vs model view
SESSION 3Data Visualisations & Report Design
- Choosing visuals based on context
- Column chart, bar chart (clustered, stacked)
- Line chart
- Card, table, matrix
- Pie chart, donut chart, treemap
- Native & custom visuals
- Using field, format & analytics pane
- Field column formatting and summarisation
- Adding and customising data labels
- Setting visual interactivity with slicers and filters
- Top N (ranking top/bottom items)
- Basic/advanced filtering
- Understanding adhoc-highlighting
- Applying conditional formatting
- Sort one column by another column
- Drill down and up using hierarchy
- Creating custom tooltips for better context
- Drillthrough page to dig deeper into data category
- Creating bookmarks to share insights and build stories
- Difference between Power BI dashboards and reports
SESSION 4AI Visuals In Power BI
- Working with AI visuals in Power BI
- Use Key Influencers visual to identify factors driving KPI
- Use Decomposition Tree to aggregate data and drill down across multiple dimensions
- Use insights in Bar Chart to analyse change in distribution
- Use Q&A visual to ask questions and get visual answers
SESSION 5Sharing, Security & Data Refresh
- Publishing to PowerBI.com
- Sharing dashboards & reports via links or Teams
- Managing permissions of underlying datasets
- Scheduling data refreshes
- Power BI service license: free, pro vs premium
SESSION 6What Is Power Query? >>> Engine To Extract, Transform & Load (ETL) Data
- Using Power Query as an ETL tool
- Power Query M language: Do you need to learn M?
- Importing data from single or multiple sources
- File: Excel, CSV, Folder
- Database (SQL, SAP, Oracle, etc)
- Online services
- Other: Web, OData Feed
- Unstructured vs structured data
- Query Editor ribbon, Navigator pane & Preview grid
- Query settings panel - recording of transformation steps
SESSION 7Data Cleaning & Formatting
- Data types: Number, Date, Text, True/False
- Remove Columns, Remove Other Columns & Choose Columns
- Removing duplicates from a data set
- Replacing values and errors
- Null values: Replace, fill or filter out
- Removing whitespaces and non-printable characters
SESSION 8Data Transformation Techniques
- Converting (selected) columns to rows and vice versa:
- Transpose
- Unpivot columns
- Pivot column
- What are the differences? When to use them?
- Transforming text columns:
- Format: trim, clean, uppercase, lowercase, add prefix
- Split column & merge columns
- Extract texts before/after delimiter
SESSION 9Data Aggregation & Calculation
- Summarise data with Group By (Sum, Median, Min, Max, etc)
- Custom Columns: Create formulas for computations
- Index Columns (row counters/sort orders)
- Number columns statistical calculations
SESSION 10Combining Data (queries)
- Difference between merge and append
- Merge queries (the V-Lookup in Power Query)
- Append queries (combining tables with the same headers)
- Use cases of merge and append queries
SESSION 11Organising Power Query Automation
- Best practices in organising your data sources
- How to automate your data refresh
- Importing multiple files located in a folder
- Update Power Query for change in location of source data
- Disabling load of redundant queries to enhance performance
SESSION 12Power Query Time Saving Tips
- Copy queries to another Power BI file or an Excel workbook
- Duplicate and reference queries
- Preview or navigate to table objects
- Navigate through complex query dependencies
SESSION 13DAX (data Analysis Expressions) Basics
- Using DAX to perform advanced analysis to gain insights
- Understanding DAX - tables/columns (DAX) vs cells (Excel)
- Understanding the difference between:
- Implicit measure
- Explicit measure
- Understanding the difference between:
- Calculated column
- Measure
- Power Query vs DAX: How do you decide?
SESSION 14DAX Context
- Understanding context as the key to:
- Building high-performing, dynamic analyses
- Troubleshooting problems in formulas
- Types of evaluation context:
- Filter context
- Row context
- Types of filters:
- Implicit filter (from the current query)
- Explicit filter (external filters outside the visuals)
- Context transition in calculated columns
SESSION 15DAX Calculation Engines - The Aggregators And Iterators
- How DAX aggregators and iterators work differently
- Aggregating functions:
- SUM, AVERAGE, MIN, MAX
- COUNT/COUNTA/COUNTBLANK/COUNTROWS
- Iterating functions:
- SUMX, AVERAGEX, MINX, MAXX
SESSION 16Commonly Used DAX Functions
- Filter functions: CALCULATE, FILTER
- CALCULATE: The most used function in DAX
- Using CALCULATE to add, modify or remove filters
- Contex transition with CALCULATE
- Using FILTER to reduce the number of rows in the table
- Safe DIVIDE function
- Logical functions:
- IF
- SWITCH (Nested IFs)
- AND
- OR
- Logical operators: AND (&&) and OR (II)
SESSION 17DAX Tips And Tricks
- Simple to advanced: Start with simple formulas, then branch out to the advanced calculations
- Variable: Using variables in DAX formulas to help write complex and efficient calculations
SESSION 18Data Modelling
- Creating and editing relationships
- Active vs inactive relationships
- Fact table vs dimension table
- Relationship cardinality
- One-to-one
- One-to-many
- Many-to-many
SESSION 19Hands-on Power BI Project
- Applying Power BI skills
- Choice of dataset:
- Sales/Finance dataset
- Predictive maintenance dataset
- Bring Your Own Data (BYOD)
- Throughout the workshop, participants will work through practical exercises to enhance their knowledge of the tools available to build Power BI dashboards and reports
Your trainer.
POWER BI TRAINING MALAYSIAAlvin Yong is a UK-registered Fellow Chartered and Certified Accountant (FCCA). He obtained his Master of Science in Professional Accountancy (Merit) in 2017 from the University of London.
To bring.
POWER BI TRAINING MALAYSIAReviews from our Malaysian clients.
POWER BI TRAINING MALAYSIA“Excellent Course!”
“Being a beginner, the instructor guided well. Learnt a lot, giving me practical knowledge & skills which I will be able to apply.”
“Very helpful session. Progressed at a very nice pace, making it clear for all participants.”
“Alvin is a very knowledgeable and patient trainer. His training session is very insightful. Gained lots of knowledge during the session. Great job!”
“Very detailed. Alvin was very professional all the time. Well done!!!”
“A good trainer and knowledgeable. Easy to understand.”
“Helpful and great presentation!”
“Eloquent ,knowledgeable and competent with the subject.”
“Alvin is very knowledgeable with Power BI.”
Related courses.
POWER BI · DAX · POWER QUERY · DATA VISUALISATIONReady when your team is.
Public runs across the region and live online — or we scope an internal cohort around your actual reports.
Enquire about in-house training