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. Advanced Dashboard Scenario

1.1. Step #0: Design

1.1.1. Design Concepts Dashboard Metrics OKR Examples: OKR Format Klancar: An Excellent Beginner's Guide To Information Architecture OKR Examples: Metric Choices Tibco: What is Data Science Dashboard Types Datapine: Make Sure You Know The Difference Between Strategic, Analytical, Operational And Tactical Dashboards Dashboard Guides Logi Analytics: Dashboard Design Fundamentals UX Planet: 10 Rules for Better Dashboard Design Information is Beautiful: What Makes a Good Visualisation? Juice Analytics: A Guide to Creating Dashboards People Love to Use Few: Why Do Most Dashboards Fail?

1.1.2. Design Questions Agile Analytics - HR

1.1.3. Design Tasks EnterpriseDNA: Power BI Data Model For Advanced Scenario Analysis Using DAX

1.2. Step #1: Query

1.2.1. Query Concepts Microsoft: Data Refresh in Power BI Microsoft: Managing Datasets Microsoft: Big Data Architectural Patterns Microsoft: Excel and Power BI

1.2.2. Query Tasks Microsoft: Import Mode

1.2.3. Query Questions Microsoft: Connecting to Data with Power BI Online

1.2.4. Additional Query Tasks Exchange Rates API Microsoft: Dealing with Records and Tables in Queries WHO Health Indicators Database WHO ODATA Service Microsoft: Folder Connector

1.3. Step #2: Wrangle

1.3.1. Wrangle Concepts W3: Data Normalisation Trifacta: What is Data Wrangling? Talend: What is Data Preparation?

1.3.2. Wrangle Tasks Microsoft: Power Query Editor

1.3.3. Additional Wrangle Tasks Microsoft: Wrangling Guide GII: Global Innovation Index Microsoft: M Query Operators Radcad: Basics of M Query Microsoft: Power Query M Guide Radacad: M Query or DAX?

1.3.4. Wrangle Questions Microsoft: Managing Data Streams with Date Filters

1.4. Step #3: Model

1.4.1. Model Concepts Radacad: Best Practice Medium: 10 Best Database Design Practices Talend: Data Model Design and Best Practices Microsoft: Star Schema Design Microsoft: Understand Star Schema and the Importance for Power BI IBM: Setting Keys Xplenty: 6 Database Schema Designs and How to Use Them

1.4.2. Model Tasks Microsoft: Create and Manage Relationships in Power BI Desktop Microsoft: Model Relationships in Power BI Desktop

1.4.3. Additional Model Tasks Microsoft: Merge and Append Radacad: Merge and Append in Power BI

1.4.4. Model Questions

1.4.5. More Model Questions

1.5. Step #4: Measures

1.5.1. Measures Concepts Microsoft: Measures in Power BI Microsoft: DAX Cheatsheet

1.5.2. Metrics Tasks

1.5.3. Additional Measures Tasks

1.6. Step #5: Visualise

1.6.1. Visualise Concepts SQL BI: Power BI Visualisations Reference UX Matters: 10 Rules for Better Dashboard Design National Geographic: The Underappreciated Man Behind the “Best Graphic Ever Produced” M Bounthavong: Communicating Data Effectively with Data Visualizations Interaction Design: Guidelines for Good Visual Information Representations UX Design: The Practicality of Nielsen’s 10 Usability Heuristics IDEO: Design Kit

1.6.2. Visualise Tasks

1.6.3. Additional Visualise Tasks Radacad: Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer: Parameter Table Pattern Four Moo: Using Slicers to Change Measures Absent Data: WhatIf Parameter Microsoft: Swap Axis by Slicer

1.7. Step #6: Publish

1.7.1. Publish Concepts Microsoft: Power BI Dashboards Roman Pilcher: What is Product Management Microsoft: Publish from Power BI Desktop Microsoft: Apps in Power BI Microsoft: Share in Power BI Microsoft: Share in Power BI Radacad: Power BI Sharing Comparison

1.7.2. Publish Tasks Microsoft: Collaborating on Assets Microsoft: Sharing Assets

1.8. Step #7: Manage

1.8.1. Manage Concepts Pilcher: What is Product Management? Medium: Venture Design Framework SAP: Product Lifecycle Management

1.8.2. Management Tasks Microsoft: Row Level Security Microsoft: Power BI Datasets

2. Predictive Analytics

2.1. Concept: Time Series Forecasts

2.1.1. Microsoft: Forecasting Tool

2.1.2. ESRI: Time Series Forecasting 101

2.1.3. Towards Data Science: The Complete Guide to Time Series Analysis and Forecasting

2.1.4. Machine Learning Mastery: What Is Time Series Forecasting?

2.1.5. How to Decompose Time Series Data into Trend and Seasonality

2.1.6. Trend, Seasonality, Moving Average, Auto Regressive Model : My Journey to Time Series Data with Interactive Code

2.1.7. Choosing The Right Forecasting Technique

2.1.8. What is the difference between a causal model and a time series model?

2.2. Task: Time Series Forecast

2.2.1. Creating Forward Forecasts in Power BI Using DAX

2.2.2. How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques

2.2.3. CORR Illustration

2.2.4. Deckler: Correlation, Seasonality and Forecasting

2.3. Supervised Machine Learning

2.3.1. Introduction to Machine Learning Logistic Regression Machine Learning Overview Algorithms of Machine Learning Oracle: Types of Machine Learning and Top 10 Algorithms Everyone Should Know Explainable AI: The data scientists’ new challenge

2.3.2. Regression Examples Deloitte Predictive Maintenance Input-Output Prediction SMU Default Prediction

2.3.3. Regression in DAX XXLBI: Simple Linear Regression in DAX Microsoft: Simple Linear Regression Kaggle: Walmart Recruiting - Store Sales Forecasting

2.3.4. Machine Learning Process What is Data Science? Supervised Machine Learning A Brief Overview of AutoML A Quick Guide to How Machines Learn Uber Michaelangelo What is Supervised Learning? Predicting Employee Attrition with Machine Learning Dealing with Interaction Effects in Regression Interaction Effect in Multiple Regression Bias-Variance Tradeoff The Case of Overfitting 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 Ridge Regression Data Standardisation SMOTE Indicio ML Workflow

2.3.5. KNIME and Alternatives KNIME Towards Data Science: Deep Learning with minimum Coding Gartner Quadrant: Data Science and Machine Learning Tableau Prep Azure Data Factory Alteryx Rapidminer EasyMorph Power BI Dataflows Apache Airflow Apache Kafka] AWS Kinesis

2.3.6. Random Forest IBM Random Forest Entropy and Information Gain Random Forest Overview R-Squared > 0.75

2.4. Tasks: Machine Learning

2.4.1. Absent Data: Python Machine Learning in Power BI

2.4.2. Reading and Writing to Databases ...more... Pipeline Challenge

2.4.3. Using the Power BI Integration Nodes

2.4.4. Using the KNIME Scheduler

2.4.5. Predicting Employee Attrition with Machine Learning

2.4.6. Regression in KNIME

2.4.7. Analytics Vidhya: Building your First Machine Learning Model using KNIME

2.5. hr

2.6. Machine Learning Questions

3. Enhanced Insight with DAX

3.1. Enhanced Visual Analytics Concepts

3.1.1. Visual Data Science 10 rules for better dashboard design Stephen Few: show insight, simplify, clarify, and generate density How to Lie with Statistics: Stand Your Ground and Gun Deaths Alberto Cairo: tell stories, enable the user to take their own path John Snow's data journalism: the cholera map that changed the world Edward Tufte: show the data, not the ducks, do not mislead... Four Principal Challenges

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

3.1.3. Distribution Curves Descriptive Statistics Combating Coronavirus Misinformation Journal of Accountancy: Using Benford’s Law to Detect Fraud

3.1.4. Relationships Hypothesise the Model Confirm the Model Validate the Concept Linearisation of Non-Linear Relationships How to Linearise a Curved Data Plot Types of Linear Relationship A Brief History of the Scatter Plot - Data Visualization’s Greatest Invention Scatter Plot

3.2. DAX Fundamentals Tasks

3.2.1. Create Calculated Tables in Power BI Desktop

3.2.2. Scenarios of Using Calculated Tables in Power BI

3.2.3. DAX Operators

3.2.4. Use Variables to Improve Your DAX Formulas

3.2.5. DAX Whitespace

3.2.6. EnterpriseDNA: Virtual Tables Inside Iterating Functions In Power BI

3.2.7. Radacad: Using Iterators in DAX

3.2.8. Deckler: For and While Loops in DAX

3.2.9. Microsoft: Model Relationships in Power BI Desktop

3.2.10. Microsoft: DAX Function Reference

3.2.11. DAX Guide

3.3. DAX Visual Analytics Tasks

3.3.1. Benford Test

3.3.2. T-Test Equation ...key... x = mean of group values n = number of group values s = standard deviation of group values t = the t statistic 1 and 2 = group labels

3.3.3. p Value

3.3.4. CORR Illustration

3.3.5. Gapminder World Poster

3.3.6. Simple Linear Regression in DAX

3.4. DAX Scripting Concepts

3.4.1. Pseudocode Noteworthy: How to Write Pseudocode: A Beginner’s Guide Viking Code School: The Elements of Pseudocode TechGeekBuzz: How to Write Pseudocode? Pseudocode 101

3.4.2. DAX Patterns Microsoft: Use DAX in Power BI Desktop Addend: DAX Functions Cheat Sheet Microsoft Power BI Community DAX Patterns

3.4.3. DAX Scripting Examples Microsoft: Days of Supply Microsoft: HR Analytics

3.5. DAX Scripting Tasks

3.5.1. Pseudocode Process 1. State the Goal 2. Initialise the Variables 3. Scaffold a Linear or Iterator Format 4. Identify the Statements 5. Define the Sequence 6. Incorporate the Statement Conditions 7. Specify the Output Expression 8. Reflect, Refine, Optimise 9. Translate to DAX

3.5.2. Moving Average Microsoft: Moving Average Pestle Analysis: Time Series Analysis: Definition, Benefits, Models Towards Data Science: Forecasting in Power BI

3.5.3. New and Returning Customers New and Returning Customers

4. Text Analytics

4.1. Text Analytics Concepts

4.1.1. Sentiment Analysis Sentiment Analysis: A Definitive Guide What is Sentiment Analysis and How Does it Work?

4.1.2. Topic Modelling Wikipedia on Topic Models Topic Modeling: An Introduction Topic Discovery and Clustering

4.1.3. 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

4.1.4. NLP Lexalytics on NLP Tibco on Text Mining Data Science Central on NLP Tibco on Text Analytics

4.2. Sentiment Analysis with VADER Tasks

4.2.1. Power BI and Python Power BI and Python Python in Power Query Editor

4.2.2. WinPython Installing new packages for WinPython

4.2.3. VADER and Power BI 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

4.2.4. Other Python Packages Sentiment Analysis In Power BI

4.3. Modifying VADER Questions

4.4. Topic Modelling with jsLDA Tasks

4.5. KNIME Concepts

4.5.1. Modern Analytics Architecture with Azure Databricks

4.5.2. KNIME

4.5.3. Data Science Presents Tech Hurdles

4.5.4. The Emerging Big Data Architectural Pattern

4.5.5. Requirements and Limitations of Python Packages

4.5.6. Text Analytics in Microsoft Azure and Power BI

4.5.7. Choosing a natural language processing technology in Azure

4.5.8. Using the new KNIME Deep Learning - Keras Integration to Predict Cancer Type from Histopathology Slide Images

4.6. KNIME and Power BI Tasks

4.6.1. KNIME General KNIME Interface KNIME Example Workflows KNIME Power BI Integration User Guide

4.6.2. LDA Topic Modeling — LDA Mallet Implementation in Python — Part 1 Topic Modeling in Python: Latent Dirichlet Allocation (LDA) Intuitive Guide to Latent Dirichlet Allocation

4.6.3. NLP in KNIME Stanford Tagger: Tag Interpretation IS Literature Mining with Topic Detection (LDA)

4.6.4. Topic Models in Python 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

4.7. Topic and Sentiment Questions

4.8. e856d1b8f83d4586ba558335a9ab9b7a

5. Course Materials

5.1. Map Link

5.1.1. Course Page

5.1.2. Copy the Map

5.2. Datasets Link

5.3. Tools

5.3.1. Download Power BI Desktop

5.3.2. Create a Power BI Online Account

5.3.3. Download WinPython

5.3.4. Download KNIME

6. Python Visualisation

6.1. The Four Types of Visual Insight

6.2. Matplotlib Library

6.2.1. Matplotlib Cheat Sheets

6.2.2. Matplotlib Library

6.3. Seaborn Library

6.3.1. Seaborn Cheatsheet

6.4. Python Preparation Tasks

6.4.1. MoonPoint: Installing new packages for WinPython

6.4.2. Microsoft: Power BI and Python

6.4.3. Microsoft: Requirements and Limitations of Python Packages

6.5. Python Visualisation Tasks

6.5.1. Microsoft: Create Power BI Visuals by Using Python

6.5.2. Absent Data: Using Python Visuals in Power BI

6.5.3. Datasets Gapminder US Covid Datasets

6.5.4. Seaborn Pair Plot Grouped Boxplots Plotting with Categorical Data Box Plot

6.5.5. Matplotlib Scatter Python Projects: Scatter Plot With Matplotlib Sample Plots in Matplotlib

7. Foundational Patterns

7.1. Core Patterns

7.1.1. The Structure of Analytics Challenges

7.1.2. The Data Science Workflow

7.1.3. The Success Factors of Information Design

7.1.4. The Four Analytics Objectives

7.1.5. The Four Types of Visual Insight

7.1.6. The Product Management Framework

7.1.7. The Ten Red Flags of Failure

7.2. Scaling Machine Learning at Uber

7.2.1. Strategy

7.2.2. Teams

7.2.3. Science

7.2.4. Process