Depict Data Studio

JANUARY 4, 2022

Here’s what’s in store for 2022 related to: Online Courses, Private Training, Data Visualization Consulting, and Personal and Professional Goals. Online Courses. This is our complimentary mini course. It’s a why-to mindset course that prepares you for the how-to courses you’ll take later on. Simple Spreadsheets.

Dashboards 123

Dashboards Consulting Visualization Reporting 123

Depict Data Studio

FEBRUARY 18, 2020

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. Download the spreadsheet here: Download the spreadsheet. Download the spreadsheet here: Download the spreadsheet.

Testing 118

Testing Visualization Strategy IT 118

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). Of course not. He was a guest speaker inside our data analysis course, Simple Spreadsheets , and is a big, big deal in the Excel community! 28 blog posts. 14 YouTube videos. 1 new baby.

Visualization 105

Visualization Dashboards Statistics Reporting 105

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

AUGUST 10, 2021

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. But the course showed me what little changes I could make to have a big impact. The Budget.

Visualization 52

Visualization Dashboards Testing Management 52

Depict Data Studio

JANUARY 23, 2023

Collecting Survey Data at HOPE International So what exactly does this have to do with spreadsheets? 6 Data Cleaning Steps to Save You Millions I’d like to show you what we do for our data cleaning process, and how Simple Spreadsheets helped to make this process even stronger. The result was a $125 million conversion error.

Testing 52

Testing Metrics IT Software 52

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. Your spreadsheets might come from…. Oftentimes, at least some spreadsheets are entered by hand. Typos Are Not Inevitable!!!

Visualization 52

Visualization Reporting IT 52

Depict Data Studio

FEBRUARY 3, 2020

I took her Soar Beyond the Dusty Shelf Report mini course and I am now working through her Simple Spreadsheets data analysis course. When I founded Community Evaluation Solutions (CES), I told myself it was: okay to make mistakes, and I never wanted to stop learning. Our Organization’s Transformation.

Reporting 101

Reporting Visualization Data Processing IT 101

Depict Data Studio

SEPTEMBER 18, 2023

You can learn more about cleaning, recoding, and transforming datasets inside Simple Spreadsheets , my prerequisite course. You can walk through each of the steps in more detail, and download the spreadsheets to follow, and come to live Office Hours inside the Dashboard Design course.

Interactive 69

Interactive Dashboards Slice and Dice IT 69

datapine

JUNE 5, 2019

We’ll discuss the primary features or benefits of BI-powered dashboards in due course. However, what you (the end user) see are simple tables, charts, and graphs – all in real time. One of the biggest advantages data dashboards have over more traditional spreadsheets is that they are almost infinitely customizable and flexible.

Dashboards 316

Dashboards KPI Sales Visualization 316

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. My Own Challenges to Communicating Results.

Visualization 52

Visualization Statistics Reporting Finance 52

Depict Data Studio

MARCH 31, 2020

I can speak on podcasts, video calls, and record online courses from anywhere with minimal tech equipment. It’s small so it even fits in my backpack while traveling for work, which means I can record online courses or speak on podcasts from anywhere in the world. Lessons Learned from Teaching Online Courses. It takes practice.

Dashboards 103

Dashboards Visualization Reporting Consulting 103

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). Host Jon Krohn asked me to summarize some of my favorite tips for data storytelling, spreadsheets, reports, and presentations. 32 new blog posts : 28 from me , and 4 from guest authors. 2 more podcast interviews.

Visualization 52

Visualization Dashboards Reporting Data Processing 52

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

Jedox

DECEMBER 3, 2020

How will you keep the user experience as simple as possible? Legacy solution users will also want to look for familiar features: an in-memory OLAP database, an easy to model multi-cube architecture and cell-based spreadsheet style reporting. Cost, of course, is always an important consideration.

OLAP 56

OLAP Cost-Benefit Data-driven Finance 56

Jet Global

APRIL 9, 2021

Of course, Oracle provides native reporting and analytics tools in Oracle ERP Cloud, but in many cases, those tools do not address the specific needs of finance teams. Finance teams no longer have the luxury of time to manually copy and paste data from multiple systems into Excel spreadsheets for analysis.

Operational Reporting 52

Operational Reporting Reporting Finance Interactive 52

Jedox

MAY 7, 2020

To successfully move from outdated spreadsheet workflows to using integrated financial planning, there are important considerations on this path. The recognition that old structures in FP&A must be revamped is of course old news, yet many organizations are still struggling with doing the needed revamp.

Uncertainty 86

Uncertainty Digital Transformation Finance Risk 86

Jet Global

JANUARY 6, 2020

Arming decision-makers across the enterprise with the best, most current information helps them bring the future into focus while making the right course of action clear. Hubble removes the IT team from the equation by offering users at all levels a reporting toolkit that’s simple enough to facilitate true self-serve reporting.

Reporting 83

Reporting Finance Consulting Software 83

Depict Data Studio

APRIL 11, 2019

All too often, I witness organizations drone on and on about simple survey results. Keep simple things simple, please. I needed to strike a balance: Keep the makeover simple while providing details about where the agency could do even better. Once-a-Year Enrollment for My Data Analysis Course is Now Open!

Visualization 56

Visualization Dashboards Reporting IT 56

Octopai

JANUARY 31, 2022

It is, of course, possible that you have an enemy – and that we shall find out. Another issue with multiple data systems is that even if everyone starts out on the same page, it’s not simple to keep everyone on the same page. Holmes, after taking a long puff of his pipe, agrees to take on the case. Asymmetrical data. asked Guy.

Metadata 77

Metadata IT Unstructured Data IoT 77

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. List all your audience types on a piece of paper, or a whiteboard, or in a spreadsheet, or even on the back of a napkin.

Visualization 105

Visualization Dashboards Testing Reporting 105

Jet Global

MARCH 23, 2020

It explains what forces led the company to its present position, what that means for the stakeholders involved, and what the next course of action should be. These visualizations were available before, of course, but they were extremely time- and labor-intensive to produce, and rare as a result.

Visualization 59

Visualization Advertising Data-driven Finance 59

Jet Global

AUGUST 19, 2020

That may include enterprise resource planning (ERP) software, specialized billing or customer management applications, Excel spreadsheets, and external systems. Manual processes : With all those systems, most finance and accounting teams are faced with the tedious task of gathering reports, statements, and spreadsheets from multiple sources.

Reporting 72

Reporting Finance Cost-Benefit Data-driven 72

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

MARCH 23, 2021

I’ve got video resources in everyday language inside our Simple Spreadsheets course. Is your student demographic data living in one spreadsheet? And your test scores are living in another spreadsheet? We’ll need to combine those two spreadsheets together. Duplicates. Merging Variables Together.

Analytics 52

Analytics Visualization Testing Measurement 52

Depict Data Studio

JULY 13, 2021

They were recently guest speakers in our Simple Spreadsheets course and had so many great insights! – — Thank you to Ann Emery, Depict Data Studio, and her Simple Spreadsheets class for inviting us to talk to them about the use of statistics in nonprofit program evaluation! & Alison Nagel, Ph.D

Statistics 98

Statistics Testing Recreation/Entertainment Experimentation 98

Juice Analytics

MARCH 1, 2022

Of course this isn’t a problem created by Tableau. Rename or alias field names to be clear and simple, especially for Quick Tableau Calcs. Instant Juicebox Score: 4 This is an important concept: you don’t want to expose your dashboard audience to the messy data field labels that come from your spreadsheet or database.

Dashboards 64

Dashboards Visualization Interactive Data Processing 64

Depict Data Studio

MAY 25, 2020

We did the spreadsheet math a dozen times. I finished building my Great Graphs: Design Principles course from the Airbnb during the day, and we relaxed in the hot tub at night. I designed and recorded my entire Report Redesign online course while looking out at the ocean. I wanted to be with my family all the time. esque vibe.

Visualization 111

Visualization Consulting Cost-Benefit Recreation/Entertainment 111

Jet Global

JANUARY 22, 2020

Turning raw data into actionable or strategic insights typically involves putting it through a financial reporting process based around the ERP and an army of static Excel spreadsheets. Common as this problem may be, the solution is surprisingly simple: Take the heavy-lifting out of financial reporting.

Reporting 78

Reporting Snapshot Data-driven Uncertainty 78

Sisense

JANUARY 7, 2022

” Despite the need to be agile, efficient, and transparent in managing risk, alarmingly, some corporations are still using spreadsheets instead of robust learning management systems. The reinsurer now plans to roll out the DGF course within the IT division as mandatory training. Minimising risk by ‘infusing’ AI.

Risk Management 52

Risk Management Risk Management Dashboards 52

Jet Global

JANUARY 4, 2021

Capturing data from an organization’s frontlines within the framework of continuous financial planning is not always so simple. Organizations faced many critical business decisions throughout 2020, and their ability to take the best course of actions often hinged on the results of proactive assessment.

Forecasting 98

Forecasting Finance Testing Sales 98

Jet Global

MARCH 30, 2020

When Excel was first released in 1985, it changed the course of business forever. Spreadsheets were nothing new at that point, even in electronic format, but Excel made them intuitive and accessible in a way that had never been possible before. Speed-o-Meter Chart. Eliminate grid/graph lines behind charts to cut down on visual clutter.

Finance 75

Finance Visualization Dashboards Metrics 75

Sisense

JANUARY 13, 2021

Building trust in the accuracy of the data and the BI system was an important step in encouraging departments to begin using the new system instead of spreadsheets and manual processes. . Reducing the number of human touchpoints and Excel spreadsheets from different departments in the process has improved accuracy. Mobile data access.

Sales 59

Sales Dashboards Management Finance 59

Occam's Razor

FEBRUARY 25, 2013

In part two, we are going to build on the formula and create a model (ok, spreadsheet :)) that you can use to compute ROA for your own company. The ROI calculation is cliché and overused because it’s so simple, even a child could do it: * How much did you invest? * Simple and amazing, right? You can start with something simple.

Analytics 142

Analytics ROI Marketing Modeling 142

Jedox

NOVEMBER 18, 2021

Do you still work with spreadsheet programs such as Excel in S&OP planning, analysis, and reporting? Then you are currently in Stage 1 of the maturity model in which spreadsheets need to be updated, sent between departments and are often stored on local drives. Stage 1 – no shared goals. Are you lacking common goals?

Forecasting 52

Forecasting Sales Optimization Finance 52

Smart Data Collective

MARCH 5, 2022

Since it’s so simple, you can start and run your own dropshipping business , you just need to get the basics set up. Of course, there is also the great platform of Sellvia that will help to get your side hustle set up and started. It’s the perfect side hustle to start, as it’s so easy to do.

Data mining 133

Data mining Big Data Data-driven Data Science 133

Jet Global

NOVEMBER 11, 2020

When so many variables are in flux, it’s the transfer pricing team’s job to notice whenever a subsidiary is off course and in danger of failing to hit its forecasted ETR. At the same time, the transfer pricing team can also work with the business unit heads of affected subsidiaries to get their perspective on what’s happening operationally.

Forecasting 98

Forecasting Finance Marketing Software 98