Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
$168
per year per user
Smartsheet
Score 8.3 out of 10
N/A
Smartsheet is an online project management and collaboration tool. It includes automated alerts, instantaneous updating and sharing across team members, resource management, nested tasks organized in a hierarchy, a Gantt chart view, exportable and automated reports, and integration with email.
$12
per month per user (up to 10 users)
Pricing
Microsoft Power BI
Smartsheet
Editions & Modules
Power BI Pro
$14
per month (billed annually) per user
Power BI Premium
$24
per month (billed annually) per user
Pro
$12
per month per user (up to 10 users)
Business
$24
per month per user (3 user minimum)
Enterprise
Contact Sales
Advanced Work Management
Contact Sales
Offerings
Pricing Offerings
Microsoft Power BI
Smartsheet
Free Trial
Yes
Yes
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
Power BI Desktop is the data exploration and report authoring experience for Power BI, and is available as a free download.
Power BI is much simple to use, and more modern than BusinessObjects, which has now been discontinued. It costs much less to license than Tableau which is perhaps more niche and designed better. It is also much more powerful for data analysis than excel, Smartsheet, Airtable, …
Smartsheet enable users to build the more custom solutions that can include workflows, reports, dashboards, sheet data, reminders, etc. It allows to create the most complete reports and have available thousand of already built solutions on the Solution Center. Also, has the …
Features
Microsoft Power BI
Smartsheet
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Microsoft Power BI
8.2
198 Ratings
0% above category average
Smartsheet
-
Ratings
Pixel Perfect reports
8.1169 Ratings
00 Ratings
Customizable dashboards
8.6197 Ratings
00 Ratings
Report Formatting Templates
7.8180 Ratings
00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Microsoft Power BI
7.9
196 Ratings
1% below category average
Smartsheet
-
Ratings
Drill-down analysis
8.3193 Ratings
00 Ratings
Formatting capabilities
7.7193 Ratings
00 Ratings
Integration with R or other statistical packages
7.4143 Ratings
00 Ratings
Report sharing and collaboration
8.2191 Ratings
00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft Power BI
8.0
189 Ratings
2% below category average
Smartsheet
-
Ratings
Publish to Web
8.1179 Ratings
00 Ratings
Publish to PDF
7.8174 Ratings
00 Ratings
Report Versioning
7.7145 Ratings
00 Ratings
Report Delivery Scheduling
8.3148 Ratings
00 Ratings
Delivery to Remote Servers
7.9111 Ratings
00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Has significantly improved collation of data and visualisation especially with business across Europe. Has given me the ability to see the Site availability at the click of a button to see which Site is in the "money" and seize opportunities based on Market data
Smartsheet shines for collaboration. When you have multiple people involved with planning events Smartsheet makes it easy to share and collaborate. For instance, multiple people can be in Smartsheet working at the same time. Also setting permissions for exactly those who need to know is quite easy with Smartsheet. For data analytics and general spreadsheet purposes Excel is better but for project management and event planning Smartsheet is superior
Options for data source connections are immense. Not just which sources, but your options for *how* the data is brought in.
Constant updates (this is both good and bad at times).
User friendliness. I can get the data connections set up and draft some quick visuals, then release to the target audience and let them expand on it how they want to.
Its hard to overstate the value of familiarity. Being able to use a tool that has some familiarity takes away the time needed to train and orient employees on a new tool and allows an organization to hit the ground running.
Smartsheet covers most of the basics of a project management tool, the usual tasks, milestones and project viewing options.
For data viewing, you get multiple data viewing options including a calendar view (good for marketing teams and those who work around scheduling), Kanban, Gaant etc
Smartsheet set up is similar to Excel, yet when you upload an Excel file, things like conditional formatting are lost. Smartsheet has its own conditional formatting, and you have to reinstate the rules. It would be great if those would apply automatically once a file is uploaded
Some Smartsheet management and access rules can take some tweaking to work properly. This may be a case of offering more info to admins so they can apply these better and with more efficiency
Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.
It definitely meets our needs as far as organizing and archiving our tasks and files. As we train more staff to view it, I see opportunities for more improvement, which I am sure this program can handle. I look forward to seeing continued improvement from Smartsheet on their capabilities and functionality.
Automating reporting has reduced manual data processing by 50-70%, freeing up analysts for higher-value tasks. A finance team that previously spent 20+ hours per week on Excel-based reports now does it in minutes with Microsoft Power BI's automated Real-time dashboards have shortened decision cycles by 30-40%, enabling leadership to react quickly to sales trends, operational bottlenecks, and customer behavior.
Smartsheet is very easy to learn. However, while I have been able to pick it easily, Microsoft Excel and Project super users that I have trained on Smartsheet get bogged down in the differences and can find it frustrating. Explaining the differences ahead of time and why Smartsheet is being chosen instead of a different software seems to counteract those reactions
It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.
I give this rating because it fills a niche in the market. MS Project scares many away from proper task management but there are limited tools our there, especially cloud-based that are mobile-friendly. Smartsheet fills this market gap, especially for small to medium-sized businesses. IT is not fair to compare it to MS Project, but fairer to see what gaps it fills.
It's absolutely paramount to take a few minutes to actually play with the software. It's nearly impossible to do anything wrong or make a mistake which cannot be fixed easily. Under the help menu is Live Training option. After you familiarize yourself with the commands, watch the live training for some in depth understanding of how to make the software fit your needs perfectly.
Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would not pay for Tableau or Sigma anymore. Not worth it at all.
Jira and Redmine are much more robust and technologically advanced project management solutions. I enjoy using either when managing a very large project. However, I prefer to use Smartsheet for my smaller to medium sized projects. As for Google Drive - I would say that Google sheets and Smartsheet are almost identical in my opinion when it comes to functionality. Personally I prefer to manage smaller projects via Google Drive, but it is a personal preference!
