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.
How to Use and Refresh Power BI Using OneDrive Data Sources
One of the challenges for users with Power BI is being able to use a data source that you can update and flow those changes to your Power BI dashboards and reports. Using an Excel file in OneDrive for Business allows you to have multiple users update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how you can leverage this feature for your own solution.
Accomplishment Logs Track Your Success for Employee Reviews
We are all busy and jumping between tasks and projects. This makes it easy for your accomplishments to get left behind as you move on to the next thing. Keeping an accomplishment log will help you track what you have completed, your successes and will also serve as a resource for items you can reuse later.
Story Telling with Data Visualizations and Infographics
Data visualizations can become the vehicle that leads a reader through your narrative. Having an infographic or series of visuals allows one to tell a story and provide greater understanding than simply having text alone.
5 Steps to Improve Your Excel Data Visualization Productivity
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.
Connecting R Scripts to SQL Azure for Data Discovery and Profiling
I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.