Data Analytics Blog
Discover more on Data Analytics

DirectQuery for Power BI Datasets and Azure Analysis Services
When the Power BI composite model was first introduced in 2018, it allowed for an expanded range of capabilities when...

Implementing a Data Model in Tableau as a Single Data Source
In the past, Tableau Desktop limited users to establish a data model utilizing only a physical layer where unions and...

Outputting to Power BI from Alteryx: From Transformation to Visualization
Do you use Alteryx to transform data? Do you use Power BI to build reports? As data professionals, it is...

Creating an Interactive Power BI Report with an R-based Predictive Model
As technology professionals, we are constantly looking for new ways to connect different technologies and streamline processes. Recently, we became...

Report-Level Security – D365 Finance and Operations Embedded Reporting
Next to gaining insightful information, report security is oftentimes cited as a critical necessity when it comes to reporting requirements....

Options for Distributing Power BI Reports Externally
Data analytics and insights are crucial for making good business decisions in today’s world. With today’s modern BI tools, organizations...

What You Need to Know About Azure Cognitive Services
Microsoft’s Azure Cognitive Services (ACS) main goal is to bring artificial intelligence within reach of every developer, no matter their...

Data Profiling Using Power Query
Profiling your data upon loading it into Power BI is key to building accurate, quality reports. Power Query examines data...

Advanced Analytics to Develop a Competitive Advantage in any Economic Climate
Advanced Analytics to Drive the next Macro-Economic Leap I recently attended a technology overview session provided by Microsoft’s Technology Center...

6 Ways Advanced Analytics can benefit the Middle Market
What is Advanced Analytics? So often the buzzwords “data science”, “machine learning”, and “artificial intelligence (AI)” are thrown around interchangeably...

An Automated Process for Copying Excel Documents from SharePoint to Azure SQL Server
The BI Team at RSM had a need for an automated process to export Microsoft Dynamics 365 – PSA data...

Changes coming to Azure Synapse
At the 2019 Ignite Conference, Microsoft announced Azure Synapse Analytics was replacing Azure Data Warehouse. As a standard with Azure-based...

Power BI Datasets: Changing Your Data Source
Power BI is continually expanding its list of accessible data sources. Power BI Developers may have noticed “Power BI Datasets”...

Data Governance: Why You Need It & How To Get Started Today
When searching through the abyss of the internet for “data governance”, it can be overwhelming. The questions come pouring out:...

Sharing and Security in Power BI Service
When using Power BI, an area that is highly overlooked is the organization of sharing and securing reports once they...

Converting Excel Users to Alteryx Analytical Nerds
There are an estimated one billion Microsoft Excel users on the planet, including you and me. This collective army of...