Anyone ever make a dashboard in Excel?

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

Yes. With pivot tables and filters. It was not my first choice but it was....fine.

like

Agree with DS1. It’s doable but not as pretty as Tableau or PowerBI. A combination of Pivot tables, slicers, and Pivot charts can accomplish a simple dashboard.

like

I’ve seen it, quite sophisticated, and slow.

like

Yep. Client didn’t want to pay for tableau license so had to use excel. Some CSV files were created with some SAS code, and the ETL with VBA. Dashboard created with pivot charts and slicers

like

How'd you guys end up doing that vs using a tool for the job, DS1 and P1?

Because I didn't have a platform available, like Tableau, where I could share things with my client. But everyone had Excel.

like

Yeah. The client gave us no real tech tools because we weren’t “IT”. I hacked something together with Sharepoint lists, Access (manually importing a csv extract that their IT mailed me when I gave them a query), and Excel.

A VBA script did all of the needed ETL, sourcing from sharepoint and access, and forced the formulas to refresh the “front end” (the only unhidden tab in the excel).

It was an awful hack of a thing, but it worked.

Related Posts

What's a good place to live to access both downtown and Argonne national lab in Lemont? I live on the far north side of Chicago now, but my partner got a new job and it would be an hour each way by car to commute for him. I work downtown along the red line. Looking for somewhere affordable, not interested in night life or anything but groceries and transit need to be 10 minute walk or less and be safe. Also prefer CTA over metra since my company has later night events. Thank you!!

like

Hello Fishes

I have recently completed my MBA program and I am looking out for a job in Finance profile and I am having 4 years of experience in Accounts Payable profile.

Also are there any openings for finance and Accounts Payable in Big 4's.

Any sort of referral or help will be appreciated as I am already looking out for job from last year and not able to get any calls its really frustrating and demoralizing..😔😔

like

Hi everyone, applied for an investment consulting internship few weeks back.
It's a client facing job, but it might come at a later stage of a job, maybe after finishing my internship and getting a job offer.
I'm interested to know what is the must develop skills, must take courses or must read books to get insight, develop the required knowledge and skills for the position. I majored in business management finance and currently preparing for CFA level 1. Thanks in advance ☺️

like

Can anyone provide referral for UBS ?

Anyone in need of an Art Producer, Video Producer, Art Buyer (freelance or staff) in New Jersey?

These guys have had this job listing up for about a year, or seems...

Post Photo
like

Seasoned strategist (brand, social, creative, influencer) available for immediate bookings! DM me for resume and portfolio.

like

I have been faking and slacking for last 2 years. I am not being pushed and challenged at work. Nobody bothers to follow-up on my work. I take my sweet time to do the bare minimum. I took a break for depression and came back . Still I didn’t have the enthusiasm to do the work.Should I just quit and figure out what I really want to do ?

like

IFV recommendations in Boston anyone? A Reproductive Endocrinologist the most - but reccs on any and all members of a health team/other tips welcome. Wide and I are about to begin this journey =/

like

As a patient transporter for Adventhealth, we are contracted, I don’t think we should be and be part of the actual hospital

like

Hi, I'm new to Dallas. Have been eyeing on rental investment in Dallas. Looking into Zillow, properties in Arlington seem to have good appreciation. Is it good idea to invest in Arlington? What other areas in Dallas can I consider (checked Carrollton, Plano, Coppell, Addison).
Thank you.

like

Did anyone else adopt the new Florida Wonders curriculum? We just adopted it this school year, and I teach 4th grade. My team and I have not found a good flow, schedule, or whatever you want to call it. We feel like it teaches too many skills in one lesson, and we are not able to truly teach anything “deep” enough for students to master. Does anyone have any insight? What do you do? Do you like the curriculum? Why or why not? Would you be willing to share what you do weekly/daily? Thanks!

like

Hello Fishes

I have been offered a role on Nokia, Bangalore. Wanted to understand the work culture, hybrid work timings/ flexi work hours , health Insurance details .
Can someone please help here?

like

Got a 30% salary bump, via an offer for Senior Consultant S&O from Deloitte. Currently underpaid at EY Advisory. I'm MBA and this year is my promotion year at EY for Manager. What to do? Get demoted and move to D? Or counter at EY? Even if EY matches my salary, and promote me to Manager, I will be an EY Manager with a Deloitte SC salary, and probably won't be able to go to D in the future. What do you think? I have built up a good relationship with my Partner and SMs at EY though.

like

Pro tip: live close to poorer people to feel rich. The feelings of wealth are extremely subjective and is mainly based on comparison

likefunny

Are there any FIFA pro players here? Friends PS4 is here with me and I'm learning to play Fifa 19. Im ok but want to get better. Any pros who can answer questions and give me tips?

like

Best pizza delivery in Boston? I really like Picco. Upper Crust is trash. Regina is decent.

like

Hey CG
I joined Altran and recently the emails have been migrated to Capgemini. I haven't received any credentials to login to Capgemini Outlook. Please provide me any number or email id for the addressing the same. Any help is appreciated 😊

I completed my HR discussion in capgemini one week back. My HR told she will send mail with a amcat test link. But till now i didn't receive any such mail(6 days passed). Am i rejected or will it take some time to send mail?

I took FAR in Aug and AUD last week. Didn’t pass FAR and feeling like I may have passed AUD. My original NTS for them runs out on dec 18. If I get a new NTS for one of them to take before busy season do I have to wait to take it until after my original NTS runs out?

like

Additional Posts in Data & Analytics Consultants

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

If you were to hang your own shingle as a consultant what BI tool would you use to deliver dashboarding to clients?

Assume that you aren’t plugging in to source systems as I primarily work in CDD.

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

like

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

What is a data lake in basic terms?

like

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

like

I need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Big 4 Data Scientists, how did you exit to big tech firms? I’ve been unlucky with online applications and even referrals. I think it might be my resume or how I present myself. Can any free birds please give guidance?

like

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

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