POWERBI

Power BI Course Index — Beginner to Advanced

Module 1: Power BI Fundamentals

  1. What is Power BI?
  2. Why Power BI is used
  3. Power BI Desktop vs Power BI Service
  4. Power BI architecture
  5. Power BI ecosystem
  6. Power BI installation and setup
  7. Understanding the Power BI interface
  8. Reports, dashboards, datasets/semantic models
  9. Import vs DirectQuery
  10. Connecting to your first data source

Module 2: Data Sources & Data Import

  1. Excel
  2. CSV
  3. Text files
  4. SQL Server
  5. SharePoint
  6. Web data
  7. Folder connections
  8. Multiple files
  9. Connecting to databases
  10. Importing data into Power BI
  11. Managing data sources
  12. Refreshing data

Module 3: Power Query — Data Cleaning

  1. Introduction to Power Query
  2. Power Query Editor
  3. Understanding queries
  4. Removing rows
  5. Removing columns
  6. Changing data types
  7. Rename columns
  8. Replace values
  9. Fill Down / Fill Up
  10. Split columns
  11. Merge columns
  12. Extract text
  13. Trim and Clean
  14. Remove duplicates
  15. Handling null values
  16. Conditional columns
  17. Custom columns
  18. Sorting and filtering
  19. Group By
  20. Merge Queries
  21. Append Queries
  22. Pivot columns
  23. Unpivot columns
  24. Transpose
  25. Date transformations
  26. Working with multiple files
  27. Parameters
  28. Query folding
  29. Power Query best practices

Module 4: Data Modeling

  1. What is data modeling?
  2. Fact tables
  3. Dimension tables
  4. Star schema
  5. Snowflake schema
  6. Primary keys
  7. Foreign keys
  8. Relationships
  9. One-to-one relationships
  10. One-to-many relationships
  11. Many-to-many relationships
  12. Active vs inactive relationships
  13. Cross-filter direction
  14. Date table
  15. Role-playing dimensions
  16. Model optimization
  17. Creating a proper star schema

Module 5: DAX Fundamentals

  1. What is DAX?
  2. Calculated columns vs measures
  3. DAX syntax
  4. Operators
  5. Variables
  6. Basic aggregation functions
    • SUM
    • AVERAGE
    • MIN
    • MAX
    • COUNT
    • DISTINCTCOUNT
  7. IF
  8. SWITCH
  9. AND / OR
  10. DIVIDE
  11. COALESCE
  12. Text functions
  13. Date functions
  14. Logical functions

Module 6: DAX — Filter Context

  1. Row context
  2. Filter context
  3. Context transition
  4. CALCULATE
  5. FILTER
  6. ALL
  7. ALLSELECTED
  8. REMOVEFILTERS
  9. VALUES
  10. SELECTEDVALUE
  11. HASONEVALUE
  12. ISFILTERED
  13. KEEPFILTERS
  14. Understanding evaluation context

Module 7: Time Intelligence

  1. Date tables
  2. Calendar functions
  3. Year
  4. Quarter
  5. Month
  6. Week
  7. YTD
  8. MTD
  9. QTD
  10. Previous year
  11. Previous month
  12. Same period last year
  13. Year-over-year growth
  14. Month-over-month growth
  15. Running total
  16. Rolling average

Module 8: Power BI Visualizations

  1. Bar chart
  2. Column chart
  3. Line chart
  4. Area chart
  5. Pie chart
  6. Donut chart
  7. Scatter chart
  8. Treemap
  9. Waterfall
  10. Funnel
  11. Gauge
  12. Cards
  13. KPI
  14. Tables
  15. Matrix
  16. Maps
  17. Slicers
  18. Buttons
  19. Shapes
  20. Images
  21. Bookmarks
  22. Drill-down
  23. Drill-through
  24. Tooltips
  25. Conditional formatting

Module 9: Dashboard & Report Design

  1. Dashboard vs report
  2. Choosing the right visual
  3. Color selection
  4. Layout
  5. Alignment
  6. Page navigation
  7. KPI cards
  8. Executive dashboards
  9. Interactive reports
  10. Mobile layouts
  11. Accessibility
  12. Report storytelling
  13. UX best practices

Module 10: Advanced DAX

  1. Advanced CALCULATE
  2. FILTER
  3. SUMX
  4. AVERAGEX
  5. COUNTX
  6. RANKX
  7. TOPN
  8. CONCATENATEX
  9. SWITCH
  10. Variables
  11. Virtual tables
  12. ADDCOLUMNS
  13. SUMMARIZE
  14. SUMMARIZECOLUMNS
  15. UNION
  16. INTERSECT
  17. EXCEPT
  18. Dynamic calculations
  19. Dynamic titles
  20. Dynamic KPIs

Module 11: Advanced Power Query / M

  1. Introduction to M language
  2. M syntax
  3. Custom functions
  4. Parameters
  5. Dynamic file loading
  6. Dynamic folder connections
  7. Error handling
  8. Reusable queries
  9. Query folding
  10. Performance optimization

Module 12: Power BI Service

  1. Power BI Service
  2. Workspaces
  3. Publishing reports
  4. Semantic models
  5. Dashboards
  6. Apps
  7. Sharing reports
  8. Permissions
  9. Workspace roles
  10. Scheduled refresh
  11. Data gateways
  12. Subscriptions
  13. Alerts
  14. Deployment pipelines
  15. Collaboration

Module 13: Row-Level Security

  1. What is RLS?
  2. Static RLS
  3. Dynamic RLS
  4. Roles
  5. USERNAME()
  6. USERPRINCIPALNAME()
  7. Security tables
  8. Testing RLS
  9. Publishing RLS
  10. Managing permissions

Module 14: Power BI + SQL

  1. SELECT
  2. WHERE
  3. ORDER BY
  4. GROUP BY
  5. HAVING
  6. JOIN
  7. INNER JOIN
  8. LEFT JOIN
  9. RIGHT JOIN
  10. UNION
  11. CASE
  12. Subqueries
  13. CTE
  14. Window functions
  15. ROW_NUMBER
  16. RANK
  17. LAG
  18. LEAD
  19. SQL aggregations
  20. Basic query optimization

Module 15: Real-World Power BI Projects

Project 1 — Sales Dashboard

Analyze:

  • Revenue
  • Profit
  • Sales quantity
  • Products
  • Customers
  • Regions
  • Monthly trends

Project 2 — HR Dashboard

Analyze:

  • Employee count
  • Attrition
  • Department
  • Gender
  • Salary
  • Age
  • Hiring trends

Project 3 — Finance Dashboard

Analyze:

  • Revenue
  • Expenses
  • Profit
  • Budget vs actual
  • Variance
  • Monthly performance

Project 4 — E-commerce Dashboard

Analyze:

  • Orders
  • Customers
  • Products
  • Revenue
  • Average order value
  • Returns
  • Customer segments

Project 5 — Executive Dashboard

Build a professional management dashboard with:

  • KPIs
  • Trends
  • Targets
  • Variance
  • Drill-through
  • Dynamic filters
  • RLS

HSK Soft Academy Online
Training in Telugu

Phone: +91-9705199915 

WhatsApp: +91-9705199915 

Location: KPHB/Lingampally

Hyderabad, Telangana, India

© 2026–2027 HSK Soft Academy. All rights reserved.