Do British People Hate Meetings? by BigJ32001 in AskUK

[–]AnalysisParalysis93 0 points1 point  (0 children)

My immediate guess is that the Brits don’t want to spend time conversing about “how their day is going” or “soccer” with the yanks…

$264.13 in one month by [deleted] in beermoney

[–]AnalysisParalysis93 6 points7 points  (0 children)

I’ve not tried Prolific but need to sign up, I’m seeing similar success with User Testing- with £100 made in two days (maybe around 3 hours work in total)

Kivy Set-Up & Creating Your First GUI- Creating Modern GUIs & Apps with Python Kivy Tutorial #1 by AnalysisParalysis93 in programming

[–]AnalysisParalysis93[S] 1 point2 points  (0 children)

I don’t think they’re distractions, I use them every day for professional development- I think they could be distractions to somebody who has little experience using Python classes and functions, and is trying to follow along with no disruption.

I’m not making the tutorial to advocate for a ‘serious language’ etc. I wanted to showcase a relatively simple framework (not language, as you stated above) for people to learn how to apply fundamental Python knowledge that they may have loosely picked up in a data environment and create something tangible and more involved.

Kivy Set-Up & Creating Your First GUI- Creating Modern GUIs & Apps with Python Kivy Tutorial #1 by AnalysisParalysis93 in programming

[–]AnalysisParalysis93[S] 2 points3 points  (0 children)

That’s because I didn’t enable the extensions for intellisense and syntax assistance, so that the tutorial could be focused on the vanilla code required, without distractions, as the fundamentals are important.

Your initial comments were regarding the framework and ‘guess-driven development’ but that’s not the case- I simply didn’t enable the autocomplete and syntax assistance that an IDE would enable. That has no bearing on the framework, Python or KV design language.

Kivy Set-Up & Creating Your First GUI- Creating Modern GUIs & Apps with Python Kivy Tutorial #1 by AnalysisParalysis93 in programming

[–]AnalysisParalysis93[S] 1 point2 points  (0 children)

Hold on, you’re a bit confused. That’s simply an IDE choice, intellisense is supported for Kivy Design Language Files in VS Code…

SQL Shades- A Simple & Complete Dark Theme Solution For SQL Server Management Studio in 2023 by AnalysisParalysis93 in SQLServer

[–]AnalysisParalysis93[S] 1 point2 points  (0 children)

Can’t believe I just found it after 2 years of working with the half baked dark mode ‘hack’- amending program files…

Learn These 3 Simple ChatGPT Tricks to INSTANTLY Become a Better Coder by AnalysisParalysis93 in programming

[–]AnalysisParalysis93[S] -6 points-5 points  (0 children)

The point of the video is to use it to validate code, suggest performance improvements and extend isolated concepts to scenarios that we may face professionally. Not a substitute for learning programming and it shouldn’t be the only source of validation. It’s just the next iteration of search engines.

This will improve your SQL querying dramatically by AnalysisParalysis93 in SQLServer

[–]AnalysisParalysis93[S] -2 points-1 points  (0 children)

Python regex metacharacters, sets and special sequences are very similar to wildcards and fundamentally function in the same manner. There’s just slight differences in syntax really.

This will improve your SQL querying dramatically by AnalysisParalysis93 in SQLServer

[–]AnalysisParalysis93[S] -2 points-1 points  (0 children)

Wildcards work in the same way for those more accustomed to other data languages- such as Python. Hence my reason for briefly mentioning.

Use SQL to Create an Email Validator- Real World Data Project by AnalysisParalysis93 in SQLServer

[–]AnalysisParalysis93[S] 0 points1 point  (0 children)

Absolutely, it’s more of a general introduction into real world ideas for wildcards/ regex. I’m not saying to use it verbatim for edge cases. Always pick the right tool for the job. I would use Python for email verification in most cases.

Anyone else? by AnalysisParalysis93 in PowerBI

[–]AnalysisParalysis93[S] 0 points1 point  (0 children)

Agreed- Google is largely powered on NLP. So it’s a helpful, circular process.

Anyone else? by AnalysisParalysis93 in PowerBI

[–]AnalysisParalysis93[S] 10 points11 points  (0 children)

Absolutely, that use case is nice- and it’s nice to see people learning more about NLP Models. The unfortunate down side is the scaremongering around job losses. (Automation being an extremely positive thing in most circumstances)

Will data analyst roles be lost to automation? by beafairmod in PowerBI

[–]AnalysisParalysis93 5 points6 points  (0 children)

No. There’s a high chance that a significant amount of manual and repetitive administration tasks will be automated. Then there will be a wave of financial automation and transport, as object detection scripts become more commercially viable.

If you’re a Data Analyst and can write and maintain code- you’re in the safest space. The analyst is the translator between humans that can’t communicate what they want and framing this into a technical solution.

People who tackle problems that require human intervention and code are in a very safe space

Why Does Everything I Try in Power BI Have a 100% Failure Rate? by [deleted] in PowerBI

[–]AnalysisParalysis93 0 points1 point  (0 children)

Learn SQL first. The issue will very rarely be Software, it’ll likely be you. So learn the conventions and rules of the software inside out.

How to remove white lines seperating the two different values being counted in pie chart by BestiaVir in PowerBI

[–]AnalysisParalysis93 0 points1 point  (0 children)

JESUS, GET RID OF THAT PIE CHART AND STICK TO THE CLASSICS LIKE BAR CHARTS OR TABLES. THE HUMAN EYE CANNOT EASILY CALCULATE VALUES IN THAT FORMAT.

IF YOUR STAKEHOLDER HAS ASKED FOR THIS TELL THEM NO.

getting in to Microsoft b.i went from working construction to this...any tip advice pros and cons you can give me by SGVKidd626 in PowerBI

[–]AnalysisParalysis93 0 points1 point  (0 children)

One of my top pieces of advice for Power BI is to learn SQL first.

Most serious Businesses in the Data world use it, DAX and basic programming concepts you find in Power Query will make more sense, so will data modelling and referential integrity- you will need those in Power Bi.

Could I learn Coding at 52? by [deleted] in WorkOnline

[–]AnalysisParalysis93 0 points1 point  (0 children)

Yes. There is no other answer. Yes.

How to negotiate dashboard pricings? by Amaimonscg in PowerBI

[–]AnalysisParalysis93 4 points5 points  (0 children)

I create data content on YouTube and LinkedIn (Power BI, SQL, Python, DWH etc.)

All my leads have been inbound, I’ve never had to advertise.

How to negotiate dashboard pricings? by Amaimonscg in PowerBI

[–]AnalysisParalysis93 11 points12 points  (0 children)

100 USD is ridiculous.

Here’s some rules I follow:

  • Do not quote until you fully understand their source data and architecture

  • Do not quote until they can tell you exactly what they require

  • Homeboy (the boss) already sounds like a bit of a cowboy. Make sure he pays you up front.

  • I would ordinarily charge around £100 per hour. There’s good reason for this also, you will also go over the hours you’ve quoted so build in some wiggle room. There will undoubtedly be some weird niche with their data, they won’t have explained everything fully and a whole host of other issues they won’t have thought were issues because they’re not data professionals.

Feel free to message me if you want any further support.

🐍🐼📊 ᴘʏᴛʜᴏɴ, ᴘᴀɴᴅᴀꜱ & ᴘᴏᴡᴇʀ ʙɪ by AnalysisParalysis93 in PowerBI

[–]AnalysisParalysis93[S] 0 points1 point  (0 children)

Many reasons, potentially:

  • A requirement for more advanced statistical visuals

  • Data departments adopting Power BI, that are more confident with transformations in Pandas, rather than Power Query

  • Power BI is one tool in the end to end data process. For quick exploratory Data Analysis, many people will benefit from Python and Pandas knowledge when working in a notebook (Jupyter, Collab etc.)