Ravindra BagaleCourses & study guides मराठी Track your progress

1. Introduction to Business Intelligence and Power BI

1.6 Who Uses Power BI in a Company?

By Last updated:

Start with a problem

In his interview, Shahrukh said "we did everything" about his last project. The panel asked which part he did, and he could not answer clearly.

Explain simply

Power BI work is split across roles: Data Engineer (prepares data upstream), Data Analyst (cleans, models, builds reports), BI Developer (reusable models, performance, security), Business User (views and filters), Administrator (tenant, capacity, gateways).

Show the data

Task in the sample project Done by
Load orders into SQL Server every night ?
Build the city sales report and Total Sales measure ?
Add RLS so Zoya sees only Kolhapur ?
Open the app every morning and check Kolhapur ₹450 ?
Install the gateway and manage capacity ?

About this data: This table uses columns: Task in the sample project, Done by. This table uses columns: Task, Role. This table uses columns: Role, Tasks in the sample. Values shown are the lesson examples already on this page (not a new dataset).

Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).

Demonstrate

  1. Read each task and ask: is it upstream data, report building, model governance, consumption or platform?

  2. Assign roles.

    Your result should look like this:

    Task Role
    Nightly load Data Engineer
    City report + measure Data Analyst
    RLS BI Developer
    Morning check Business User (Zoya)
    Gateway + capacity Administrator

  3. Write one sentence for your CV: "I built the city sales report and the Total Sales measure on a model with RLS."

Show the result

Your result should look like this (fictional sample):

Role Tasks in the sample
Data Engineer 1
Data Analyst 1
BI Developer 1
Business User 1
Administrator 1

Explain what happened

Splitting tasks by role made it clear who owns what. In small companies one person may hold several roles, but you should still name which part you did.

Explore further

  • Job titles vary; describe the tasks, not only the title.

Detailed reference for this lesson:

Role Main tasks in Power BI
Data Analyst Cleans data, builds models and reports, answers business questions
BI Developer Builds larger, reusable semantic models, handles performance and security
Data Engineer Prepares data upstream (databases, data warehouses, Fabric lakehouses)
Business User / Manager Views reports, filters, exports, subscribes to e-mails
Power BI Administrator Manages tenant settings, capacities, gateways, governance

Ravindra Bagale's Tip

Friends, many students assume one person does everything. In real teams, data engineers, report developers and business users have different roles. In interviews, describe clearly which part you did, rather than saying "we did everything". Keep this in mind!

Fix common mistakes

Wrong result Reason Correction
"We did everything" in an interview Team work described, not your part Name your tasks and results
Analyst blocked waiting for gateway setup Admin role not involved early Involve the admin when the source is on-premises
Business users asked to write DAX Roles mixed up Give them a finished app and training to filter

Practise independently

Practice task

Ravindra cleaned the CSV, wrote Total Sales and published the app; Rani only viewed it. Which roles did each person play?

Hints
  • Count build tasks vs viewing tasks.
Solution

Ravindra: Data Analyst (clean, model, measure) and some BI Developer work (publishing the app). Rani: Business User.

Think like a professional

Prepare one clear story: the problem, your exact part, the number you delivered (for example ₹2,100 total, 11.0 minutes average delivery).

Ravi Sir's Cards for this lesson

Who uses Power BI in a company. A report is useful only if it fits the person reading it. Different people need different things.Revision card

मराठी cards