Thanks for bringing up this post OP. I am in the same situation, started working in accounting then transitioned to financial planning and analysis, and got really interested in data analytics beyond financial analysis/reporting. I have been learning SQL via Udacity - SQL for Data Analyst course (it's free).
Here is a photopea file you would like to change the background. Simply click file> open & place... and select your favorite background of the same dimension (2560x1440). You might need to change the text color (or size if you want), that would be in the "Text" folder. Unfortunately, it's a mess since I didn't think anyone would use it. To save the folder : file > export as.. > JPEG then select max settings. If you need help with something let me know.
I am a huge fan of R Studio. The free, open source version is excellent, and is perfectly suited to your needs.
You can even install the server version with Shiny, which will let you serve up interactive web-pages. I used to be a big fan of Spotfire, which is similar to Tableau. Because of R/R-Studio, I haven't used Spotfire or Tableau in almost 5 years.
You could also photoshop the source image - it'd be helpful to see what we were starting with and what the intended modifications are. That would help point you down the right path.
This is a great book on it. Used in college and still apply a lot from it today in my role. All about what gets the point across the fastest for your audience.
Storytelling with Data: A Data Visualization Guide for Business Professionals https://www.amazon.com/dp/1119002257/ref=cm_sw_r_cp_api_glt_i_NE2EE7DM5GYRN065VPEW
This is a great book on it. Used in college and still apply a lot from it today in my role. All about what gets the point across the fastest for your audience.
Storytelling with Data: A Data Visualization Guide for Business Professionals https://www.amazon.com/dp/1119002257/ref=cm_sw_r_cp_api_glt_i_NE2EE7DM5GYRN065VPEW
Apple has built capabilities for users to download their data. Here is an article that has the details:
https://observer.com/2018/10/apple-data-download-how-to-get-copy/amp/
Although, it seems like messages may not be included, but not sure if that has changed since 2018.
Here is a 3rd party app that apparently allows to export messages to CSV but I have not tested myself:
https://imazing.com/transfer-iphone-text-messages-to-computer
I personally thought that Python and it's plotting libraries were easier to learn than R.
Python libraries like Matplotlib are good for basic visualization (with some pretty good advanced stuff too) but with a bit of work, you can make some amazing visuals with Plotly, Bokeh, Seaborn, and Folium. Most of these libraries are also great for interactive visuals. You can google galleries to see!
The plotly site has a lot of great examples of what you can do: https://plot.ly/python/ .
A few years back I created a widget with Tasker that would automatically add a row in a Google Sheet with some information and a timestamp by pressing one of two buttons (start shift, end shift).
I used that because I wanted to log my work shifts and it integrated nicely with my budgeting spreadsheet, aka allowed me to estimate how much I'd earned that month, whether I was on track or if I needed to ask for extra shifts, etc. You can basically create a simple interface with a few buttons or text fields that would push all of that to a spreadsheet. Won't look as pretty as Loggable but it would be fully customisable.
There’s a lot of ways to implement your use case. Do you have any Natural Language Processing chops? Do you have access to a really beefy machine or a spark cluster? Python’s NLP Toolkit can do the word frequency counting. But counting word frequency across all US news outlets for the past 10 years is going to be pretty computationally intensive (if you can even find that comprehensive of a dataset).
I’d start with common crawls news dataset, although I’m not sure they have that 10 years of history: https://commoncrawl.org/2016/10/news-dataset-available/
At openweathermap we use several sources to provide data that is accessible via the API and other services. First of all, we use data from global and local providers, such as NOAA, Environment Canada, Met Office and others. Secondly, we employ data from a rich network of weather stations that are spread globally (around 80k of these), weather radars and satellites. On a third level use our own model as well. Data from these sources are then combined and monitored by our algorithms of accuracy verification. https://openweathermap.org/price#history
Thought the same as you:
https://www.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6
A spreadsheet should work for that. You can also create a Google Form that updates the spreadsheet if you prefer inputting information that way.
Alternatively, you can try creating something with a platform like Appsheet.
There's a really powerful app called Open Refine that might be relevant to you. I would suggest going over to their website and watching the short introduction videos.
After watching the videos, if it seems like this might hold some value for you, then I'd try installing it (it is free).
If you hit difficulties, just ask (either here, or in Open Refine's own communities). Small, specific requests are easiest on the people offering support. The difference between "help completing this task" vs. "help planning this project" is significant.
Sure thing! Hopefully it's helpful, and not stuff you already know or random gibberish.
If you don't have Python and Jupyter already, Anaconda (https://www.anaconda.com/) is definitely the easiest way to go about getting both set up.
Thanks, this helps.
Personally this whitepaper really pulled my Tableau data management skills up a notch. I never let anyone go to production without reading it first (or at least the parts that are relevant to whatever you are doing):
https://www.tableau.com/sites/default/files/whitepapers/designing-efficient-workbooks-v10.0.pdf
I appreciate you sharing this. It was helpful. I am just concerned how my VPN companies would respond to this with whom I am blindly trusting my online data with. ExpressVPN, Nord and Ivacy are till dat the most trutable, but nothing can be vouched for sure as their stance before and after May 25th would clarify a lot of things.