Depict Data Studio

DECEMBER 21, 2021

6,000 total participants in our dataviz training academy so far (with 5 cohorts going through our Full Courses in 2021 alone). Here are our favorite 21 data visualization resources from the past year. Knowing your audience” is terrible data visualization advice. Of course not. 28 blog posts. 14 YouTube videos. 1 new baby.

Visualization 105

Visualization Dashboards Statistics Reporting 105

O'Reilly on Data

OCTOBER 10, 2023

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. It’s a suggestion I would have expected from a mentor who had used Python and Pandas to work with data. Where is that data used?

Testing 182

Testing Modeling IT Risk 182

Depict Data Studio

FEBRUARY 25, 2020

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. Here’s how.

Visualization 52

Visualization Reporting IT 52

Depict Data Studio

MAY 9, 2022

She enrolled in our Dashboard Design course and is sharing how she used her new skills in her personal life. Before: Compiling the Data in a Spreadsheet. I decided to apply some of the lessons I learned in the Dashboard Design course to make the sheet more accessible. I had to do a bit of data cleaning first.

Dashboards 97

Dashboards Data Processing Consulting Testing 97

Depict Data Studio

FEBRUARY 18, 2020

Nowadays, you might hear it called “Quality Improvement Specialist,” “Research Analyst,” or even “Data Scientist.”. I was going on and on about all my great spreadsheet skills. These days, I spend most of my time training others on data visualization—which means I spend less time inside spreadsheets.

Testing 118

Testing Visualization Strategy IT 118

Depict Data Studio

AUGUST 10, 2021

Kristen Summers is the Senior Grants Manager at Saint Luke’s Foundation and a Depict Data Studio student. Fortunately, after completing about 70% of the Dashboard Design course, I was able to revitalize a tired spreadsheet into an information powerhouse and a colorful budget visualization into a professional presentation.

Visualization 52

Visualization Dashboards Testing Management 52

Depict Data Studio

DECEMBER 19, 2022

7,700 total participants in my dataviz courses so far. Here are my favorite data visualization resources from the past year. . I’ve talked about data storytelling a bajillion times, and this video encapsulates some of those key points. What Makes a Useful Data Story? Includes a spreadsheet you can download.

Dashboards 53

Dashboards Visualization Data Processing Reporting 53

CIO Business Intelligence

JANUARY 30, 2024

As CIO, you need a data strategy. What strategy really means Strategy is not just a course in business school. And strategy is most definitely not a “Well, we have a PowerPoint deck and a spreadsheet, so we are done” situation. When we started this century the buzz in IT was “everything is going to have a chip.”

Strategy 111

Strategy Consulting Measurement Big Data 111

Depict Data Studio

AUGUST 21, 2023

From a data prep perspective, one really long table is the correct way to store the underlying data. ” Let’s chat more about that distinction: storing underlying data vs. tables that look nice visually. But you’ll need different types of tables at different phases in the data analysis and visualization process.

Dashboards 52

Dashboards Visualization Statistics Interactive 52

Depict Data Studio

SEPTEMBER 4, 2023

In this example, let’s pretend we’re visualizing demographic data from an Excel spreadsheet, like this: Here’s how you’ll add your dataset to Tableau: Open Tableau Public. Unions are most often used when more data is coming in, and you need to add more rows to the bottom of the dataset. Open your file.

Dashboards 52

Dashboards Visualization Software IT 52

Depict Data Studio

MARCH 31, 2020

You might recognize Jon from our earlier interview about tips for doing and teaching data visualization in cultures other than your own. Our latest conversation was part of the Urban Institute’s Data@Urban Digital Discussions series. Which Data Visualization Trends Are Here to Stay? Tips for Presenting Data Over Video Calls.

Dashboards 103

Dashboards Visualization Reporting Consulting 103

Depict Data Studio

JULY 20, 2021

He was a guest speaker inside our data analysis course, Simple Spreadsheets. Bill’s first spreadsheet experience. Bill shared that his first time with a spreadsheet of any sort was in 1984 while he worked for a company that sold computer software. I recently had the honor of speaking with Bill Jelen, a.k.a.

Consulting 98

Consulting Software IT 98

Depict Data Studio

JUNE 6, 2022

I registered for the Simple Spreadsheets course because I was a beginner with using Excel and I knew I was utilizing only a fraction of its capabilities. Although this example was in the personal realm, I think there are potentially a lot of other applications for visualizing data in this way. The Challenge.

Visualization 111

Visualization Data Processing Reporting IT 111

Depict Data Studio

JUNE 8, 2021

Exploratory Data Visualization. First, we talked about my three favorite techniques for exploratory data visualization: Spark lines Data Bars Heat Tables. Want to add miniature trend lines to your spreadsheet? Here’s how: Highlight the data you want to visualize. Choose a solid-filled Data Bar. Spark Lines.

Visualization 119

Visualization 119

Jedox

JANUARY 28, 2021

A: I think the role is moving from the CFO, in a department that spends up to 80% of their time gathering data, maintaining spreadsheets, and building reports to what I like to call the CVO. Specifically, the data that the company holds and being able to collaborate with other business units.

Finance 64

Finance Digital Transformation Reporting Technology 64

Depict Data Studio

JUNE 2, 2020

One of the primary reasons for taking Ann’s data visualization course, Great Graphs , was to learn better ways to use Microsoft Excel as a visualization tool. Here’s how my own work and my students’ work evolved after taking the data visualization course. Training University Students on Data Visualization.

Visualization 52

Visualization Statistics Reporting Finance 52

Depict Data Studio

SEPTEMBER 18, 2023

dynamic) dashboards are a great option for technical audiences that have the time and interest to explore the data for themselves. This is semi-fictional data. We might check for and deal with missing data. We might add lots of new columns of recoded data. Want to make an interactive dashboard in Microsoft Excel?

Interactive 69

Interactive Dashboards Slice and Dice IT 69

Depict Data Studio

FEBRUARY 3, 2020

I’ve learned a lot through data viz thought leaders, especially Ann. I took her Soar Beyond the Dusty Shelf Report mini course and I am now working through her Simple Spreadsheets data analysis course. You’ll gain skills and your clients will be more engaged in their data and results. Use great data viz.

Reporting 101

Reporting Visualization Data Processing IT 101

Depict Data Studio

JUNE 23, 2020

I started building this course three years ago. This is a software how-to course. Research-based data visualization best practices are baked into the entire course. This course is NOT for supervisors who delegate all their graph production to someone else. We added to it, and added to it, and added to it.

Visualization 52

Visualization Reporting Software Consulting 52

Depict Data Studio

SEPTEMBER 22, 2020

I started out as an evaluator and I always loved the data viz side of my job. Some people love doing logic models or lit reviews, me I love poring through spreadsheets trying to figure out the pattern. Reasons Evaluators Should Be Learning About Data Visualization and Reporting. Data + Love with Zack Bowders.

Reporting 105

Reporting Visualization Dashboards IT 105

Jet Global

DECEMBER 12, 2019

Since its launch in 1985, Microsoft Excel has not only become the leading name in spreadsheet software but arguably also a second home (and language) to accountants and CFOs alike. Excel Charts, as its name suggests, focuses mainly on data visualization within Excel and offers attractive, user-friendly dashboarding to easily digest your data.

Dashboards 87

Dashboards Visualization Consulting Software 87

Depict Data Studio

JANUARY 9, 2023

Here’s what’s in store for 2023 related to: Online Courses, Private Training, Conference Keynotes, Data Visualization Consulting, and. Online Courses. I have courses on 6 different topics. Here’s the calendar: Great Graphs in Excel , my Excel-specific dataviz course: Registration closes on Friday, March 3.

Dashboards 40

Dashboards Consulting Visualization Data Processing 40

Depict Data Studio

SEPTEMBER 15, 2020

On her podcast, we talked about my unexpected shift from being an evaluator to a data visualization designer, along with my tips getting started working for yourself or teaching online. That way, each school can view their own data? My specialty, though, is data visualization. Watch Our Conversation. Listen to the Episode.

Visualization 105

Visualization Consulting Dashboards Reporting 105

datapine

JUNE 5, 2019

“It is a capital mistake to theorize before one has data.”– Data is all around us. Data has changed our lives in many ways, helping to improve the processes, initiatives, and innovations of organizations across sectors through the power of insight. Let’s kick things off by asking the question: what is a data dashboard?

Dashboards 316

Dashboards KPI Sales Visualization 316

Depict Data Studio

AUGUST 18, 2020

My audience can understand the information, so the data actually gets used. This course is NOT for supervisors who delegate all their report production to someone else. This course is NOT for graphic designers who exclusively use Adobe Illustrator or Acrobat. This course only opens once a year for registration.

Reporting 52

Reporting Visualization Dashboards Consulting 52

Octopai

JULY 9, 2020

Your Guide to Machine Learning Data Lineage for BI: From Source to Target. Too often, data lineage is considered a linear course that does little more than reveal the route data took to arrive at its final destination. Sick of all the manual mapping required to sort out inconsistencies in your data?

Insurance 86

Insurance Risk Management Machine Learning Metadata 86

erwin

OCTOBER 3, 2019

It provides a holistic, top down view of structure and systems, making it invaluable in managing the complexities of data-driven business. Of course, enterprise architecture can’t sit at the strategy table without results. Of course, this means organizations have a better understanding of what they should invest in.

Enterprise 111

Enterprise Cost-Benefit Data-driven Risk 111

Depict Data Studio

DECEMBER 8, 2020

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.

Dashboards 52

Dashboards Consulting Visualization Software 52

Jet Global

MARCH 17, 2020

The Office of the CFO in many global businesses is having to work quickly to pull together information on short notice to advise their boards on potential courses of action. . Despite the advances in automation, some finance teams still budget and forecast in spreadsheets, a manual process which is extremely prone to error.

Forecasting 97

Forecasting Sales Marketing Finance 97

Depict Data Studio

DECEMBER 18, 2023

9,200 total participants in my dataviz courses so far (and ~25,000 taught virtually and in-person over the past decade). Here are my favorite data visualization resources from the past year. How to Influence Others with Your Data: SuperDataScience Podcast Interview : I was invited to speak on the #1 podcast in the data field.

Visualization 52

Visualization Dashboards Reporting Data Processing 52

Depict Data Studio

OCTOBER 20, 2020

We’ll simply remove the borders that outline each of the twelve data points. I grouped the twelve data points into categories: Visitors (blue), Transactions (purple), and New Materials Acquired (turquoise). Download the Spreadsheets. Dashboard Design: The Full Course opens for once-a-year registration in November 2020.

Reporting 102

Reporting Dashboards Visualization Metrics 102

Jet Global

OCTOBER 12, 2022

A better approach is to proactively manage transfer pricing throughout the course of the year using purpose-built transfer pricing software. The fact that the data is constantly changing renders this task even more challenging. Last-minute transfer pricing changes can have significant real-world implications for the organization.

Software 52

Software Finance Uncertainty Risk 52

datapine

JULY 8, 2020

Moreover, companies are becoming more data-driven, complex, and require stable performance in order to succeed in our cutthroat digital age. Such a real-time dashboard ensures productivity increment and centralized data collection that enables executives to overcome numerous operational challenges within their line of work.

Dashboards 202

Dashboards Reporting Metrics Visualization 202

Depict Data Studio

APRIL 27, 2020

I Was Going to Wait… I was going to wait and open registration for our dataviz course in a few more months, once things get back to “normal.” Media outlets are reporting that their COVID-19 data visualizations are their most viewed pages. This is our flagship data visualization course. Pause the videos.

Visualization 52

Visualization Software Reporting Dashboards 52

Depict Data Studio

APRIL 10, 2023

Visualizing data in charts, graphs, dashboards, and infographics is one of the most powerful strategies for getting your numbers out of your spreadsheets and into real-world conversations. But it can be overwhelming to get started with data visualization. If so, this step-by-step data visualization guide is for you!

Visualization 105

Visualization Dashboards Testing Reporting 105

Depict Data Studio

JANUARY 23, 2023

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

Testing Metrics IT Software 52

Depict Data Studio

SEPTEMBER 17, 2019

In my sixth year of self-employment, the demand for data visualization skills is stronger than ever. Are you ready to take your organization’s data communications skills to the next level? The once-a-year enrollment period is now open for Great Graphs: Transform Spreadsheets into Stories. Re-watch them as many times as you need.

Visualization 40

Visualization Consulting Dashboards Reporting 40