Microsoft Power BI (Using Power BI Desktop and Service)
Data Analytics
Course Overview
Power BI is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports and then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. In addition, scale across the enterprise, with governance and security built in.
Duration: 4 days / 32 hours
Delivery Method: Classroom-based, Virtual Instructor Led Training
COURSE OBJECTIVES
At the end of this course, the student must be capable on the following skillsets:
· Creating Filter Based Data Analysis Expressions
· Create Dynamic Dashboards using Power BI Visuals
· Publishing Power BI Reports in Power BI Service
PRE-REQUISITES
Microsoft Office Excel, Knowledge on Basic Database Management
TARGET AUDIENCE
Data Analyst, Sales, Human Resource, Admin Executives
COURSE OUTLINE
MODULE 1: REFRESHER ON POWER BI ESSENTIALS
· Setup Power BI Desktop Configurations
· Import Excel / CSV file to Power Query Editor
· Transform, Clean and Consolidate Data in Power Query Editor
MODULE 2: CONNECTING TO EXTERNAL DATA SOURCES
· Getting Data from SharePoint
· Getting Data from Database
· Getting Data from the Web
· Dynamic Source with Parameters
· Setup Data Model / Table Relationships
MODULE 3: APPLYING FILTER-BASED DATA ANALYSIS EXPRESSIONS
· Create Basic Formulas with Data Analysis Expressions
· SWITCH Function
· Joining Data with Related
· CALCULATED Function
· CALCULATE and ALL Function
· CALCULATE and FILTER Function
· Iterator X Functions
· DAX Time Intelligence Formulas
· Creating a Calendar Table
MODULE 4: ADVANCED DATA ANALYSIS EXPRESSIONS
· Using Variables in DAX
· Error Handling
· Advanced Calculate Function
· Keep Filters
· Remove Filters
· AverageX
· RankX
· Advanced Time Intelligence Function
MODULE 5: OPTIMIZE RIBBONS
· Pause Visuals
· Optimization Presets
· Apply All Slicers Button
· Performance Analyzer
MODULE 6: ADDING DYNAMIC VISUAL TOOLS IN POWER BI REPORT
· Adding Conditional Formatting
· Editing Report Interactions
· Adding Drill-through Filter
· Preview: Custom Visual
· Cards and KPI’s
· Filled Map Visuals
· Gauge Charts
MODULE 7: POWER BI REPORTING TOOLS
· Setting up Report Interaction
· Adding Field and Number Parameter
· Clustering
· Grouping and Binning
· AI Visuals
· Bookmarks and Navigation Button
· Creating Page Tooltips
· Anomaly Detection
MODULE 8: PUBLISHING AND SHARING
· Publish from Power BI Desktop
· Publish Reports to Web
· Printing, PDFs and Exporting to PowerPoint
· Export Data from Visualization
· Create a dashboard.
· Understand real-time dashboards.
· Enhance the dashboard usability.
MODULE 9: CREATE AND APPLY DASHBOARD SETTINGS
· Create Dashboard in Power BI Service
· Generate Quick Insights
· Data Driven Alerts
· Report Subscriptions
· Data Lineage View
· Data Lineage Tools
· Create and Manage Workspaces
· Publish Apps in Workspace
MODULE 10: CREATE AND MANAGE WORKSPACES
· Create and manage a workspace.
· Understand workspace collaboration.
· Monitor usage and performance.
· Distribute an App
MODULE 11: REFRESHING DATASETS
· Understanding Data Refresh
· Personal Gateway
· Replacing a Dataset
· Troubleshoot gateway connectivity.
MODULE 12: ROW-LEVEL SECURITY
· Understand aspects of Power BI security
· Configure static and dynamic row-level in Power BI Desktop
· Configure static and dynamic row-level in Power BI Service
MODULE 13: UNDERSTANDING DATA FLOWS
· Quick tour at Dataflows Interface
· Creating New Dataflows for Local file
· Connecting Dataflow to Power BI Desktop
· Scheduled Refresh Dataflows
REGISTER NOW
