Live Developer Training: next batch coming soon. Be the first to know.Live training: next batch soonJoin the waitlist →Join →
Tutorial hub · free, step by step

Power BI tutorials

Step-by-step Power BI tutorials from real reports: data modelling, DAX, Power Query, visuals, conditional formatting, security and sharing.

163 tutorials5 topicsBy a 13-times Microsoft MVP
Learning path

New to Power BI? Follow these steps

Already working with Power BI? Skip ahead to the topic you need.

  1. Build your first report

    Licences, Power BI Desktop and a first report.

  2. Clean your data

    Shape and combine data in Power Query.

  3. Write DAX

    Measures, filters and date calculations.

  4. Design, secure and share

    Visuals, formatting, security and sharing.

Topic 01

Fundamentals, data modelling and integration

Licences, Power BI Desktop, relationships, calculated columns and measures, and connecting to data.

24 tutorials
Topic 02

DAX measures, filters and calculations

FILTER, CALCULATE, dates, counts, sums and conditional logic in DAX.

59 tutorials
Show all 59 tutorials
Topic 03

Power Query transformations and data shaping

Clean, reshape and combine data in the Power Query Editor before it reaches your model.

32 tutorials
Show all 32 tutorials
Topic 04

Visualizations, slicers and conditional formatting

Charts, tables, slicers, bookmarks, sorting and conditional formatting.

35 tutorials
Show all 35 tutorials
Topic 05

Security, sharing, export and real-world scenarios

Row-level security, sharing, exporting and complete report scenarios.

14 tutorials

Want a structured path?

Turn raw data into interactive reports and dashboards with Power BI Desktop, Power Query, DAX and the Power BI service. Or see the Power BI career roadmap with the skills, certification and pay for the role.

Bijay Kumar, 13-times Microsoft MVP
Who writes these tutorials

Bijay Kumar

13-times Microsoft MVP · Founder, TSinfo Technologies

Bijay has more than 18 years of hands-on experience with Microsoft technologies, specializing in SharePoint, the Power Platform, SPFx and Microsoft 365. He has trained thousands of developers and IT professionals through SPGuides, wrote “SharePoint Online Modern Experience Practical Guide”, co-wrote “Microsoft Power Platform: A Deep Dive”, and runs the SPGuides YouTube channel. Every lesson comes from real client projects.

FAQ

Frequently asked questions

What is Power BI used for?

Power BI turns data from Excel, SharePoint, SQL databases and hundreds of other sources into interactive reports and dashboards that people can explore and share.

Which licence do I need?

You can build reports for free in Power BI Desktop. Sharing them with others in the Power BI service needs a Pro or Premium Per User licence, or a Premium or Fabric capacity. Our Free vs Pro vs Premium tutorial explains the differences.

What's the difference between a calculated column and a measure?

A calculated column is computed row by row and stored in the model. A measure is calculated when it's used in a visual, so it responds to filters and slicers. Most aggregations belong in measures.

Should I learn Power Query or DAX first?

Power Query first. Clean, well-shaped data makes DAX much simpler, and many problems people try to solve with DAX are easier to fix in Power Query.

Is there a Power BI certification?

Yes. PL-300 (Power BI Data Analyst Associate) is the current Power BI certification.