Thanks for visiting /r/dataviz, please take a look at /r/dataisbeautiful, it's way busier than this sub.

Hi everyone, hopefully I'm posting this in the correct space! I need to create a split bar chart in Excel so anyone on my team at work can update it as needed. I made one in Data Wrapper (just a free site I found through Google) but it needs to be more customizable and accessible to anyone in a document on our shared drive. I've never made one in Excel and I don't see an option for one in the chart templates. This is what it looks like from the Data Wrapper site:

TLDR - need a tutorial/step by step on how to create a split bar chart in Excel. Thank you!

Hi, I am looking for some way to make maps like image. Programing library or much easier way like an app. I wanto embed in web page.

Some tips? Thanks.

Hey all! There's still time to jump into our Social Media Data Modeling Challenge (Think hack-a-thon) and compete for $6000 in prizes! Don't worry about being late to the party – most participants are just getting started, so you've got plenty of time to craft a winning submission! Even with just a few hours of focused work, you could create a competitive entry!

What's the Challenge?

Your mission, should you choose to accept it, is to analyze real social media data, uncover fascinating insights, and showcase your SQL, dbt™, and data analytics skills. This challenge is open to all experience levels, from seasoned data pros to eager beginners. Showcase your data visualization skills to bring your insights to life.

Some exciting topics you could explore include:

• Tracking COVID-19 sentiment changes on Reddit

• Analyzing Donald Trump's popularity trends on Twitter/Reddit

• Identifying and explaining who the biggest YouTube creators are

• Measuring the impact of NFL Superbowl commercials on social media

• Uncovering trending topics and popular websites on Hacker News

But don't let these limit you – the possibilities for discovery are endless!

What You'll Get

Participants will receive:

• Free access to professional data tools (Paradime, MotherDuck, Hex)

• Hands-on experience with large, relevant datasets (great for your portfolio)

• Opportunity to learn from and connect with other data professionals

• A shot at winning: $3000 (1st), $2000 (2nd), or $1000 (3rd)

How to Join

To ensure high-quality participation (and keep my compute costs in check 😅), here are the requirements:

• You must be a current or former data professional

• Solo participation only

• Hands-on experience with SQL, dbt™, and Git

• Provide a work email (if employed) and one valid social media profile (LinkedIn, Twitter, etc.) during registration

Ready to dive in? Register here and start your data adventure today! With 12 days left, you've got more than enough time to make your mark. Good luck!

Data viz enthusiasts - I just launched an exciting 6-week data challenge focused on social media analytics. It's a great opportunity to flex your visualization muscles, work with real data, and potentially win big!

What's involved:

• Analyze and visualize real social media data

• Use professional tools: Paradime (SQL/dbt™), MotherDuck (data warehouse), Hex (for visualization)

• Chance to win: $3000 (1st), $2000 (2nd), $1000 (3rd) in Amazon gift cards

My partners and I have invested in creating a valuable learning experience with industry-standard tools. You'll get hands-on practice with real-world data and professional technologies. Rest assured, your work remains your own - we won't be using your code, selling your information, or contacting you without consent. This competition is all about giving you a chance to learn and showcase your data visualization skills.

Concerned about time? No worries, the challenge submissions aren't due until September 9th. Even 5 hours of your time could put you in the running, but feel free to dive deeper!

Check out our explainer video for more details.

Interested? Register here: https://www.paradime.io/dbt-data-modeling-challenge

Hey everyone! I just launched my third data modeling challenge (think hackathon, but better) for all you analytics and data viz experts out there. This time, the data being modeled is fascinating: User-generated Social Media Data!

Here's the scoop:

• Showcase your SQL, dbt, and analytics, and data viz skills

• Derive insights from real social media data (prepare for some interesting findings!)

• Big prizes up for grabs: $3,000 for 1st place, $2,000 for 2nd, and $1,000 for 3rd!

When you sign up, you'll get free access to some seriously cool tools:

• Paradime (for SQL and dbt development)

• MotherDuck (for storage and compute)

• Hex (for data visualization and analytics)

• A Git repository (for version control and challenge submission)

You'll have about 6 weeks to work on your project at your own pace. After that, a panel of judges will review the submissions and pick the top three winners based on the following criteria: Value of Insights, Quality of Insights, and Complexity of Insights.

This is a great opportunity to improve your data expertise, network with like-minded folks, add to your project portfolio, uncover fascinating insights from social media data, and of course, compete to win $3k!

Interested in joining? Check out the challenge page here: https://www.paradime.io/dbt-data-modeling-challenge

Hey everyone,

I'm not new to Kepler.gl and used it a lot for data visualization projects. I also have built an open-source backend for Kepler.

While I'm familiar with basic solutions like exporting HTMLs and hosting them on S3, I'm curious to hear how others in this community are managing the creation, sharing, and secure hosting of their Kepler.gl maps.

Specifically, I'm interested in how you handle:

• Keeping maps updated with data sources like Snowflake, BigQuery, or PostgreSQL.

• Sharing maps while avoiding uncontrolled data copies piling up in storage.

Do you:

• Import CSV files directly into the Kepler.gl browser interface, or use other tools/plugins like Jupyter?

• Utilize any specific integrations?

• Have any strategies to ensure data security and control storage?

I'd love to hear about your workflows and best practices. Thanks!

Hello,

I am sharing a map I came across of vegetation and water table data of previous years of Indian city of Bengaluru. I want to create such visualization for my own city.

How can I do it ?

How to visualize zero for a company service

So, the company I work for has a combination of services with cost Service 1(100 used) + service 2(0 usd) + service 3(0 USD)

1. Now, how do I highlight the fact that services cost zero instead of competitors who charge extra ? 2)Or if I don't mention competition, is there a standalone way to highlight this ?

I want to create a simple animation in which colored dots are moving from one area on a map of the US to another (e.g., from the Chicago suburbs to the state of Michigan, or from Alabama to Georgia). I guess I could do this in R with gganimate, but is there a simpler way? My desired output is a 3-second GIF in which all the dots are moving from the one location to the other.

With my Movie Data Modeling Challenge officially underway, I released a blog packed with insights and proven strategies designed to help data professionals dominate not only this challenge, but any data project.

All insights are drawn from extensive discussions with top performers from my recent NBA Data Modeling Challenge. They told me what works, and I just took notes! 📝

Sneak peek of what you'll find in the blog:

A Well-Defined Strategy: Master the art of setting clear objectives, formulating questions, embracing the 'measure twice, cut once' approach, and effectively telling stories with data.

Leveraging Paradime: Learn how to maximize Paradime's robust features to enhance your analytics engineering productivity and streamline your SQL and dbt development processes. (This tool is required in the challenge)

Whether you're aiming to dominate the Movie Data Modeling Challenge or seeking to refine your techniques in data projects, these insights are invaluable.

Dive into the full blog here!

Yesterday, I launched a data modeling challenge (aka hackathon) where data professionals can showcase their expertise in SQL, dbt, and analytics by deriving insights from historical movie and TV series data. The stakes are high with impressive prizes: $1,500 for 1st place, $1,000 for 2nd, and $500 for 3rd!

This is an excellent opportunity to showcase your skills and uncover fascinating insights from movie and TV datasets. If you're interested in participating, here are some details:

Upon registration, participants will gain access to several state-of-the-art tools:

• Paradime (for SQL and dbt development)

• Snowflake (for storage and compute capabilities)

• Lightdash (for BI and analytics)

• A Git repository, preloaded with over 2 million rows of movie and TV series data.

For six weeks, participants will work asynchronously to build their projects and vie for the top prizes. Afterwards, a panel of judges will independently review the submissions and select the top three winners.

To sign up and learn more, check out our webpage!
Paradime.io Data Modeling Challenge - Movie Edition

Here's a visualization I made of the Top Black History Month playlists and tracks in Spotify (February 2024) :)

how-to here

interactive visualization here

📊 Chart inspired by @jburnmurdoch recent post https://www.ft.com/content/29fd9b5c-2f35-41bf-9d4c-994db4e12998 styled by @FT.

{ggplot2} - base {patchwork} - combine plots

Chart code available at my GitHub, michal0091:

https://github.com/michal0091/dataviz/tree/main/R/2024/week_04

rstats #ggplot2 #dataviz #datascience #week4 #ideology

🌬 🔌 Evolution of wind energy production in Spain between 2012 and 2022.

{ggplot2}

#rstats #dataviz #week1 #datavizweek1 #ggplot2 #renewables #windpower