Discussion: View Thread

SSRS vs. Power BI

  • 1.  SSRS vs. Power BI

    Posted 6 days ago
    We recently hired a database specialist and he has learned the basics of Crystal Report writing. We are now looking at converting our reports over to SSRS, however we have heard some chatter that the industry / Microsoft is slowing moving towards Power BI and now we are wondering if it's worth our time training our new specialist on SSRS or should we just shift our focus to Power BI. Any thoughts, comments or suggestions would be highly appreciated.

    ------------------------------
    Christopher Gibbons
    Sr. Accountant
    Prairie Electric, Inc.
    6000 NE 88th St.
    Vancouver WA 98665

    O: (360) 573-2750
    C: (360) 241-1581
    E: chrisg@prairielectric.com
    ------------------------------


  • 2.  RE: SSRS vs. Power BI

    Posted 5 days ago
    Hi Chris,

    Here's what we've found with those three report options in Vista:

    Crystal Reports
    Pros:
    • Best integration with Vista, especially regarding data security
    • Many standard reports available to modify
    Cons:
    • Hard to learn and use
    SSRS
    Pros:
    • OK integration with Vista
    • Ability to include on dashboards
    • Scheduled reports through subscriptions 
    • Can be made available in Keystyle
    Cons:
    • Extra layer of configuration and permissions required
    • Data security only works if using Windows Logins in Vista
    Power BI
    Pros:
    • Easy to create nice looking reports and dashboards
    • Lots of resources available through Microsoft and third-parties for learning
    Cons:
    • No real integration with Vista
    • Doesn't work well with composite keys, so every report requires making a denormalized SQL view


    ------------------------------
    Michael Kelley
    President
    Silvertrek Systems LLC
    Battle Ground WA
    (360) 667-3340
    ------------------------------



  • 3.  RE: SSRS vs. Power BI

    Posted 2 days ago

    Excellent thank you Michael!

     

    Chris Gibbons

    Accounting / Contracts

    Prairie Electric, Inc.

    Office  360-573-2750

    Fax       360-576-7422

    Web     prairielectric.com

     

    <a href=image004.png@01CFA024.CC246DC0">

     

    6000 NE 88th Street

    Vancouver, WA 98665