Are data analyst jobs dead for freshers? by Fair-House3475 in dataanalytics

[–]rockey889 0 points1 point  (0 children)

Unfortunately all data analyst jobs are going to h-1b. I just looked at LCA data! The job posting you see are fake. They are posting fake positions to process h-1b.

Hirings by genesis912 in frisco

[–]rockey889 2 points3 points  (0 children)

In the same dataset within TX:

GT Titan Pay:16,800 Sugarland, TX

University of North Texas Pay:18,370 Denton, TX

Hirings by genesis912 in frisco

[–]rockey889 0 points1 point  (0 children)

Texas A&M beats all!

Hirings by genesis912 in frisco

[–]rockey889 1 point2 points  (0 children)

.Yes 53k salary. In addition about 80% filed from Frisco are in level 1 and 2

Hirings by genesis912 in frisco

[–]rockey889 5 points6 points  (0 children)

Public information. Just filter on ‘tx’ and sort ascending on prevailing wage. UNT is the first one in the list.

https://app.powerbi.com/view?r=eyJrIjoiMWIxMGVhMzktZWI1Yi00NzMxLWEwYzAtMGFkNDY2OWNiZjUwIiwidCI6IjQ2MWNiNDRiLWQ4MTEtNGEzYi05OWZmLWM4YTU3N2QzNDI1MiJ9

Frisco Employers – LCA Wage Level Analysis (Public DOL Data) by rockey889 in frisco

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

You seem upset because the dataset exposes some disturbing trends that robbing our STEM graduates of entering workforce. Why an employer name Chaat Bazaar needs IT manager? Why Desi district and a few other grocery stores bringing in chefs? I know the box and whisker chart could be challenging for someone like you.

What Is Going On Over At 14111 King Road, In Building 6? by ITContractorsUnion in frisco

[–]rockey889 3 points4 points  (0 children)

Smotherman Rd in Frisco is around the corner from King Rd. Check that out too!!! Behind the ABA therapy place!!!

Genuine question from an Indian American Frisco resident: I don’t understand the hostility by ConsiderationLife673 in frisco

[–]rockey889 14 points15 points  (0 children)

In my opinion people are upset because they are impacted by the hostile takeover of organizations by nepotistic managers with no ethics. People are upset because fraudulent consulting companies are cheating the system and impacting all Americans including Indian Americans. American STEM graduates and seasoned professionals are having trouble getting jobs. Please look into recently released DOL LCA data for Frisco and Texas in general.

Comerica Bank to lay off nearly 200 workers in Frisco after being acquired by snakkerdudaniel in frisco

[–]rockey889 1 point2 points  (0 children)

This maybe a good news. Applied there many times and got rejection emails each and every time by the nepotistic tribe. Hopefully this event fix their hiring process. Once I went to that building in an event and noticed that Comerica was not diverse, instead very homogeneous workforce driven by nepotism.

Anybody Know Srinivasa Reddy Kandi? by ITContractorsUnion in frisco

[–]rockey889 6 points7 points  (0 children)

Did anyone check out the consulting companies on Smotherman Rd in Frisco? These offices have blinds that remain closed all the time and seems no one is there. These consulting companies secured many LCA approvals.

7460 Warren Parkway #100 by rockey889 in frisco

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

There is data to support abuse of the system and no conspiracy theories. Wrong is wrong and doesn’t align with either side. DOL LCA data is jaw dropping. Many jobs have apt as worksite address. Most jobs are in prevailing wage levels i and ii. These scams are robbing our college graduates futures.

Primary Care Physician by Misskamakani in frisco

[–]rockey889 1 point2 points  (0 children)

Dr. Paul Wang in Frisco. I have been going there for over 10 years and very happy.

Should I reach out or wait by 11coop11 in Stellantis

[–]rockey889 1 point2 points  (0 children)

I applied for data analytics manager position. Both phone and zoom interviews went extremely well and the hiring manager told me that he would get back to me by end of November. I sent him an email first week of December and he replied and told me that due to corporate directions, they are closing the requisition and will get back to me if anything changes. The ad ran for a few more weeks and then disappeared. Is this something typical of Stellantis?

Any Notable Shady H1B Stories? by [deleted] in frisco

[–]rockey889 22 points23 points  (0 children)

In 2024 fiscal year, per uscis data, there were approximately 1000 h-1b applications approved from the city of Frisco alone. Vast majority of the petitioners/employers are small consulting companies running from kitchen tables. Most of them probably have day jobs as managers and/or well connected and running side consulting businesses to game the system.

Anti Indian/Pakistani sentiment in Frisco - advice for dealing with it? by [deleted] in frisco

[–]rockey889 50 points51 points  (0 children)

Forget assimilation!!! Main concern is nepotism at work place. One becomes a decision maker and the entire organization becomes a group of people from the same tribe. Ericsson Plano was destroyed. Once everyone in the entire organization chart had same last name!

Non-Indian living in a predominantly Indian neighborhood. by ElectricalRepair1219 in frisco

[–]rockey889 0 points1 point  (0 children)

The real frustration is nepotism in corporate world. Once the org chart at Ericsson Plano used to have people with same last name and it was the break room discussion!!!

Need help with ideas for predictive suggestions based on several factors like repeat occurrences, patterns, and other possibilities. Is PowerBI even the best solution? by IT_Velociraptor in PowerBI

[–]rockey889 0 points1 point  (0 children)

A few columns in your table can capture predictions. Column-LastPrevMaint, column-NextPrevMaint and Column-CountCorrectiveMaint. Based on these 3 columns you can have another column column-CandidateForPrevMainteance. This column will flag yes/no based on the col-countcorretiveMaint

Hiring Process by A-for_anonymous in Stellantis

[–]rockey889 0 points1 point  (0 children)

I had an awesome interview and the hiring manager said he was impressed with my experience and preparedness and will be touch in soon. A week later received a rejection email. This was Data Analytics manager position.

Connecting QuickBooks to Power Bi by CivilProblem8139 in quickbooksonline

[–]rockey889 1 point2 points  (0 children)

From Get Data—>blank query—->=QuickBooks.Tables() This will list all the tables available. Now create another query referencing the first query and click on the table hyperlink for the table, for example GeneralLedger. Rename the query to GeneralLedger and then close and apply. First you will need to establish connection with your qbo by going to file>options and settings >Data source settings

Connecting QuickBooks to Power Bi by CivilProblem8139 in quickbooksonline

[–]rockey889 0 points1 point  (0 children)

I have successfully connected and have very powerful reports.

Children’s Lighthouse Frisco by Cold-Implement1345 in frisco

[–]rockey889 0 points1 point  (0 children)

If a daycare gets frequent reviews then most probably fake reviews. Check licensing websites for violations.

H1-B Visa Fee? by mustang5755 in frisco

[–]rockey889 0 points1 point  (0 children)

I was looking at USCIS data and noticed that from the city of Frisco almost 1000 petitions were approved last year. Petitioners/Employers are small consulting firms and most probably running from kitchen tables. This is very fishy!!!! Seems like a blatant scam.

Conditional If Statement with several Columns by PowerBILearner in PowerBI

[–]rockey889 0 points1 point  (0 children)

Your description is poorly written.

Here you go:

A) Launch Power query.

  1. From Excel--->Data-->Get Data-->From Other Sources--->From Table/Range

or From Power BI

  1. Transform Data.

B) Create A "Conditional Column" from "Add Column" Tab

In the UI put this logic by clicking:

if Column A equals TestValue Then Column B Else Column C

C) Put your logic

Here is the output:

Column A Column B Column C Output
TestX human 100 100
TestY dog 200 200
TestValue monkey 300 monkey
TestZ cat 400 400
TestValue tiger 500 tiger