Ambeone’s POWER BI Training

For Business Analytics, Data Visualization and Data Dashboards

Power BI Basic

This is a 2 Days Training program or Four Weeks program (4 hours per week) that will equip with essential knowledge for using Power BI for Data Visualization as well as Data Cleaning as well as creating and sharing reports and dashboards.

It is a must for all working executive so they can learn how to use data in their jobs and present their performance reports to management in easy and attractive manner.

Course Outline – Power BI Basic

1. Get or connect to data
   • Identify and connect to data sources or a shared semantic model
   • Change data source settings, including credentials and privacy levels
   • Choose between DirectQuery and Import
   • Create and modify parameters
   • Resolve import errors if any
2. Clean the data
   • Evaluate data, including data statistics and column properties
   • Resolve inconsistencies, null values, and data quality issues
3. Create basic visualization and reports
   • Select an appropriate visual
   • Format and configure visuals
   • Apply and customize a theme
   • Apply conditional formatting
   • Apply slicing and filtering Configure the report page
   • Choose when to use a paginated report
4. Transform and load the data
   • Select appropriate column data types
   • Create and transform columns
   • Group and aggregate rows Pivot, unpivot, and transpose data
   • Convert semi-structured data to a table
   • Create fact tables and dimension tables
   • Using reference or duplicate queries and the resulting impact
   • Merge and append queries
   • Identify and create appropriate keys for relationships
   • Configure data loading for queries
5. Create and manage workspaces
   • Create and configure a workspace
   • Configure and update a workspace app
   • Publish, import, or update items in a workspace
   • Create dashboards Choose a distribution method
   • Configure subscriptions and data alerts

Power BI Advanced

The Advance Modules for Power BI are focused for working professionals using data and engaged in creating KPIS and Dashboards for management .

The program will train you to be a Expert in Power BI and even prepare you for taking the PL-300 -Microsoft Power BI Data Analyst Certification exam.

We will provide you hands On practice with several assignments, projects and case studies to become a successful Business Analyst using Power BI advance features.

Course Outline- Power BI Advanced

1. Design and implement advance data model and relationships
   • Configure table and column properties
   • Implement role-playing dimensions
   • Define a relationship’s cardinality and cross-filter direction
   • Create a common date table
   • Identify use cases for calculated columns and calculated tables
2. Create model calculations by using DAX
   • Create single aggregation measures
   • Use the CALCULATE function
   • Implement time intelligence measures
   • Use basic statistical functions
   • Create semi-additive measures
   • Create a measure by using quick measures
   • Create calculated tables or columns
   • Create calculation groups
   • Create Visual Calculations using DAX
3. Optimize model performance
   • identifying and removing unnecessary rows and columns
   • Identify poorly performing measures, relationships, and visuals
   • Improve performance by reducing granularity
4. Enhance reports for usability and storytelling
   • Configure bookmarks
   • Create custom tooltips
   • Edit and configure interactions between visuals
   • Configure navigation for a report
   • Apply sorting to visuals
   • Configure sync slicers
   • Group and layer visuals by using the Selection pane
   • Configure drill through navigation
   • Configure export settings
   • Design reports for mobile devices
   • Enable personalized visuals in a report
   • Design and configure Power BI reports for accessibility
   • Configure automatic page refresh
5. Identify patterns and trends
   • Use the Analyze feature in Power BI
   • Use grouping, binning, and clustering
   • Use AI visuals
   • Use reference lines, error bars, and forecasting
   • Detect outliers and anomalies
6. Secure and govern Power BI items
   • Identify and configure gateway
   • Assign workspace roles
   • Configure item-level access
   • Configure access to semantic models
   • Configure a model scheduled refresh
   • Implement row-level security roles
   • Configure row-level security group membership
   • Apply sensitivity labels