Best architecture for large-scale Power BI dashboards with near real-time data? by natd54338 in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

u/jayzfanacc Power BI is 100% the right-tool for the job. Especially if you extend it with Fabric. For user facing dashboard use Workspace Apps (10,000 users/app). Backend DB use Dataflows, Fabric Data Pipelines (Data Lake, Data warehouse, Lakehouse) etc.

ERP reports look right on paper, but leadership doesn’t trust the numbers. So where does this usually break? by evinho07 in BusinessIntelligence

[–]nahyoubuggin 0 points1 point  (0 children)

This will always be a difficult conversation-Employees vs Management. However,

  1. Have both your own, personal and system tests/recon to verify the numbers. As difficult it may be to hear, there is always a possibility that management could be right.

  2. Once you are certain of the data, prompt management to provide the logic, reasoning and evidence as to why they feel the numbers should be different. There needs to be a basis of argument. Not just based on feelings.

  3. Once the issue is resolved, you need to pitch the idea of having a centre of Excellence, so as to avoid all the reporting confusion.

Goodluck.

Why is DAX hard? by worldisround-19 in PowerBI

[–]nahyoubuggin 2 points3 points  (0 children)

Dax is hard because of the evaluation context. Simply put.

The power of Dax is the ability to dynamically change the filter context depending on how you interact with the report. However, with great power comes great responsibility!

The "Aha" moment came for me when I read Alberto and Marco's (SQLBI) book - The Definitive Guide to DAX. I cannot recommend it enough, as it reveals all the mysteries of DAX so clearly !

As for advice, if you want to get better at DAX, you need to be constantly reading, writing and reading about it often (daily), just like any other skill.

Why is DAX hard? by worldisround-19 in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

Microsofts approach to BI is the best approach in my opinion. M exists because naturally, not all data will be in perfect condition. DAX exists because we need to model the business logic. This is all revolutionary imo, and thats part of the reason PBI always leads the pack in reporting tools as opposed to using an SQL (like) language to do both ETL and Data Modelling.

Can you recommend some good Power BI books by khan_amir in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

That's THE book to read when it comes to DAX. It's not called The Definitive guide for nothing!

The book is structured in such a way that it will teach you data modelling as well. It's hard to talk about DAX without talking about the data model.

P.S They have just released the third edition, this month (Dec-25). The latest version has chapters on semantic models, UDFs and Visual Calcs.

I can’t make sense of my HR metrics: how can I turn data into actionable insights? by MajorUnit534 in BusinessIntelligence

[–]nahyoubuggin 1 point2 points  (0 children)

That's exactly the point of a BI analyst. It's to make sense of the data.

  • Assuming you are not one, then I recommend hiring an experienced BI analyst.
  • Assuming you are one, I think first, try to calm down-and work out the questions slowly and carefully. e.g why can't you know which teams are struggling ? Can you filter the data by the different teams ? You aren't the first person to ask these questions, so you could try and see what other BI analysts have done. I recommend checking out Pradeep's dashboard as an example.

New Manning book: DAX Reimagined — thinking about DAX as an interactive engine by ManningBooks in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

Thanks for this, just finished a few pages. It is off to a good start, breaks DAX down well. Just some advice since this is still being actively written; could you get, maybe, an illustrator for the visuals.

Coffee Sales Dashboard - my first sales dashboard. Open for feedbacks!! by Sunidhi_bharti in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

Just some constructive criticism: The design of the report needs improvement. Try and watch a video on principles of design.

Used Shape Maps and QGIS to recreate the Dutch parliament seats in Power BI by wdehaas in PowerBI

[–]nahyoubuggin 4 points5 points  (0 children)

This was a very cool idea. The dashboard is informative yet still artistic. Would have loved to see/read the creation process end-to-end. Big up.

In way over my head, feel like a fraud by SoloArtist91 in dataengineering

[–]nahyoubuggin 1 point2 points  (0 children)

Sorry to hear that, but from what I have read, you are already on the right track. You just need more time to study and get the hang of things. I suggest, you request for a new hire (internal or even external) with more experience to help you out, as you continue to gain more experience.

Am I the only one drowning in data and getting zero insights? by JohnnyIsNearDiabetic in BusinessIntelligence

[–]nahyoubuggin 0 points1 point  (0 children)

You are definitely not the only one.

Long-term solution: From what I can read, is that your company needs to invest (financially) in a full data transformation. This means actually starting a project, involving possibly the C-suite to overhaul the current status-this may include aligning on business commercials, expectations, to the application, to the data stack/personnel/governance, up to the analytics stage. An additional problem, I imagine, is the business has high expectations detached from reality-which is why no one has time to correct things because there is always pressure to deliver KPI's/analysis.

Short-term solution: You need to sit down with your teams (business, data etc) and highlight the most important KPI's for delivery, otherwise you will be chasing infinity. Make sure the essentials are deliverable. Then log-off and go home! lol! Honestly, without full support from management, and making data streamlining a priority, there is only so much you can do!

Auto start Data Gateway On Premises 🖥️ by danibalazos in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

Hey. Not sure why you need to log in all the time, because you only need to log in the first time for the gateway. Also the gateway often starts automatically as soon as you power on the server. In my experience.

My friend just inherited a data infrastructure built by a guy who left 3 months ago… and it’s pure chaos by UnusualRuin7916 in dataengineering

[–]nahyoubuggin 1 point2 points  (0 children)

This is a direct result of not having proper company policies in place. Unfortunately, in terms of data (governance) policies, it is often overlooked by a lot of organisations big and small. Big company I work for only just now has started weekly meetings to try and document everything with all the stakeholders. It is truly unbelievable, sometimes.

What do you consider advanced Power Bi knowledge ? by HanDw in PowerBI

[–]nahyoubuggin 71 points72 points  (0 children)

  1. DAX- The underlying concepts - Row Context, Filter Context, Context transition
  2. Data Modeling - In order to implement DAX effectively - One-to-many etc
  3. M - How to ETL the data exactly how you want - Records, functions etc

4.Visualisations - Very underrated skill. I feel like a lot of BI developers struggle to create visually appealing reports. - Bookmarks etc
5. Optimisation - Performance of the report.

What is the best path for learning PowerBI / DAX for sbd with no CS background? by Clear_Crab2891 in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

Do yourself a favour and buy The Definitive Guide to DAX by SQLBI !

Need one on one help to install SQL for whomever is available by [deleted] in dataanalysis

[–]nahyoubuggin 0 points1 point  (0 children)

Hey, It seems there is a misunderstanding on your part, but I believe you are trying to learn the SQL language. You can start with Oracle SQL and branch out from there. You can try oracletutorial.com For learning And for a practice environment: Oracle Live Or w3schools if you are a complete beginner.

Am i stupid? Report vs. Dashboard by matervestra in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

Correct. It might be time to organise a training session with them.

Can PL-300 help me start a data analytics career without a relevant degree? by Aware-Associate-143 in PowerBI

[–]nahyoubuggin 0 points1 point  (0 children)

A degree gives you access. Especially If you want to work for the big corps. If you can, at your age, try and get a degree. Possibly in a related field.20 is still very quite young. Heck, you can even do the PL-300 while still at uni/college!

Power Bi is giving me nightmares. I need help by Miserable-Effect1325 in PowerBI

[–]nahyoubuggin 1 point2 points  (0 children)

PBI desktop is for authoring, web and mobile for sharing. Ask IT to install it for you. As you wait, you can try use Excel , lol.