Power BI Builds 1 - Executive Sales Report

[haroonali1000]

Challenge 1- Executive Sales Report

Welcome to the Enterprise DNA data challenge!

To learn more about the challenge and how it works be sure to check out the forum below!

About the Challenges category

Welcome to the EDNA data challenge. An opportunity to enhance your Power BI development and learning curve. Sharing, learning and growing! Join us bi-weekly for a new scenario based on what you are likely to face in the real world. We take a data set and turn it into an actionable report providing information and insight. The Enterprise DNA community will then come together to review the project and would love for you to join us. So How Does It Work? Join the EDNA Challenge an awesome com…

THE BRIEF
You are an analyst working at a major retailer.

The sales director has approached you and asked for you to prepare a report that he can take to the executives regarding sales performance and to make sure it looks good. Unfortunately, he is unavailable for any further conversations about what he wants in the report!!

SUBMISSION DUE DATE - Sunday, 14th June 2020 (PST)

Objective: Produce a sales report for executives.

The data set can be downloaded below

EDNA Data Challenge-Sales Scenario.xlsx

Best of luck!

Enterprise DNA

[haroonali1000]

A couple of points to note/consider:

This request is for an executive report so make sure the report you create is for the desired audience.

User experience and interface is very important.

What are the key metrics???

A few ideas to get you started-Top 5 products…Worst Performing stores…performance to date…

Any questions don’t hesitate to shout.

Remember to submit:

• place an image of your report and a link to the published report (can use the publish to web feature).

• Submit your PBIX file with the following naming convention ‘Challenge Name-Your Name’ to the Enterprise DNA email info@enterprisedna.co with the Subject of Power BI Challenge.

[sam.mckay]

Exciting! Start of something big I think with this initiative. Nice work

[sheik_mishuk]

Hi @haroonali1000

Thats really an exciting initiative

Is the deadline next Wednesday?

Regards

[sam.mckay]

This has been updated above

[sam.mckay]

One other thing for this challenge…

If you want to record the development of your work, we may feature it on Enterprise DNA TV as a speed build.

Some free screen recording apps below

Best free screen recorders on Windows and Mac (January 2023)

All you have to do is record the screen as you’re working. We can complete any fancy editing from there!

Interested to see what you all create.

Sam

[Harsh]

Hello @haroonali1000,

Just wanted to know that the report should of One Page only or it can be created containing multiple pages?

Thanks & Regards,
Harsh

[haroonali1000]

Hi @Harsh

There is no right or wrong answer for this. You can do as you see fit to meet the requirements.

The key objective is to ensure that you create a report which would be suitable for use by executives.

We will then hopefully provide some general feedback and as to how the enterprise team would tackle such a request.

Regards,
H

[kentyler]

[sam.mckay]

Downloaded no issue at my end

Not sure what that could be.

[haroonali1000]

Be sure to check out the colour theme generator.

Analyst Hub by Enterprise DNA

A great way to ensure a consistent and professional look to you reports.

Looking forward to seeing the submissions.

H

[joedias]

Hey @kentlyer.

I had similar issue so I closed out of excel and all applications then downloaded the file from Google drive as a .xlsx ( I am on Excel 2010) may also depend on what Excel version you are running. It downloaded fine but opened up in Protected View and All I did was click the yellow Edit button up top to get out of Protected Mode.

Try this and let me know if you have any questions

Cheers

Joe

[joedias]

@Sam, This is the first of the challenges correct? Will working on these challenges counted as responding to issues on the forum?

Thanks,
Joe

[sam.mckay]

Yes that’s correct

[haroonali1000]

Hi All,

Trust the challenge is keeping you busy.

These challenges are based on scenarios which mimic what we are likely to face in industry.

We are starting with something which is an integral skill in the life of a Power BI developer/analyst.

Which is taking data and turning it into actionable information that the business can use to make decisions (this is what BI is supposed to do!).

After the submission date we will hopefully share some great tips and methods and on how to tackle such a scenario and the thought process of one of the consultants on our team as to how they would tackle the problem statement.

This is a great way for all parties to share their best practices hopefully inspiring some of the best analysts around.

I look forward to learning with you.

H

[MathewA]

Not sure if this bothers anyone else, but the sales team are all selling to stores outside their region.

[Greg]

Hi. The submission due date is noted as June 14: I’m guessing this means 2020-06-14 11:59 PM, but UTC or New Zealand time? Can you please confirm the UTC date/time? Thanks, Greg

[sam.mckay]

US time. But I think since this is the first one we can be flexible.

[sam.mckay]

I’m looking forward to posting mine to the thread tomorrow!

[haroonali1000]

Hi @MathewA we are using a randomised data set I wouldn’t worry to much about this.

Regards,
H