<img src="https://track.adform.net/Serving/TrackPoint/?pm=268420" width="1" height="1" alt="">
 
af inspari | 21. juni 2017
  

Inspari BI Tool Update - Qlik Sense, Tableau & Power BI

Nogle har en forkærlighed for iOS, mens andre sværger til Android eller Windows. Den form for ’religionskrig’ finder vi også inden for datavisualiseringstools. Hvad enten du er til Qlik, Tableau eller Power BI, får du her BI Tool News med seneste nyt fra de tre markedsledende tools.

Rigtig god fornøjelse! 

[læs mere]

Tableau Microsoft data analytics BI tool Qlik Sense Power BI

  
 
af Jens-Jacob Aarup, CEO | 28. februar 2017
  

hvad betyder kvadranten for dit valg af BI-tool?

Så kom den årlige opdatering af branchens væsentligste vurdering af softwareleverandører, nemlig Gartner Groups Magic Quadrant for Business Intelligence and Analytics Platforms. Sidste år foretog Gartner en af de mest markante ændringer i kvadranten set i en del år, da de ændrede væsentligt på de produktkriterier, de foretog evalueringen ud fra. Kvadranten blev justeret, så den tog afsæt i det moderne business intelligence (mode 1), der i høj grad drives af forretningen og er præget af en høj grad af self-service. Det gamle business intelligence (mode 2), hvor industriens dinosaurer har hersket med rapportfabrikker i mange år, blev flyttet ud i en markedsrapport. Her kunne virksomheder med behov for flere pyjamasrapporter (du ved, rapporter med skiftende farvelægning i rækkerne, som mest af alt ligner en pyjamas) læse hvilke softwareleverandører, der var gode til netop dette. Opdateringen resulterede i et nyt felt af leaders, som kun indeholdte Qlik, Tableau og Microsoft. Netop disse værktøjer har defineret det moderne BI, mens de andre leverandører har stræbt for at følge med.

[læs mere]

Tableau Microsoft gartner magic quadrant business intelligence qlik analytics

  
 
af Martin Kolding Pedersen | 9. december 2015
  

endelig kom opdateringen af MS reporting services - læs dommen her!

Microsoft SQL Server Reporting Services har fået en overhaling. Spørgsmålet er, om vi kunne have forventet mere, eller om SSRS bare er blevet endnu bedre og vildere?

[læs mere]

SQL Microsoft data datazen ssrs

  
 
af Daniel Svendsen | 27. november 2013
  

Enrich your Data Warehouse dimensions with help from SQL Server 2012 Master Data Services

As a Data Warehouse Consultant, I´m often asked the following by customers: “Is it possible to enrich our dimension data with some manually maintained data” and the answer is always “yeah, of course”. However, quite quickly the questions of:

- Who should input this data
- How do I inform that a new dimension value is available
- In which system should the user import this data
- And how can it been done in a user friendly manner

I have successfully used Master Data Services from SQL Server 2012 to manage this challenge.
Master Data Services offer an Excel plugin and a web application that makes it easy for business users to push data to a SQL Server. This tutorial will focus on the Excel plugin for pushing data.
This blog post will explain how you can push data from your SQL Server to your MDS implementation, thereby making it possible for the business user to enrich the data.

[læs mere]

SQL SERVER 2012 T-SQL SSIS Microsoft

  
 
af Henrik Zacher Molbech | 26. marts 2013
  

Using table variables in a SSIS data source is not returning any records

Every now and then standard queries just aren’t sufficient as data sources and therefore it might be neccesary to add an intermediate step. For instance by using a table variable. But using a table variable will by default not return any records. So what do we do, then?

[læs mere]

T-SQL SQL Server SSIS Microsoft

  
 
af Henrik Zacher Molbech | 29. november 2012
  

Special characters in SSAS Name properties

Have you ever got the request to use special characters, like ( ) / & %, in the names of your measures or dimension attributes in your multidimensional cube, but only to find that the Name property will not accept this? There is a way to implement this even though it is not done on the Name property but involves Translations.

[læs mere]

SQL SERVER 2012 SQL Server Microsoft

  
 
 
af inspari | 15. november 2012
  

Output row values effected by an update

Have you ever thought about logging the before and after value for an update or delete? It’s actually pretty simple getting these information as a return on an update and delete.

Lets make a quick example.

[læs mere]

T-SQL SQL Server Microsoft

  
 
af inspari | 9. november 2012
  

Updateable views

By default view are updateable. It means you can write a TSQL update statement against a view just like you can update a table. I both cases you off course need update permissions. This give you an opportunity to let users update views containing less columns than the original table. You can update data in a view even if your dataset is a join on two or more tables.

In this blog we will se how you avoid users from update data out of your view.

[læs mere]

T-SQL SQL Server Microsoft

  
 
af inspari | 7. november 2012
  

Avoid schema changes corrupting your views

Maybe you are using views as a layer between your tables and your users. If you have a lot of views you properly know the case where a table is change and now your view is not working anymore.

Lets see how to avoid schema changes corrupting your views.

[læs mere]

T-SQL SQL Server Microsoft

  
 
 
af inspari | 12. september 2012
  

PASS SQLRally Nordic 2012

PASS SQLRally Nordic is the biggest SQL Server event around here. This year the event is held in Copenhagen at Crowne Plaza. The conference is running 3 days. 1. October is a full day of pre-conference seminars, followed by two days with more than 30 technical sessions during the main conference.

[læs mere]

SQL SERVER 2012 Microsoft