|
I read rnbergrens post below on PowerBI and wondered what alternatives there are?
We have a couple of legacy application at my company that creates reports using SSRS.
We need a new application that uses SSAS for the data, and the obvious choice for our management is PowerBI.
I have never worked with it, so my personal choice would be Devexpress just because of impressive support.
But what else is around? And why would you recommend it.
BTW, is SSRS still a viable choice?
And no, Crystal Reports is NOT a choice.
|
|
|
|
|
I have worked in Tableau, SSRS, PowerBI etc...
SSRS would be my personal first choice and it is still viable as far as I am concerned. unfortunately in my current job my employer has mandated the use of PowerBI which would be my last choice.
Tableau is a solid choice but is pretty expensive.
There are others. I have played with quite a few. These are the ones that stand out the most to me.
PS I have been working in PowerBI for about 6 months now. I have had nothing but headaches for the simplest things. Like Data refreshing automatically. That was a huge pain. And the afore mentioned Hotkeys not working and getting on my nerves yesterday. Also, the lack of programmability to the interface(Powerbi, Visual Studio, Object model etc.. I would take anything at this point)
PPS I have 4 on going reports/dashboards in production from production data in PowerBI so I am making it work. It is just ugly.
PPPS I hate it when management makes a decision upon high about which tool to use. You don't tell your mechanic which tool to use. Don't tell your staff. Tell them what you want and let them make the decisions on best tools.
To err is human to really elephant it up you need a computer
modified 20-May-22 9:55am.
|
|
|
|
|
Quote: PPPS
Hmmmm. It would appear that we have another peon who doesn’t know his place!
Send out the four horsemen of the HRpocalypse!!!!
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
Jörgen Andersson wrote: my personal choice would be Devexpress just because of impressive support.
I don't think Power BI and DevExpress are interchangeable.
I don't know DevExpress reporting very well, but as I understood it offers a designer to create reports, like Crystal Reports, but done right.
With Power BI you create dashboards with real-time data.
Crystal Reports and DevExpress create reports and documents that can be used in your software, like invoices.
Again, I could be wrong, but I haven't heard of anyone switching the one for the other and I know companies use both tools side by side.
Jörgen Andersson wrote: And no, Crystal Reports is NOT a choice.
This goes without saying 
Unfortunately, I still have a client who's using it 
Jörgen Andersson wrote: PowerBI and wondered what alternatives there are?
To answer your question, sort of...
A customer of mine is using Qlik | Analytics & Data Integration Platform[^] , and as far as I know they're happy about it.
I haven't used or seen it though, so I can't say what it's like.
I've seen Tableau[^] mentioned in this thread, which is also one of the bigger and more well-known alternatives.
Again, can't say if it's good.
After all, Crystal Reports is probably the most well-known reporting tool and still much used, and probably the worst pile of crap I've ever used
|
|
|
|
|
Well, Devexpress has both a Dashboard Server and a programming interface. But I have only used the latter.
|
|
|
|
|
What you really need is 10,000 nuns and orphans.
|
|
|
|
|
Be sure what you actually are looking for. A reporting tool or a powerful, interactive business intelligence tool. As Sander said they are not the same. Stick with SSRS for static and scheduled reports (I applaud your disgust of Crystal) and look for a BI suite.
The problem we had with MS offering was that it tied you into their eco system, you end up purchasing a number of different servers to drive the tolls.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
Good point.
I don't really believe our users are able to use interactive tools. They want ready made reports.
|
|
|
|
|
One thing to consider is, who will be creating the reports in the long run. If the reports will always be created by developers, then choosing a good, programmable reporting tool, like DevExpress, would be a good choice.
However, if you plan to create an environment where also users will also be able to create their own reports, then the usability and proper metadata capabilities would be important. In such case why not PowerBI but you also have other options like Qlik, Tableau or even products like Cognos. They each have their pros and cons, depending on the requirements.
|
|
|
|
|
Looks like another vote for Devexpress. 
Also see my response to Mycroft.
|
|
|
|
|
there is no issue using SSRS, you need to check which version you are using and what is the new version and how long its being supported by msft and how you plan to use it and if it covers you new requirement needs, powerbi you need to check how you will cover the deployment requirements and licensing etc since its cloud based etc or on premise (Understand Power BI and Setup On premises Power BI Report Server - YouTube.) power-bi is simple and there are lotta books and videos on yt etc that can get u started, you need to need to know some BI concepts in general plus analyze the end users requirements etc. (if you are looking for bi suites there companion of bi vendors)
Caveat Emptor.
"Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long
|
|
|
|
|
Power BI is a step above MS Query, MS Access, Excel.
Data analytics with "hooks" into various database systems. It's a query tool; which anyone can muck up if the queries are convoluted enough. Reports; charts; it has what users want to see.
No "dragging or dropping" or "programming".
BI is "on line"; SSRS is "batch".
DevExpress is a "programming tool" for "programmers". BI is an end-user (desktop) tool; from easy to complex (power users).
Give the users BI and listen to their feedback / get them started.
And, it's free.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
I just had one of those rare moments where a UI makes me happy.
I've updated my mac and iPad to the latest and greatest so I could play with Universal Control. This is where you use your mac's keyboard and mouse to control the iPad (or other mac). The iPad essentially becomes an extension of the screen.
The ballet behind all this must be impressive and, I imagine, an absolute 'mare to debug and get right. Determining the location of hardware through the wireless signal, authentication, latency, the event messages, the data passed around as part of a file drag and drop. So many things to go wrong.
But what blew me away was the setup: you bring the iPad close. You drag your mouse to the side of your mac's screen, and then keep dragging, and then...it appears on the iPad as though it's behind a flexible barrier. You drag a little more and it pops out and you have a cursor on the iPad.
It was fun. It was creepy too, but it just worked and was so, so cool.
Anyway, serious kudos to the person who agreed to pay for the developer time to add that wonderful setup experience.
cheers
Chris Maunder
|
|
|
|
|
Chris Maunder wrote: I've updated my mac and iPad to
I updated my AmigaOS and an equal amount of people cared.
..but yes, this year is going to be when Maccy goes desktop, right? 
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Confusing scan ? I imagine (9)
Confusing = enigmatic and also an anagram indicator
Scan ? = CT mixed with I imagine
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
And to top it all off the clue itself is the clue!
Basically a CCC tautology!
Well done!
If you can't laugh at yourself - ask me and I will do it for you.
|
|
|
|
|
pkfox wrote: CT mixed with I imagine
is 10 letters.
|
|
|
|
|
It is I should have said CT and imagine - well spotted.
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
My manager ("M") and I are at Subway today enjoying our usual Friday lunch when this guy steps out of the store carrying two platters. The bottom platter is a tray of subs and the top platter is a tray of wraps. The guy takes one step out of the door when the top platter goes flying and lands behind M.
In my minds eye I see the wraps all over the footpath. But no, a miracle has happened. The platter has done a flip and has landed upside down, all the wraps are in one piece (nothing out of place, nothing unravelled) sitting perfectly in the lid.
So the guy puts the platter of subs down on a nearby table and picks up the base which now became the lid, puts it on the what was originally the lid, picks it all up and takes one step . . .
At this point M says "Oh boy, were you lucky" and exactly the moment these words were uttered, the guy dropped the platter again. This time they went everywhere. There was absolutely no chance of salvage this time.
I didn't laugh I felt so sorry for the guy, all I said to M was that it was his fault for jinxing him.
I know I'll go to hell because I've 'lol' when I told my workmates (they all said it was M's fault) and when I told my wife and son (they both said it was M's fault as well).
To give the guy full credit, he was very stoic about. No swearing or no carry-on, just cleaned it up and went about his way with his one platter.
Please don't judge me, I can't help but wonder if he dropped that as well when he got back to the office. I honestly do feel bad for the guy (it's usually me that this sort of thing happens to).
// TODO: Insert something here Top ten reasons why I'm lazy
1.
|
|
|
|
|
If first you succeed, try, try again?
cheers
Chris Maunder
|
|
|
|
|
The universe figured there was something wrong with the luck he got the first time and quickly made the necessary corrections.
Seems about right to me.
And yeah, I would feel sorry for the guy but would not miss the chance later on to tell the tale and laugh about it.
|
|
|
|
|
Confusing scan ? I imagine (9)
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
All I can come up with is REFLECTOR, with "CT" for "SCAN ?"
And I'm pretty sure that's wrong.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
At least you came up with something!
|
|
|
|
|
You are on the right track ! what can you make of CT I imagine ?
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
modified 20-May-22 7:47am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
