Date Time No. of Days Fees (Inclusive Taxes)
19/01/2023 2:00 PM - 5:30 PM 2 5605

MIS Reports using Microsoft Excel Power BI

Introduction

This Power Bi course is an intensive and interactive course

Excel users can save time with Power BI (Business Intelligence) and get powerful Interactive MIS Reports & Dashboards, using the skills they already have.

Excel is a powerful, flexible tool for every analytics activity. Combining it with Power BI one can quickly start creating stunning interactive dashboards by easily transferring all the current Excel queries, data models, and reports to Power BI, without learning a new application or language.

Key Benefits:

  • Create data dashboards and visualizations in minutes
  • Quick and easy access to your data
  • Data search and exploration
  • Insight into data from all types of devices
  • Ability to work across the company
  • Live dashboard monitoring
  • A consolidated clear overview
  • Informed business decision making
  • Easy monitoring of performance
  • Integration to well-known products, such as Excel
  • Stream analytics in real time

Course Content

  • Power BI
  • Analyse Data with Excel
    • Setting up Power BI Data to work with Excel
  • Create Reports in Power BI Desktop Section
    • Matrix Visualization
    • Changing the Method of Aggregation 
    • Cards and Multi Row Cards 
    • Percentage Calculations
    • Filtering Data
  • Visual Filters
  • Page Filters
  • DrillThrough Filter
    • Graphs and Visualizations
  • Clustered Column Graphs
  • Stacked and 100% Graphs 
  • Column Graph Challenge
  • Trend Analysis Graphs 
  • Area Graphs 
  • Ribbon Graphs 
  • Additional Graphs 
  • Scatterplots and Bubbleplots 
  • Interactive Dashboards
  • Creating Interactive Dashboards
  • Pinning Visualizations to Dashboards
  • Mobile Reports
  • Using Custom Visualizations
    • DAX Formulas
    • DAX Measures
    • Creating and Managing Relationships in Power BI 

Princeton Academy Resource https://princetonacademy.in/resources/

Microsoft Power BI is Free Software

To Download Power BI Click Here