Remove courses data-analysis-in-spreadsheets
article thumbnail

Visualizing 24 School Divisions’ Submissions with a Dashboard in Microsoft Excel

Depict Data Studio

This guest post comes from Amadu Sidi Bah, who’s graduated from our Simple Spreadsheets, Great Graphs, Report Redesign, and Dashboard Design courses. I was tasked with supporting the project team with data analysis and preparing the policy options paper. Great work, Amadu! — Ann K.

article thumbnail

The top 15 big data and data analytics certifications

CIO Business Intelligence

Data and big data analytics are the lifeblood of any successful business. Getting the technology right can be challenging but building the right team with the right skills to undertake data initiatives can be even harder — a challenge reflected in the rising demand for big data and analytics skills and certifications.

Big Data 126
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Automated Mentoring with ChatGPT

O'Reilly on Data

Second Try: Python and Data in Spreadsheets My next experiment was with a short Python program that used the Pandas library to analyze survey data stored in an Excel spreadsheet. Ethan and Lilach Mollick’s paper Assigning AI: Seven Approaches for Students with Prompts explores seven ways to use AI in teaching.

Testing 183
article thumbnail

12 data science certifications that will pay off

CIO Business Intelligence

Data scientist is one of the hottest jobs in IT. Companies are increasingly eager to hire data professionals who can make sense of the wide array of data the business collects. According to data from PayScale, $99,842 is the average base salary for a data scientist in 2024.

article thumbnail

How to Enter Cleaner Data AND Automate the Entire Analysis and Visualization Process

Depict Data Studio

This is a brand new bonus module for current and past students in my data analysis course, Simple Spreadsheets: From Spreadsheet Stress to Superstardom with Microsoft Excel. — “How can I get cleaner data???”. Later on, you have to do all this data cleaning… and you have a mess of entries.

article thumbnail

Watch Out for Mars! 6 Data Cleaning Steps to Save You Millions

Depict Data Studio

The answer, surprisingly, is that the crash was caused by a classic case of BAD DATA. That’s right–this spacecraft, this wonder of science, was rendered useless by bad data being entered into its flawless system. Collecting Survey Data at HOPE International So what exactly does this have to do with spreadsheets?

Testing 52
article thumbnail

Getting Started with Google Sheets: Conversation with Ben L. Collins

Depict Data Studio

Ben joined as a special guest at Office Hours (special live sessions for full course students where we share ideas and give feedback on each other’s projects). He started his own business 5 years ago teaching online courses using Google software. Prior to that he was an accountant which is how he got his start with spreadsheets.