- Data Analytics and Microsoft
- The tasks of a Data Analyst
- Getting Started with Power BI
- Get data from multiple data sources such as SQL Server, Azure Cosmos DB, Azure Analysis Services
- connection methods and their performance implications
- options for data storage
- Optimize query performance
- Resolve data import errors
- Lab : Preparing Data in Power BI Desktop
- Connecting to data sources and inspecting data with Power Query Editor
- Identify data anomalies
- Data shaping
- Apply data shape transformations
- Enhance the data structure
- Data Profiling
- Data cleaning
- Lab : Transforming and Loading Data
- Querying and transforming data sets
- Loading data
- Introduction to data modelling
- Data relationships
- Performance implications
- Data security
- Working with tables
- Dimensions and Hierarchies
- Create histograms and rankings
- Lab : Data Modelling in Power BI Desktop
- Create Model Relationships
- Configure Tables
- Review the model interface
- Create Quick Measures
- Lab : Advanced Data Modelling in Power BI Desktop
- Configure many-to-many relationships
- Enforce row-level security
- Introduction to DAX
- DAX context
- Using DAX for simple formulas and expressions
- Advanced DAX
- Working with Time Intelligence and Key Performance Indicators
- Lab : Introduction to DAX in Power BI Desktop
- Create calculated tables
- Create calculated columns
- Create measures
- Lab : Advanced DAX in Power BI Desktop
- Use the CALCULATE() function to manipulate filter context
- Use Time Intelligence functions
- Optimise the data model for enterprise-level performance
- Achieving efficiency by using variables
- Data modelling best practices
- Optimise DirectQuery Models
- Create and manage Aggregations
- Design a report page layout
- Enhance the report with visualisations
- Report navigation and interactions
- Use Performance Analyzer to improve efficiency of queries
- Lab : Designing a report in Power BI
- Create a live connection in Power BI Desktop
- Design a report
- Configure visual fields and format properties
- Lab : Enhancing Power BI reports with interaction and formatting
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use Bookmarks
- Graphical representation of data insights
- Create a Dashboard
- Navigation tools
- Real-time Dashboards
- Enhance a Dashboard
- Lab : Designing a report in Power BI Desktop - Part 1
- Create a Dashboard
- Pin visuals to a Dashboard
- Configure a Dashboard tile alert
- Use Q&A to create a dashboard tile
- Paginated report overview
- Create Paginated reports
- Lab : Creating a Paginated report
- Use Power BI Report Builder
- Design a multi-page report layout
- Define a data source
- Define a dataset
- Create a report parameter
- Export a report to PDF
- Advanced Analytics
- Statistical functions
- Identifying outliers
- Conduct time-series analysis
- Using the Analyze feature
- Use advanced analytics custom visuals
- Data Insights through AI visuals
- Lab : Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use the visual to forecast values
- Work with Decomposition Tree visual
- Work with the Key Influencers visual
- Creating Workspaces
- Understand workspace collaboration
- Assigning user roles and security
- Distribute an App
- Sharing and Managing Assets
- Monitor workspace usage and performance
- Lab : Publishing and Sharing Power BI Content
- Map security principals to dataset roles
- Share a dashboard
- Publish an App
- Create dynamics reports with parameters
- Configuring a dataset refresh schedule
- Managing Power BI assets
- Manage and promote datasets
- Troubleshoot gateway connectivity
- Security in Power BI
- Configure row-level security roles and group memberships
- Test roles in Power BI Desktop