Subscribe: Productivity and Performance
Added By: Feedage Forager Feedage Grade B rated
Language: English
business process  business  data  let’s  months  number  power scenario  process  projects  ranges bands  ranges  read ranges  read  scenario   
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Productivity and Performance

BI as Business Insight

Proving that what you do has real impact.

Last Build Date: Sat, 30 Apr 2016 02:24:23 +0000


HowTo: Add a record thru code AndAlso Get Current User with Visual Studio LightSwitch

Sat, 30 Apr 2016 02:21:14 +0000

In my BI journey these last several years, I had to face a common need: provide a way for business analysts to maintain (add, modify, delete) records on a backend table. It’s very common that users need to classify/aggregate the data from your transactional systems with taxonomies not in those source systems, and thus the... Read more

Use Ranges/Bands for measuring Frequencies and visualizing Empirical Distributions

Tue, 29 Mar 2016 22:19:35 +0000

Scenario The majority of BI-related activities require measuring something on your business process. These measures usually relate to one of: Inputs to a business process (usually leading indicators, i.e. number of incidents occurring; volume of calls happening; duration of calls; number of transactions). How the process performs (i.e. number of tickets per analyst; time to... Read more

Grouping in Ranges/Bands

Tue, 29 Mar 2016 18:43:36 +0000

Scenario In my previous post “Ranges as Filters for Dates” I covered a way to group on ranges of months that we could use in selections. In this post I’ll share a way to simplify the measures using DAX’s SWITCH function, and also apply it to other cases. HowTo In the previous post we used... Read more

Ranges as Filters for Dates

Mon, 21 Mar 2016 02:26:36 +0000

Scenario We may have data across months, and we’d like to, at times, focus on the next 3 months, the following quarter, or the first 6 months… or similar, i.e. how many people between 20-30 years old, or 30-40, etc. How do we define these ranges, and how can we visualize them? HowTo Let’s say... Read more

Parameters for What-If Scenarios in Power BI

Sun, 20 Mar 2016 15:18:58 +0000

Scenario If we increase the current forecast by 5%, what would have happened with the variance to forecast? If we had reduced by 3% instead, then what? How can we provide an input parameter to calculate variables and see the impact of that change in the charts and trends? Let’s start from a simple report... Read more

Dynamic TopN & Ranking in Power BI

Sat, 19 Mar 2016 19:27:56 +0000

Scenario Let’s assume we have data about projects, and we want to rank the projects by budget, so that if we filter the data by some criteria (i.e. region, country, or some other classification) the ranking recalculates for the new scope. We also want some metrics calculated for the TopN projects, i.e. total budget for... Read more

Data Warehouse versus Business Intelligence

Mon, 24 Jan 2011 09:46:13 +0000

The traditional definition of “data warehouse, or DW” from late ‘70s/early ‘80s involved the end-to-end solution for business users… from extracting data and aggregating it into special data models, the queries, all thru the applications/reports the users interacted with to consume that data. In the ‘90s, the concept of “Business Intelligence, or BI” came to... Read more

Objective for this blog

Sun, 15 Aug 2010 09:31:00 +0000

Making decisions that drive action without objective data to back it up makes no business sense at all, but it happens all the time. Much guess-work goes on, so huge risks and costs follow. And employees get frustrated with activity that doesn’t deliver the expected value. Some examples of not really managing your business: Not... Read more