Advanced Power BI

Get Started. It's Free
or sign up with your email address
Advanced Power BI by Mind Map: Advanced Power BI

1. Metrics Scenarios

1.1. Context Setting for Metrics Scenarios

1.1.1. Tibco: What is Data Science

1.1.2. Energy Central: Analytics Curve

1.1.3. Weekdone: OKRs

1.1.4. Microsoft: DAX Reference

1.1.5. Microsoft: Use DAX in Power BI Desktop

1.1.6. Tutorials Point: DAX

1.2. Exploring the DAX Toolkit

1.2.1. ...cheatsheets... Microsoft: DAX Function Reference Microsoft: Measures in Power BI DAX Guide Addend: DAX Functions Cheat Sheet Microsoft: DAX Cheatsheet

1.2.2. ...deeper dives... Radacad: Using Iterators in DAX Radacad: Scenarios of Using Calculated Tables in Power BI Microsoft: Create Calculated Tables in Power BI Desktop DAX Operators Deckler: For and While Loops in DAX EnterpriseDNA: Virtual Tables Inside Iterating Functions In Power BI Microsoft: Model Relationships in Power BI Desktop LoBa: Power BI XIRR or IRR LoBa: Power BI XNPV or NPV DAX Patterns: Time Functions

1.3. DAX for Isolation and Manipulation

1.3.1. Step 0 - Design EnterpriseDNA: Power BI Data Model For Advanced Scenario Analysis Using DAX

1.3.2. Step 1 - Query Microsoft: Import Mode

1.3.3. Step 2 - Wrangle Microsoft: Enter Data Directly

1.3.4. Step 3 - Model Microsoft: Create and Manage Relationships in Power BI Desktop Microsoft: Model Relationships in Power BI Desktop

1.3.5. Step 4 - Measures Create Measures Microsoft: Measures in Power BI Develop Measures Microsoft: DAX Variables LearnDAX: Variables

1.3.6. Step 5 - Visualise SQL BI: Power BI Visualisations Reference

1.3.7. Step 6 - Publish Publishing in Power BI Microsoft: Power BI Dashboards Microsoft: Publish from Power BI Desktop Microsoft: Apps in Power BI Microsoft: Share in Power BI Radacad: Power BI Sharing Comparison Publish Reports and Dashboards Microsoft: Collaborating on Assets Microsoft: Sharing Assets

1.3.8. Step 7 - Manage Managing Power BI Products Pilcher: What is Product Management? Medium: Venture Design Framework SAP: Product Lifecycle Management Managing Roles and Datasets Microsoft: Row Level Security Microsoft: Power BI Datasets

1.4. Designing DAX Formulas

1.4.1. Noteworthy: How to Write Pseudocode: A Beginner’s Guide

1.4.2. Viking Code School: The Elements of Pseudocode

1.4.3. TechGeekBuzz: How to Write Pseudocode?

1.4.4. Pseudocode 101

1.5. Using DAX Patterns - Scenarios

1.5.1. Mathematical Algorithms T-Test Equation ...key... p Value

1.5.2. Dynamic Context Microsoft: Moving Average

1.5.3. Conditional Summary Microsoft: New and Returning Customers

1.6. Using Patterns Created by the Community

1.6.1. Microsoft: Days of Supply

1.6.2. ...other... Microsoft: HR Analytics DAX Patterns

2. Machine Learning Scenarios

2.1. Text Analytics

2.1.1. Context Setting for Text Analytics Sentiment Analysis: A Definitive Guide What is Sentiment Analysis and How Does it Work? Wikipedia on Topic Models Topic Modeling: An Introduction Topic Discovery and Clustering Lexalytics on NLP Tibco on Text Mining Data Science Central on NLP Tibco on Text Analytics Use Cases Customer Care Microsoft Using Sentiment Analysis to Predict Product Reviews Trading Signals Document and Contract Review MonkeyLearn - Chewy Trustpilot Reviews VADER Sentiment Analysis in Algorithmic Trading Text Analytics: 5 Examples To Open Your Eyes To Your Own Opportunities

2.1.2. Sentiment Analysis Scenarios Power BI and Python Python in Power Query Editor Installing new packages for WinPython VADER Scoring Methodology Sentiment Analysis in Power BI Simplifying Sentiment Analysis using VADER in Python (on Social Media Text) VADER Sentiment Analysis in Algorithmic Trading Sentiment Analysis In Power BI

2.1.3. Topic Modelling Scenarios Introduction to Topic Modelling Introduction to KNIME Modern Analytics Architecture with Azure Databricks KNIME Data Science Presents Tech Hurdles The Emerging Big Data Architectural Pattern Requirements and Limitations of Python Packages Text Analytics in Microsoft Azure and Power BI Choosing a natural language processing technology in Azure Using the new KNIME Deep Learning - Keras Integration to Predict Cancer Type from Histopathology Slide Images KNIME and Power BI Tasks KNIME Interface KNIME Example Workflows KNIME Power BI Integration User Guide Topic Modeling — LDA Mallet Implementation in Python — Part 1 Topic Modeling in Python: Latent Dirichlet Allocation (LDA) Intuitive Guide to Latent Dirichlet Allocation Stanford Tagger: Tag Interpretation IS Literature Mining with Topic Detection (LDA) Topic Modeling and Sentiment Analysis on Amazon Alexa Reviews Topic Modeling and Latent Dirichlet Allocation (LDA) in Python Topic Modeling in Power BI using PyCaret

2.2. Predictive Analytics

2.2.1. Context Setting for Predictive Analytics Towards Data Science: Machine Learning Overview What is the difference between a causal model and a time series model? Algorithms of Machine Learning Oracle: Types of Machine Learning and Top 10 Algorithms Everyone Should Know Explainable AI: The data scientists’ new challenge Deloitte: Predictive Maintenance SMU: Default Prediction Predicting Employee Attrition with Machine Learning What is Data Science? Supervised Machine Learning A Quick Guide to How Machines Learn What is Supervised Learning? Uber Michaelangelo Dealing with Interaction Effects in Regression Interaction Effect in Multiple Regression Bias-Variance Tradeoff The Case of Overfitting A Brief Overview of AutoML Avoiding Overfitting - when we used all of our data to "train" the model, making too focussed on that data alone! Supervised Learning Workflow Supervised Learning Family Machine Learning Model Selection ML Model Performance Metrics IBM Random Forest Entropy and Information Gain Random Forest Overview R-Squared > 0.75

2.2.2. Supervised Learning Tasks Absent Data: Python Machine Learning in Power BI Reading and Writing to Databases Using the Power BI Integration Nodes XXLBI: Regression in DAX Using the KNIME Scheduler Predicting Employee Attrition with Machine Learning Regression in KNIME Analytics Vidhya: Building your First Machine Learning Model using KNIME

2.2.3. Machine Learning Questions

3. Course Materials

3.1. Map Link

3.1.1. Course Page

3.1.2. Copy the Map

3.2. Datasets Link

3.3. Tools

3.3.1. Download Power BI Desktop

3.3.2. Create a Power BI Online Account

3.3.3. Download WinPython

3.3.4. Download KNIME

4. Insight Driven Organisations

4.1. Thoughts on Insight Driven Organisations

4.1.1. Microsoft: Big Data Architecture

4.1.2. McKinsey: Analytics Translators

4.1.3. Deloitte: Analytics and AI-driven Enterprises

4.1.4. HBR: The Strategic Choice Cascade

4.1.5. Pichler: Product Management Framework

4.2. McKinsey: Red Flags and Pitfalls

4.3. Scaling Machine Learning at Uber

4.3.1. Strategy

4.3.2. Teams

4.3.3. Process

4.3.4. Science

5. Visualisation Scenarios

5.1. Context Setting for Visualisation Scenarios

5.1.1. UX Planet: 10 Rules for Better Dashboard Design

5.1.2. SQL BI: Power BI Visualisations Reference

5.1.3. Interaction Design: Guidelines for Good Visual Information Representations

5.1.4. National Geographic: The Underappreciated Man Behind the “Best Graphic Ever Produced”

5.1.5. Information is Beautiful: What Makes a Good Visualisation?

5.1.6. M Bounthavong: Communicating Data Effectively with Data Visualizations

5.1.7. Alberto Cairo: tell stories, enable the user to take their own path

5.1.8. Klancar: Beginner's Guide To Information Architecture

5.1.9. Datapine: Make Sure You Know The Difference Between Strategic, Analytical, Operational And Tactical Dashboards

5.1.10. Logi Analytics: Dashboard Design Fundamentals

5.1.11. Juice Analytics: A Guide to Creating Dashboards People Love to Use

5.1.12. Few: Why Do Most Dashboards Fail?

5.2. A Dashboard Scenario

5.2.1. Radacad: Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table Pattern

5.2.2. Four Moo: Using Slicers to Change Measures

5.2.3. Microsoft: Swap Axis by Slicer

5.3. Visualisation for Data Science

5.3.1. A Distribution Scenario Journal of Accountancy: Using Benford’s Law to Detect Fraud Wikimedia: Benford Test

5.3.2. A Time Series Scenario Tripathi: CORR Illustration Deckler: Correlation, Seasonality and Forecasting Machine Learning Mastery: How to Decompose Time Series Data into Trend and Seasonality

5.3.3. A Modelling Scenario NHS Excel: Types of Linear Relationship Data to Viz: Scatter Plots Quarknet: How to Linearise a Curved Data Plot XXLBI: Simple Linear Regression in DAX Gapminder World Poster

5.3.4. A Significance Scenario Biology for Life: T-Test p Value Apptimize: KAYAK’S Most Interesting A/B Test

5.3.5. A Forecasting Scenario Towards Data Science: Forecasting in Power BI How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques Creating Forward Forecasts in Power BI Using DAX ESRI: Time Series Forecasting 101 Towards Data Science: The Complete Guide to Time Series Analysis and Forecasting Machine Learning Mastery: What Is Time Series Forecasting?

5.4. Python Visualisation in Power BI

5.4.1. Python Visuals in Power BI Microsoft: Create Visuals Using Python ...libraries... Matplotlib Library Matplotlib Cheat Sheets Seaborn Library Seaborn Cheatsheet

5.4.2. Python Preparation Tasks MoonPoint: Installing new packages for WinPython Microsoft: Power BI and Python Microsoft: Create Power BI Visuals by Using Python Absent Data: Using Python Visuals in Power BI

5.4.3. Python Visualisation Tasks Seaborn: Pair Plot Seaborn: Grouped Boxplots Seaborn: Plotting with Categorical Data Seaborn: Box Plot Matplotlib: Scatter Matplotlib: Sample Plots Python Projects: Matplotlib Scatter sources... US Covid Datasets Gapminder

6. Wrangling Scenarios

6.1. Context Setting for Wrangling Scenarios

6.1.1. W3: Data Normalisation

6.1.2. Microsoft: Big Data Architectural Patterns

6.1.3. Microsoft: Connecting to Data with Power BI Online

6.1.4. Trifacta: What is Data Wrangling?

6.1.5. Microsoft: Data Refresh in Power BI

6.1.6. Radacad: Modelling Best Practice

6.1.7. Medium: 10 Best Database Design Practices

6.1.8. Talend: Data Model Design and Best Practices

6.1.9. Microsoft: Star Schema Design

6.1.10. Microsoft: Understand Star Schema and the Importance for Power BI

6.1.11. IBM: Setting Keys

6.1.12. Xplenty: 6 Database Schema Designs and How to Use Them

6.1.13. Microsoft: Wrangling Guide

6.1.14. Talend: What is Data Preparation?

6.2. Querying Online Sources

6.2.1. Exchange Rates API

6.2.2. Microsoft: Dealing with Records and Tables in Queries

6.2.3. WHO Health Indicators Database

6.2.4. WHO ODATA Service

6.3. Data Preparation Scenarios

6.3.1. Microsoft: Managing Data Streams with Date Filters

6.3.2. Microsoft: Power Query Editor

6.3.3. Radcad: Basics of M Query

6.3.4. Microsoft: Power Query M Guide

6.3.5. Radacad: M Query or DAX?

6.4. Flat Model Tasks

6.4.1. Microsoft: Folder Connector

6.4.2. Microsoft: Merge and Append

6.4.3. Radacad: Merge and Append in Power BI