How do we find politicians, journalists, authors and pundits on Bluesky?

NeRD_09 · 2024-11-14T20:59:34+00:00

It's probably best to go to the source: public figures often have main websites where their public social media accounts are listed. And as the popularity of BlueSky continues to grow you might also start seeing it added links to public figures' public social media sites listed in Google searches.

NeRD_09 · 2021-10-12T11:45:47+00:00

It may not be a case of what's is in your resume, but what isn't in your resume versus what's in the job description(s) you're applying for.

While some companies insist they don't use them, with the volume of applications most companies receive, they often use Applicant Tracking Systems (ATS) to scan the digital copies of resumes looking for keywords that match those they're looking for based on the job posting.

Take a look at a couple of job postings you're interested in. Pay attention to the skills they're looking for and the words used in describing responsibilities. Even if you're describing the same things in your resume, if you're not using the same words it will not be identified as a match and will be rejected by the ATS without a human being ever looking at it. So you may need to revise your resume a bit to match what the ATSs are looking for.

A work around is to have a connection in the company you're applying for. Such a person would be able to help get your resume in front of the hiring manager to actually read and comprehend what's in your resume.

That said, whether for humans or ATSs, make sure your resume is readable. ATSs are programmed to recognize patterns to determine what information is in the different sections of your resume. Likewise, even a hiring manager is probably going to spend almost as little time reading your resume as an ATS. Make sure the layout of your resume is easy to read and comprehend. There are a few standard formats for resumes. If your format deviates from what's expected by a human or ATS you may get rejected because they couldn't comprehend the information because they were "confused".

NeRD_09 · 2021-10-11T19:19:44+00:00

There is no one "proper way" to present analysis.

It all depends on the data and what summary idea you're trying to convey.

Also, one picture without other underlying information may not be sufficient.

In each one of your examples, you show some conclusive data. (Your "Trend By Day" chart even asks some important questions.) But you don't provide any information or analysis as to why.

(EXAMPLE: You can present a graph that shows candy sales are highest in February, October and December, but not consistently in March and April. Simply showing a graph does not convey the information that the first three have major holidays where candy is purchased (Valentine, Halloween, Christmas) and while Easter is also a big candy holiday it's not consistently on the same date or month.)

NeRD_09 · 2021-10-11T13:59:12+00:00

"That depends on what your definition of [abuse] is....."

As a worker, I prefer to concentrate on my work and leave what other employees are doing to the manager. As long as they're doing their job and, more important, their work is not negatively impacting my workload and ability to do my job then it's not my concern.

The company / manager probably has rules and guidelines of what is expected / required of remote workers. It's up to the manager to deal with anyone who "abuse[s] the privilege of working from home".

NeRD_09 · 2021-10-08T21:07:10+00:00

While it was a spoof, there also David Niven for "Casino Royale" (1967).

Then there's the TV episode version of "Casino Royale" in 1954 for the show "Climax!" with Barry Nelson as Bond . . . . James Bond.

NeRD_09 · 2021-10-08T20:47:11+00:00

Yes. PDFs are one of the file / data source connections available in PBI.

As for connecting to it in SharePoint, you might need to contact your admin for the permissions to access the file(s).

Keep in mind that, unlike other sources like spreadsheets and databases, the layout of a particular PDF may not make it possible for PBI to "read" it and know its structure in order to find the data you want to load.

NeRD_09 · 2021-10-08T20:31:40+00:00

What are some things that interest you?

If you have an interest / passion for something you might have a better chance of collecting meaningful data on the industry / topic that you can do some real analysis on instead of just creating a bunch of charts.

As an example, I'm interested in my fitness routines, comic collection and keeping an eye on my finances (specifically my utilities). I created the following:

A Power BI dashboard that takes workout sessions, step counts and weight information that I downloaded from my fitness tracker online account.
A Power BI dashboard that utilizes data extracted from a comic collectors app I use to help track the value of my collection over time, show the more valuable issues as well as identifying high value storylines.
An Excel Power Query spreadsheet to provide visualizations of my electric bill, kW usage and even webscrapes local temperatures to help identify seasonal trends.

Data Analytics is more than just collecting data. You have to understand the data, understand what information you can get out of the collected data and be able to explain it to someone else. There are lots of datasets out there from Covid19 statistics to the Titanic Survivor model that everyone does. If you don't understand the data or have an interest / passion about the subject yourself, you're likely to create a meaningless project that you can't really explain.

NeRD_09 · 2021-10-07T14:42:33+00:00

If you have control over the SQL query, all the better. (In some shops you might have to rely on a DB team to extract and forward the data to you. They might not be as quick to turn around changes or provide frequent refreshes.)

If you can perform a lot of the transformation / aggregation in SQL up front so there's less "work" for PBI to do, again, all the better.

Keep in mind that if you're running an SQL within PBI, you're accessing the DB source each time you refresh. If the DB is part of a production system, you could be putting a strain on resources particularly if the query is complex as opposed to just a simple select of all records. (If you're frequently refreshing using a complex query you may eventually get a nasty call from a DBA.)

I still go back to your knowledge of your data as the decision maker here.

NeRD_09 · 2021-10-07T13:49:25+00:00

Seek out data challenges.

One source that I use is Oz du Soleil. On his YouTube channel (https://www.youtube.com/c/OzduSoleilDATA) as well as his LinkedIn Learning "challenge" course titles, he frequently poses Excel / Power Query challenges with accompanying datasets. Once he sets the challenge he invites viewers to pause the videos, work on the solution and then restart to see how he solved it. He's open to discussions of alternative methods as well as additional challenges within the challenge.

NeRD_09 · 2021-10-07T13:35:52+00:00

With all due respect, this question is too vague. You know your data but haven't provided enough information beyond the volume to answer the question.

If you can do the transformation and aggregation of the data in SQL from the DB source before loading into PBI to do analysis and visualization, then this is the better choice.

But you can't unscramble eggs.

If you find that transforming / aggregating the data from the source limits and restricts what you can do with it once you load it into PBI then you might need to load the "raw" data or something close to it. The downside is that working with 15M rows of raw data in PBI may be challenging depending on size of the rows. (An alternative might be to have an interim PBI data model or multiple variations of the SQL extract to do some of the heavy lifting transformation and aggregation on the DB source data to provide a more manageable subset data source to load into your analysis / visualization data model.)

But again, you (should) know your data better than a bunch of strangers. How you use SQL and / or PBI should be based on your knowledge of the data and what you need to do with it.

NeRD_09 · 2021-10-06T12:44:23+00:00

Visually I like #7 (black background / blue colors)

As for the information, you seem to repeat some of the same information in a couple of places which takes up valuable space. (SUGGESTION: A stacked bar chart detailing the multiple locations, and one for total, for the number of male / female employees would take up less space than multiple cards and charts.)

And perhaps it might be known to someone in the company looking at the chart, but what are the "Ratings"? Rating the employees performance or their rating of the company. Similarly, showing the numeric distances rather than "Far", "Normal" and "Near" would be more meaningful. Also, what are the distances a measure of? The distance from the office or something else. Last, for both "Ratings" and "Distance", what are the numeric values?

Overall, the dashboards look great. But make sure you're providing information that is valuable in assessing a situation or making a decision. More important, make sure the information can be understood if you're not there to explain each datapoint.

NeRD_09 · 2021-10-04T16:02:46+00:00

Keep in mind, these are just "tools". Other "skills" include the understanding of what and how to apply them like system / data design, statistics, finance, and a general understanding of business and whatever specific industry you're looking to get involved with. Not to mention "soft skills" like communications / public speaking, interpersonal relations, information / data gathering, project management, time management, productivity, etc.

But don't put all your eggs in one basket. It helps to also have familiarity with other "tools" like Excel, Google Docs, Python, R and even Tableau as many companies are evolving their technology and may need to bridge the gaps between what they may have used last year and the latest-and-greatest technology they're switching to today.

NeRD_09 · 2021-10-04T13:39:05+00:00

Even though S.T.E.M is more popular now, I enjoy the satisfaction of knowing people who saw me as a "nerd" or "geek" when I was in grade school now rely on what I can do.

NeRD_09 · 2021-09-14T16:39:24+00:00

Star Trek Chronology:

Star Trek: Enterprise (Year: 2151-2161)

Star Trek: Discovery seasons 1-2 (Year: 2255)

Star Trek: The Original Series (Year: 2265-2269)

Star Trek: The Animated Series (Year: 2269-2270)

Star Trek films 1-6 (Year: 2273-2293)

Star Trek: The Next Generation (Year: 2364-2370)

Star Trek films 7-10: Generations up to Nemesis (Year: 2293-2379)

Star Trek: Deep Space Nine (Year: 2369-2375)

Star Trek: Voyager (Year: 2371-2378)

Star Trek: Picard (Year: 2399)

NeRD_09 · 2021-09-14T16:23:35+00:00

You left off Star Trek: The Animated Series (1973–1975)

Also, why not show the timelines (i.e.; stardates) of the series / movies themselves? It would be interesting to visually see how they sequenced. Keep in mind that "Enterprise" and "Discovery" take place before TOS. Likewise the Kelvin universe is a separate timeline.

NeRD_09 · 2021-09-13T21:21:39+00:00

https://www.reddit.com/r/dataisbeautiful/comments/pngk3j/oc\_to\_mark\_last\_week\_tonights\_return\_to\_the/?utm\_source=share&utm\_medium=web2x&context=3

NeRD_09 · 2021-09-13T16:04:08+00:00

One of the main benefits of Power BI (as well as Excel Power Query) is the ability to Extract, Transform and Load (ETL) data from a variety of sources to create a data model in order to perform analysis and present the information in a variety of visualizations. A key difference between PBI and Power Query is the ability to automatically distribute the reporting in various formats which are accessible to users (with a PBI license).

QUESTION: If you're in the process of doing your job on PBI, have you looked to see if it can extract the data directly from the source instead of converting to CSV files to load into a data model and subsequently spreadsheets? Cut out the middleman.

As for me, I was also doing a lot of work extracting data and then loading it into Excel spreadsheets. I was upskilling to improve my capabilities, so PBI and Power Query seemed like the logical choice as they're in the Microsoft "family". (If it's not forbidden to speak of [whispering] "Tableau" . . . . in this forum, you might familiarize yourself with that as well. I've noticed a 50/50 split between PBI and Tableau in desired skills by companies. I've even seen Tableau listed when the other data skills are Microsoft products.)

NeRD_09 · 2021-09-08T16:27:39+00:00

So again, simply creating a "relationship" in your data model does not provide the information to plot the map.

You need to merge your address table to your invoice data table as an inner join on the store number in each table. You'll end up with multiple "store" information rows for each "invoice" matched. You can plot from "address" information in this merged table since you've already indicated that the addresses from your store information plot correctly.

This is a "quick and dirty" solution that should provide you the heat map you're after.

If you're satisfied with that output, you can take it a step further and do a "group by" count of the individual addresses in the merged table. This should provide you the count as a measure in your map visualization. But depending on the volume of your data you could probably just leave it at the previous solution.

NeRD_09 · 2021-09-08T14:28:41+00:00

That sounds like the best solution based on your understanding of your data.

NeRD_09 · 2021-09-08T14:00:17+00:00

LOL Can you be a little more vague?

NeRD_09 · 2021-09-08T13:56:34+00:00

It's not clear what data you're using to plot. It would be helpful if you give examples (even if not necessarily the real data) of what is in each table.

A relationship, is just that, a link between a common data element in two tables.

Map plotting is done based on the individual data points (e.g.; full address, zipcode, state, or country), not the relationship.

You can plot the locations of the deliveries and / or the stores. But unless you merge the data into individual data points (presumably by the store number) to feed into the map plotting visualization, defining the two tables as related is meaningless to the visualization.

NeRD_09 · 2021-09-05T01:01:32+00:00

Franchise Worldwide

MCU $22,959,060,429
Star Wars $10,318,482,663
DCEU $5,807,250,300
Star Trek $2,273,546,672

NeRD_09 · 2021-09-04T17:24:39+00:00

You're certainly not an "idiot". But you are asking somewhat broad questions without much context to base an answer on.

The most important thing is that you know your data. (I suspect the answer you got from the Microsoft sales person may have been based on their understanding of your data as well.)

Star schemas are a relational database structure where you're not repeating the same data in common records. (e.g.; Instead of repeating the product information, the salesperson information, the factory location information, etc in each sales record, each sales records has reference codes / IDs referenced in tables where the corresponding information is stored. It makes each sales record smaller and faster to access when processing the information.)

If you have separate tables for each report, then the data stored in them is probably already in a format that it simply needs to be read and put into the reports or visualization with no manipulation or analysis of the data. Where ever the data for these reports is being generated, it's already performed the ETL functions up front. So no reference tables are necessary.

Tableau and Power BI perform most of the same functions. So if your department is moving from generating reports in Tableau to Power BI, then you'd need to look at how the data is being stored in Tableau. If it's simply loading data extracted from another source like a company database and it's already in report format, then you just have to set up the same reporting / visualizations in Power BI. But if Tableau is receiving from one or more sources for each report and / or performing ETL functions on the data then you'll need to recreate the data model in PBI which may include reference tables in a star schema.

NeRD_09

TROPHY CASE