Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like
Posting as :
works at
You are currently posting as works at

You’re gonna have to submit that to IT with a client charge code to bill to. Please expect 24-72 hours before a response and another 24-72 hours of troubleshooting before IT has to remote in and part the firm mandated garbage on your laptop to install this. Thx

funny

You forgot to add: call help desk a few times to get an update on your ticket number. And tell them each time your work location, working hours, and call back number in case you’re disconnected. And please hold because they are experiencing longer than normal wait times.

Ignoring the access component of this question which was addressed by KMPG1, power query has a get data option that links to Sql Server painlessly in my experience. As long as you have the server and database name you should be in the clear and can write your sql query in the specified field. Just refresh data like you would a pivot table and it should pull your query again.

like

Related Posts

Happy Friday! Looking for an associate healthcare project management position in the south Florida area. If you’re hiring please contact me!

likesmart

Did expediting L2 EAD work for anyone? I am currently in change of status but I need to travel to India as my dad is too alone.

like

Ikon or epic pass for NE skiing?

Anyone work in Cyber at pdubs? Currently in RA in process assurance and was curious what exactly you guys do each day.

like

Has anyone taken up the Personal Capital investment management service that they offer?

They say they will manage my 401k but to do that they will require my credentials that I use to log into fidelity. Is that normal? Has anyone here done that before? Any feedback or experiences of using them?

like

Do you have any advice for a career in a bank?(Position in IT)

like

Best way to prepare for A&M interview / case studies for the PEPI CFO Advisory group? Heard case would be about the three F/S, which I understand from accounting perspective but wondering if I need to know anything specific. Thank you!

like

Anyone else think headlines for pitches and client presentations are bullshit? Those headlines will never exist

like

𝑫𝒆𝒕𝒆𝒄𝒕𝒊𝒐𝒏 𝒐𝒇 𝒍𝒂𝒕𝒆 𝒄𝒐𝒎𝒆𝒓𝒔 𝒂𝒏𝒅 𝒆𝒂𝒓𝒍𝒚 𝒍𝒆𝒂𝒗𝒆𝒓𝒔!

The Most Awaited!!

#SAP #SuccessFactors #TimeTracking #TimeandAttendance #HXM

Post Photo

Hi fishes, how is the increment percentage when compared to erstwhile Altran....? Is it better or worse

like

Hi all - just joining and looking for some guidance! I am currently in an IT internship position (making pretty solid money considering) and following this summer I will stay on part time during my senior year (discussing a full-time job offer after already). I’m getting my computer science degree, so I would like to do something more technical in the workplace when I graduate. How do I advocate myself for that to my manager without sounding unappreciative of the position I’m in?

like

Which languages do you use at your job as a software engineer?

like

KPMG folks, thoughts about Lighthouse relative to other big 4s? About to start the interview process. Coming from EY FSO DDnA

like

Hi fishes!
Anyone knows how's the working
environment in Amdocs Pune NEO unit ?
TIA

like

Today I joined the JPMC mumbai and got the offer from UBS Pune, both are providing the same package.
I want to work in pune, what should I do?
Leave the JPMC and join UBS

like

Larsen & Toubro Infotech Received an offer from LTI as SPECIALIST -data science ? How are the projects , learning opportunities and WLB ? Can somebody please share their experience as Data science specialist at LTI?Larsen & Toubro InfotechEY DeloitteZS Associates PwC

like

Happy to finally have a $100k NW! Thanks for everyone’s help in this bowl!

Post Photo
likeupliftingsmarthelpful

Hi Fishes,

I got offer letter from Mphasis. Any idea about Morgan Stanley Account.

And what are good/bad about joining Mphasis.

Hi , I am awaiting an offer from Citi , the position is located in their Tampa office. I would like to know the culture, WLB, Compensation, or any insights you are willing to provide. It is in compliance and control category. AVP, but also listed as an intermediate level.

Additional Posts in Excel Genius

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Would anyone be willing to teach me vlookup?

like

Any book recommendations on excel modeling for real world business applications?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

How long did it take you to become good at excel? Like fast?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

What are your top Excel ninja tricks? Ones that few people know...

like

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

How do you fix microsoft excel cannot paste data error?

like

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal