Lukket

Power BI Pro Dashboard Architect

Power BI Pro Dashboard Architect

Searching for an Architect who can create dynamic live dashboards for to C-levels and decision makers, utilizing Power BI Pro and Office 365. Our data is housed within Salesforce, but for this buildout, we will be using a data warehouse. You have experience navigating data warehouses and have excellent communication skills which allow you to provide both data and explanations easy to team members at all levels. We are looking to develop a handful of reports, and we would like to include useful business intelligence. Below are examples a select sample of reports.

Background on the Company: We a are a lender to small and medium-sized businesses, clients typically repay us with a small amount daily. Our product's term typically ranges from 2-15 months and payments can be collected on a daily or weekly schedule. The data we collect includes (FiCO Score, Funding Amount, Payback Amount, Balances, Address, Our Proprietary In-house score, Payment Pace, A Proprietary delinquency metric, etc.) Security, reporting, and responsive metrics are a must.

Prerequisites: Knowledge of both Microsoft SQL 2012 & Salesforce Object Databases, in-depth understanding of Microsoft Power BI and Office 365, ability to work quickly and iterate rapidly as requirements may change throughout the project.

What we will provide: Siloed access to our data warehouse including a completed data dictionary. Access to internal staff for questions and broader discussions on the data, and what we would like to see from it. We are also willing to change the structure and the data available in the silo per request.

1. Geographic Report - featuring a Map and the ability to drill down to states with breaking down industry per State. Additionally, using the drill down functionality, we would like some functionality to compare States by sector directly (see below requirements for Industry). We would like this report also to highlight areas where our poorest performing and our highest performing clients run their businesses.

2. Industry Report - Building upon the previous item, we would like to be able to view in detail stats regarding the performance by Industry. Including Average Factor, default percentage per vertical. Industries are attributed to every deal using a list of 45 general label industries and as well as a SIC code which describes in greater detail the exact nature of the client's business.

3. Accounts Receivable Report - create a dynamic calendar using a table with expected daily cash collections for each day, with a historic addition of the cash we received each day. This doesn't need to be on a Gregorian calendar.

4. Vintages - our contracts range from 2-15 months in duration a vintage represents a class of deal concerning its term. We would like to see performance metrics built out comparing 2,3,4,5,6…etc. month deals. Metrics such as average FICO, term (loan duration), relationship months (number of months we've had the client), zip code, Funded, Payback, Balances, collections)

5. Industry Standard Report - We would like to with the help of outside data, collected from various sources (i.e. US Agencies, Purchased Data Sets, Competitor Statistics) to create a beta (Beta is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. Beta is used in the capital asset pricing model (CAPM), which calculates the expected return of an asset based on its beta and expected market returns. Beta is also known as the beta coefficient.)

Evner: Data Analytics, Data Cleansing, Datavidenskab

Se mere: power bi technical architecture, power bi security white paper, microsoft power bi architecture diagram, power bi architecture overview, power bi desktop architecture, power bi architecture ppt, power bi security concerns, power bi on premise architecture, sharepoint render list view custom control, ajax category list view, sharepoint list view cut field, jevents month list view, reading null values dataset list view, list view window based project aspnet, hotscripts web page show whole list view, basefieldcontrol list view, joomla calendar list view, basefieldcontrol render list view, custom field type list view, list view read data bse

Om arbejdsgiveren:
( 0 bedømmelser ) United States

Projekt ID: #16338186

15 freelancere byder i gennemsnit $660 på dette job

malavshelat

Hi there ! This is Malav. Below is the proposal for your project based on my skills. Skills Summary: - Globally certified SAS programmer for Base SAS and data manipulation techniques. - I have 2.5 years of Flere

$555 USD in 10 dage
(1 bedømmelse)
1.5
mehranrana1990

I am BSCS. I also have vast experience in field and writing. let's kick off the task . cheers mate

$666 USD in 15 dage
(0 bedømmelser)
0.0
mutunga12

Dear Client, Am skilled at excel as a data analytics and visualization tool. I analyze thousands of records daily using several parameters as defined by clients. I also prepare dashboards for C-Level presentations. Flere

$730 USD in 10 dage
(0 bedømmelser)
0.0
snaciri81

Data viz and data analysis are my passion. I am inspired when I help people to achieve their goals while providing a high quality data story. More than 5 years in BI and analytics and more than 12 years in IT. Str Flere

$555 USD in 10 dage
(0 bedømmelser)
0.0
ajax181

Hi, I have around 3 years of analytics experience along with hands-on experience in Power BI. I can provide great service at very affordable cost

$555 USD in 10 dage
(0 bedømmelser)
0.0
madenkhan

ABOUT ME I'm a data analyst and visualization consultant located in Canada. I have years of work experience in the field of data visualization, reports building, and forecasting analysis. I love finding patterns in co Flere

$666 USD in 10 dage
(0 bedømmelser)
0.0
aabid431

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

$600 USD in 20 dage
(0 bedømmelser)
0.0
Smitdevice

Hello, We at Canny Informatics have created exceptional dashboards and have provided excellent services to our clients. Please, let us know more details about the same and we'd be able to send you data of what we Flere

$1000 USD in 10 dage
(0 bedømmelser)
0.0
cannyinformatics

Hello, Our overall experience of more than 10 years would help you get your desired results with accuracy and more. Please, let us know more details and message us to know more and we'd be happy to help you do the Flere

$888 USD in 10 dage
(0 bedømmelser)
0.0
arpansharma321

ya I Can do this work

$555 USD in 10 dage
(0 bedømmelser)
0.0
neetacv

I am having 20 years of IT experience in finance domain . I have worked almost 15 years on various data warehouse projects. --Specialized in Data warehouse design & Implementation --Implemented data warehouse for re Flere

$555 USD in 10 dage
(0 bedømmelser)
0.0
krajeshmenon

Hi there, Greetings! I understand you have a requirement to build Power BI reports / dashboards based off data from a warehouse that essentially derives the data from Salesforce Objects. Am looking forward to Flere

$750 USD in 8 dage
(0 bedømmelser)
0.0
clouclix

Hi, ( I am ready to sign NDA with you) Hope you are doing great. Thank you for posting your project on Freelancer. I have gone through to your requirement and as per our understanding, you are looking to Flere

$555 USD in 10 dage
(0 bedømmelser)
0.0
$722 USD in 10 dage
(0 bedømmelser)
0.0
reshmimandal

-Passionate data and business analytics professional with deep analytical expertise. Superior analytical, statistical, and critical thinking/problem solving skills. -Extensive medical informatics/economics reporting Flere

$555 USD in 5 dage
(0 bedømmelser)
0.0