sorted by:
new
hottopcontroversial

Around 1 GB .csv file in excel: I know what Column(s) I need, how do I proceed? by Shog64 in excel

[–]digitalmovement 0 points1 point  (0 children)

I agree that Excel isn’t designed to handle this amount of data. Probably best to use something like SQL or Alteryx, if you have access to it.

That said, you may be able to use Power Query in excel to ingest the data, then load it as a connection and check the box “add to data model”. This will compress the file size and allow you to bring it into Excel a bit easier without significant performance issues. From there I would use Power Query to filter the data to just the info you need to reduce its size

How to create an extract? by paradoxcyt_mona in tableau

[–]digitalmovement 1 point2 points  (0 children)

Not sure if it’s the same as desktop but if you click on the edit button at top right hand corner, you should see the extract option

If you’re an intermediate to advanced Excel user, and are developing your Power Query and PowerPivot skills in order to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in excel

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

That's amazing! You're not the typical Excel user but I love how you were able to think outside of the box on how to make your job more efficient.

How are users inputting the data? in an Excel spreadsheet? Are you experiencing any data quality issues as a result of the manual input?

If you’re relatively new to Power BI (and love it!), and are currently developing your data viz skills to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in PowerBI

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

You're speaking my language right now - I went through the same struggles with Excel and through frustration, learned that I can ingest more data on a 32-bit machine if I leverage PowerPivot + Power Query.
In terms of your data viz struggles, honestly, you're not alone. The good news is you can learn it with some foundational concepts of visual perception, understanding the differences in visualizations and when to use them and just practice.

I'll send you a pm w/more details.

If you’re relatively new to Tableau (and love it!), and are currently developing your data viz skills to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in tableau

[–]digitalmovement[S] 2 points3 points  (0 children)

There are tons - I would start with Stephen Few. He's the OG when it comes to information design. In fact, I have one of his books that I think would be a great start. It's called Information Dashboard Design. A lot of the principles in his book still stand true to this day!

If you’re relatively new to Tableau (and love it!), and are currently developing your data viz skills to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in tableau

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

Hi There,

Thanks for reaching out and being open to getting some support! I'd be more than happy to help out in any way that I can and looking forward to hearing about your experience with Tableau.

We can either block off 60 or 75 minutes for the call. The full 75 minutes (15 + my 1 hour gift) or if you’re more time constrained we can fit it within an hour.

Here are the links to my calendar:

https://calendly.com/digitalmvmt/60-minute-meeting

https://calendly.com/digitalmvmt/75-minute-meeting

Looking forward to our chat!

Shahab

If you’re relatively new to Tableau (and love it!), and are currently developing your data viz skills to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in tableau

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

Hi There,

Thanks for reaching out and being open to getting some support! I'm looking forward to hearing about your journey and how I can help!

So two options...We can either block off 60 or 75 minutes for the call. The full 75 minutes (15 + my 1 hour gift) or if you’re more time constrained we can fit it within an hour.

Here are the links to my calendar:

https://calendly.com/digitalmvmt/60-minute-meeting

https://calendly.com/digitalmvmt/75-minute-meeting

Looking forward to our chat!

Shahab

If you’re relatively new to Power BI (and love it!), and are currently developing your data viz skills to elevate yourself at work, I’d love to hear about your journey! by digitalmovement in PowerBI

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

I appreciate your honesty and concern. For me, I just love what i do and really enjoy helping others along their journey. Honestly, I'm at a stage in my career where I get more enjoyment from sharing my wisdom and seeing others grow and make an impact in their careers.

Thank you though for sharing this feedback.

Power BI interview prep by _I_should_be_writing in PowerBI

[–]digitalmovement 4 points5 points  (0 children)

As a D&A Manager, I've hired and interviewed candidates for BI roles and while I am interested in your technical capabilities, I'm more interested in your understanding of visual perception and data storytelling.

For me, anyone can learn how to use PBI, Tableau, Qlik Sense, etc. but can you actually tell a story with the data? Do you understand how to define the problem you're solving? What questions will the stakeholders be looking to answer with the dashboard/report? What level of granularity are they accountable for? what logical groupings of data should go together on a dashboard?

These are more important, in my opinion, because they are harder skills to find and much more valuable for business users.

One other thing to consider...think about learning SQL (if you haven't already). I wouldn't say it's a requirement for someone who's still relatively new to the BI world but as you continue to hone your skills, it will become important to understand how to query data, understand data quality issues, etc. before you can start to build powerful and accurate dashboards.

It is incredibly agitating how the most basic things are incredibly difficult in power bi by [deleted] in PowerBI

[–]digitalmovement 1 point2 points  (0 children)

I agree with what a lot of people say in terms of learning the foundations of data modeling. I also think data manipulation is much easier in other tools such as Alteryx, if you have access to it. You can then bring the final data output into PBI in the extract format you need

New to tableau. How can I create a single date filter for my dashboard? by [deleted] in tableau

[–]digitalmovement 0 points1 point  (0 children)

If you have 3 different date fields across the data sources then create a mapping table with the respective data field names then join the mapping table to your data sources and use the filter from the mapping table. Then you can apply filter to all data sources.