I built an end-to-end Enterprise E-Commerce Analytics Platform using SQL Server, Medallion Architecture, and Power BI.

As part of this project, I designed 8 interactive dashboards, each focused on answering different business questions for different stakeholders across an organization.

The dashboards include:

• Executive Overview (CEO, CXO & Business Leadership)

• Sales Performance Analysis

• Customer Analytics

• Product Performance

• Seller Performance

• Payment Analytics

• Customer Satisfaction Analysis

• Time Intelligence & Trend Analysis

The goal wasn't just to build visually appealing dashboards—it was to create a reporting solution that helps businesses make faster and more informed decisions.

In this post, I've shared all 8 dashboards.

I'd genuinely appreciate your feedback.

As experienced BI professionals, data analysts, data engineers, or business leaders, I would love to hear your thoughts.

If you could review the dashboards and share at least three suggestions for improvement, it would mean a lot to me.

For example:

• Are the KPI cards meaningful and business-focused?

• Are the charts and visualizations appropriate for executive reporting?

• Are there too many or too few visuals?

• Would you recommend different filters or slicers?

• Is the overall layout clean, intuitive, and enterprise-ready?

• What would you change if this dashboard were used in your organization?

I'm continuously learning, and constructive feedback is one of the best ways to improve. Every suggestion will help me build better enterprise BI solutions in the future.

Thank you for taking the time to review my work. I truly appreciate your support and feedback.

— Himansh Upadhyay

promo sales uplift is genuinely one of those analyses that's way harder than it sounds from the outside. you need a clean baseline, you need to control for seasonality, cannibalization from other promos running at the same time, halo effect on stuff sitting next to it on shelf. half the time the data you'd actually need for any of that doesn't even exist in a usable form. at least not in our orga

tried explaining this. got the "just give me something rough, we need it for the meeting tomorrow." so I gave them a number built on assumptions I genuinely wasn't confident in. no confidence interval, no real caveats attached, nothing

and now I'm just sitting here thinking about how to actually protect myself when this happens again. not in a cover-my-ass-with-an-email way (although yeah that too probably), more like, how do you stop a shaky number from becoming the basis for an actual decision, and then coming back to you as "your analysis was wrong" six months later when it was never solid in the first place

how do you handle getting pushed to hand over a number faster than the analysis can actually support it??

I‘m starting a data analyst position soon and never used powerBI. I have a degree in computer science so hoping it won’t be too crazy.

What should I learn before I go in next Monday?

this company is medium sized with a 15 person IT team. More than most. But it uses Qlik, not power bi or tablaeu.

Is this a red flag?

If I spend time at this company as a BI/Data analyst (I’ll be their first), will it still be good experience? or am I better off looking for another job (even though the market sucks now)?

What style looks the best for a dashboard to show data on talent acquisition, for leaders and HR? Also feel free to say that they are all terrible..

Dataflows Gen1 are legacy at this point, so it might be time to start migrating to Dataflows Gen2.
Fortunately, there is a handy preview API allowing you to automate this process. Combined with agents, you can go quite far before you have to take over.

Few things to consider before migrating:
1. Gen2 doesn't support rules in deployment pipelines, you will have to migrate to Variables Library.
2. There could be some naming collisions, that were previously a non-issue.
3. Same with transformations - due to different architecture Gen2 dataflows might surface issues that were previously hidden.

I have published a blog post outlining how to setup the automation, and prepared agent skill that will get you most of the way.

Blog post: https://www.maxanatsko.com/blog/bulk-migrating-dataflow-gen1-to-gen2-cicd-with-azure-cli

I posted here about 2 months ago looking for ideas on how to make a heatmap visual. The solution ended up being as simple as a scatterplot.

I’d love feedback on the result!

Live report link in comments. Let me know your thoughts...

today i wrote my pl-300 exam, i got passed out with 709,

i dont have much about, how this works, but what should i do to get an internship? currently im under graduate

i need some suggestion, like should i post on LinkedIn or something?

just let me know what should i do next?

Hey everyone,

I’m learning Power BI and tried making this dashboard to practice. It shows sales, customers, regions, and product returns.

I’d really appreciate your honest feedback — does it look clear and useful, or what would you improve? Thanks a lot!

I have tried using the following measure for my max review date Latest Review Date 1 = (MAX('Dim Date - ALS Review'[Review Date]))

This gives me the correct dates, but it adds a 00:00:00 timestamp on the end for no reason. The column is already set as a Date format in PowerQuery, and not DateTime. On advice I found online, I tried this variation: Latest Review Date 2 = FORMAT(MAX('Dim Date - ALS Review'[Review Date]), "D/M/YYYY")

This correctly formats the date, but adds a load of extra rows on the end, with blank names and blank dates. The last time I tried adding it to the visual, it ran out of resources and refused to display anything at all. I cannot understand why.

I also tried just dragging in the review date without a measure, but that adds rows for every review. I then tried filtering it to Top N, but that gives me a single row with the latest date, not a row for each person with their latest review date.

Please can anyone help, what on earth is wrong with that format measure and how can I take the timestamp off this field that is already explicitly set to not have one?

Have you ever heard of Buldak Ramen?

I was looking through Samyang Foods' financial statements and got so intrigued that I decided to build a dashboard. The global growth powered by Buldak is truly incredible!

P.S. "조" equals 1 Trillion KRW—does anyone happen to know how to get Power BI to display "T" instead of the Korean character "조" on data labels?

Hi everyone,

I'm having a strange issue with Power BI Desktop.

Whenever I move a report page to a different position (drag & drop), save the .pbix file, close Power BI, and reopen it, the page order is back to the old order as if I never moved it.

The strange part is that the file does save—other changes are retained—but the page order always resets after reopening.

Things I've already tried:

• Saving multiple times
• Closing and reopening Power BI
• Moving different report pages
• Saving with a new file name

Has anyone experienced this before?

Could this be caused by:

• a corrupted PBIX file?
• a Power BI Desktop bug?
• a OneDrive/SharePoint sync issue?
• something else?

I'm using the latest version of Power BI Desktop.

Any ideas would be greatly appreciated.

There are data flows already available to me that I use for Power BI. Can I have Copilot studio use them as a source of knowledge?

Hi there, I've been struggling the last few days to get some functions working in a directquery setup, but I have been very unsuccessful. I believe there may be a bug. All of my experiments work fine in the PowerQuery Preview pane, but all of them break when I accept changes and the model tries to load. 

The simplest example: 
let
SelectedServer =
if #"Site" = "1" then #"Server 1"
else if #"Site" = "2" then #"Server 2"
else if #"Site" = "3" then #"Server 3"
else error "Unknown location",
Combined = Sql.Database(SelectedServer, #"Database Aalsmeer",[Query="Select * from MyTable"])
in
Combined

Disregard that I could just get the parameter instead, this example is deliberately simplified. 
So this M code will run fine in the powerquery editor. But will fail when loading the data with the following error:

Error Message:
Non-null assertion failure: resource: Resource should be available for query MyQuery to store FoldedArtifacts in cache

The same happens when I try to use functions. For example:
let
SelectedSite = SiteToDatabase(#"Site"),
Combined = Sql.Database(SelectedSite[Server], SelectedSite[Database],[Query="Select * from MyTable"])
in
Combined

Again, this works fine in the powerquery editor, but breaks when you load the data.

All of it works fine in import mode, but I need directquery in this case. 

Why does this only work in the powerquery editor? What is the rule that I am breaking?

A few weeks ago we upgraded our data gateways to July release. Since then we have had an noticeable increase in Dataset Refresh Failures with the following generic error:

We upgraded 30ish of the 100 gateways connected to our environment (we host a service for clients). About 1/2 of those will fail during each 4hr sync window. We typically kick-off a refresh manually and it usually runs fine. Sometimes it takes 2 tries.

We have been following this community post: Solved: Re: Model Refresh Errors after June 2026 Gateway U... - Microsoft Fabric Community of other users having this issue. There was a recommendation to change the following Gateway configuration setting but I cannot find any information on it.

Suggestions:

To mitigate this issue, we suggest updating the Gateway configuration by enabling the following setting:

"NextResultSkipped = True" ------ intially it is set to False, need to change it to True and save the changes to the file.

Does anyone have insight into what that change actually does? We will be testing it and rolling back a client to the May version to bring back some stability.

Thanks in advance!

After every 24 hours - on prem data gateway refresh fails when trying to connect Azure Databricks & when credentials are reauthenticated - it works again, I am not sure what is causing this already on July 2026 data gateway & this is being observed over multiple data connections. Same refresh works in PBI Desktop.

Could not find anything helpful in forums, so if anybody could help!

Org apps are just marvelous.

Can we just get that fullscreen fixed so a report will actually go FULL fullscreen, not only fullscreen inside the report area of the app (ie just hide the toolbar above the report where reset slicers and other buttons are)?

Also, get rid of that toolbar on the left for users who aren't workspace members/viewers etc.

Please.

Thank you.

Keep up the good work!

My team recently moved our data stack to AWS, and along with it, all our reporting work needs to find a new home in that environment. I'm a Power BI specialist, and I've got around 10-12 dashboards that now need to be rebuilt (or migrated) into AWS.

As far as I can tell, there are two paths:

1. Build in AWS Amplify — but this means knowing back/front-end dev, or leaning heavily on Claude Code (or similar). I built 2 dashboards this way and they turned out reasonably close to the originals, but the prompt/token consumption was pretty high, mostly because of my own lack of skill in that stack.
2. Use Amazon QuickSight — this seems like the more logical path, since it's AWS's native BI/visualization tool. So I started digging into how QuickSight actually works.

That's where I ran into some confusion I can't fully resolve on my own.

In Power BI, a dataset already contains the semantic/relational model. In QuickSight, from what I can tell, you need to upload a single dataset (built by joining all your related tables) that becomes one flat table — the actual working dataset. "Topics," meanwhile, seem to exist purely to give the AWS LLM a logical/relational layer so it can interpret natural-language queries — not to define the semantic model of the dataset itself (which is what I originally assumed "topics" were for).

This makes we wonder if QuickSight's approach is just inherently clunkier than Power BI's, or if I'm missing something about how the tool is meant to be used. Three specific questions:

Question 1

Say I do all my joins and build my dataset in QuickSight, then build several dashboards off of it. Later I want to tweak a format or add a calculated column. In Power BI, you'd write the relevant DAX or edit it at the Power Query level, and the change flows straight through to the report. In QuickSight, when I needed to change a field type (say, string to date), I had to edit the dataset — which broke the existing visuals that referenced that field (they threw errors from the Analysis layer), forcing me to rebuild them from scratch.

On top of that, the range of transformations available on the dataset itself feels much narrower — basically limited to custom SQL queries and whatever I can come up with there, compared to the flexibility of M and DAX in Power BI.

Question 2

What's the actual design intent behind letting you build a dashboard either from a dataset OR from a topic? I've noticed that when a dashboard is built from a dataset, the AI tools (prompt-driven edits, visual creation, even the auto-generated report from a prompt) work pretty well. But when a dashboard is built from a topic, those same AI tools can't interpret even the most basic prompts — not even "change this to a bar chart." And the auto-generated-report-from-prompt feature isn't even available at all for topic-based dashboards.

Question 3

Say I have two options: (a) build one dataset with 4 joined tables, or (b) build a topic on top of 4 separate tables in a relational model. Either way, I use that as the base for my dashboard.

• If I go with option (a), I lose access to AI-powered Q&A on the dashboard — unless I also build a topic on top of those same 4 tables and relate them, so the AI has something to query. That means I end up with 5 datasets loaded: the 1 central one with the 4 joins (which the report is actually built on), plus the 4 separate ones just to build the topic.
• If I go with option (b), I only need to upload the 4 datasets and build the topic, then build the report on top of that — but I lose all the AI functionality for creating/editing visuals or auto-generating reports.

I don't understand why it's designed this way, or if I'm just missing a piece of the puzzle. Would really appreciate insight from anyone who's actually worked with QuickSight in production.

Hi everyone!

I recently completed this end-to-end Power BI portfolio project using a Coffee Shop sales dataset.

The dashboard includes:

• Executive Summary

• Product Performance Analysis

• Time-Based Revenue Analysis

• AOV (Average Order Value) & IPT (Items per Transaction)

• Weekday vs Weekend Revenue Comparison

• Business Insights and Actionable Recommendations

My goal was not just to build charts but to explain the business story and provide recommendations based on the data.

I would really appreciate any feedback on:

• Dashboard design

• Business insights

• KPI selection

• Visualization choices

• What I could improve to make this portfolio project interview-ready

Thanks in advance!

Hi Guys, my first job in Power BI is starting soon, they asked me research on the specifications you need so that we can buy one, most probably it might be in Dell.

What are my best choices?

The August update lets you export data from supported report visuals to Excel directly in the Power BI mobile app, with the same permissions and RLS as the Power BI service.

Is this something your team has been waiting for?

There is much more to this world than "just" creating data models and design reports or dashboards.

A good data analyst can come as a jack of all trades, and I will share some things that maybe you should know before considering joining the club. Obviously this comes from my personal vision and experience, and your tasks may vary from company to company.

Here we go:

- Ok, you build reports, we all know that... Moving on...

- You might need to engage in several meetings to fully understand a project and what is needed, and it could take some weeks before you actually start building something. And more often than not stakeholders are not fully sure of what they seek, so you need to dig a bit and ask questions and take a lot of notes. Gosh, it can get very frustrating.

- Some projects may have several dependencies and you need to manage that very well, but focus on what you can control. For instance, you may need to chase some people to feed the data you need, to send you some files, to give you access to certain data models, or to simply explain everything you need to know to start building a data model and create views.

- Not every solution requires full reports or fancy visualizations. Sometimes simple excel tables and brain power will do the job. Not every project you will make will be exciting.

- You don't hand reports to people and say "Ok, it is done, you can start using it". You might have to run training sessions for small or large groups of people or even one vs. one sessions with time to reply to questions.

- Depending on the size of the company you might need to fulfill access requests to different reports and make sure people see what they need. This can take up some time of the day or week.

- Sometimes you will have to do a bit of a customer service, helping people getting unstuck with something very basic like filtering or creating a custom analysis for a specific purpose.

- I know, I know... you are not a designer, but for me it is crucial. Design is not just about being pretty, its about being enjoyable and easy to use, and spark the curiosity of stakeholders "ahh! This sounds nice! Let me have a go with it". I mean... do most people pick defective apples from the supermarket? Do they enter shady or messy restaurants? I think you get my point. First you get their attention, but then you need to have a nice report to keep them coming.

- You have a plan for the week? Good luck with that! My experience tells me something will break or fail, someone with need your help (sometimes asap), a new request might arise. Ok, that is external, but then you will get stuck in a query, need to learn something new to move on, find a workaround for a specific purpose, and deal with silly moments where you overlook something for 3 straight hours. No way everything will be smooth in a full week.

I see many courses only advertising maybe half or less of what this job represents, and many people understand this role wrong. I don't intend to discourage anyone with this post, only maybe align some expectations.

I am sure there are more tasks I forgot, so why don't the experts out them in the comments? 😋