• What are star schema, snowflake schema and constellation schema data models

• Configure table and column properties

• What are dimension and fact tables?

• Implement role-playing dimensions

• Define a relationship's cardinality and cross-filter direction

• Create a common date table

• Identify and implement appropriate visualizations

• Format and configure visualizations

• Use a custom visual

• Apply and customize a theme

• Configure conditional formatting

• Apply slicing and filtering

• Configure the report page

• Configure bookmarks

• Create custom tooltips

• Edit and configure interactions between visuals

• Configure navigation for a report

• Apply sorting

• Configure sync slicers

• Group and layer visuals by using the Selection pane

• Drill down into data using interactive visuals

• Design reports for mobile devices

• Use the Analyze feature in Power BI

• Use grouping, binning, and clustering

• Use custom visuals like Deneb and Iconmap

• Use AI visuals

• Use reference lines, error bars, and forecasting

• Detect outliers and anomalies

• How to use SVGs in native visuals

• Visual calculations

• Filter context, row context and evaluation context
• DAX Aggregators and  Iterator functions
• CALCULATE function in DAX and the NO CALCULATE approach
• DAX Table functions
• Time Intelligence functions in DAX
• Time Intelligence through the offset method
• New DAX Query View for writing and debugging DAX
• Using AI tools like chatGPT to assist in writing DAX

• Create and configure a workspace

• Assign workspace roles

• Configure and update a workspace app

• Publish, import, or update assets in a workspace

• Create dashboards

• Choose a distribution method

• Apply sensitivity labels to workspace content

• Configure subscriptions and data alerts

• Promote or certify Power BI content

• Identify when a gateway is required

• Configure a dataset scheduled refresh

• Configure row-level security 

Advanced Topics

• Introduction to Microsoft Fabric
• External tools DAX studio and Tabular Editor 2

Abu Bakar Alvi is a highly experienced Product Manager, a certified Project Management Professional and Data Analyst with over 24 years of industry experience.

He is working primarily as a consultant and corporate trainer. He has trained 1000+ students in multiple public and corporate trainings in Pakistan and globally specializing in Program Management, Data Analytics, and Data Visualization. He is a Microsoft Certified Trainer, a certified Power BI Data Analyst Associate (PL-300) and a certified Azure Enterprise Data Analyst Associate (DP-500). Additionally, he is a certified Project Management Professional (PMP) and an Agile Certified Practitioner (PMI-ACP) from the Project Management Institute (PMI), USA. He is also a certified Azure Data Engineer and Tableau Desktop Specialist.

His expertise and contributions to the field of Electronics Engineering were recognized by the Government of Pakistan in 2005 when he was awarded the prestigious Tamgha-e-Imtiaz, the 4th highest civil award, for professional excellence. He is the youngest Pakistani professional engineer to get this honor at the age of 27.