MIS, Dashboard & Reports
Course Content
Pivot Tables & Power Pivot - Advanced Pivot Techniques and Dashboards
- Pivot Tables for Reporting & Summarization: Different reports & layouts, Automating & updating pivots on data modification
- Data Modelling: Creating relationships between different data tables.
- Creating Calculated Columns and Measures: Using DAX (Data Analysis Expressions).
- PivotTables with Power Pivot: Creating advanced PivotTables using the Power Pivot model.
- Data visualization: Advanced charting techniques, Slicers, Sparklines and Timelines
- Use Case Example: Building a dynamic dashboard.
Advanced Data Sourcing, Cleaning & Automation using Power Query
- Data Import: Importing data from various sources (Excel, CSV, Folders, PDF, databases, web).
- Data Transformation: Cleaning, reshaping, and preparing data with Power Query.
- Merging and Appending Data: Combining & Consolidation data from different sources.
- Use Case Example: Automating data preparation for monthly reports.
Data Analysis - Advanced Analysis & Forecasting techniques
Advanced Visualization and Dashboarding beyond Excel using POWER BI
- Introduction to the visual elements available in Power BI.
- Understanding the role of advanced visualizations in conveying complex insights.
- Custom Visualizations:
- Introduction to custom visuals marketplace in Power BI.
- Installing and using custom visuals.
- Examples of scenarios where custom visuals are more suitable than standard visuals
- Advanced Formatting Options
- Customizing colors, fonts, and backgrounds for visualizations.
- Utilizing themes to maintain consistent formatting across reports.
- Applying conditional formatting based on data values.
- Comparing formatting capabilities with Excel and showcasing the additional flexibility in Power BI.
- Drill-through and Drill-down Techniques
- Hierarchies and Grouping
Timings: 10:00 am – 5:00 pm, Registration begins at 9:30 am