Power Query in it’s default form is simply glorious and allows any one with a basic knowledge to merge and collate data sets with the use of the excellent User Interface. But it comes at a price. Hard coding. Now you’ll find in many organisations where power query has been used to transform data and processes that most of the […]
Creating Running totals in power query is quite tricky – currently there are no out of the box click interface or formulas that’ll enable you to easily create running totals. I made 2 Videos to illustrate how you can do a running total and a Month to Date Running total in Power Query. Basic Running Total Pattern Month To Date […]
I’ve been strugglig quite a bit this last week to get my temp tables up and running in SSIS.But after alot of struggling i finally managed to get it going.But it took alot of seaching around. Well in this video i explain the settings that need to change in SSIS to make it work. I found these 2 links very […]
In some cases you might want to highlight the lowest value in a powerbi chart. Here is a sample of a published PowerBI Chart based on the Rotten Tomatoes movie dataset.Each bar represents a month – the month with the lowest number of movie releases is highlighted in red. First create the new measure that will Count the Number of […]
Correlation charts can be used to show how strong a relationship is between variables. Correlations are calculated using the correlation coefficient formula. in our example we will be using a car attribute datasets containing the different attributes of cars. Lets look at some examples of the Types of correlations we are expecting. 1 – Positive Correlation (Strong Positive Relationship – […]
There is just so much data out there that it’s just almost impossible for the human mind to make sense of it.The best way to start making sense of large datasets is by visualising it and take advantage of your inate human ability to spot patterns / trends and correlations. I’m gonna kick off a series of posts on the […]
One of the dashboards I’ve created for my clients contains data from a massive query that populates SQL # temp tables and then reads from the result temp tables. My problem was how do I do this in Qliksense ? I don’t want to rewrite this query in the Qliksense language. I just basically want to take the query as […]
You have a simple database table (UserNames) as below You want to get this table and it’s contents into a csv file. You create a simple dataflow package (OLEDB = Source & CSV Flat File = Destination) You run the data flow task and feel happy that everything was soooo easy. You take a little peek inside the created CSV […]
Some more Tutorial video for Sparx System Enterprise Architect working with Elements
Quick Tutorial revealing the different ways of adding elements to your models in Sparx Systems Enterprise Architect.