Thats really an exciting initiative 
Is the deadline next Wednesday?
Regards
This has been updated above
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
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
3 Likes
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
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
Be sure to check out the colour theme generator.
A great way to ensure a consistent and professional look to you reports.
Looking forward to seeing the submissions.
H
1 Like
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
@Sam, This is the first of the challenges correct? Will working on these challenges counted as responding to issues on the forum?
Thanks,
Joe
Yes that’s correct
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
3 Likes
Not sure if this bothers anyone else, but the sales team are all selling to stores outside their region.
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
US time. But I think since this is the first one we can be flexible.
I’m looking forward to posting mine to the thread tomorrow!
Ahh that explains it. It does make it difficult to build a proper hierarchy though, lol
I think this is a good thing to flag up as it may be that there is a data quality issue in a real scenario
John
1 Like
Has anyone found on the sales table blank or incorrectly converted date rows?
This can sometimes happen when you create source data files or copy and paste from sources.
I normally convert fact data to CSV files if possible…?
I also normally enter the other tabs (Dimensions Data for Regions, Teams, Products and Locations) using Enter Data in Power BI Desktop and in production it can be useful stored as data flows.
I ended up fixing the date issue by just re-highlighting the date column and removing blanks.
Here is the sales ledger as text file if anyone is interested in this format for the sales transactions.SalesLedger.txt (1.1 MB)