Advanced Power BI

Service Description

Take your Power BI expertise to the next level with our comprehensive advanced course. Dive deep into complex data models and analytics techniques, empowering you to deliver high-impact insights for your organization. Module 1: Power BI Desktop Introduction - Download Power BI Desktop - Overview and Terminology - Imports - Visualizations - Filters and Queries - Reports Module 2: Data Sources - Compatible Data Sources - Get Data - Direct Query vs Import Data - Defining Hierarchies based on a single Table - Create and Manage Relationships between Tables - Use Append Queries - Merge Data Tables Module 3: Visualizations - Creating Visualisations - Colour Formatting - Setting Sort Order - Scatter and Bubble Charts - Slicers, Timeline Slicers & Sync Slicers - Cross Filtering and Highlighting - Visual, Page and Report Level Filters - Drill Up, Down and Through - Hierarchies - Reference / Constant Lines - Tables, Matrices & Conditional Formatting - KPI’s, Cards and Gauges - Map Visualizations - Custom Visuals - Custom Report Themes - Grouping and Binning - Selection Pane and Bookmarks Module 4: Querying Data - Query Editor - Filters and Delimiters - Transforms - Pivot and Group By - Creating Custom Calculated Columns - Creating Tables - Adding Conditional Columns Module 5: Data Analysis Expression (DAX) - DAX Overview - DAX data types and operators - Common DAX functions - Referencing other tables in DAX - Using CALCULATE and RANKX - Using RELATED, RELATEDTABLE, LOOKUPVALUE Module 6: Reports and Exports - Report Elements and Options - Working with Pages - Adding Graphics - Report Level Filters - Report Themes - Export Power BI Data to CSV - Create a Power BI Template Module 7: Sharing Content - Power BI Service - Sharing Dashboards with internal and External users - Sharing content with Office 365 groups - Using Publish to Web with Dashboards Module 8: Power BI Workspaces - Understanding Workspaces - Creating Workspaces - Personal vs - Workspace Permissions and Roles Module 9: Power BI App - Supported Platforms - Creating Dashboards for Mobile devices - Accessing Reports and Dashboards from Mobile Module 10: Gateways - Power BI Personal Gateway - Working with OneDrive - Working with SharePoint Lists