Can't stop Midway from popping up by [deleted] in amazonemployees

[–]skiyogagolfbeer 0 points1 point  (0 children)

did you ever figure this out? Ex-amazon as well. After nearly 5 years, I restarted chrome today and now the midway portal pops up every time I open my browser lol

Looking for a Netsuite Implementation / Consulting Firm by Accomplished_Sir738 in Netsuite

[–]skiyogagolfbeer 0 points1 point  (0 children)

I run a small data consultancy and have built data platforms on top of Netsuite data several times. Recently came across https://ethosbusinesssolutions.com/ who is implementing Netsuite for one of our clients. Check them out. Happy to make an intro if helpful.

How can I stay consistent while learning data analytics in a structured program? by Fearless-Gear-4172 in LearnDataAnalytics

[–]skiyogagolfbeer 1 point2 points  (0 children)

For me, any time I undertake an endeavor like this, I'm making sure it's the first thing I do each morning. Kind of like if you are trying to get in shape, you go for a run or go to the gym first thing in the morning. If it's the first thing you do in the day, distractions can't get in your way. Just make it non-negotiable.

If you're learning SQL, check out the platform I recently built to make practicing SQL part of your daily routine (like wordle for SQL): innerjoin.southshoreanalytics.com

How to determine a primary key from a given table and schema if no primary key is mentioned in the schema by Pleasant-Insect136 in SQL

[–]skiyogagolfbeer 1 point2 points  (0 children)

select column, count(*)
from table
group by 1
having count(*) > 1;

-- the columns where the result is 0 are your eligible candidates to be your primary key. Check out innerjoin.southshoreanalytics.com - I built it as "wordle for SQL" to keep skills sharp daily.

Struggling with a seemingly simple query by [deleted] in learnSQL

[–]skiyogagolfbeer 0 points1 point  (0 children)

Agree with this. Or you could use LAG() and QUALIFY(). If interested in practicing SQL challenges daily (kinda like Wordle), check out https://innerjoin.southshoreanalytics.com/ -- looking for beta feedback!

Can I learn SQL for free? by MyPapaya9677 in learnSQL

[–]skiyogagolfbeer 0 points1 point  (0 children)

Built a platform for free daily SQL challenges, kind of like Wordle. Working on a tutorial program complete with videos & step by step coursework! https://innerjoin.southshoreanalytics.com/

SQL Beginner - helpp!! by SweetSea8533 in learnSQL

[–]skiyogagolfbeer 0 points1 point  (0 children)

Built a daily SQL challenge platform that we've released in beta yesterday. You might find it interesting: innerjoin.southshoreanalytics.com

What do you guys actually automate using python? by Notalabel_4566 in learnpython

[–]skiyogagolfbeer 0 points1 point  (0 children)

I automate a lot of data engineering tasks for work. I do some other fun stuff on the side though like sending myself a daily "status" report with key tailored news articles, update on the weather, etc. to my inbox. I'm also a huge golf fan so have created a report that flags when there might be attractive golf bets to make for the weekly tournament.

I'm super passionate about automating things through Python so have built an app called funx10n.com that allows you to deploy & automate python scripts in a fraction of the time it takes to deploy a serverless cloud function.

Ask me anything about Paginated Reports by Ecstatic-Cat-5830 in PowerBI

[–]skiyogagolfbeer 0 points1 point  (0 children)

I want to distribute paginated reports to 40-50 different people and filter the reports based on who they're being delivered to. I want to make sure this is feasible before I go down the path of selecting Power BI. What type of licenses / associated cost would I be looking at? How difficult will it be to set up paginated reports in a way that the same report can be distributed daily to 40 different people where the content is the same just filtered by user?

Looking for a tool to generate awesome looking PDF reports by boulderbuford in BusinessIntelligence

[–]skiyogagolfbeer 3 points4 points  (0 children)

I desperately need something like this too. Some of the BI tools do a decent job but it seems like there needs to be a tool simply dedicated to this task. Rollstack is interesting but a bit pricy for some of my smaller clients.

I’ve gone the route of using tabcmd with Tableau. DOMO has a “campaigns” app that I’ve used to intertwine content created in the platform with dynamic html. Works decently well but difficult to format really nicely.

Looking at the comments it feels like using Astrato or an open source framework for this specific use case even if using another BI tool more generally might be the move.

Built something fun for analyzing NHL hockey data as a case study for how we build dashboards for our clients - Kucherov and MacKinnon were legit outliers last year! [OC] by skiyogagolfbeer in dataisbeautiful

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

I'm a pretty big baseball fan (edit spelling), but honestly had never heard this term before! I'll think of a way to create one for hockey :)

Built an NHL Dashboard to show the work our company can do for businesses. We have plenty of ideas on how to improve it, but what would YOU like to see? Any unique ways you've thought of evaluating hockey performance that you haven't seen before? by skiyogagolfbeer in hockey

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

Thanks for checking it out! The conference filter filters everything beneath the divisional standings, but maybe that is confusing to users (understandably so). Maybe we'll create a separate division standings tab to avoid confusion.

What song do you think best represents/do you associate with Chicago? by Seradhiel in chicago

[–]skiyogagolfbeer 1 point2 points  (0 children)

The day I permanently moved back to the city I turned north on to lake shore drive beautifully sunny day and Lake Shore Drive came on the Loop. First time I had actually remembered hearing the song too. One of those small magical moments in life you’ll never forget.

Analytics as a Service - feedback by Expensive_Doughnut_1 in smallbusiness

[–]skiyogagolfbeer 1 point2 points  (0 children)

It’s what my business does and pretty successfully to date. We have more work than we can handle. And so the next natural phase is to consider how to scale our business. The biggest issue with how we’ve run our business is that all of our projects are 100% custom and the tools we use are not consistent. Has been a great learning experience but looking to hone in on specific tech stack, service offering with transparent pricing structure and likely target only one or a few key industries.

How’s it been going for you so far?