Create dashboards/reports from Excel in PowerBI or other easy analytics tool
Project details
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
Awarded to:
Imenso Software
(4.9)
Project budget: $150 USD
budget limits: $30-250 USD
number of bids: 20
average bids: $162
Awarded to:
Imenso Software
(4.9)
Project budget: $150 USD
budget limits: $30-250 USD
number of bids: 20
average bids: $162
Project details
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
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
Skills: Business IntelligenceData AnalyticsData CleansingData Processing
skills of Imenso Software
| skill ? | level ? | projects ? | ||
|---|---|---|---|---|
| ETL |
|
17 | ||
| Data Cleansing |
|
17 | ||
| Data Modernization |
|
1 | ||
| Power BI |
|
17 | ||
| Data Integration |
|
1 | ||
| Data Analytics |
|
17 | ||
| SQL |
|
34 | ||
| Data Architecture |
|
1 | ||
| Database Administration |
|
17 | ||
| Business Intelligence |
|
17 | ||
| Laravel |
|
17 | ||
| Software Development |
|
17 | ||
| Data Delivery |
|
1 | ||
| Web Development |
|
17 | ||
| Microsoft SQL Server |
|
17 | ||
| Data Visualization |
|
1 | ||
| Data Governance |
|
1 | ||
| Data Warehousing |
|
1 | ||
| Database Development |
|
1 | ||
| Test |
|
1 | ||
| Quality and Reliability Testing |
|
1 | ||
| Test Automation |
|
1 | ||
| Usability Testing |
|
1 | ||
| Troubleshooting |
|
1 | ||
| Debugging |
|
1 | ||
| Database Design |
|
1 | ||
| Data Science |
|
1 | ||
| Database Management |
|
1 | ||
| Database Programming |
|
1 | ||
| Business Requirement Documentation |
|
1 | ||
| SAP Business Planning and Consolidation |
|
1 | ||
| Entrepreneurship |
|
1 | ||
| Enterprise Architecture |
|
1 | ||
| Data Analysis |
|
1 | ||
| A/B Testing |
|
1 | ||
| Cloud Data |
|
1 | ||
| Game Testing |
|
1 | ||
| Advertising |
|
17 | ||
| Social Sales |
|
1 | ||
| Data Processing |
|
17 | ||
| Twitter Marketing |
|
1 | ||
| Social Video Marketing |
|
1 | ||
| Instagram Marketing |
|
1 | ||
| Viral Marketing |
|
1 | ||
| Interactive Advertising |
|
1 | ||
| Commercials |
|
1 | ||
| .NET |
|
17 | ||
| Software Testing |
|
17 | ||
| Social Media Marketing |
|
17 | ||
| Data Mining |
|
1 | ||
| PHP |
|
17 | ||
| PPC Marketing |
|
1 | ||
| Marketing |
|
17 | ||
| Business Strategy |
|
1 | ||
| Internet Marketing |
|
17 | ||
| Business Plans |
|
1 | ||
| Business Consulting |
|
1 | ||
| Business Coaching |
|
1 | ||
| Business Analytics |
|
1 | ||
| Business Analysis |
|
1 | ||
| Microsoft |
|
1 | ||
| Leads |
|
1 | ||
| B2B Marketing |
|
1 | ||
| Sales Promotion |
|
1 | ||
| Bulk Marketing |
|
1 | ||
| Content Marketing |
|
1 | ||
| Facebook Marketing |
|
17 | ||
| Market Research |
|
1 | ||
| Market Sizing |
|
1 | ||
| Software Architecture |
|
1 | ||
| Lead Generation |
|
1 | ||
| Branding |
|
1 | ||
| Brand Management |
|
1 | ||
| Sales Management |
|
1 | ||
| Brand Marketing |
|
1 | ||
| Testing / QA |
|
1 | ||
| Sales |
|
1 | ||
| Website Testing |
|
1 | ||
| Digital Agency Sales |
|
1 | ||
| Marketing Strategy |
|
1 | ||
| Website Design |
|
1 | ||
| Website Build |
|
1 | ||
| Landing Pages |
|
1 | ||
| Digital Marketing |
|
1 | ||
| Product Marketing |
|
1 | ||
Some Imenso Software projects
| Project Title | Skills required in the project |
|---|---|
| Create a wordpress website | Logo Design Web Development Website Design WordPress |
| Modify Existing WordPress Website | WordPress |
| Erstellen Sie eine WordPress-Vorlage | CSS HTML jQuery / Prototype PHP WordPress |
| Build a Website for an on line office space rental company | Graphic Design HTML PHP Website Design |
| Digital Marketing Campaign | Advertising Facebook Marketing Internet Marketing Marketing Social Media Marketing |
| Financial Management Software — 3 | Laravel PHP Software Development Software Testing Web Development |
| Move SQL Server | .NET Database Administration Microsoft SQL Server SQL |
| Build the power bi reports | ETL Power BI SQL |
| Create dashboards/reports from Excel in PowerBI or other easy analytics tool | Business Intelligence Data Analytics Data Cleansing Data Processing |
