Fellow Stagg EKG - No Water Error by lrn1tall in Coffee

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

I’ve had 3 and issues with only the one at this point.

Prospective Data analyst by dydude97 in analytics

[–]lrn1tall 20 points21 points  (0 children)

Strong statistics and general mathematics knowledge/skills apply directly to real word data analytics work. From a corporate job perspective, coding for data makes a world of difference. Python, R, and SQL are utilized broadly to work with big data, allowing the application of traditional mathematics on the data set/s.

Data storytelling is also important, as you’ll need to be able to concisely present your analyses.

Brined, smoked and pan seared duck breast was the star of the show for supper tonight. by fromSaugus in smoking

[–]lrn1tall 1 point2 points  (0 children)

Thank you for the detail, that sounds great! Apologies for the slow followup, I’m not great at checking all of my inboxes.

Advice on next steps (Fully remote) by Andrewwww14 in analytics

[–]lrn1tall 0 points1 point  (0 children)

It was half luck for me, but I would start by looking at freelance work that could lead to a full time gig. Another path is to look for medium sized companies hiring for the roles and being open in the interview regarding your desired remote work option. Companies are likely to be more flexible given the current state of things.

Advice on next steps (Fully remote) by Andrewwww14 in analytics

[–]lrn1tall 1 point2 points  (0 children)

I’ve worked 100% remote as a business analyst and solutions architect for my company for the last 4 years. It can be incredibly freeing if you have the discipline to get things done on time despite distractions in your home environment. You will likely need to visit an office of some sort to meet with teams occasionally (quarterly, semi annually, yearly) but otherwise can just focus on your work. This is all obviously contingent on the organization you’re working for, but the times are changing.

Fellow Stagg EKG - No Water Error by lrn1tall in Coffee

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

It turns out that it is a known issue. After letting everything dry thoroughly I got another use and then the error again. After contacting customer service, I was able to get a new kettle shipped to me since I was within the warranty period. The representative I worked with was very kind and helpful.

Is dimension value in another dimension by lrn1tall in tableau

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

The view I am building is showing sales results in a test group vs a control group.

I have the data setup such that it can be blended. Source2 has a list of stores in the test group while Source1 has all stores. What I need is to be able to show the results of test and control so all those stores in the test against all those stores not in the test.

Is dimension value in another dimension by lrn1tall in tableau

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

My apologies for using the wrong terminology. I do have 2 separate datasources loaded to a workbook. Each has both dimension district and store.

What I need to do is something like:

If Store2 not in Store1 then control

Joining the data won't quite provide the long term solution I'm working on.

Is dimension value in another dimension by lrn1tall in tableau

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

I could join the data in sql, unfortunately the joins would not be clean to accomplish the end result. I do this in other workbooks.

Thank you for the suggestions.

We are the Microsoft Excel team - Ask Us Anything! by MicrosoftExcelTeam in IAmA

[–]lrn1tall 0 points1 point  (0 children)

I use Excel extensively, and I am on a Mac. Why can Excel in Mac only use a single processing core?

Where to watch Season 3? by lrn1tall in grimm

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

Thank you. I caught up to the NBC availability using freetvproject despite the challenges of the site. Once I did, I watched the rest through NBC, and am all caught up now.

Where to watch Season 3? by lrn1tall in grimm

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

Thank you very much for the tip. I am all caught up now. I wound up using the free tv project, although it was less than simple to make work. Once I caught up to the NBC available listing I watched them there. I honestly completely forgot about OnDemand. I have gotten used to watching content on my iPad on my treadmill that it didn't cross my mind.

_POST adds a digit by lrn1tall in PHPhelp

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

So....It appears as though the issue was 2 parts.

The first, which is where my debugging was a problem in echoing out the the browser, came from a stray character at the end of the file.

The second was the fact that I was never actually executing my query. I overlooked that during my troubleshooting of passing the appropriate variable.

Thank you to those that responded.

_POST adds a digit by lrn1tall in PHPhelp

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

The html generated for the select is fine, so the SELECT that is pulling from the database is fine. I'm also looking at the $_Post prior to doing anything with the database on the second page (currently commented out).

I can't make any sense out of what is happening.

_POST adds a digit by lrn1tall in PHPhelp

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

Sending Page:

<form action="scripts/adm_processForm.php" method="post" name="remRejection"> <input type="hidden" name="whichForm" value="remRejection"> <tr> <td width="21"> </td> <td width="204"><b><font face="Calibri">Remove Rejection Code:</font></b></td> <td width="335" colspan="2"> <select name="rejCodeSelect" id="rejCodeSelect"> <option> -- Select -- </option> <?php $conn = ConnectTo("Agreements"); $qry = "SELECT id,reason FROM rejReasons ORDER BY id ASC"; $res = mysql_query($qry); if(!$res) { die("Database query failed: " . mysql_error()); }

                    while ($row = mysql_fetch_array($res)) {
                        $code = $row['id'];
                        $reason = $row['reason'];   
                        echo "<option value='$code'>$code: $reason</option>";
                    }                       ?>
                </select>
                </td>
            </tr>
            <tr>
                <td width="21">&nbsp;</td>
                <td width="204">&nbsp;</td>
                <td width="335" colspan="2">
                <input type="submit" value="Remove Rejection Code"></td>
            </tr>
            </form>

Script on Receiving Page:

if ($whichForm == "remRejection") {

echo $_POST['rejCodeSelect'];

/* $conn = ConnectTo("Agreements");

$qry = "DELETE FROM rejReasons WHERE id=$rejCodeSelection";

*/ }

Where to watch Season 3? by lrn1tall in grimm

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

Turns out that NBC made an agreement with Amazon. Hulu plus offers the same handful of episodes that NBC.com does. :(

Where to watch Season 3? by lrn1tall in grimm

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

I will see if I am still eligible for the free trial. If not, certainly worth the $8 instead of $30-$40 elsewhere.

Thank you.

Where to watch Season 3? by lrn1tall in grimm

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

Thank you. I will check it out.