I'm not an expert on SSAS, so I can't answer that part, but PowerBI lets you build a quick star schema and start analyzing data immediately. SSAS can do...

Hi,

this is close, but not quite right, I think... First off, since you're new, it would help those folks trying to help you if you could post your table...

Jeff,

Just wondering what you would say to an applicant that admitted up front that he may be underqualified, but asked you to help him figure out what he needed to...

I would start by reading this article: The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]

well, people on the US side of the pond might not know it...

Then honestly I'd leave it off. I don't think it's worth the space.

If, for some odd reason, you can have actuals records with no budget, and the reverse, then you would need a full outer join between the two tables, not an...

I would start with looking up Gaps and Islands. There's Itzik Ben-Gan's code, which is a good starting point. Dig around there. Dwain Camps wrote some. how...

What columns you include in your date dimension should probably be determined by what kinds of summaries you intend to do with dates...

Or link to your SQL Server database and use linked tables etc... I wouldn't waste a lot of space on my resume on Access. The market for it is almost...

I got this to work...

I started with a dataset with a date column, Consent_Date.

Created a new table and entered this:

NewDateTable = CALENDAR(MINX('PatientSymptoms',[CONSENT_DATE]),MAXX('PatientSymptoms',[CONSENT_DATE]))

... which generated a table of all the...

At the bottom of this page, it says that there are both 32- and 64-bit versions of SSRS.

add a case sensitive collation to your query.

Here[/url]'s a really good example.

here's one I did ...

SELECT *

FROM dbo.Patient

WHERE LastName COLLATE Latin1_General_CS_AS LIKE 'Do%';

so a last name starting with 'DO' would...

Removed the "compare to last week" part...

looks like there's a piece missing:

FROM MyData T1

LEFT JOIN T2

ON DATEADD(yyyy,-1,T1.InvoiceDate) = T2.InvoiceDate

(I think).

I'm pulling week to date sales data (ex. if I were to run it tomorrow it would pull sales totals for Monday and Tuesday of this week). But, I want...