Getting Started with Power BI
- Read (20 minutes) – Getting Started with Power BI – https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started
- Tutorial (30 minutes) – Short Intro lesson by Microsoft – https://docs.microsoft.com/en-us/learn/modules/introduction-power-bi/
- Tutorial (30 minutes) – From Excel workbook to stunning report in Power BI Desktop – https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report
- Video (8 minutes) – What is Power BI? – https://www.youtube.com/watch?v=Vqz2d7pTOV8
- Video (30 minutes) – How to use Microsoft Power BI – https://www.youtube.com/watch?v=TmhQCQr_DCA
- (Resources) – Microsoft Learn Power BI – https://docs.microsoft.com/en-us/learn/browse/?expanded=power-platform&products=power-bi
- (Resources) – Power BI Premium Per User – Power BI – https://docs.microsoft.com/en-us/power-bi/admin/service-premium-per-user-faq
- (Resources) –Pricing & Product Comparison – https://powerbi.microsoft.com/en-us/pricing/
Get Data
- Video (11 minutes) Power BI Get Data: Import vs. DirectQuery vs. Live – https://www.youtube.com/watch?v=y4S-k34qmnw&t=253s
- Tutorial (1 hr 30 min) Get Data in Power BI – https://docs.microsoft.com/en-us/learn/modules/get-data
- Reference – DirectQuery, Live Connection or Import Data? Tough Decision! – RADACAD – https://radacad.com/directquery-live-connection-or-import-data-tough-decision
Shape and Transform Data
- Read (15 minutes) Data Profiling in Power BI – Column quality & Distribution – PBI Visuals – https://pbivisuals.com/2021/02/15/data-profiling-in-power-bi/#:~:text=Power%20BI%20The%20data%20profiling%20tools%20provides%20you,are%20the%20main%20parts%20of%20data%20profiling%20process.
- Read (15 minutes) Shape and Combine data – https://docs.microsoft.com/en-us/power-query/power-query- tutorial-shape-combine
- Tutorial (2 hrs) – Clean, Transform, and load data in Power BI – https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/
Model Data
- Tutorial (30 minutes) Build Your First Star Schema Model in Action – https://radacad.com/build-your-first-star- schema-model-in-action-power-bi-modeling-basics
- Tutorial (20 minutes) Power BI Aggregation: Step 1 Create the Aggregated Table – RADACAD – https://radacad.com/power-bi-aggregation-step-1-create-the-aggregated-table
- Tutorial (130 minutes) – Design a data model in Power BI – https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/
Ask / Answer Questions (DAX)
- Tutorial (2 hrs 20 min) – Introduction to creating measures using DAX in Power BI – https://docs.microsoft.com/en-us/learn/modules/create-measures-dax-power-bi/
- Read (5 minutes) – Power BI: The difference between DAX and Excel formulas | Xylos Learning Blog – Power BI: The difference between DAX and Excel formulas | Xylos Learning Blog
- (Resource) Data Analysis Expressions (DAX) Reference – Data Analysis Expressions (DAX) Reference – DAX | Microsoft Docs
- (Resource) DAX Guide – DAX Guide
- (Resource) – DAX Video Course – DAX Tools Video Course – SQLBI
- (Resource) – DAX Patterns – https://www.daxpatterns.com/
Visualize your Data / Build Reports
- Tutorial (1 hr 20 min) – Work with Power BI visuals – https://docs.microsoft.com/en-us/learn/modules/visuals-power-bi/
- Tutorial (1 hr 45 min) – Create a data-drive story with Power BI – https://docs.microsoft.com/en-us/learn/modules/data-driven-story-power-bi/
- (Tutorial (2 hrs) – Perform analytics in Power BI – https://docs.microsoft.com/en-us/learn/paths/perform-analytics-power-bi/
- Samples – Power BI Samples (download and open *.pbix files with Power BI) – https://docs.microsoft.com/en-us/power-bi/create-reports/sample-datasets?WT.mc_id=sitertzn_learntab_samples-card-powerbi
Share the Reports / Dashboards / Apps
- Tutorial (1 hr 10min) – Create dashboards in Power BI – Create and manage workspaces in Power BI – Learn | Microsoft Docs
- Tutorial (30 min) – Create and manage Workspaces in Power BI – https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/
- Video (15 min) – Get started with the Power BI Gateway – Get started with the Power BI Gateway – YouTube
- Video (10 minutes) – Sharing and Collaboration in Power BI – Sharing and Collaboration in Power BI – YouTube
Best Practices
- (Resource) – Best Practices Analyzer – https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/
- Tutorial (11 min) – Best Practices Analyzer – https://www.youtube.com/watch?v=1Qan0_VmZRw