Advanced Power BI MasterClass

This is a very practical, and hands-on course on Power BI that will transform your Data Analysis skills and make you a PRO in using Advanced Power BI Features

• Master advanced DAX measures for more powerful data analysis.
• Explore advanced use cases and techniques in Power Query.
• Learn data visualization best practices and advanced settings.
• Implement row-level security to protect your data.
• Optimize your data models to keep them small and efficient.
• Import and use custom visuals to enhance your reports.
• Create Python or R visuals for more dynamic data presentations.
• Utilize new KPI cards, gauges, and other visuals to add value.
• Understand and apply AI features, Quick Measures, and Advanced Time Intelligence Comparisons.

ADVANCED POWER BI – COURSE OUTLINE

Section 1: Data analytics With Power BI

• Understanding data analytics
• Explore Roles in data Analysis
• Key Tasks for a data analyst
• Introduction to Power BI Desktop Advanced Features
• Components of Power BI
• Understanding Power BI Services

Section 2: Design a data model in Power BI

• Get data from files & folders
  

  

• Get data from relational data sources
• Get data from a NoSQL database
• Get data from online services
• Select a storage mode
• Get data from Azure Analysis Services
• Fix performance issues
• Resolve data import errors
• Understanding Constraints & Performance issues
• Understand data types mismatch issues
• Resolving data quality errors

Section 3: Data Cleansing With Power BI

• Shape the initial data
• Simplify the data structure
• Evaluate and change column data types
• Combine multiple tables into a single table
• Profile data in Power BI
• Use Advanced Editor to modify M code

Section 4: Creating Advanced DAX measures in Power BI

• Using the Calculate function
• Understanding Filter Context
• Using IF, SWITCH, FIND
• Using VALUES, HASONEVALUE, SELECTEDVALUE, and CONCATENATEX
• Using ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS
• Creating Virtual Tables
• Create semi-additive measures
• Advanced Date Comparisons With Same Period Last Year, Year To Date, Month to date totals,
• Using Date Functions like DATEADD, FIRSTDATE, LASTDATE, NEXTYEAR
• Writing Custom Time Intelligence Functions
• Using RELATED & RELATEDTABLE functions in Power BI

Section 5: Performance Optimization in Power BI

• Performance optimization Considerations
• Review performance of Measures, Relationships, and visuals
• Using variables to improve performance & Troubleshooting
• Reduce cardinality in the Data Model
• Optimize DirectQuery models with table level storage
• Create and manage aggregations

Section 6: Working with Power BI visuals

• Introduction to Advanced Power BI visualizations
• Add visualization items to reports
• Choose an effective visualization
• Format and configure visualizations
• Import a custom visual into Power BI
• Add an R or PYTHON visual in a report

Section 7: Create a data-driven story with Power BI reports

• Introduction to create a data-driven story with Power BI reports
• Design a report layout
• Add buttons, bookmarks, and selections
• Design report navigation
• Use advanced interactions and drill through
• Configure conditional formatting
• Apply slicing, filtering, and sorting
• Publish and export reports
• Comment on reports
• Fine Tune report performance
• Optimize reports for mobile use

Section 8: Create dashboards in Power BI

• Introduction to dashboards
• Configure data alerts
• Explore data by asking questions
• Add a dashboard theme
• Pin a live report page to a dashboard
• Configure a real-time dashboard
• Configure data classification
• Explore mobile view & Auto Mobile Layouts

Section 9: Perform analytics in Power BI

• Introduction to analytics
• Explore statistical summary
• Identify outliers with Power BI visuals
• Group and bin data for analysis
• Apply clustering techniques
• Conduct time series analysis
• Use the Analyze feature
• Use advanced analytics custom visuals
• Review Quick insights
• Apply AI Insights

Section 10: Work with AI visuals in Power BI

• Introduction to working with AI visuals
• Use the Q&A visual
• Find important factors with the Key influencers visual
• Use the Decomposition Tree visual to break down a measure

Section 11: Create and manage workspaces in Power BI

• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

Section 12: Secure Access With Row-Level Security

• Configure row-level security with the static method
• Configure row-level security with the dynamic method

Section 13: Manage datasets in Power BI

• Create dynamic reports with parameters
• Create what-if parameters
• Use a Power BI gateway to connect to on-premises data sources
• Configure a dataset scheduled refresh
• Configure incremental refresh settings
• Manage and promote datasets
• Troubleshoot service connectivity

Power BI Certification: How This Course Prepares You for PL-300

The Microsoft PL-300 exam (Power BI Data Analyst Associate) is the current Power BI certification. It replaced DA-100 in 2022. This 2-day Advanced Power BI MasterClass covers the same four skill
areas the exam tests, hands-on and in the classroom:

1.  Prepare the data: clean and transform data with Power Query
2.  Model the data: relationships, cardinality, hierarchies, DAX measures with CALCULATE and FILTER, time intelligence and performance optimisation
3.  Visualise and analyse the data: interactive dashboards, drill-through, KPIs and advanced visuals
4.  Deploy and maintain assets: publish and share reports, and secure them with row-level security

New to Power BI? Start with our beginner Power BI MasterClass, then take this advanced Power BI course before you sit for the Microsoft PL-300 certification. 

Intellisoft is a Pearson Authorized Test Centre for such Microsoft Certifications.