Nitya Patel
Nitya Patel
Online classes

Nitya Patel

Qualification: B.Sc.

Class mode: Online

Rating: 0.0· (0 reviews)

Location: Nagpur, Maharashtra

1 years Teaching experience
English, Hindi Languages
Weekdays/Weekend Availability

About Nitya

Nitya Patel holds a Bachelor of Science degree and has one year of teaching experience. She is passionate about helping students learn and grow in their academic journeys. Nitya believes that every student has unique learning needs and adapts her teaching methods to suit each individual.

She offers tutoring in both English and Hindi, making her sessions accessible to a wider range of students. Nitya aims to create a supportive and engaging learning environment where students feel comfortable asking questions and exploring new concepts. Her goal is to foster a love for learning that extends beyond the classroom.

Courses by Nitya

Course Title

Power BI: From Basics to Interactive Dashboards

Course Level

Beginner to Advanced

Course Duration

20–25 Hours (Recorded / Live)

Prerequisites

  • Basic computer knowledge

  • Familiarity with Excel is helpful but not mandatory

  • No coding experience required

🧱 MODULE 1: INTRODUCTION TO BUSINESS INTELLIGENCE

  • What is Business Intelligence (BI)?

  • Why BI is important in today’s data-driven world

  • Introduction to Power BI

  • Power BI vs Excel vs other BI tools

  • Real-world use cases (Sales, Finance, HR, Education)

🧱 MODULE 2: POWER BI ECOSYSTEM & SETUP

  • Power BI Desktop overview

  • Power BI Service overview

  • Power BI Mobile apps

  • Power BI licensing (Free vs Pro)

  • Installing Power BI Desktop

  • Understanding Power BI interface:

    • Report View

    • Data View

    • Model View

🧱 MODULE 3: DATA IMPORT & CONNECTIONS

  • Understanding data sources

  • Importing data from:

    • Excel

    • CSV

    • Text files

  • Introduction to database connections

  • Load vs Transform data

  • Navigator window explained

🧱 MODULE 4: DATA CLEANING & TRANSFORMATION (POWER QUERY)

  • Introduction to Power Query Editor

  • Cleaning data:

    • Removing nulls

    • Removing duplicates

    • Changing data types

  • Filtering and sorting data

  • Splitting and merging columns

  • Rename and replace values

  • Append vs Merge queries

  • Creating conditional columns

  • Best practices for clean data

🧱 MODULE 5: DATA MODELING CONCEPTS

  • What is data modeling?

  • Fact tables vs Dimension tables

  • Creating relationships between tables

  • One-to-many and many-to-many relationships

  • Cardinality and cross-filter direction

  • Active vs inactive relationships

  • Optimizing the data model

🧱 MODULE 6: DATA VISUALIZATION FUNDAMENTALS

  • Understanding the Visualizations pane

  • Using Fields and Filters

  • Creating basic visuals:

    • Bar charts

    • Column charts

    • Line charts

    • Pie and donut charts

  • Table and Matrix visuals

  • Formatting visuals (colors, labels, titles)

  • Sorting and highlighting data

🧱 MODULE 7: ADVANCED VISUALS & DASHBOARD DESIGN

  • KPI cards and gauges

  • Maps and filled maps

  • Treemaps and funnel charts

  • Using slicers for interactivity

  • Page-level, report-level, and visual-level filters

  • Drill-down and drill-through

  • Tooltips and bookmarks

  • Dashboard layout and design best practices

🧱 MODULE 8: DAX FUNDAMENTALS

  • What is DAX?

  • Calculated columns vs Measures

  • Basic DAX functions:

    • SUM

    • AVERAGE

    • COUNT

    • DISTINCTCOUNT

  • Using IF and SWITCH functions

  • Introduction to CALCULATE

🧱 MODULE 9: INTERMEDIATE & ADVANCED DAX

  • Understanding Row Context and Filter Context

  • Using FILTER function

  • ALL and ALLEXCEPT functions

  • Variables (VAR) in DAX

  • Time intelligence concepts

  • Creating:

    • YTD

    • MTD

    • QTD

  • Performance tips for DAX

🧱 MODULE 10: INTERACTIVITY & USER EXPERIENCE

  • Using slicers effectively

  • Sync slicers across pages

  • Creating interactive navigation using buttons

  • Page navigation and reset filters

  • Enhancing report usability

🧱 MODULE 11: POWER BI SERVICE & SHARING

  • Publishing reports to Power BI Service

  • Understanding workspaces

  • Sharing dashboards and reports

  • Exporting reports

  • Introduction to scheduled refresh

  • Overview of data gateways

🧱 MODULE 12: REAL-WORLD PROJECTS

Project 1: Sales Dashboard

  • Revenue analysis

  • Product performance

  • Region-wise insights

Project 2: HR Analytics Dashboard

  • Employee attrition

  • Department analysis

  • Gender diversity insights

Project 3: Student / Education Dashboard

  • Attendance tracking

  • Performance analysis

  • Insight-based reporting

🧱 MODULE 13: CAREER & PRACTICAL GUIDANCE

  • Power BI roles and career paths

  • How to build a Power BI portfolio

  • Resume tips for Power BI beginners

  • Common interview questions

  • Freelancing overview and dashboard pricing basics

🎁 BONUS CONTENT

  • Practice datasets

  • Dashboard design checklist

  • Beginner-friendly DAX reference

  • Interview preparation questions

🎯 LEARNING OUTCOMES

By the end of this course, students will be able to:

  • Analyze and clean data using Power BI

  • Build professional dashboards

  • Write basic to intermediate DAX formulas

  • Create interactive and shareable reports

  • Apply Power BI skills to real-world problems

💰 COURSE VALUE JUSTIFICATION (₹1000)

  • Beginner → Advanced coverage

  • Hands-on projects

  • Industry-relevant skills

  • Portfolio-ready dashboards

  • Career guidance

Nagpur, Maharashtra
Online
1 hour
English, Hindi
1000 INR
Weekdays/Weekend

What students say

0.0
0 reviews

No reviews yet.

Ready to start learning Power Bi Dashboard? Contact Nitya.

Nitya Patel
Nitya Patel

0.0(0 reviews)

1000 INR/class

Start Your Teaching Journey Today

Join thousands of tutors who are sharing their knowledge and helping students succeed.

Start getting Students

Explore Tutors by Location and Skills

Find Expert tutors across India for Popular Subjects, Skills and Cities

Popular courses

    Popular Locations

      Popular Searches