Power BI - Design and build a dashboard for Automotive Retail Dealerships



I have started up a new business which involves reporting and analytics for new vehicle franchise dealers. I have one model which is complete that is excel based and works off a trail balance (totals only no transactions). This will be my base for all other reports that are developed. Going forward I want to use Power Bi as this allows me easy access for mobile, iPad, desktop viewing etc.

Example reports that I have seen so far are Adventure Works (You Tube) and this shows variance Actual, Budget and variance. Gives you idea of what I want but must also have last year (same period) and variance.

[url removed, login to view]

Second report is also financial dashboard which has a lot more detail than the first demo. This is from You tube as well and what I am looking for:

[url removed, login to view]

Last report is same company but focus on cost (biggest area for my focus will also be this).

[url removed, login to view]

Other reports that I will want to be produced are employment cost per employee report.

Detailed sales and productivity report by salesperson, technician and parts and service advisor vs earnings vs gross profit generated.

As you can see this may turn out to be a big project so looking for a developer(s) to journey with me, of course depending on costs.

Now that's the big picture if you can do this let me know but small steps first!

I require as project one a dashboard for balance sheet and income statement (comparison to this year to last year and this year to budget as well as variances).

I need recommendations as to how you would prefer the information structured which will be done through excel

Skills: Business Analysis, Database Programming, Datatables, Financial Analysis

See more: power bi showcase, power bi partner, power bi dashboard examples, power bi healthcare, power bi clients, power bi report templates, power bi use cases, power bi customers, retail website design build, schematic 48vdc telecom power supply design, personal development power point design template, amp switching power suppy design, organization chart design build contract, design build marquee tent, terrascape design build inc, design build oil gas yahoocom, unique design build, outdoor power website design, power plant design project generator transformer student, power point design templates

About the Employer:
( 5 reviews ) Markham, Canada

Project ID: #16074176

Awarded to:


Hi, I am expert in excel and power bi data analysis and data visualization. 90% of my previous work the same excel and power bi report and dashboard. You can check some of my previous works here. [login to view URL] More

$275 CAD in 5 days
(1 Review)

Hi There! I'm an accountant by trade but am passionate about Power BI and it would be great to work on your project. Power BI is an awesome platform. In my last job I used Power BI for HR metrics as well as financial More

$333 CAD in 5 days
(1 Review)

10 freelancers are bidding on average $441 for this job


I have been an accountant since 1996 and have worked with many numbers of different clients since then. I particularly enjoy working with startup businesses and help them to grow their business. In addition I can do a More

$555 CAD in 10 days
(35 Reviews)

Greetings from Houston ! I am a  'Dean Scholarship' recipient for (MBA in Finance) business graduate studies from NYU Stern, USA.   I am CFA (USA) charter holder.  I am expert in financial modelling and am part o More

$250 CAD in 3 days
(22 Reviews)

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

$555 CAD in 10 days
(54 Reviews)
$250 CAD in 1 day
(24 Reviews)

sir I am expert in dashboard designing. I am MBA and mphill in computer.

$555 CAD in 1 day
(6 Reviews)

Greeting, I have understood your Design and build a dashboard for Automotive Retail Dealerships task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of exp More

$750 CAD in 5 days
(2 Reviews)
$333 CAD in 10 days
(1 Review)

Greetings for the day, Please accept my proposal for developing the Finance report in Power BI. I have master degree in Statistics and over 2 years of industry experience in developing BI solutions in variety of dom More

$555 CAD in 20 days
(0 Reviews)