RSMUS.comData Analytics Blog
Discover more on Data Analytics
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...