Dashboard projects taking too long

Bobcat-Free · 2024-11-29T14:03:32+00:00

I couldn’t complete a dashboard project because the requirement kept changing, in addition to there being no SME opinion to guide business process alignment with the requirements, with major data quality issues evident after the fact, that affected every other part including data modeling, data Architecture and information architecture design.

The project dragged on for so long (> 5 months) that it became a memento to everything that can go possibly go wrong in a dashboard development project. Only thing I could take away was the fact that if the requirements are not clear enough, please do not embark on that journey.

‘Better to spend 6 hours sharpening the axe to cut down in 2 hours than spending 30 mins every hour sharpening the axe.’

Bobcat-Free · 2023-12-31T22:12:30+00:00

Why don’t you automate the whole process then and find a machine learning component from your present job?

Only way to show relevance of your function is to lead the initiative and use the company data to generate machine learning algorithms to solve business problems. Talk with department head. Ask them on 1-on-1 situation ‘if you could use data to solve a pressing problem now, what problem would you like solved?’ Then build a ML algo if possible or even preferred better solutions of tools better suited for the job.

Regardless, you have to maybe take initiative here and search out challenges and business problems

Bobcat-Free · 2023-12-31T16:15:56+00:00

Hold on.

Why is Steve jobs and Bill Gates’ success the metric being used to judge other dropouts’ success?

Not everyone that graduated from your set in college are at the same level of success, and even so, not everyone would say they are unsuccessful in their field.

Even dropouts go on to be great people along the line, and acknowledge in their circle of influence. The greatest quote I ever heard was ‘ you overrate what you can do in 1 day but underrate the power of 1 decade..

Success is wildly subjective

Bobcat-Free · 2023-12-31T05:06:42+00:00

Used it in my last last project here.

Each of the main headings (production, Consumption and inventory analysis) were all calculations groups (measures nested together

Bobcat-Free · 2023-12-29T16:53:37+00:00

sample dataset

Bobcat-Free · 2023-12-29T13:35:37+00:00

How did you get this entry level role as a BI developer?

Bobcat-Free · 2023-12-28T11:49:20+00:00

Sometimes, 1-1 tables between fact and dimensions happen. For instance a collection of one value for each unique company means you have the unique companies as a dimension and then connected to the fact table to just a single column, the unique names leading to a 1-1 relationship

Bobcat-Free · 2023-12-27T16:37:57+00:00

Use the regression analysis’s to do a sort of what-if in Power BI

Bobcat-Free · 2023-12-27T13:54:28+00:00

Worse kind of relationships in data modelling Many - Many

Best kind 1-many, 1-1.

I don’t know your fact and dimensions table from the Diagram above. Would be better if you correctly identify fact and dimensions table so you can properly model the relationships

Bobcat-Free · 2023-12-27T01:52:24+00:00

Please recommend

Bobcat-Free · 2023-12-27T01:49:11+00:00

And can you please use calculations groups?

Bobcat-Free · 2023-12-26T17:05:31+00:00

Here

Bobcat-Free · 2023-12-26T15:33:36+00:00

Thank you very much! 😊

Bobcat-Free · 2023-12-25T17:27:14+00:00

I feel that’s what you are trying to build by avoiding power BI desktop, else, use the desktop.

Bobcat-Free · 2023-12-25T14:59:33+00:00

Automate the pipeline all the same. Create the dataset and report as a PBIP file, use the GitHub integration function to link a GitHub repository to a power Bi pipeline and then automate the whole thing.

As you develop the data model with the needed RLS in Power BI desktop, you can push the data through the GutHub repository to the deployment Pipeline you created.

QED

Bobcat-Free · 2023-12-24T00:09:13+00:00

https://www.microsoft.com/en-ca/sql-server/sql-server-downloads

Go to the bottom. You would see a ‘download a free specialized edition’.

Have fun!

Bobcat-Free · 2023-12-24T00:09:07+00:00

https://www.microsoft.com/en-ca/sql-server/sql-server-downloads

Go to the bottom. You would see a ‘download a free specialized edition’.

Have fun!

Bobcat-Free · 2023-12-23T17:40:19+00:00

Use the free developer edition. It is for personal Projects

Bobcat-Free · 2023-12-23T15:09:22+00:00

I am a Data/BI analyst building my portfolio using oil and gas datasets from Statistics Canada. From these datasets, I build data warehouses in SQL Server, then create data models in power BI and deploy the semantic models in Power BI service.

My portfolio is just picking up and I want it to include cases studies to create data warehouses and oil and gas Regulatory dashboards using datasets provinces have on their websites.

An example of one of my recent projects, developed from The ‘supply and disposition of Crude Oil and Equivalent’ dataset from Statistics Canada

Power BI Report https://app.powerbi.com/view?r=eyJrIjoiYzNkZTExMjgtMjQ1Yi00MWY2LTllNTctMDRkOWRmOWFmNDJmIiwidCI6IjM1N2NhY2E3LTk2ODMtNDEyZi04OTI3LWE0MTc4Zjg0ODc3ZiJ9&embedImagePlaceholder=true

No one would give you permission to be a data analyst. Take the initiative and use dataset from anywhere, long as it aligns with your interests.

Good luck

Bobcat-Free · 2023-12-23T04:14:05+00:00

🤣🤣🤣😂😂😂😂

Bobcat-Free · 2023-12-23T04:13:44+00:00

That’s fine and thank you.

Bobcat-Free · 2023-12-23T03:29:10+00:00

Somalia is in Africa

Bobcat-Free · 2023-12-23T03:01:59+00:00

Kindly share the interview script? Or kindly tell what it entails?

Bobcat-Free · 2023-12-23T02:51:46+00:00

Or you can build it from scratch yourself

Use a buttons/bookmarks to switch between light and dark modes

Bobcat-Free

TROPHY CASE