Power BI and Analytics Training

Jul 7, 2024

Power BI and Analytics Training

Introduction

  • Trainer: Corporate trainer and owner of an analytical firm in Karnataka
  • Trained companies: Deloitte India, Axis Bank, Poly, among others
  • Specializes in Power BI and Analytical Dashboarding
  • Relationship with 360 Digit MG: ~1 year

About the Program

  • 30 hours of training: From beginner to advanced
  • No prior knowledge of Power BI required
  • Program includes:
    • Introduction to Power BI
    • Installation
    • Connecting to the database (SQL)
    • Data preparation
    • Advanced DAX calculations
    • Visualization
    • Publishing dashboard
    • Row-level security and gateway refresh
  • Key topics: Analytics from the ground up, dashboard building, publishing, and management

Structure of the Program

  • Theoretical foundation session
  • Topics covered:
    • Power BI licenses
    • Architecture
    • Types of dashboards in Power BI
    • Dashboard lifecycle
  • Goals
    • Understand various business intelligence (BI) tools
    • Emphasis on Power BI

Agenda for the Session

  1. Understanding Business Intelligence (BI)
    • Definition and importance
    • Power BI introduction
    • BI terminology
    • Core BI concepts: Strategic, operational, and technical dashboards
  2. Introduction to Power BI components
  3. Connecting Power BI to different data sources
  4. Installation verification

Key Topics

Business Intelligence (BI)

  • Provides insights like a car's dashboard for organizational operations
  • Necessary for understanding sales trends, campaign management, client acquisition metrics, etc.
  • BI lifecycle: Question → Data → Data preparation → Report/Dashboard → Insight

Understanding Business Problems for BI

  • Importance of identifying business problems/questions
  • Examples: Investment decisions, manpower forecasting, talent management dashboards

Data and Data Preparation

  • Essential to gather relevant data for accurate BI
  • Data might be unstructured or from multiple sources
  • Data needs preparation for accurate analysis

Types of Analytics

  1. Descriptive Analytics: Define data (mean, median, mode, etc.)
  2. Diagnostic Analytics: Identify influencing factors (e.g., why sales are high in certain regions)
  3. Predictive Analytics: Forecast future trends (e.g., future sales)
  4. Prescriptive Analytics: Provide actionable recommendations (e.g., how to manage supply chain for forecasted sales)

Types of Dashboards

  1. **Strategic Dashboards: **
    • Used by high-level management (CEOs, managers, etc.)
    • Overview of organizational performance
    • Includes KPIs, profit margins, etc.
  2. **Operational Dashboards: **
    • Used by mid-level managers
    • Detailed insights into specific operations (e.g., digital marketing campaigns)
  3. **Analytical Dashboards: **
    • Detailed, granular insights
    • Visualizations and complex analysis (sales funnels, etc.)
  4. **Technical Dashboards: **
    • Used by blue-collar employees
    • Monitoring performance and KPIs

Power BI Components

  1. **Power BI Desktop: **
    • For building dashboards
  2. Power BI Service:
    • For publishing and sharing dashboards
  3. Power BI Mobile Apps:
    • Access dashboards on mobile devices
  4. Power BI Gateway:
    • For data refresh and secure data flow

Power BI Licenses and Features

  1. Power BI Pro ($10/month/user)
    • Eight data refreshes per day
    • Sharing and collaboration
    • Mobile access
  2. Power BI Premium ($20/month/user)
    • 48 data refreshes per day
    • Advanced AI features
    • Larger model size
  3. Power BI Premium Per Capacity ($4995/month)
    • Multi-geo deployment
    • Auto-scaling and capacity management
    • No per-user license

Installation

  1. Visit Power BI download page
  2. Choose 'Power BI Desktop' and install
  3. Verify installation by checking the Power BI version
  4. Download updates if available
  • Versions are updated monthly with new features and bug fixes

Questions and Interaction Encouragement

  • Trainer requests interactivity
  • Plans for breaks (10 minutes around 3:30 PM)
  • Questions can be asked anytime during the training

Conclusion

  • Interactive sessions planned for the next classes
  • Recap and Q&A sessions to clarify previous doubts