Find Jobs
Hire Freelancers

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

$250-750 CAD

Completed
Posted over 6 years ago

$250-750 CAD

Paid on delivery
Hi, MUST HAVE POWER BI AND DAX EXPERIENCE – FINANCIAL BACKGROUND WOULD BE HIGHLY RECOMMENDED 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. [login to view URL] 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: [login to view URL] Last report is same company but focus on cost (biggest area for my focus will also be this). [login to view URL] 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
Project ID: 16074176

About the project

10 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]
$275 CAD in 5 days
4.8 (1 review)
2.6
2.6
User Avatar
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 tracking, predominately from excel data sources. In regards to data structure, are you currently using a financial system to track this info? The beauty of Power BI is it's data cleansing and restructuring capabilities, so as long as your data source is fairly consistent, then I should be able to work around however the data is extracted. Looking forward to hearing from you, please don't hesitate to get in contact to discuss further. Thanks Julie
$333 CAD in 5 days
5.0 (1 review)
2.8
2.8
10 freelancers are bidding on average $441 CAD for this job
User Avatar
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 anything and everything concerned with start-ups, new companies in development and growth stages carving out long term strategic partnerships.
$555 CAD in 10 days
4.9 (35 reviews)
6.4
6.4
User Avatar
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 of JPMC (i-banking). I have access to Bloomberg,  Financial Times, Wall Street Journal and Thomson Financial databases. I am proficient in working on  excel, word and power point. Am expert in carrying out External & Internal Benchmarking together with Business Analytics. I have developed function/business wise performance through monthly Balanced Scorecards for Marketing, Merchandising ,  Logistics, Finance & Planning functions I have designed  functionalities for  CEO level Dashboards I have created more than 900 business plans, financial and marketing plans, grant proposals and Investor Memorandums over the last 10 years. I am aware of the business drivers and cost benchmarks for diverse businesses.
$250 CAD in 3 days
5.0 (22 reviews)
5.9
5.9
User Avatar
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 portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$555 CAD in 10 days
5.0 (54 reviews)
6.0
6.0
User Avatar
sir I am expert in dashboard designing. I am MBA and mphill in computer.
$555 CAD in 1 day
5.0 (6 reviews)
3.9
3.9
User Avatar
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 experience in Business Analysis, Database Programming, Datatables, Financial Analysis
$750 CAD in 5 days
4.9 (2 reviews)
3.8
3.8
User Avatar
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 domains (including finance). I am well versed with Power BI (data transformation using power query, data modeling, DAX, producing eye catching dashboards, keeping data fresh on service using data gateway, creating organisational content packs, distributing over cloud, etc.). I see that you are looking for a freelancer to develop the Power BI dashboard for finance reporting and I believe I am a strong candidate for this job. I have developed a similar dashboard for finance reporting in Tableau and eagerly waiting to showcase my work. I would be happy to interview for this job but to give you a better understanding of my qualifications I would like to have a Kick-Off meeting to discuss the scope of project, milestones, deadlines and budget along with some POC to showcase my skills and earlier work. Let me know if you have any question and when you would like to discuss our next steps. Cheers, Abid
$555 CAD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Markham, Canada
4.8
5
Payment method verified
Member since Nov 18, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.