Welcome to HASH COMPUTERS

"WELCOME TO HASH COMPUTERS"

CERTIFICATE IN POWER BI ( S-POWER BI )

BASIC INFORMATION

  • Course Fees : 2000.00 3000.00/-
  • Course Duration : 1 MONTH
  • Minimum Amount To Pay : Rs.2000.00

Introduction to Power BI and Excel

Before diving into Power BI, it's important to have a fundamental understanding of Excel, as Power BI integrates well with it.

Excel Overview (1 Day)

  • Basics of Excel (Cells, Rows, Columns)
  • Data Formatting and Conditional Formatting
  • Formulas & Functions (SUM, VLOOKUP, IF, etc.)
  • Data Validation & Pivot Tables
  • Charts and Graphs

Power BI Introduction (1 Day)

  • What is Power BI?
  • Importance of Data Visualization
  • Power BI Components (Power Query, Power Pivot, Power View)
  • Understanding the Power BI Desktop Interface
  • Connecting Power BI with Excel

Power BI Course Syllabus (1 Month)

Week Topics Details
Week 1 Getting Started with Power BI - Introduction to Power BI Service & Desktop
- Installation & Setup
- Understanding Data Sources in Power BI
- Importing and Transforming Data (Power Query)
- Data Cleaning & Shaping (Removing Duplicates, Handling Missing Data)
Week 2 Data Modeling & DAX (Data Analysis Expressions) - Understanding Data Modeling Concepts
- Relationships between Tables (Star & Snowflake Schema)
- Introduction to DAX
- Basic DAX Functions (SUM, COUNT, AVERAGE, IF, SWITCH)
- Calculated Columns & Measures
- Time Intelligence Functions
Week 3 Data Visualization & Reporting - Creating Basic Visuals (Bar, Line, Pie Charts)
- Advanced Visuals (Maps, Gauges, Treemaps)
- Filters & Slicers
- Customizing Visuals (Formatting, Themes, Tooltips)
- Creating & Managing Reports
- Interactive Dashboards
Week 4 Advanced Power BI & Deployment - Power BI Service & Publishing Reports
- Power BI Mobile View
- Row-Level Security (RLS)
- Performance Optimization Techniques
- Power BI Integration with Other Tools (Excel, SQL, SharePoint)
- Best Practices & Final Project Presentation

Final Assessment & Certification (Last 2 Days)

  • Project Work: Build a Power BI Dashboard using a real-world dataset.
  • Q&A Session & Doubt Clearing
  • Course Completion & Certification

ELIGIBILITY - 10TH