#Data visualizations

[resonance-reblogs]

In addition to the above, this is also a neat resource - it pulls data from several of the various orgs mentioned and visualizes it on a globe. You can get wind speed at various atmospheric layers, ocean currents, air and ocean temperature, precipitation and humidity, particulates and various greenhouse gas concentrations, all kinds of neat things. Whenever it's smoky out and we don't know of any fires nearby, we usually pull up this site first and look at where it's being carried in from.

Anyway - enjoy!

Noticed something a little funky in the world around you and want to figure out what's up? Especially if there might be something you ought to be doing about it? Not sure what information sources to trust these days? If you're in the US, federal agencies like NOAA, USGS, EPA and more collect massive amounts of scientific data every day, much of which is publicly available online - if you know where to look.

A PDF version with clickable links is available for free on my itchio page (quakeandquiver); I'll add a direct link in a reblog.

[techtrendslive]

Bring your data to life with D3.js. This JavaScript library helps transform static charts into interactive stories.

With Gartner predicting that Data Storytelling will drive Business Intelligence in 2025, mastering D3.js can be a career game-changer for you.

Learn how to visualize data like never before. Dive deeper with USDSI®: http://bit.ly/3TACLxN https://youtu.be/8EtSLpyUPgg

[techinfotrends]

Do you want to create smart and impactful data visualizations? Unleash the best amalgam of pandas and Matplotlib for orchestrating data-wrangling tools to succeed!

[technologyblogofmohit]

Unleash the Power of Data with the RIght Tableau Developers

Are you ready to unlock the power of data?

A Tableau developer is like a magician who can transform raw data into actionable insights. From integrating and preparing data to creating stunning visualizations and optimizing performance, these developers play a crucial role. Tableau empowers businesses to make data-driven decisions that drive success.

Look how to select the best Tableau Developers and harness the power of Tableau!

Read here!

[orsonblogger]

Vena Introduces Vena For Microsoft PowerPoint, Purpose-Built To Help Strategic Finance

Vena introduces Vena for Microsoft PowerPoint, integrating with Microsoft 365 to empower strategic finance and operations teams in transforming data into impactful presentations. This native integration merges Vena's reporting and analytics prowess with PowerPoint's familiar interface, enabling finance professionals to craft compelling narratives seamlessly.

With Vena for Microsoft PowerPoint, users can dynamically connect charts, tables, and dashboards to slides, interact with real-time data, and collaborate in building narratives from anywhere. This streamlined process reduces the time spent on presentations, enhances data storytelling, and improves team alignment and decision-making. Early adopters like Bell Partners report significant productivity gains, with monthly reporting updates taking minutes instead of hours. This integration reflects Vena's commitment to driving business insights and empowering users to leverage the full potential of their financial and operational data.

Read More - https://www.techdogs.com/tech-news/business-wire/vena-introduces-vena-for-microsoft-powerpoint-purpose-built-to-help-strategic-finance-and-operations-professionals-revolutionize-turning-data-into-impactful-stories

[associative7]

Unleash the Power of Data Analysis with R Development at Associative, Pune

In today’s data-driven world, businesses need powerful tools to extract valuable insights from their ever-growing information. R, a free and open-source programming language, has become a go-to choice for statistical computing and graphics. Here at Associative, a leading software development and consulting company in Pune, India, we offer expert R development services to empower your data analysis capabilities.

Why Choose R for Data Analysis?

R boasts a unique set of features that make it ideal for data analysis tasks:

Statistical Powerhouse: R offers a vast library of statistical functions and packages, allowing you to perform complex analyses with ease.

Data Visualization: Create compelling and informative data visualizations with R’s rich graphics capabilities.

Open-Source & Community-Driven: Benefit from a large and active community that constantly innovates and contributes new packages, keeping R at the forefront of data science.

Flexibility & Customization: R’s open-source nature allows for extensive customization and tailoring to your specific data analysis needs.

Associative: Your R Development Partner

Associative’s team of experienced R developers in Pune brings a wealth of knowledge and expertise to your data analysis projects:

Data Wrangling & Cleaning: We’ll meticulously prepare your data for analysis, ensuring its accuracy and completeness.

Statistical Modeling & Analysis: Our developers will leverage R’s capabilities to build robust statistical models that uncover hidden patterns and trends within your data.

Interactive Data Dashboards & Reports: We’ll create interactive dashboards and reports that effectively communicate data insights to stakeholders.

Custom R Package Development: Need specialized functionality? Our team can develop custom R packages to address your unique data analysis requirements.

R Integration with Existing Systems: We’ll seamlessly integrate R with your existing data infrastructure for a streamlined workflow.

Unlock Data-Driven Decisions with Associative

By partnering with Associative for your R development needs, you gain access to a team of skilled developers who can transform your raw data into actionable insights. We are committed to helping you leverage the power of R to make informed decisions and achieve your business goals.

Ready to harness the potential of R for your data analysis?

[datavalleyai]

The Role of a Senior Data Engineer: Key Responsibilities and Skills

Data Engineers play a crucial role in today's data-driven world. They collect, process, and store data, enabling data scientists and analysts to utilize it effectively. As the data landscape evolves, the demand for Senior Data Engineers continues to rise. In this article, we will explore the evolving role of a Senior Data Engineer, essential skills required to excel in this role and how a course at Datavalley can help you acquire and hone these skills.

The Evolving Role of a Data Engineer

Senior data engineers are accountable for building and upkeeping data collection systems, pipelines, and management tools. They oversee the activities of junior data engineers and the architectures themselves. While this role has always been essential, it has evolved significantly in recent years due to the proliferation of big data and cloud technologies. Here are some key aspects of a Senior Data Engineer's responsibilities:

1. Data Ingestion:

One of the primary tasks of a Data Engineer is to design systems that can efficiently ingest data from various sources, such as databases, APIs, and streaming platforms. This requires expertise in tools like Apache Kafka, Apache Nifi, or cloud-based solutions like AWS Kinesis.

2. Data Modeling and Transformation:

Data engineers play a critical role in creating data models that enhance data accessibility and comprehension for non-technical stakeholders, including analysts and data scientists.

Data Engineers need to create and manage data pipelines that transform raw data into a format suitable for analysis. Proficiency in SQL is crucial for data modeling, and ETL (Extract, Transform, Load) tools like Apache Spark or Talend are commonly used for data transformation.

3. Collaborative Engagement

Daily meetings are a fundamental aspect of a data engineer's routine. These meetings often include the daily scrum, where team members discuss recent achievements, ongoing tasks, and potential obstacles.

Additionally, data engineers actively participate in cross-functional meetings, collaborating with data scientists, data analysts, product managers, and application developers.

4. Data Storage and Data Query Optimization:

Selecting the right data storage solution is critical for performance and scalability. Data Engineers should be well-versed in traditional databases (e.g., PostgreSQL, MySQL) as well as NoSQL databases (e.g., MongoDB, Cassandra) and cloud-based storage options (e.g., Amazon S3, Azure Data Lake Storage).

As data volumes continue to grow, data engineers are tasked with optimizing data queries to ensure efficient data retrieval. This optimization process may involve the creation of indexes, data restructuring, or data aggregation to facilitate quicker queries.

5. Data Quality and Governance:

Ensuring data accuracy and compliance with regulations is vital. Data Engineers must implement data quality checks, data lineage tracking, and access controls to maintain data integrity.

6. Cloud Computing:

The cloud has revolutionized data engineering. Familiarity with cloud platforms like AWS, Azure, or Google Cloud is essential, as many organizations are migrating their data infrastructure to the cloud.

7. DevOps and Automation:

Data Engineers often collaborate closely with DevOps teams to automate deployment, scaling, and monitoring of data pipelines. Proficiency in tools like Docker and Kubernetes is increasingly valuable.

Data engineers are instrumental in managing the data infrastructure that underpins data processing and storage. This aspect of their role often encompasses a combination of development and operational tasks, particularly in larger teams.

8. Facilitating Data Flow

In essence, data engineers serve as intermediaries between data sources, storage systems, and end-users. Their role is to ensure the smooth flow of data within an organization, making certain that data is readily available and accessible to those who require it.

By bridging the gap between technology and business, data engineers empower analysts and data scientists to focus on deriving insights rather than grappling with data retrieval and manipulation.

9. Data Security:

Protecting sensitive data is a top priority. Knowledge of encryption techniques, IAM (Identity and Access Management), and security best practices is crucial.

Essential Skills for a Senior Data Engineer

Now that we've outlined the evolving role of a Senior Data Engineer, let's delve into the essential skills needed to excel in this field.

1. Strong Programming Skills:

A Senior Data Engineer should be proficient in at least one programming language commonly used in data engineering, such as Python, Java, or Scala. These languages are essential for building data pipelines and working with big data frameworks.

2. Proficiency in SQL:

SQL is the backbone of data manipulation and querying. A Senior Data Engineer should have a deep understanding of SQL to design efficient database schemas and perform complex data transformations.

3. Data Modeling:

Creating effective data models is crucial for organizing data and ensuring its accessibility and usability. Skills in data modeling techniques like entity-relationship diagrams and star schemas are invaluable. Getting advanced data engineering certifications with Snowflake’s cloud-based platform would be beneficial.

4. Big Data Technologies:

Familiarity with big data technologies such as Apache Hadoop, Spark, and Flink is essential. These tools are used for processing and analyzing massive datasets efficiently.

5. Cloud Platforms:

As mentioned earlier, cloud platforms like AWS, Azure Cloud Services, and Google Cloud Platform are increasingly central to data engineering. Knowledge of these platforms, including services like AWS Lambda and Azure Data Factory, is a must.

6. ETL Tools:

Data Engineers need expertise in ETL tools like Apache NiFi, Talend, or cloud-based alternatives to streamline data integration and transformation processes.

7. Database Management:

A deep understanding of both SQL and NoSQL databases is essential. Data Engineers should be able to design, optimize, and manage databases effectively.

8. Data Pipeline Orchestration:

Tools like Apache Airflow or cloud-native solutions like AWS Step Functions are essential for orchestrating complex data pipelines.

9. Version Control:

Proficiency with version control systems like Git is essential for collaboration and code management in data engineering projects.

10. Interpersonal Skills:

Communication, problem-solving, and teamwork are equally important for a Senior Data Engineer. They often collaborate with data scientists, analysts, and business stakeholders, so effective communication is vital.

Why Datavalley for Data Engineer?

To acquire and master these essential skills for a Senior Data Engineer, consider enrolling in a course at Datavalley. Datavalley offers a comprehensive Data Engineer program designed to provide hands-on experience and in-depth knowledge in all the areas mentioned above. Here's why Datavalley is the right choice:

Comprehensive Curriculum: Our courses cover Python, SQL fundamentals, Snowflake advanced data engineering, cloud computing, Azure cloud services, ETL, Big Data foundations, DevOps, Data lake, AWS data analytics.

1. Expert Instructors: Datavalley's courses are led by experienced data engineers who have worked in the industry for years. Experts teach modules to broaden your understanding and provide industrial insights.

2. Hands-on Projects: The best way to learn is by doing. Datavalley's curriculum includes hands-on projects that allow you to apply your skills in real-world scenarios.

3. Cutting-edge Tools and Technologies: Datavalley stays up-to-date with the latest tools and technologies used in the field of data engineering. You'll learn the most relevant and in-demand skills.

4. Industry Networking: We provide opportunities to connect with industry professionals, helping you build a network that can be invaluable in your career.

5. Career Support: Datavalley goes beyond teaching technical skills. They offer career support services, including resume reviews and interview coaching, to help you land your dream job.

6. Project-Ready, Not Just Job-Ready: Our program prepares you to start working and carry out projects with confidence.

7. On-call Project Assistance After Landing Your Dream Job: Our experts will help you excel in your new role with 3 months of on-call project assistance.

Conclusion

Becoming a Senior Data Engineer requires a diverse set of technical skills and a deep understanding of data infrastructure. As data continues to grow in importance, so does the demand for skilled data engineers.

Datavalley's Big Data Engineer Masters Program can provide you with the knowledge and practical experience you need to excel in this role. Whether you're looking to advance your career or enter the field of data engineering, Datavalley is the right choice to help you achieve your goals. Invest in your future as a Senior Data Engineer and unlock the potential of data on your journey.

[allgremlinyaps]

some more zukaang doodles a la flavor de aged up Aang!au......

[nyaa]

北へ。/ Kita e. White Illumination (1999) Sega Dreamcast

[alienorchids]

MALICE MIZER postcard, 1999

[scipunk]

Blade Runner 2049 (2017)

[mostly-natm]

The student becomes the teacher.

[technologyblogofmohit]

Salesforce Tableau Implementation Services | Elevate Your Data Strategy

Improve your Salesforce data analysis with our Salesforce Tableau Implementation services. Our team will integrate Tableau with Salesforce, creating a unified platform for comprehensive data insights. Enhance your decision-making process and gain a competitive edge. Contact us to find out how we can improve your data strategy.

Streamline your operations with powerful visualizations and real-time data access. Drive growth and efficiency with our customized solutions!

[zoloteh-volossya]

BG3 Fanfiction Statistics, Part 2

Welcome to part 2 of my BG3 AO3 fanfic statistical analysis! In part 1, which can be found here, I discussed general fanfic data for the fandom and took a look at pairing trends for the player character, Shadowheart, Karlach, Lae’zel, and Minthara. In this section, I will discuss pairing trends on AO3 for Astarion, Gale, Wyll, and Halsin, then compare all 8 main characters and talk about pairings more broadly.

Please note that the data for this analysis was gathered between July 21, 2024 and July 24, 2024. I gathered data for the top 300 ship tags in the BG3 fandom, and due to time constraints did not look at pairings with fewer than 5 fics.

I will try and be as transparent as possible when discussing how I obtained and processed this data. A copy of my spreadsheet can be found here and contains all of the tables I will be discussing for anyone who wishes to take a closer look at the data. If you don’t care about the numbers and/or my thoughts about them, feel free to skim through this post and just look at the charts!

I will be referencing the “PC” a lot in this section. See part 1 for an explanation of my methodology, but basically I combined Tav, Dark Urge, Original Character, Reader, and You into one Player Character (PC) supercategory while filtering to prevent double counting. This makes it clearer who each character is typically paired with. It also drops the number of ships from 300 to 162. Throughout this essay, I will use “ship tags” to refer to the original 300 ships that I gathered the data for and “pairings” to refer to the 162 ships that remain when I condense the player character down.

CHARACTER PAIRING STATISTICS, CONT.

In part 1, I went through Tav, the Dark Urge, Shadowheart, Karlach, Lae’zel, and Minthara and took a look at who they are shipped with and their fic category (F/M, M/M, F/F, Other, Multi) breakdown. In this continuation, I will look at Astarion, Gale, Wyll, and Halsin.

ASTARION

Astarion was included in 50.2% of all fic pairings (the number of fics tagged Astarion/PC + the number of fics tagged Astarion/Gale + the number of fics tagged Astarion/Halsin and so on, divided by the total sum of all fic pairings). This percentage increased to 53.9% when otp:true was applied. This means that over half of all shipping content for BG3 on AO3 involves Astarion!

Astarion is in 7 of the top 10 ship tags and 64 of the top 300 ship tags. When I condense the pairings with the PC down, he is in 7 of the top 30 ships and 40 of the 162 total pairings. The loss of 24 ship tags comes from me having to condense down not only all his ship tags with the PC but also all his threesomes and foursomes and moresomes with the PC.

Notably, Astarion was the only BG3 character to have race specific ship tags – Astarion/Tiefling!OC (68 fics), Astarion/Half-Elf!OC (27 fics), and Astarion/Drow!OC (9 fics). These all got condensed down into the Astarion/PC supercategory as well.

Astarion/Gale is #4 and his next pairings with a non-player character are #8 Halsin and #9 Wyll. Pairings #1, 2, 3, 5, 6, 7, 10, and 16 are all just him with different tags for the player character. Condensing down all the player character tags yields us his top 20 pairings.

As expected, the player character dominates his pairings with 11,756 fics. His biggest non-PC ships are with Gale with 2,431 fics (of which an unusually high proportion are otp:true – 1,752 – almost three quarters of all his fics with Gale), Halsin with 848 fics, and Wyll with 582 fics. Ignoring the PC, he mostly seems to be shipped with men – the first canon woman to show up is Karlach at #8 with 157 fics (an order of magnitude less than Gale). He has four threesomes (Halsin/PC/Astarion, Gale/PC/Astarion, Karlach/Wyll/Astarion, Wyll/PC/Astarion) in his top 20 ships. I was surprised at how high Cazador (#6, 387 fics) was at first, but a lot of that is likely from Astarion’s backstory.

#20 was Astarion/Astarion with 15 fics, which means that Astarion is following in the proud tradition of tumblr sexymen like the Onceler before him.

As expected from looking at Astarion’s pairings in general, he has slightly more M/M (8,923 fics) shipping than M/F (7,996 fics) shipping. M/M pairings have an unusually high rate of otp:true fics – that’s mostly from Astarion/Gale. Oddly, there’s a small number (51) of F/F otp:true fics – these are either genderbends or mistags.

Looking at the pattern of pairings with the PC only, a different pattern emerges.

This time, there’s significantly more M/F fics (6,910, 58.8% of Astarion’s fics with the PC) than M/M fics (4,182, 35.6%), though the numbers are closer when you look at otp:true (46.7% M/F vs 37.6% M/M). We can infer then that it is more common to ship female player characters with Astarion than men. The Other category is significant (1,601 fics, 13.6%) and likely was used for a tag for nonbinary player characters. There’s still a bizarre 38 otp:true F/F fics.

GALE

Gale is in 19.7% of all pairings and 26.5% of otp:true pairings. He has 33 ship tags in the top 300, which drops to 23 when I condense all the player characters into “PC.”

Unlike Astarion, whose chart was completely dominated by his pairing with the PC, Gale has almost as many fics with Astarion as he does with Tav. The top pairings for Gale are primarily with the player character – #1, 3, 4, 5, 6, 7, and 8 are all just different tags for the player character (Gale/You and Gale/Reader are synonymous and so have pretty much the same number of fics). Condensing all that down yields the following chart.

There’s a stark drop off after the player character and Astarion – an order of magnitude decrease in fics (#4 Shadowheart/Gale has 111 fics, a massive drop off from 2,431 Astarion/Gale fics). And #3 is just a threesome with both the PC and Astarion. I’ve commented on it before, but Gale/Astarion has a truly unusual proportion of otp:true fics – something that indicates that there are no background pairings in most of that ship’s activity. I would not be surprised if many of those fics are modern AUs or post game fics that don’t feature the other BG3 characters much if at all.

The quartet of Astarion-Gale-Halsin-PC is prominent in Gale’s top 20 ships. All permutations of that multiship are present: #1 Gale/PC, #2 Astarion/Gale, #5 Halsin/Gale, #3 Astarion/PC/Gale, #6 Astarion/Halsin/Gale, #11 Gale/Halsin/PC, and #15 Astarion/Gale/Halsin/PC. Towards the bottom of his top 20 we start getting into his multiships with most or all of the main protagonists. This’ll be more common with the other companions – there are only 11 Astarion / Gale / Wyll / Shadowheart / Lae’zel / Karlach fics, so when these show up the list is descending into very low fic count pairings.

Looking at Gale’s fic category breakdown, M/M predominates with 3,859 fics to M/F’s 2,938 fics. Given the very high proportion of otp:true fics, we can assume that most of that is Astarion/Gale. Indeed, when we look at Gale’s ship with the player character (his only other substantial ship), we see a very different picture.

Gale’s ship with the player character has much more M/F content than his general ship content and also than Astarion. M/M content drops from 57.1% of all his fics to 30.5% of his ships with the player character, while M/F content rises from 43.5% of all his fic content to 68.1% of his fic content with the player character. ‘Other’ shipping is about 9.6% of ship content with the player character. Looking at otp:true content, a little more than half as many male player characters are shipped with Gale as female player characters.

There are, for some reason, 16 F/F otp:true fics for all of Gale’s ships and 7 otp:true F/F fics for his ship with the player character.

WYLL

Wyll is featured in 5.2% of all pairings and 5.7% of otp:true pairings, a truly stunning drop from the ~50% of Astarion and 20-26% of Gale. He is in 24 of the top 300 BG3 ships, a number that drops to 18 when I condense all the player characters into one category.

Interestingly, Astarion/Wyll outpaces Wyll/Tav as Wyll’s most popular ship. Like with Gale/Astarion, the proportion of otp:true fics for that pairing is unusually high.

When we condense all of Wyll’s player character pairings into one category, it (barely) edges out Astarion/Wyll, with 588 and 582 fics respectively (also note that no Wyll pairing has thousands of fics, unlike Gale and Astarion before him). What also happens when we condense the player characters is that Wyll does not reach a full 20 ships – he drops to 18 pairings. He has more than this, of course, but my methodology ignores all pairings with fewer than 5 fics. Therefore, Wyll’s 19th and 20th most popular pairings have 4 fics or fewer. I have represented these missing pairings with little :( emojis, because this is a sad state of affairs.

Karlach is by far Wyll’s most popular ship after Astarion and the PC, with 327 fics. The otp:true proportion is low, so it is likely often a background ship or has background ships. The next highest pairing is #4, Gale, with 54 fics. The numbers rapidly drop from there – by #6 Wyll/Lae’zel we are at 26 fics and by #14 Wyll/Karlach/Shadowheart we are down to only 10 fics.

Wyll’s pairings, like all of the male characters, tend towards M/M, with 1,010 total fics. F/M follows up with 794 and Other with 162. Much of his M/M fics come from Astarion/Wyll, as we can see when we look at Wyll’s ships with the PC.

Like Astarion and Gale before him, the proportion of M/F rises when we look at Wyll’s pairings with the player character specifically. Unlike Astarion and Gale, though, no category even comes close to breaking 1,000 fics. M/F has 357 fics (or about 60.7% of his fics total) and M/M has 224 (38.1%). With otp:true applied, M/F is 56.3%, M/M is 40.7%, and Other has 13.3%. These numbers add to more than 100%, so even on otp:true fics people are evidently tagging multiple categories. This is likely due to “Reader” fics with a generic reader.

HALSIN

Halsin is featured in 9.7% of all pairings, almost twice Wyll’s proportion. This drops to 7.9% though when you apply otp:true – a much larger drop than pretty much anyone else other than the PC. It’s likely because Halsin has a disproportionately high number of fics with threesomes, which eliminate a fic from otp:true if the threesome subrelationships are also tagged.

He is in 31 of the top 300 ship tags and 21 of the top 162 pairings.

Like every other man in this essay, Halsin’s ship with Astarion is very prominent. The first canon woman to show up is Shadowheart at #15.

As expected, Halsin/PC is easily his most popular pairing, with 1,637 fics. Astarion and a threesome with Astarion and the PC follow with quite decent fic counts of 848 and 456 respectively. The otp:true proportion for Halsin/Astarion is abnormally high. Gale and Shadowheart seem to be his other major ships. Gale/Halsin is #4 with 106 fics and Gale/PC/Halsin is #8 with 19. Shadowheart/Halsin is #6 with 36 fics and Shadowheart/Halsin/PC is #10 with 17.

The Astarion-Halsin-Gale-PC quartet shows up prominently in Halsin’s top pairings. In addition to the ships previously mentioned, Halsin/Astarion/Gale is #5 with 92 fics.

What’s notable about Halsin’s fic categories is the abnormally large number of fics tagged Multi – 1,257 fics, or 37.4% of the total. Given that he’s the poly companion, this makes sense.

Looking at Halsin with the PC specifically, the typical pattern appears. The percentage of M/M drops and M/F rises. Unlike the other characters and like his general shipping situation, the percentage of Multi fic is quite high – 32.7%.

CHARACTER COMPARISON

Now that I’ve looked at all the main characters individually, let’s take a look at how they compare to each other across a variety of metrics.

FIC RATINGS

In my individual character discussions, I didn’t talk about their relative rating proportions much, even though I was carefully tracking it. This is because all rating plots look just about the same until you compare people against each other directly.

Taking a look at all fics, I noticed a couple of things. First of all, Wyll is the companion with the least amount of horny fic written about him, with 33.4% of fics that include him in a pairing being rated Explicit. Halsin is the horniest, no surprise, with 52.8% of fics that include him in a pairing being rated Explicit – over half! Astarion has 41.2% Explicit fics while Gale has 43.6%. Amongst the women, Minthara has the highest percentage of Explicit fics (47.8%) while all three other women are within 38% – 40%.

Interestingly, the percentage of fics rated Mature remains within 22% – 26% for all companions except Minthara, who has 27.8%. The proportion of General fic is between 9% and 11% for Astarion, Gale, Shadowheart, and Karlach. Wyll has more than that, with 11.4%, while Lae’zel and Minthara have less than that with 8.4% and 5.6% respectively.

The situation does not change appreciably when I only look at fics with the otp:true condition.

FIC CATEGORIES

I have been talking about the percentage of M/F, M/M, F/F, Other, and Multi fics for each of the main characters. It’s interesting to compare them with each other. Please note, though, that in the individual character sections the percentages given were the percent of all fics for that character, and so the percentages added up to more than 100% because many fics tag several categories. In this section, the percentages given are a percent of all pairings. They therefore all add up to 100%, but it also means that fics that tag multiple categories are counted multiple times in that 100%.

The men all have more M/F than the women do (Astarion and Gale have the most while Lae’zel and Minthara have the least). Halsin, unsurprisingly, has the most Multi fic while Minthara has the least. Karlach has a surprisingly low proportion of F/F fic.

An interesting note is that the men all have less F/F fic than the women do M/M fic. This means that women are in background pairings to M/M ships or have background M/M ships in their focus fics proportionally more often than the men have background F/F ships or are in the background of F/F fics. The exception is Wyll, who has a F/F percentage close to the percentage of M/M fics in the womens’ fics.

Looking at ships with the PC specifically, some interesting patterns emerge.

Astarion, Gale, Wyll and Halsin have significantly (by more than 10%) more M/F content and less M/M content in their ships with the PC than their ships in general. Lae’zel and Minthara see a slight (less than 5%) increases in M/F and decreases in F/F as well. Shadowheart mostly stays the same. Karlach, on the other hand, sees a moderate (between 5% and 10%) decrease in M/F and increase in F/F in her ship with the PC specifically.

But remember, all these values include background pairings, and we have no way of knowing what proportion of each category actually contains the character we are interested in. So, what happens when we strip background pairings out of the equation by applying otp:true?

Wow! What a difference! Now, these values aren’t necessarily representative of all their pairings – just the ones that authors like to focus on without any background ships. Recall from the individual character analyses that often the second most popular ship after the pairing with the PC had an unusually high otp:true ratio. So we can assume, for example, that a large proportion of the M/M fics for Astarion and for Gale are from Gale/Astarion.

Every woman except Karlach is gayer than all of the men. Surprisingly, Karlach is the straightest companion by this particular metric.

Applying otp:true to ships with the PC specifically yields very different results.

Like what we saw with all ships, ships between the PC and men have significantly more M/F content than the mens’ ships generally. In this case, every man except Astarion jumps to around 50% M/F, and Astarion still jumps from 24.3% to 42.9%. The consistent pattern is that when looking at otp:true fics, M/M is preferred unless the pairing is with the player character, in which case M/F is more popular.

The conclusions for the women are not as clear cut. Karlach has more F/F and less M/F when looking specifically at ships with the PC, while Lae’zel has almost twice as much M/F when you look at her ship with the PC than her general otp:true fics – almost certainly due to the loss of Shadowheart/Lae’zel. Shadowheart experiences a significant (>10%) decline in the proportion of F/F fics, while Minthara sees a smaller one (~5%). What remains true, though, is that the majority of the player character shipping for the women is F/F.

The green bars in the chart are for the Other category, an expansive category that includes a lot of nonbinary PC shipping. You can therefore estimate how popular it is to ship each main character with a nonbinary Tav. Karlach has the most (18.6%) while Lae’zel has the least (5.2%). Everyone else is between 10% (well, 9.8% for Gale) and 12% except for Astarion who has 13.6%.

PAIRINGS

Most of both parts of this essay has been spent looking at each main character in relative isolation. But if you plot all pairings next to each other it paints a very interesting picture about each character’s relative popularity.

Astarion shows up 7 times in the top 10 ship tags and 12 times in the top 30 ship tags. The first non-Astarion ship is #4, Tav/Gale. There are no canon women in the top 10 ship tags – the first to show up is Shadowheart, at #14. Wyll does not appear until #18, in a pairing with Astarion. His pairing with Tav is #25. Lae’zel’s ship with Tav does not even make it onto this plot, at #38. Minthara is in an even worse situation – she first shows up at #60.

The results when I condense all the player character tags into “PC” are... stark.

Astarion dominates the BG3 fanfiction sphere in a way that is very surprising for a piece of media with six strong main characters. In fact, in order to actually be able to see the teeny tiny bars representing everybody else, here's a second graph with Astarion/PC excluded.

Astarion/PC is far and away the most popular ship, with 11,756 fics. Gale/PC is the second, with 3,500 – less than a third as many. Next is Astarion/Gale (2,431 fics) with an unusually high “otp:true” ratio, which indicates that it is frequently being written without any background ships. Surprisingly, Gortash/PC is fourth with 1,891 fics, followed by Halsin/PC with 1,637. Shadowheart/PC is the first woman to show up, at #6 with 980 fics. This is still 657 fics less than Halsin/PC and 911 fics less than Gortash/PC, which means that Gortash/PC is almost twice as popular as Shadowheart/PC. Astarion/PC has 12 times as many fics as Shadowheart/PC.

Karlach follows Shadowheart at #7 with 890 fics. Of the main cast, Lae’zel is next at #10 with 694 fics, and unlike every other Origin character her most popular ship is not with the PC but with Shadowheart. Wyll/PC does not make it into the top 10 ships, coming in at #11 with 588 ships. Notably, Raphael has more fics with the PC than either Lae’zel or Wyll, coming in at #9 with 745. Astarion/PC has a whopping 20 times as many fics as Wyll does and Gortash has over three times as many fics with the PC as Wyll does.

Lae’zel/PC finally shows up at #16 with 348 fics. Rolan/PC has more fics (#13, 477), and Astarion/PC has 33 times as many fics. Minthara/PC, meanwhile, is all the way down at #23 with 234 fics. Raphael, Rolan, Zevlor, the Emperor, and Haarlep all have more fics with the PC than she does. Halsin/PC has 7 times as many fics as Minthara/PC.

If you add up all the pairings each main character is tagged in, you get the following chart.

Astarion is far and away the most written about character in the BG3 fandom, followed by Gale and Halsin. If you divide these numbers by the total number of pairings, Astarion is in 50% of pairings, Gale is in 20%, and Halsin is in 10%. No other character breaks 10% - Shadowheart is in 7% of pairings, Karlach in 6%, Wyll in 5%, Lae’zel in 4%, and Minthara is in 1%.

Out of curiosity, I tallied up the numbers for Gortash as well. He appears in 6% of all pairings and 7% of otp:true pairings. This means that Gortash breaks even with Karlach and appears in more pairings than Wyll, Lae’zel, or Minthara, and if you look at otp:true he beats all the women and Wyll. This is despite Gortash having very few ships with characters outside of the PC, unlike most of the main cast who have notable secondary ships like Shadowheart/Lae’zel.

PAIRING ANALYSIS

Why am I focusing so much on pairings? Mostly because BG3 is an ensemble game – many fics will tag characters who show up for any significant length of time, even if just in the background. Therefore, if a character is tagged that is indicative that they are being included but not necessarily a sign that they are being focused on.

AO3 is a largely romance focused site (only 12% of all BG fics are categorized as General) and so characters in a pairing are more likely to be a focus of a fic. Of course this is not a hard rule, as in-depth character studies may have no pairings tagged at all or may tag a pairing that shows up in the background – but I have no way to distinguish these fics from a fic that tags a character because they show up for one paragraph. There is also the problem that many pairings are background pairings that are tagged but show up only briefly. To try and avoid that, in the following conversation, I will often be focusing on ships with the PC specifically. Fics pairing a character with the PC are especially likely to be focusing on that character and their romance and are much less likely to be a background ship than other pairings.

Looking at the data, the four most popular characters to ship with the PC – Astarion, Gale, Halsin, and Gortash – constitute the majority of fan works. Astarion, Gale, and Halsin in particular are shipped in all the possible configurations and these pairings are comparatively popular. Astarion/Gale is #3, Astarion/Halsin is #8 (above any Wyll or Lae’zel ships), Astarion/Halsin/PC is #14 (above Lae’zel/PC and all Minthara ships), Astarion/Gale/PC is #26, Gale/Halsin is #33, and Astarion/Gale/Halsin is #34.

So I did a little experiment. I went through my data and counted all the pairings that contained ONLY Astarion, Gale, Halsin, Gortash, and/or the PC. Then, I went through and counted all the pairings that weren’t in that group but did contain at least one of Astarion, Gale, Halsin, or Gortash.

Pairings containing ONLY a combination of the PC, Astarion, Gale, Halsin, or Gortash constituted 66.9% of all fic pairings in the BG3 fandom and (in a neat coincidence) also 66.9% of otp:true fic pairings. Adding in fics that involve at least one of these men with someone else ups the numbers to 73.3% of all fics and 75.0% of otp:true fics. Which means that only about a quarter of pairings do NOT include one of these four white men.

Now, it isn’t unusual for a couple of people to dominate a fandom like this. Many fandoms’ creative output primarily consist of only a couple of popular characters and their associated pairings. What is notable, though, is that BG3 is an ensemble game with 6 strong and nuanced main characters, three of whom are women, and two additional strong side characters, one of whom is a woman. But the four primary objects of fandom’s focus are 2 of the main characters, one of the side characters, and a villain.

This discrepancy is especially notable for Shadowheart and Lae’zel. For ages, when I’ve seen people bring up the relative scarcity of women in fanfic, the rejoinder is that the true culprit is the source media. Stories just don’t feature complex, interesting women with fully realized arcs, people say. There’s no narrative meat to for fandom to sink their teeth into.

This is not the case in BG3.

Both Shadowheart and Lae’zel have excellent narrative arcs that are well embedded into the game – Lae’zel has two game areas dedicated to her plotline (the creche and the astral plane) and you literally cannot progress the game past act 2 without interacting with Shadowheart’s dedicated area. The characters grapple with crisises of faith, culture clashes, and important decisions throughout the game – and who they end up becoming changes depending on the player character’s actions. This is great stuff! But it does not translate into fanfic popularity.

Lae’zel in particular is underrepresented. It’s notable that she is main character who is integrally tied into the plot and yet she is only tagged in 16% of fics – even including all the fics that merely tag her as a background character. She only appears in 4% of pairings. Her pairing with the PC comes in at #16, with 355 fics. But hey, her largest ship is with Shadowheart, so let’s look at the total number of pairings she shows up in – 1,319. Gortash/Dark Urge has 1,594 fics – that single pairing has 275 more fics than all of Lae’zel’s pairings added together. Gortash’s total pairing count is 2,052 and exceeds Lae’zel’s by almost 700 fics. Halsin’s total pairing count is over 2.5 times as large as Lae’zel’s at 3,346 fics total. Gale’s total pairing count is over five times as large, at 6,760 fics total. Oof.

Shadowheart is a bit better off – her pairing with the PC is the most popular woman at #6 with 980 fics. But this is still 657 fics less than Halsin/PC and 911 fics less than Gortash/PC, which means that Gortash/PC is almost twice as popular as Shadowheart/PC. When you take Shadowheart’s other pairings into consideration, things improve a little bit. She has 2,418 pairings total, which is about 400 more than Gortash’s total, though still over 900 fics less than Halsin’s total. But any Shadowheart/Lae’zel fan can tell you about sifting through their fics and finding that many only feature them as a background pairing for Astarion/Tav or some other more popular pairing. So let’s take a look at the otp:true numbers. Looking at otp:true fics only, Shadowheart has 765 fics and Lae’zel has 495 fics. Meanwhile, Halsin has 858 and Gortash has 800 – more than Shadowheart and much more than Lae’zel.

Neither Gortash nor Halsin really have arcs in game, though both of them do have implied arcs that happened before it. They’re interesting characters, sure, but undoubtedly Shadowheart and Lae’zel have more going on, more narrative meat to chew on. And yet, they’re completely overshadowed in fandom.

Speaking of being overshadowed, let’s talk about Wyll. Wyll is the only man in the main cast who is not particularly popular. He does not even make it into the top 10 pairings! He has fewer fics than Shadowheart or Karlach. Notably he has far far fewer fics with the PC than any other major male character and even several male villains. Gortash/PC has over three times as many fics as he does, Halsin/PC has 2.78 times as many fics as he does, and Astarion/PC has a whopping 20 times as many fics as he does. Even Raphael/PC has more fanfic! Even taking total pairings into account, Gortash still has more pairings than Wyll’s 1,770 total, while Halsin has almost twice as many.

A counterpoint that is commonly raised in this fandom is that Wyll is a boring character with less content than other Origin companions. Now, I disagree with this assessment of Wyll’s comparative boringness (I find him more interesting than Gale and much more interesting than Halsin, personally) but for the sake of this argument let’s not dispute this. The fact of the matter is that even if Wyll’s arc is half baked, Halsin has no arc at all and much less content in game. Gortash has even less content, with any potential past entanglement with Dark Urge being merely implied. Raphael doesn’t even have the implications of a past relationship with the PC, is never in a position to be in a relationship with the PC, and is canonically bad in bed to boot. And yet these men have far more fanfic with the PC than Wyll does.

I cannot help but notice that Astarion, Gale, Halsin, and Gortash are white men and Raphael presents himself as a white man.

What’s also notable is who doesn’t show up. Many minor non-player characters have quite sizable followings with a significant number of ships. Rolan, for instance, has 586 fics across 9 pairings. Zevlor has 393 ships, Dammon has 257, Kar’niss has 131, and Abdirak has 112. Other male characters that showed up on my list include Ansur (110, all with Balduran/the Emperor), Blurg (69, all with Omeluum), Vellioth (55, all with Cazador), Rugan (54), Kith’rak Voss (49), Sebastian (47, all with Astarion), Orpheus (40), Geraldus (29), Nere (22), He Who Was (21), Yurgir (18), Loroakkan (15, all with Rolan), Aradin (12), Danis (11 with Bex), Barcus (9 with the PC, not Wulbren), Petras (8 with Astarion), Guex and Ikaron (8 with each other), Franc Peartree (7 with Gortash), Lump the Enlightened (6), and Cal (6).

Meanwhile, if I eliminate Aylin and Isobel (not really “minor” NPCs), the first female minor NPC to show up in my list is Alfira with 58 fics. Nocturne follows with 57, Lakrissa with 34, Bex with 11 (all with Danis), Councillor Florrick with 8 (all with Minthara), Duke Stelmane with 8 (all with the Emperor), Kagha with 6, and Cerys with 6 (all with Rolan).

Councillor Florrick is notable because she has as much of a role in acts 1, 2, and 3 as Rolan, Zevlor, and Dammon yet she has no fics with the PC that showed up in my dataset; her only appearance is as part of a ship with Minthara. Ulder Ravenguard – a notable NPC from act 3 – never shows up at all, while Geraldus – a very minor NPC from act 3 – does. Rugan shows up but his boss Zarys never does. Neither does Roah Moonglow, who has a role in acts 1, 2, and 3 while Rugan only shows up in act 1. Araj Oblodra does not show up, but Sebastian does. Cal and Rolan show up in my dataset, but their sister Lia does not. Petras is the only vampire spawn to have over 5 of a pairing – Dalyria, who is present in all scenes where he is, does not. Alfira has the same presence in the story as Rolan (if anything, she has more), yet she shows up in less than a tenth as many fics. Vellioth, who never shows up at all, has 5 times as many fics as Viconia, who does.

The fandom has a definite trend for who gets written about, and it’s not women or Black people.

I’m not writing this to try and shame or guilt anyone. I have a dear friend who absolutely adores Astarion, and fandom acquaintances who I respect that are deeply invested in Gale, Halsin, and Gortash. And I don’t blame anyone for seeing a minor character and being intrigued enough by him to write fic. It makes sense that people are drawn to these characters – they’re really well written characters with engaging storylines. But all of the main characters in BG3 are well written, and who fandom chooses to focus on and prioritize says things about whose stories, whose lives, we pay attention to and care about.

I don’t expect this essay to change anything. Honestly, it’s mostly a primal scream of annoyance, broadcast to tumblr in hopes that other people who are annoyed by this phenomenon can find it. But it’s also a cold hard repudiation of any claim that the reason that women or Black people are underrepresented in fandom is solely due to the source material being lacking. BG3 proves that false.

[sophiebaek]

Benophie Calendar - 2024

Benophie Season (s4) documentation so far!

Some dates may not be exact but dug around the best I could! Will be adding as production and press go along.

Special thanks to @vengerb3rg for brainstorming and fact checking xx

[datavalleyai]

Why Earn a Microsoft Power BI Certification?

In today’s data-driven world, organizations are increasingly relying on business intelligence tools to gain insights from their data, make informed decisions, and stay competitive. Microsoft Power BI has emerged as one of the leading platforms for data visualization, analysis, and reporting. To validate their expertise in using this powerful tool, many professionals are opting to earn a Microsoft Power BI certification. In this extensive discussion, we will explore why earning a Microsoft Power BI certification is not just a wise career move, but an essential one in the realm of business intelligence and data analytics.

1. Demonstrated Expertise

One of the primary reasons to pursue a Microsoft Power BI certification is to demonstrate your expertise in the field of data analysis and visualization. Certification programs are designed to cover a comprehensive range of Power BI features and functionalities, ensuring that certified individuals possess in-depth knowledge and skills. This expertise is invaluable in a world where data drives decision-making across industries. Employers, clients, and colleagues can trust your ability to harness the full potential of Power BI to extract actionable insights from complex datasets.

2. Competitive Advantage

In today’s highly competitive job market, having a Microsoft Power BI certification can give you a significant edge over other candidates. Employers are constantly seeking individuals who can help them leverage data for better decision-making. When you hold a Power BI certification, you stand out as someone who has invested time and effort to master a crucial tool in the business intelligence and analytics toolkit. It signals to potential employers that you are proactive about staying current in your field.

3. Career Advancement

Whether you are just starting your career or looking to advance in your current role, a Power BI certification can open doors. Many organizations require or prefer candidates with certification when hiring for roles related to data analysis, business intelligence, or reporting. Moreover, it can lead to promotions and salary increases. Employers are often willing to reward employees who bring additional skills and value to their organization. A Power BI certification can be the ticket to climbing the career ladder in the data analytics and BI domain.

4. Increased Earning Potential

Earning a Microsoft Power BI certification can have a positive impact on your earning potential. Certified professionals often command higher salaries than their non-certified counterparts. According to industry reports, BI professionals with certifications tend to earn significantly more than those without. This increase in earning potential can quickly offset the time and cost of preparing for and taking the certification exams.

5. Enhanced Job Security

In a rapidly changing job landscape, job security can be a concern for many professionals. By obtaining a Microsoft Power BI certification, you make yourself more indispensable to your organization. Your ability to analyze data, create compelling visualizations, and derive actionable insights becomes a valuable asset. In times of downsizing or restructuring, your skills can help ensure that you remain a valuable member of the team.

6. Versatility and Industry Relevance

Microsoft Power BI is widely used across various industries, including finance, healthcare, retail, and manufacturing. Its versatility makes it a valuable skill that can be applied in diverse professional settings. Whether you are working in marketing, operations, finance, or any other field, the ability to harness Power BI can help you excel in your role. A Power BI certification attests to your ability to adapt to different industry requirements.

7. Access to a Thriving Community

The Power BI community is vibrant and active. By becoming certified, you gain access to a network of professionals who are passionate about data analysis and visualization. This community offers valuable resources, including forums, user groups, webinars, and blogs. It’s a place where you can continue learning, share your knowledge, and stay updated on the latest Power BI developments. This sense of belonging to a community of like-minded individuals can be both professionally and personally fulfilling.

8. Keeping Abreast of Evolving Technology

The field of data analytics and business intelligence is continually evolving. Microsoft invests heavily in the development and enhancement of Power BI, regularly releasing updates and new features. To stay relevant and competitive, professionals need to keep pace with these changes. Earning a Power BI certification is a structured way to ensure that you are up to date with the latest advancements in the tool. It validates that you have the skills needed to leverage Power BI’s full potential.

9. Recognition and Credibility

Microsoft Power BI is a globally recognized tool used by organizations of all sizes. Holding a Microsoft Power BI certification is a badge of recognition and credibility. It tells employers and clients that you are proficient in a tool that is trusted and widely adopted. This recognition can be especially beneficial if you are a consultant or freelancer, as it can help you win new projects and clients.

10. Personal and Professional Growth

Earning a Microsoft Power BI certification is not just about career advancement and financial rewards; it’s also a journey of personal and professional growth. The process of preparing for the certification exams forces you to deepen your understanding of data analysis concepts, Power BI capabilities, and best practices in data visualization. As you tackle real-world scenarios and challenges in your preparation, you become a more skilled and confident data professional.

Conclusion

In conclusion, earning a Microsoft Power BI certification is a strategic investment in your career and professional development. It provides tangible benefits, including the demonstration of expertise, a competitive advantage, career advancement, increased earning potential, job security, and access to a thriving community. Moreover, it keeps you versatile and relevant in an ever-evolving field and enhances your recognition and credibility.

Whether you are a data analyst, business intelligence professional, or anyone interested in working with data, a Power BI certification can significantly boost your career prospects and open up exciting opportunities in the world of data analytics and business intelligence. It’s a step toward becoming a trusted data expert, capable of transforming data into actionable insights that drive success in your organization and beyond.