Microsoft Power BI

Different Power BI products

Power BI Desktop
- Free
- Publish to the powerbi.com
- Can share .pbix file so others with the “free” Power BI Desktop can view
- Create Web Embed Code you can post at Public website
  - 2022-09-03 update: All of "Share" features now requires a Power BI Pro license 1
Power BI Pro
- USD 10 / month / user
- Collaborate on shared data
- Audit and govern how data is accessed and used
- Package content and distribute to users with apps
- Publish to powerbi.com and have others view on any device
- From published report viewers can download Data Model into Excel or as a .pbix file.
Power BI Premium
- Contact Sales, USD 5k / month
- Unlock higher limits for Power BI Pro users
- Access interactive and paginated reports online or use Power BI Report Server for on-premises reporting

Power BI, Power Query, Power Pivot, What to use when?

Power Query and Power Pivot complement each other. Use both to shape your data in Excel so you can explore and visualize it in PivotTables, PivotCharts, and Power BI

Power Query is the recommended tool for locating, connecting to and importing data.
Power Pivot: is great for modeling the data you’ve imported

	Power Query	Power Pivot	Desktop & PowerBI.com
Role	Import and shape data	Data modeling and calculations	Complete business intelligence tool
Language	M	DAX	M and DAX
Key strengths	- Nice easy to use interface - Powerful tools to import and clean data - All Excel users can benefit from this tool	- Easily handle millions of rows of data - Modeling tools for efficient data storage and analysis - Powerful DAX calculations going beyond standard Excel	- Incredible visualization options - Simple built-in interactive options - Powerful DAX calculations - Simple publishing to PowerBI.com and mobile devices

A diagram explaining how these Powerful tools are related power-platform

With respect to report usage, typical usage can be seen below.

usage-diagram

Tool	Used by	Purpose
Power BI Service	Report consumers	Consuming all types of reports: interactive, paginated and Excel
Excel Online	Report consumers	Consuming Excel reports from SharePoint, Teams, or the Power BI service
Power BI Desktop	Model builders Interactive report designers	Building Power BI dataset Building interactive reports
Power BI Report Builder	Paginated report designers	Building paginated reports
Excel	Analysts	Building Excel reports Analyzing Power BI datasets

Tutorials:

Add-on for DAX

DAX Formatter is a free tool by SQLBI that transforms raw DAX formulas into clean, beautiful and readable code.
DAX.do is a free online playground to write, run and share DAX queries.
DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing, and query execution breakdowns.
Power BI Sidetools is an external tool intended to increase productivity during reports development in Power BI desktop. It combine sereral tools, such as DAX generator, DAX debugger, DAX parser

Add-on for Dashboard reporting:

Charticulator create custom chart designs for your reports using data modeled in Power BI.
- Free with many templates
Zebra BI offer many report templates both free and paid
- Pricing
- Example template
Other Level’s | Youtube channel, which give inspirations and tutorial on dashboard visuals
- Individual Pricing plan for each template
How to Power BI | Youtube channel, which share tutorial on how to design page navigation, clean menu and custom visual in Power BI
Entreprise DNA | Power BI Showcase, some great dashboard from which I get inspiration
inforiver: besides of visualization, this add-in put Power Bi on steroid with Excel-like features, which are simulation, planning, and writeback capabilities. Beside of their own licenses, Inforiver requires a PBI License if you want to publish and share the reports like any other visual. It is interesting to compare this solution vs Causal
Deneb, another library to create custom visual for Power BI