One of the worst programs that we have to use currently is Tableau, it's honestly way worse than looker studio or Power BI. This program is atrocious, but we have several dozen reports that use it, and it doesn't really make much sense to me at all... Say I want to calculate sales, units, and percent sold by sales reps. I dragged those to the view, simple. Now I add a month filter and let the user select months. But if they select all months, this is where things go haywire. I don't know what Tableau is actually doing, but when you select more than one month, it's not actually summing up the ..read more

Recently published a series of polls on LinkedIn, as well as gathering existing research. They're still open and would highly appreciate further responses! -/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/-/- These recent polls are beginning to provide some valuable and interesting insights in organisational use of data and technologies in enhancing corporate wisdom. While a majority of respondents use 50% or less of their data for decision-making, many do highly rely on this data rather than professional intuition. Further, the consensus is that both external and internal data are only being used 'some ..read more

I just started a Business Intelligence Analyst role. The organization has several manufacturing processes they manage, and my co-workers are all passing around the same excel sheet to do analyses, etc. there are several data sources I’ve heard, multiple versions of the same excel sheet, etc. and wanted to know from you guys where to begin with documenting the different processes that leverage the data, and the data itself. As of now, there is absolutely 0 documentation. Thanks submitted by /u/_Username-ChecksOut [visit reddit] [comments ..read more

I work at a small company, where I handle monthly CSV reports from various sources. Using Pandas, I clean and manipulate this data before preparing Excel analysis reports for our senior leadership. One of these reports is particularly hefty, comprising around 850,000 rows (roughly 170 TB). The other three reports are much more manageable in size. I've been exploring alternative methods for storing and accessing our data to enhance our analysis and visualization capabilities. While I'm relatively new to database administration and data engineering, I do have some basic SQL experience. I've com ..read more

Many investors thought that Tesla’s stock price would plummet after it released a bad financial report, but the opposite was true. Tesla’s surge drove the entire market to rise, but you must understand that Tesla is just speculation, and the stock has not A strong level of profitability can support the current stock price, which will "fall" sooner or later.After Meta released its financial report, its stock price plummeted, once falling below $400! What will the market be like tomorrow? I expect tech stocks to experience another short-term pullback, so how should investors respond? If you wan ..read more

Hey all, I recently started a consulting business in Data and BI/Analytics, and I just got an enquiry from a potential client to help them with building PowerBI reports sourced from Excel files. As this is my very first engagement, for those of you who have more experience, if you can provide some guidance on the process how you normally engage with a (potential) client from beginning to end, it will be much appreciated. How do you normally charge your clients? Hourly or outcome based? And how do you deal with inevitably requirement changes/creep, revisions etc? Also, as I will be using Micro ..read more

Hi All I work for an Analytics Consulting firms and most of our clients are UK insurance companies. My current project is getting over where I used to work as BI developer. My responsibilities includes writing SQL codes and creating dashboards. I used to interact directly with senior stakeholders like head of sales and claims. I am getting a new role as a data profiler for their new project. I feel I will not get to learn anyhow new and interesting. My job description says profiler will analyse different data sources and make sure it meets business standards. Can someone give me insights if t ..read more

For anyone interested in breaking into business intelligence and overwhelmed by all the information out there, I’m hosting a free online workshop on Saturday, May 4th 12pm EDT to talk about the roadmap to stand out in today's competitive job market (link in my Reddit bio). As a former business intelligence analyst who eventually became a hiring manager and data director, I see so many aspiring analysts focus on building projects that have no company relevance, send resumes that don't resonate with hiring managers, have no idea what to expect in interviews, and eventually feel frustrated, disc ..read more

Sure, here's the translation of your question into English: I have a company with my business partner, and we recently shifted from the fitness sector to consultancy. We both invested around 7-9k in fitness, but I invested significantly more time because I was involved in that sector before he joined the company. I still want to be involved in fitness and am in the process of setting up the right people like a VA and SDR and closer to handle certain tasks. my business partner, says he wants me to run this under our company, instead of separately (even though I'm doing all the work). And there ..read more

I am starting a new job as a BI analyst on the 1st of May. Curious: Any ideas of the first things I can do in the first month in the new role? What can I do in the one week I have left before May? Any interesting and/or useful thoughts or suggestions I can do ? Thanks in advance submitted by /u/Snoo68308 [visit reddit] [comments ..read more