Here is an invite to a webinar in early Dec. about Power BI.
https://register.gotowebinar.com/register/4904496247223055363
Yes, this is a M$ tool. We use it at Ring and all users really like how easy it is for them to pulll data that they need. We have independent cubes for Sales, Purchasing, Production, Shipping, GL, etc.
On 29 November 2017 at 14:32, Stephen Russell srussell705@gmail.com wrote:
Here is an invite to a webinar in early Dec. about Power BI.
https://register.gotowebinar.com/register/4904496247223055363
Yes, this is a M$ tool. We use it at Ring and all users really like how easy it is for them to pulll data that they need. We have independent cubes for Sales, Purchasing, Production, Shipping, GL, etc.
Watched this today. A bit boring to be honest! However, I am interested in this tech and I can see some nice possibilities.
May I ask you a question Stephen? I'm hesitant about revealing our data structures to customers because: 1. They won't understand it. 2. They may misuse it (GDPR etc). 3. Structure changes.
How are you handling this? I'm thinking an option may be to de-normalise data into a separate db.
Cheers!
All of our data comes from a DW and not from the live ERP system of record. That system has 280 gigs of Dimension and Fact data that spans 10 years now.
It has taken 2 years since first cubes were presented to the company but Power BI went in real fast and we had to hire a FT just to keep knocking out more content for users requests. Having the data remerged in the cube makes it much easier for naming and safety of data.
Power BI isn't the only tool for this. It is CHEAPER overall but we are on prem and not put our data in the cloud yet.
On Wed, Dec 13, 2017 at 1:51 PM, Paul Hill paulroberthill@gmail.com wrote:
On 29 November 2017 at 14:32, Stephen Russell srussell705@gmail.com wrote:
Here is an invite to a webinar in early Dec. about Power BI.
https://register.gotowebinar.com/register/4904496247223055363
Yes, this is a M$ tool. We use it at Ring and all users really like how easy it is for them to pulll data that they need. We have independent cubes for Sales, Purchasing, Production, Shipping, GL, etc.
Watched this today. A bit boring to be honest! However, I am interested in this tech and I can see some nice possibilities.
May I ask you a question Stephen? I'm hesitant about revealing our data structures to customers because:
- They won't understand it.
- They may misuse it (GDPR etc).
- Structure changes.
How are you handling this? I'm thinking an option may be to de-normalise data into a separate db.
Cheers!
-- Paul
[excessive quoting removed by server]
On 13 December 2017 at 20:10, Stephen Russell srussell705@gmail.com wrote:
All of our data comes from a DW and not from the live ERP system of record. That system has 280 gigs of Dimension and Fact data that spans 10 years now.
It has taken 2 years since first cubes were presented to the company but Power BI went in real fast and we had to hire a FT just to keep knocking out more content for users requests. Having the data remerged in the cube makes it much easier for naming and safety of data.
Power BI isn't the only tool for this. It is CHEAPER overall but we are on prem and not put our data in the cloud yet.
Thanks Stephen. Can I ask what is a FT is? We have an extremely good report engine but our customers struggle to produce the reports they require.
On Wed, Dec 13, 2017 at 3:40 PM, Paul Hill paulroberthill@gmail.com wrote:
Thanks Stephen. Can I ask what is a FT is?
It can be whatever you want it to be! That's the joy of acronyms.
Stephen probably means Full-Timer, but it could be Fire Control Technician if you're talking Navy Ranks, or Financial Times if newspapers, or 12 inches if we're talking Imperial.
On Wed, Dec 13, 2017 at 3:27 PM, Ted Roche tedroche@gmail.com wrote:
On Wed, Dec 13, 2017 at 3:40 PM, Paul Hill paulroberthill@gmail.com wrote:
Thanks Stephen. Can I ask what is a FT is?
It can be whatever you want it to be! That's the joy of acronyms.
Stephen probably means Full-Timer, but it could be Fire Control Technician if you're talking Navy Ranks, or Financial Times if newspapers, or 12 inches if we're talking Imperial.
Pick top 1 from the list. :)
This generates the data visually in the dashboard and exports to Excel which is the standard for our company at least.
Have you considered generating an additional DW for sale to your users, that puts a lot of the pre-joins together making reporting a lot easier? You fill that data nightly with maybe an emergency reload for a daytime load.
We send out an email every morning to the right people on yesterdays numbers giving new YTD totals. From there they pull what they want/need.
On Wed, Dec 13, 2017 at 2:40 PM, Paul Hill paulroberthill@gmail.com wrote:
On 13 December 2017 at 20:10, Stephen Russell srussell705@gmail.com wrote:
All of our data comes from a DW and not from the live ERP system of record. That system has 280 gigs of Dimension and Fact data that spans
10
years now.
It has taken 2 years since first cubes were presented to the company but Power BI went in real fast and we had to hire a FT just to keep knocking out more content for users requests. Having the data remerged in the cube makes it much easier for naming and safety of data.
Power BI isn't the only tool for this. It is CHEAPER overall but we are
on
prem and not put our data in the cloud yet.
Thanks Stephen. Can I ask what is a FT is? We have an extremely good report engine but our customers struggle to produce the reports they require.
-- Paul
[excessive quoting removed by server]
On 13 December 2017 at 22:03, Stephen Russell srussell705@gmail.com wrote:
Have you considered generating an additional DW for sale to your users, that puts a lot of the pre-joins together making reporting a lot easier? You fill that data nightly with maybe an emergency reload for a daytime load.
This is exactly what I was thinking. Thanks.
On 13 December 2017 at 21:27, Ted Roche tedroche@gmail.com wrote:
On Wed, Dec 13, 2017 at 3:40 PM, Paul Hill paulroberthill@gmail.com wrote:
Thanks Stephen. Can I ask what is a FT is?
It can be whatever you want it to be! That's the joy of acronyms.
Stephen probably means Full-Timer, but it could be Fire Control Technician if you're talking Navy Ranks, or Financial Times if newspapers, or 12 inches if we're talking Imperial.
Doh! I was thinking it was a data warehousing related acronym!
-
Paul Hill -
Stephen Russell -
Ted Roche