Suoritettu

Create dashboards/reports from Excel in PowerBI or other easy analytics tool

I have excel with data, it has 6 sheets . Need to in analytics tool (e.g. power BI):

1. Minimal normalization / cleansing

2. Upload data to analytics tool (e.g. power BI, google studio or alike) and create reports/dashboards.

Please note the following:

1. Each sheet in excel has primary key to join data. However 2-3 sheets primary key column data need to be matched and normalized (e.g. the unique joined key name may be mispelled , case sensitive or other). The normalization should be using RegExp or similar I can easily adapt

2. The data sometimes appear as Text type in excel while its actually number, need to handle data type changes

3. As I want the reports /dashboard to updated daily, every time I conduct new Excel reports should refresh. Need a a script or way to take the excel automatically from shared folder or similar.

4. List of reports I have and you can ask. I presume around 15-20 variations depend how report is built with which filters.

5. The tool/reports can be easily changed / configured by me in future by the analytics tool. Help choosing the analytics tool e.g. power bi or other

6. I want the excel to only hold raw data not to do the normalization , calculated fields and cleansing(e.g. today it has VBA and other formulas)

7. consult what tool best to use - free for personal use, easy to configure drag and drop, can be whitelable etc

Taidot: Data Analytics, Data Cleansing, tietojenkäsittely, Liiketoimintatiedon hallinta

Näytä lisää: power bi interactive dashboard, microsoft reporting tools, power bi free, power bi dashboard, power bi ser, power bi logo, power bi pro, power bi desktop, excel macros create text files excel, create stand alone excel program, create xml file excel vba, create database msacess excel, create stand alone excel files, create drilldown reports using crystal reports aspx, create iif file excel, create avery labels excel file, create front end excel, script create reports excel, create graphic reports excel, create reports excel

Tietoa työnantajasta:
( 6 arvostelua ) NY, United States

Projektin tunnus: #23779788

Myönnetty käyttäjälle:

jayprihar69

Experienced Power BI Developer with DAX and SQL skills | Available to start | Excellent in communication| Strong analytical skills | Hello, Having the relevant technology experience I am interested in working with yo Lisää

$150 USD 7 päivässä
(0 Arvostelua)
0.0

21 freelanceria on tarjonnut keskimäärin 156$ tähän työhön

suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Lisää

$500 USD 7 päivässä
(72 arvostelua)
6.8
antoinepal

Hello, I can build the dashboards you want in Power BI as i am an experienced Power BI developer with over 8 years in the field. Please check my portfolio to see my work and the level of my experience. Thanks!

$250 USD 7 päivässä
(38 arvostelua)
6.5
aimefx

Hi, I am an expert in Excel and Power BI, and I have completed 100+ power bi project here. you can check my profile: https://www.freelancer.com/u/aimefx I have read the project description, I can complete your projec Lisää

$140 USD 3 päivässä
(70 arvostelua)
5.7
SCONSUL

Hello I am interested in your request. I will provide you a high quality service. I work for an industrial company as a planning engineer and I manage a large number of data ( over than 15000 products) using pivot tabl Lisää

$108 USD 2 päivässä
(1 arvostelu)
0.8
WardWarrior

Hi, I have reviewed your requirements and I would recommend completing this project with Power BI. I have created similar dashboards solutions, examples below. I am a Power BI architect with 10+ years of experience dev Lisää

$220 USD 10 päivässä
(0 arvostelua)
2.0
jameelhussain306

I will complete your project as quickly as possible as you want.I will create dynamic power BI dashboard as you want for your business.I will create this dashboard as soon as possible and will provide additional revisi Lisää

$30 USD 7 päivässä
(0 arvostelua)
0.0
gilocesar

Qlik Sense is the best BI Product to fulfill all your requirements. More Consulting during the Job. KR Gilbert

$230 USD 5 päivässä
(0 arvostelua)
0.0
pierpa010

hi, (blueMagic) i used to work with Tableau/Power BI/Excel with huge datasets, creating sales reports, maps and business development strategies for a big multinational corporation (Philip Morris International). I set Lisää

$180 USD 3 päivässä
(0 arvostelua)
0.0
jainaashi15

I've experience working with Power BI dashboards in my office projects. I've more than 5 yrs of experience working with MNCs. Though I'm new here but you can expect a finished product and a professional work within the Lisää

$90 USD 7 päivässä
(0 arvostelua)
0.0
diptojyotidutta

Hello, I am a BI Analyst and I have done various projects and POC (Proof of concept). I have created many dashboards and reports using the BI Tool Qlik Sense. I also have knowledge of Microsoft Power BI, which I guess Lisää

$111 USD 4 päivässä
(0 arvostelua)
0.0
sandipingole6318

I am good typist and I have good knowledge about excle work and I have experience about excle work and I have also good typist

$444 USD 2 päivässä
(0 arvostelua)
0.0
nomfundomakhoba

I have extensive experience with data , SQL, excel and the visualization tools I have used are the following: Qlikview, PowerBI and Qliksense. I will ensure

$140 USD 7 päivässä
(0 arvostelua)
0.0
Servicehour24

"Hello, Create dashboards/reports from Excel in PowerBI or other easy analytics tool I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd li Lisää

$150 USD 2 päivässä
(0 arvostelua)
0.0
Q0a

I am the best. Relevant Skills and Experience I am good.

$155 USD 7 päivässä
(0 arvostelua)
0.0
rajeshkaligram

I have done any Microsoft Office excel and work work. and data entry work.

$30 USD 10 päivässä
(0 arvostelua)
0.0
govindpatra

Respected Sir,/Ma'am; hope you are also doing well. I have great exposures in Excel and Power BI, please check my portfolio and please text me for more discussion about the project. Please chose once and I assure you, Lisää

$100 USD 3 päivässä
(0 arvostelua)
0.0
$155 USD 3 päivässä
(0 arvostelua)
0.0
seagudong

Hello! I WANT THIS JOB. I understand your requirements and I know it fits me well. If you dont want to waste your time im here 24/7 just beep me back. I will try my very best, my 100% best to the job properly. Looking Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
Sohail748

Hello Dear...! Alert: I will give you 20% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that your Looking a developer which hav Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0
silviastanescu

I will deliver a QlikView report (including dashboard charts) based on the excel data and example of other reports/dashboards that the customer likes, within 7 days. The report will be customisable by the customer, in Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0