How to Use Free Microsoft Office Online
This first article in the Introduction to Data Analysis series will walk you through setting up Microsoft’s free Office Online and introduce you to using Excel Online with OneDrive.
Business Intelligence (BI) is a technology-driven process that leverages software and services to transform raw data into actionable insights. These insights aid in strategic and tactical business decisions.
Our Business Intelligence category delves into the various aspects of BI, providing insightful articles that explore key trends, tools, strategies, and best practices in the field.
Whether you’re a seasoned professional or a newcomer to the world of BI, this category provides valuable knowledge to enhance your understanding and skillset.
This first article in the Introduction to Data Analysis series will walk you through setting up Microsoft’s free Office Online and introduce you to using Excel Online with OneDrive.
You can improve your data visualizations productivity by using the built-in table functionality available in Excel. This tutorial and sample Excel workbook, available on GitHub, will move you from raw table to interactive analysis in less than 5 minutes.
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.