I will build power bi dashboards and write sql queries for your business data

Kenya

I speak English, Swahili

271 orders completed

Data Tasks and Construction Management

I am a Data enthusiast, Construction Management Specialist, IT Project Manager and a Professional Virtual Assistant. I have over 7 years of professional and industry experience in Data Management, C...

Level 2

Has met high performance criteria and has a proven track record for meeting client expectations.

About this Gig

Greetings.

Welcome to this Gig.


The data you already have holds the answers that you are most probably looking for.


Most businesses just cant reach the answers because the numbers sit in several tables, scattered spreadsheets or reports that have not been properly analyzed.


I fix that by pulling the data with SQL, cleaning it, and turning it into a Power BI dashboard that you and your team can open and use without the need for expounded explanations.


What I do:

  • Write and tune SQL queries (joins, CTEs, window functions) for SQL Server, MySQL or PostgreSQL
  • Clean and model your data so the dashboard numbers match your source
  • Build interactive Power BI dashboards with KPIs, filters and drill-downs
  • Analyse sales, customer, finance or operations data and explain the findings in plain language


What you receive

  • pbix file
  • SQL scripts
  • Clearly written summary of what the data shows and what to do about it.


For me to work on your project, I need a sample of your data (or read-only database access) and about 3 to 5 questions you want answered.


Message me with your goal and I will tell you what is possible and which package properly fits your requirements.


Welcome aboard....

Technology:

AnyLogic

•

Excel

•

Power BI

Analysis Type:

Quantitative Analysis

•

Qualitative Analysis

Expertise:

Web analytics

•

AB test

•

Trends

•

Prediction

•

Probability

•

Math

Programming language:

Python

•

R

•

SPSS

•

SQL

•

NoSQL

Tools:

EViews

•

mplus

•

NVivo

•

Google Colab

•

Microsoft Excel

My Portfolio

Other Data Analytics Services I Offer