Blog articles over Data Architecture, Data Engineering, Business Intelligence, Machine Learning, and Data Quality Improvement
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.
1. Monthly or Quarterly Year-Over-Year Comparision PARALLELPERIOD is the function to get the same period in previous year. 2. YTD Year-Over-Year Comparison YTD function can be used to get the period from start of this year to current date. To get the same YTD period in last year, we could combine the YTD and PARALLELPERIOD … Continue reading MDX #1 – Year-Over-Year Comparison
I have been searching for CTI solutions for Dynamics CRM 2011 and found Flexor CTI is a good choice which provides most of common CTI features, such as click-to-dial, screen popping, on-screen call control, journal and log calls direct to customer records in Dynamics CRM, and also management reporting. This add-on is very easy to … Continue reading Dynamics CRM 2011 Computer-Telephony Integration Solution Using Flexor CTI Add-on
When we create custom Dynamics CRM workflows using the built-in Dynamics CRM workflow designer, there is a common requirement that we want to look up and reference Guid of current entity record in the workflow. For example, when a task is created or assigned in Dynamics CRM site, we often create a workflow to send … Continue reading Using Guid of Entity Record in Dynamics CRM Workflow Designer – A Generic Solution based on Custom Plugin
Data Ninjago (Finsight-Tech Blogs) 
You must be logged in to post a comment.