BISP 

60% Complete Courses » Microsoft Power BI
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


What you will learn in this Power BI Training Course?
  • Get an in-depth understanding of Power BI and how it works in different scenarios
  • Learn about the three vital components - the Desktop, service, and Mobile apps
  • Visualize and analyze data, derive insights from Excel spreadsheet or local database
  • Create compelling reports, visualizations, derive real-time insights and deploy it on demand
  • Create, share, collaborate and benefit from business information with purpose-built
  • Know how to get work done without being a Business Intelligence professional
  • Use Salesforce Data, Azure SQL Database & SQL server analysis tabular data
  • Deploy content packs to work with Quick Books online and Adobe analytics
  • Complete live Projects on Power BI to get hands-on experience.

Module-1: Power BI Installation
  • Installation

Module-2: Power BI OverView
  • The business Challenge - Who Gets The Annual Bonus?
  • Connecting Power BI to a Data File - CSV File
  • Navigating Power BI
  • Drilling down and up in hierarchies
  • Advanced drilling in hierarchies
  • Adding Colours
  • Adding A Calculated Column
  • Adding Labels and Formatting

Module-3: Timeseries, Aggregation, and Filters
  • Downloading and connecting to the dataset
  • Working with timeseries
  • Understanding aggregation and granularity
  • Creating an area chart & learning about highlighting
  • Filters and Slicers in Power BI

Module-4: Maps, Scatterplots and Interactive BI Reports
  • Joining data in Power BI
  • Understanding how LEFT, RIGHT, INNER, and OUTER joins work
  • Joins with duplicate values
  • Joining on multiple fields
  • Creating a map, working with hierarchies, lats and lons
  • Calculated Columns vs Calculated Measures in Power BI
  • Creating a scatter plot
  • Combining charts, filters and slicers
  • Adding a Donut Chart

Module-5: Creating an Interactive Power BI Report
  • Downloading the dataset and connecting Power BI
  • Mapping: How To Set Geographical Roles
  • Creating Table Calculations for Gender
  • Creating Bins and Distributions for Age
  • Creating Bins and Distributions for Balance
  • How to create a Treemap chart
  • Creating a Customer Segmentation Dashboard
  • Controlling Report Interactivity
  • Analyzing the Customer Segmentation Dashboard

Module-6: Custom Visuals
  • The Challenge: Visualizing the European Debt Crisis
  • Installing a Custom Visual for Power BI
  • Mechanics of a Chord Chart
  • Setting up the second Chord Chart
  • Adding Treemaps
  • Exploring the visualization
Course Id:
MSPB001 
Course Fees:
301 USD