ERP and BI

Kategorie: Allgemein

  • Dynamicallly writing those pesky Update Statements

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Intelligent SQL: Whenever you are loading a data warehouse, often one of the most time consuming tasks is writing the update statements that you need in order to properly handle changing records coming from your system. Further adding to development time, columns are then split into type 1 or type 2 attributes,…

  • How to design your SSRS or Power BI dashboard

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Clint Huijbers' Blog: Here’s how you should design your SSRS of Power BI dashboard (thanks to Julie Koesmarno). More info on her blog: http://www.mssqlgirl.com/power-bi-in-a-jiffy-composition-in-power-view.html To my delight, she mentioned about composition, in particular Fibonacci Spiral. It reminded me of one of the fundamental things that I have learned in photography (as a…

  • Office Sway für jedermann

    —

    by

    selfservicebi
    in

    Mehr dazu hier

  • Thoughts On The New Power BI

    —

    by

    selfservicebi
    in

    Chris Webb's BI Blog There’s been a lot of Power BI-related news in the last few days. I think it’s enough to say that there is a new Power BI in town, a very different (and much better) story from what we’ve had up to now. Sadly the preview is only available in the US…

  • DAX Studio v2

    —

    by

    selfservicebi
    in

    Cool, besser als die meisten Türchen, die man in diversen Adventskalendern öffnen kann: http://geekswithblogs.net/darrengosbell/archive/2014/12/08/dax-studio-v2ndashchristmas-comes-early.aspx

  • SSIS 2012 – Configurations and Monitoring

    —

    by

    selfservicebi
    in

    Und noch ein sehr guter Artikel über die tiefgreifenden Features in SSIS 2012 und höher: https://www.simple-talk.com/sql/ssis/ssis-2012-projects-deployment-configurations-and-monitoring/?utm_source=ssc&utm_medium=publink&utm_content=ssis2012projects2

  • Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query

    Tutorial: How to Create a Star Schema Model in Power BI and Power Pivot Using Power Query

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf business intelligist: Click Here to download this Tutorial file Very often our analysis starts with a flat data set that contains all of the pertinent columns in a single table that looks like the one above. As we can see, we can analyze this data using three different lenses or dimensions: Product…

  • SSIS: Experimenting with the target cache lookup

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Intelligent SQL: As a part of the project I’m currently working on, the development team is very enamored with the cache transform in SSIS. I consider myself pretty experienced with SSIS, and I’ve always stayed away components that come anywhere close to touching disk with SSIS, as I believe it slows down…

  • PASS Summit 2014 Day 1 Keynote

    —

    by

    selfservicebi
    in

    A New Power Bi. It’s getting quite hard to keep the pace. Chris Webb's BI Blog I’m sitting on the blogger’s table for the PASS Summit 2014 keynote, and this post is a quick summary of all of the BI-related announcements (minor and hopefully major) made this year. The really interesting developments will get their…

  • Self-Service BI – Erstes Resümee

    —

    by

    selfservicebi
    in

    Ich  beschäftige mich nun seit einiger Zeit vornehmlich theoretisch mit dem Thema Self-Service BI. Für mich hat sich nach dem Studium diverser Artikel, Bücher und in Anbetracht meiner bisherigen praktischen Erfahrungen als Entwickler folgende Erkenntis duchgesetzt: 1. Die Datenbasis für BI Auswertungen im unternehmerischen Umfeld muss meiner Meinung nach ein Data Warehouse sein. Der Begriff…