Kategorien
Allgemeines

Power BI Enterprise Architecture for SMB

Working on an SMB Power BI architecture for around 12 months, I wanna share my thoughts, workarounds and proposals for a discussion. As the architecture is pretty new and I used to work with qlik architecture, the last 10 years, I would love to have some feedback from power bi seniors. I have the following […]

Kategorien
Allgemeines Qlik Script

Datamodelling Qlik Concatenate, Power BI Combine, SQL Union

The last 6 months have been quiet full of many new things to learn – after working more than 10 years with qlik and SQL a new player named “Power BI” has been added to my skills. So getting more and more used to it, I feel, like I should give other qlik developers to […]

Kategorien
VB.NET

Execute MSSQL Task with VB.NET Console Application

Download the latest Visual Studio Community Edition (about 4gb). Then start a new Project “Console VB.NET” and use the following code for executing a stored procedure on your MS SQL Server:

Kategorien
Allgemeines Allgemeines

Qlik Sense SetAnalysis and Power BI Dax Comparisson

For my new job I have to move my skills from qlik to microsoft power bi which – at the beginning – is quite challenging. So to keep a bridge in my mind and to speed up my knowledge curve, I document here the samples on how thinks work in qlik sense/view and how in […]

Kategorien
Allgemeines

Excel macro loop by sheet

Collect data from multiple excel tabs and put them together at a new collector sheet: Sub WorksheetLoop() Dim WS_Count As Integer Dim I As Integer ‘ Set WS_Count equal to the number of worksheets in the active ‘ workbook. WS_Count = ActiveWorkbook.Worksheets.Count ‘ Begin the loop. For I = 1 To WS_Count ‘ Insert your […]

Kategorien
Allgemeines

MS SQL PIVOT with text as Fieldtype

The trick is, that you cast the text/string into varchar and then you can use MAX as aggregation type to return the readable value.

Kategorien
Allgemeines

Power BI and MS CRM Entity Tables

Temporary Entity Tables build with DAX Query and using the CRM Tables: StringMapBase MetadataSchema.Entity

Kategorien
Allgemeines

Power BI Calender DAX

Generating a calender was a very important task within qlik sense/view – so even as the date functions within power query or dax are awesome, I still prefer to have an “inbuild” calender. To achieve this goal, you can switch to the “Modeling” view -> add a “Table” and then just copy and paste the […]

Kategorien
Allgemeines

T-SQL read tables and columns from a linked server

Kategorien
Allgemeines

T-SQL execute procedure for each row of a master table

From time to time it’s needed to loop over the rows of a master table – e.g. different companies within your organisation are stored within different databases. So to avoid creating “long” SQL-scripts where you just change the db information, you can ease it up by: