MIS Reports and Data Analysis Training Using Microsoft Power BI

MIS Reports and Data Analysis Training Using Microsoft Power BI

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 acce ss to your data.
• Data search and exploration.
• Insight into data from all types of devices.
• Live, real time, analytics and dashboard monitoring.
• A consolidated clear overview & Informed business decision making.
• Integration to well-known products including Excel.

Course Outline:

• 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.
• Drill Through 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.