Power BI
What you'll learn
- Introduction
- Connectivity
- Visualizations
- Advanced data
- Calculations and queries
- Advanced Visuals
- Deployment
- Administration
Course content
8 modules • 24Hrs Duration
Introduction (1 hours)
- Business intelligence
- Data analysis
- Self-service BI
- Planning a report
- Power BI service
- Power BI Vs Power BI Pro
- Getting started (1 hour)
- Power BI desktop installation
- Power BI online
- Building your first report
- Direct query Vs Import
- Various Tools and windows introduction
Lab
Lab-1: Power BI desktop installation
Lab-2: Building your first Power BI report
Connectivity (2 hours)
- Excel connectivity
- Azure SQL connectivity
- Web service connectivity
- OData connectivity
Lab
Lab-3: Excel connectivity
Lab-4: Azure SQL connectivity
Visualizations (8 hours)
- Table layout
- Area chart
- Bar and column chart
- Cards – Multi and single row
- Combo charts
- Doughnut charts
- Funnel charts
- Gauge charts
- Key influencers chart
- KPI’s
- Line charts
- Maps
- Matrix
- Pie charts
- Ribbon chart
- Scatter and bubble chart
- Scatter high density
- Slicer
- Standalone images
- Tree maps
- Waterfall charts
Lab
Lab-5: KPI’s, Pie charts, Line charts
Lab-6: Maps, Tree maps
Advanced data (3 hours)
- Data modelling
- Relationships between data sources
- Pivot columns
- Group rows
- Query formulas
Lab
Lab-7: Building relationship between two data sources
Lab-8: Pivot columns
Calculations and queries (3 hours)
- Aggregations
- Expressions
- Measures
- Calculated columns
- Bidirectional Cross filtering
- Natural language query
Lab
Lab-9: Expressions and Measures
Lab-10: Aggregations and Natural language query
Advanced Visuals (3 hours)
- Grouping two visuals
- Customize visualization legends
- Customize visualization backgrounds
- How to add totals and show in group
- Developer API
- Power BI mobile app
Lab
Lab-11: Customize visualization backgrounds
Lab-12: Power BI mobile app
Deployment (2 hours)
- Publish the report
- Share the report
- Dashboard
- Workspace
- What is PBIX file?
Lab
Lab-13: Publish and share the report
Lab-14: Pinning report to dashboard
Administration (1 hour)
- Licensing
- Handing security rights for reports
- Row level security
- How to deploy Power BI report to LIVE environment
- Scheduled refresh
Lab
Lab-15: Adding security rights
Trainers recent project activities
- Successful data migration and code migration from AX 2012 to Dynamics 365 for Operations 10.0.12 version.
- PowerApps Timesheet management application, in integration with Dynamics 365 for Operations.
- Complete module design and architecture development for Estimation process in Dynamics AX 2012.
- Custom Embedded Power BI report creation for Dynamics 365 Asset Management.
Prerequisites
- Basic understanding of data analytics and business intelligence concepts.
- Familiarity with Microsoft Power Platform is beneficial but not required.
- No prior experience with Power BI is necessary.
Who this course is for
- Business analysts and data professionals looking to harness the power of Power BI for data visualization and reporting.
- IT professionals and consultants interested in developing their skills in business intelligence.
- Individuals seeking to transform data into actionable insights using Power BI.
This course includes
Certificate of completion
24 hours trainer-led online session
14 hours offline lab exercise