The live online cohort based training covers the 4 pillars of Power BI development as well Power BI Service in the cloud. Participants mostly perform hands-on work along with the instructor in a live setting. In addition, they are required to submit 3 projects, 2 x minor and 1 x major. The content for the 07 weeks training includes
- Introduction to Power BI based data analytics
- Data Transformation using Power Query
- Dimensional Data modeling
- DAX Programming
- Data Visualization and Report Design
- Power BI Service and capstone project
Understanding data analytics
- Different types of data analytics
End-to-end data analytics process
- What is the analytics eco-system?
Requirements gathering process and framework
- How to gather requirements for a business problem?
- Connecting to different data sources like CSV, Excel, RDBMS and web data sources
- Creating conditional & calculated columns
- Data Cleaning operations
- Merging columns and tables using append and merge operations
- Transpose, Pivot, Unpivot operations
- Understanding and writing M-script
Design and implement a dimensional data model
- 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
Create reports
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
Enhance reports with report navigation and design
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
Data Storytelling and UI / UX design
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 manage workspaces and assets
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
Manage datasets
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.