Power Query & Various links

Search for a text in a table

Source: checks each row


Pivot Text to Table

Pic. Pivot Text to Column we need an intermediary number column


----
List.Generate + GroupByAllRows
https://youtu.be/LiDYLSxQTmQ?t=2252


Parameters: Filter Country at File-opening

http://biinsight.com/power-bi-desktop-query-parameters-part-3-list-output/



Replace words




https://community.powerbi.com/t5/Community-Blog/Conditional-Code-Branching-in-Power-BI-Query-if-then-else-gt/ba-p/39998

How to draw lines

http://community.powerbi.com/t5/Community-Blog/R-script-and-R-visuals-in-Power-BI/ba-p/27011

Free e-book

Data Lake vs Data Warehouse: Key Differences

Data Lake vs Data Warehouse: Key Differences

Pic. The structure (Source)


Pic. DataTables = FlowTables and LookupTables = ResourceTables (Source)


Pic. The Lookup/ResourceTables holds the attributes (adjective/adverb) for the Process. 


Tabular editor
http://www.kapacity.dk/a-new-way-to-work-with-sql-server-tabular-models-the-tabular-editor/?lang=en (source)


Swagger - API design editor

Excel Power Pivot to SSAS Tabular in less than 30 minutes (video)

Starting Your Modeling Career with Analysis Services Tabular Models Part 1
Installing Visual Studio Express (video)

SQLBits Presentations mtrl
Excel addin: thingiequery

Variables in DAX
From SQL to DAX, joining tables
Parent Child hierarchies (drill down, DAX path formulas)
Many to Many relationships
Rank within groups & filter

PowerQuery: Load images
Interate over multiple web-pages
PowerQuery: List buffer (from 35 to 2sek)
PowerUpdate, intro

DAX Example
Max Value per Group in a Calculated Column
Measures in Slicers

Charts: GitHub

CubeFormulas
CubeMember, Video,
Cube formulas explained, 2, CubeValue formula, CubeMember

Programming language school (simple practical examples)

Power BI, installing
Videos, Example

MDX formulas explained

Various links - DAX related
Microsoft SQL Server Analysis Services: Tabular Deep Dive
How to Download and Install Visual Studio 2013 Express
Microsoft PowerPivot Excel 2013 in Action
SQLug.se - Alberto Ferrari - Many-to-many in DAX , session 1
SQLug.se - Alberto Ferrari - DAX
Solving Complex Business Problems with DAX

Power Query-related
Working With Excel Named Ranges In Power Query
Power Query forums

Extract CSV data from PDF files with Tabula
Tabula (video)


Google maps API & PowerBI
http://biinsight.com/power-bi-and-google-maps-api-address-lookup/

Free books
http://www.kdnuggets.com/2015/09/free-data-science-books.html


Power-BI
PowerBI - Synonyms
PowerBI - Conditional categories
Connect to Oracle/Hyperion db
GeoJason
PBIUG - OneDrive

Structure of Mathematics

http://www.nickols.us/controltheory.html
http://www.nickols.us/TargetModel.pdf










SharePoint
Save Excel-Table as SharePoint-List