söndag 25 juni 2017

PowerBI & DAX

Link: Day1, Day2

PowerBI UserGroups Attachements, NorwayUserGroup

PowerBI & Visio

----

RatioToParent_Ordered:=
IF (
    ISFILTERED ( Product[HProduct] ),
    SUM ( 'Internet Sales'[Sales Amount] )
        / CALCULATE ( SUM ( 'Internet Sales'[Sales Amount] ), ALL ( Product[HProduct] ) ),
    IF (
        ISFILTERED ( Product[HModel] ),
        SUM ( 'Internet Sales'[Sales Amount] )
            / CALCULATE ( SUM ( 'Internet Sales'[Sales Amount] ), ALL ( Product[HModel] ) ),
        IF (
            ISFILTERED ( Product[HSubcategory] ),
            SUM ( 'Internet Sales'[Sales Amount] )
                / CALCULATE (
                    SUM ( 'Internet Sales'[Sales Amount] ),
                    ALL ( Product[HSubcategory] )
                ),
            IF (
                ISFILTERED ( Product[HCategory] ),
                SUM ( 'Internet Sales'[Sales Amount] )
                    / CALCULATE ( SUM ( 'Internet Sales'[Sales Amount] ), ALL ( Product[HCategory] ) )
            )
        )
    )
)

Link: 4 hierarchies

--
Slicers to Choose Which Measure to Display

Link

---
The Logic behind the Magic of DAX

Source

---
Other
* DAX+MDX files
* World Wide Importer db
* VBA Chart-arrows
* DAX Rolling 5yrs park
---

https://youtu.be/1yWLhxYoq88?t=2987

this one has a great chance to become my favorite video from #MSDataSummit where #PowerBI and Visio meet https://t.co/YYzt0cXMTz
— Tom Martens (@tommartens68) June 14, 2017

---

Row Level Security In Power BI – Star Wars Challenge

https://datachant.com/2017/05/24/row-level-security-power-bi/

---

BOM database

http://www.thebiccountant.com/2017/06/13/bill-of-material-bom-explosion-part2-costing-in-excel-and-powerbi/

---

Use a "Reference" as "DB Connection".

---

Unpivot Nested Tables

----
The Analytical process

Pic: Link

Pic: From MSDataSummit

Pic. pdf and the Interactive model

---
Measure Influencing Dimensions (resources)

Source: Intelligent Process Modeling and Monitoring with Visio and Power BI - YouTube

---
Democracy Indicator

---

Make a story

----

Photo published for Inside Europe’s biggest data visualisation laboratory

Pic: Inside Europe’s biggest data visualisation laboratory. Imperial Collage London maps bitcon transactions across 64 screens (link)

---

And for those of you with less time on your hands, here's the speedy version 🏃: pic.twitter.com/SJzqVEiFmP
— John Burn-Murdoch (@jburnmurdoch) May 21, 2017

---

---
Trump Lies

söndag 23 april 2017

Weekend notes: ETL & SQL-Server 2017 (Graph-Model, DrillDown)

ETLPower QueryModelPower PivotDataJSONCSV, ExcelStreaming datasetsSourcesDatabasesAPIs/SaaSFilesViewPivot Tab...

Source: https://www.slideshare.net/oliviertravers/microsoft-power-stack-2017

PowerQuery
DataSources --> Transformations
1. Clean;Extract/Transform --> 'Data-Table'
2. Categories/Measures/Relations --> 'Info.-Table'
3. Restrictions/Access-Roles -->'Acc.-Table'

----
SQL-Server 2017: Drill Down + Graph-Model

1. NorthWind: Relational-Model --> Graph-Model

Image title

2-4. Foreign keys becomes Relationships, Join-Tables become Relationships, Attributes...
Image title

5. Graph
Image title

måndag 17 april 2017

Tableau - Zen Masters

Tableau Zen Masters

----

---

----

---

----

---

lördag 8 april 2017

Weekend notes

Location tracker

Retreive IP-adresses

----

4 ways to get USERNAME in Power Query

----

lördag 25 mars 2017

Weekend Notes - Manage Sets

Manage Sets (MDX)

DrillDown-Slicer

{[DimCustomer].[CustomerGeo].[All],
IIF( [Measures].[Distinct Count of Country] > 1,
[DimCustomer].[CustomerGeo].[Country], [DimCustomer].[CustomerGeo].[City] ) }

DateSlicers1 via 'Manage Sets'