Exploring the future of financial data architecture: AI-native FICC canonical models, large-scale financial data processing, and enterprise data quality & governance.
Power Query is a self-service ETL tool from Microsoft which is able to extract data from a broad range of data sources, transform the data, and finally load the data to PowerPivot. However, I have recently found that Power Query could also be a very handy SharePoint Metadata viewer to inspect the schema of SharePoint sites, lists, content … Continue reading Inspecting SharePoint Metadata using Power Query
In the last blog post, I've created a box-and-whisker plot to compare UK's performance on Eurovision contest with others. That would be good to have a nice Viz to show where the votes from for each country. This can be achieved using Tableau Map and Path. It is straightforward to create this Viz using the Path … Continue reading Tableau #2 – Visualising Eurovision Voting Path
Eurovision is my favourite song contest programme, not only because of the not bad songs but also the acid humour from the BBC presenter Terry Wogan. I have been watching this show for a few years, from my memory, UK has constantly performed poorly on the final voting which has been blamed as "tactical Eastern … Continue reading Tableau #1 – Analysis of UK’s Eurovision performance
There are many options available for building SharePoint-based applications. This blog post introduces another non-traditional option - building SharePoint application using SQL Server Reporting Services. To introduce this approach, I will demo how to create a simplified second-hand car listing solution (within less than one hour): Firstly, we go to a Sharepoint site and create … Continue reading Building SharePoint Solutions using SQL Server Reporting Services
PowerView, the new commer of Microsoft reporting tools family, empowers report builders to create eye-catching reports with wow-factors in a rather simple way. One nice feature offered by PowerView is the image-based filter. Obviously, it would produce much better user experience compared to the drop down style filter in SSRS. Not only it looks much nicer, but … Continue reading Creating PowerView Style Filters on SQL Server Reporting Services Reports
Business Question 1: What are the top(n) products with highest sales growth from previous year in each sales territory? Firstly, we need get the sales of previous year using ParallelPeriod method and then calculate the sales growth (%) by comparing the sales of current year aganist previous year. We will then combining GENERATE and TOPCOUNT … Continue reading MDX #5 – Product Sales Growth Analysis
I have met a very strange issue when I was creating SSAS partitions using Partition Wizard in SSDT 2012. I have gone through all the steps in Partition Wizard successfully, but no partition was created although everything seems running fine. Although I have managed to create the partitions in the SQL Server Management Studio with no problem, … Continue reading Creating SSAS Partitions through Directly Modifying XML Source file
Business Question 1: How much sales percentage does each product sub-category take aganist the total sales of 'Components' cateogry in 2007 In the example above, the .parent is used to return the current product's parent category. Alternatively, ANCESTOR function can also be used which could specify the level of the category (e.g, we hope to get the percentage of current … Continue reading MDX #4 – Sales Ratio aganist Parent Levels
Requirement: Users specify a date range by giving a Start Date and a End Date, and expect to make Year-Over-Year comparison of a measure (e.g. Sales Amount) in the given period. For example, a user input start date as "04/07/2007" and end date as "04/11/2007", and want to compare the sales between the period "04/07/2007 - 04/11/2007" … Continue reading MDX #3 – Year-Over-Year Comparison within Given Period
To get top (n) products with highest sales in every sales territory, the GENERATE function is exactly what we need which applies a set to each member of another set.
Data Ninjago (Financial Data Architecture) 
You must be logged in to post a comment.