Business Intelligence Complete automation with Power BI and Excel Data Sources

Complete automation with Power BI and Excel Data Sources

There are many tools available for providing data to digital analysts. Some allow for streaming available data, while other sources face hurdles with every step. However, when hard-to-get information is put into a Power BI report, which requires regular updates, the process can seem like a waste of time.   Luckily, there is a solution.  Finding free options is challenging, but through the creative use of several Microsoft Office 365 tools, you can automate Power BI datasets. Many variations …

Read Article Read More

Business Intelligence Intuitive dashboard reporting in Power BI

Intuitive dashboard reporting in Power BI

When building a dashboard for digital analytics, you are aiming for one thing: an intuitive, easily navigable dashboard that tells your story clearly. In this blog post, I will show you how to do this by creating a dashboard with a web-like interface right in Microsoft’s Power BI Desktop.   Preliminary considerations  As always, keep the basics in mind. Know …

Read Article Read More

Data Analytics Beyondsoft Calendar debuts in the Microsoft Office Store

Beyondsoft Calendar debuts in the Microsoft Office Store

If you’re familiar with the world of Power BI, you know that visualizing data across time can be difficult, especially if you’re looking to display that data to generate reports or provide visuals for clients. A new calendar solution, created by Beyondsoft Senior Solutions Architect, Manny Merino, not only helps you organize and visualize daily …

Read Article Read More

Business Intelligence Using Microsoft’s Power BI to Implement a Management Dashboard Directly Connected to Atlassian’s JIRA APIs

Using Microsoft’s Power BI to Implement a Management Dashboard Directly Connected to Atlassian’s JIRA APIs

The Beyondsoft Data & Analytics Team lives and breathes JIRA—Atlassian’s phenomenal issue and task tracking solution. We particularly love the myriad data points it captures during a ticket’s life cycle. Unfortunately, however, we’ve found its reports to be sadly lacking; this deficiency evolved from a nuisance into a major bottleneck during the team’s adoption of …

Read Article Read More

Power BI Self-Service ETL

Self-Service ETL

Self-Service ETL with Power BI Recently, I’ve been using Microsoft’s Power BI heavily and am impressed with this solution as an end-to-end self-service business intelligence (BI) option. In addition, I’ve really come to appreciate the possibilities that self-service BI offers.   What is Self-Service BI? Gartner defines self-service BI as “end users designing and deploying …

Read Article Read More

Business Intelligence 5 Tips for Optimizing SSAS Tabular for Power BI

5 Tips for Optimizing SSAS Tabular for Power BI

SSAS Tabular and Power BI are two cornerstones of Microsoft’s new generation of BI tools, and play quite well together out of the box. For these tips, I’ll assume you have a properly connected gateway up and running linked to a tabular model in Power BI, and that the model has been properly designed so …

Read Article Read More

Business Intelligence Tableau Software vs. Microsoft Power BI

Tableau Software vs. Microsoft Power BI

This blog was originally posted to the Piraeus Consulting blog on August 21st, 2014 and may contain out-of-date information. As BI professionals, we rarely lack software to support our work, but we often do lack information relevant to helping us select the right software for the right need. In its 2013 rollout of Power BI, …

Read Article Read More