I've always considered SSAS as data marts too. One and the same to me, just different pros and cons over using SSAS versus a database or even both.

I...

Man, a good bunch of these really sound like they depend on you versus what was there previously. I think Jeff hit it on the head with the questions that...

Hrrm, maybe you're looking in the wrong locations for those analyzing data? There are a lot of data science blogs and articles out there that cover a great deal on...

On the hourly aspect too, think about how you handle half-hour's. If you have a shift that starts at 6:30 versus 6:00

I don't deal with shifts, but I deal with different fiscal years across clients. Depending on the client vertical, they may have different ways of rolling up their quarterly data...

Well yeah, was just using it for reference. I don't know how you're currently populating your Fact. I would assume though that you would use INSERT INTO WHERE NOT EXIST...

Regardless of best practices and methodologies from proven methods, your design at the core is saying that new hire record is not an active record. Therefore, when you select all...

As a fan of Python who uses it with SQL Server, this is great news to me!

This is just my opinion so take it with a grain of salt. I don't have 5+ years in data, but I do have 7+ years in software development. I...

Yeah, doesn't hurt to try. Python and the packages above are all free and open source. I work with SQL Server as well and run Python on Windows. So, it's...

Example of how easy it is to load data into Pandas with Python to analyze a single file.

import pandas as pd

header = ['Date',...

Just to follow an alternative method here while you try to dabble with the GUI to solve this problem. How many records/files are you talking about here that have similar...