Learn Data Skills
Ekta Rajani

Ekta Rajani

Data Analyst

The EnergyWise


My Portfolio Highlights

My New Project

Analyzing Unicorn Companies

My New Course

Data Visualization in Power BI

My New Track

Data Analyst

Use data transformation on relational databases and combining star schema data modelling approach within Power BI to showcase insights for different stakeholders.

My Work

Take a look at my latest work.


Overview of churnrate in a telecommunication company using Power BI


Project: Analyzing Motorcycle Part Sales using SQL and Power BI


Analysing Unicorn Companies with SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

The EnergyWise | Sep 2020 - Present

Data Analyst / Account Manager

Energywise, A startup specializing in energy audit for buildings. • Work on data analysis within energy performance covering historical data, instrument data to identify trends in consumption of energy in the building. Use star data model to build relationships within Power BI. Measure, and analyse data via statistical techniques, visual graphs for report using SQL, Excel and Power BI dashboards. • Identify KPIs for the building’s performance against benchmarks. Provide tailored recommendations required for optimizing the energy performance of the building. • Work closely with stakeholders and assisted in proposals and supervised audits.
Show More

Swayy | Jun 2016 - Jun 2018

Strategy and Marketing Analyst / Content Creator

Swayy Media Group, A UK startup (funded round A and B) IT services consulting company specializing in digital influencer marketing. • Performed data transformation using SQL such as filtering, grouping, aggregation, joins and extraction to generate KPIs and insights. Investigated different segments of influencers to identify customer satisfaction. • Collected, analysed data and developed reports. Worked on marketing plan, customer success plan, growth hacking strategy reports alongside team members and via management inputs. • Assess data quality and perform validation tasks to provide clean datasets to gather insights. • Work along SEO specialist resulting in first page index ranking for the blog articles by leveraging SEO, content marketing, keywords, specific titles and meta tags.

Independent Consultant | Oct 2013 - May 2016

Independent Consultant / Analyst

• Social media marketing of gaming app with zero ad budget. Analyzed various social media platforms and forums to create a gaming audience profile. Created targeted posts for audience, earning download rate of 60% for Android based app (initial stage) using twitter. • Started a blog owlhike.com for 2 years and secured content writing work.

TransUnion | Jul 2013 - Sep 2013

MBA Based Consultancy Project+Dissertation (Distinction)

Previously known as Call Credit Information Group in 2013, UK Business Objective: Strategic Business Segmentation for marketing service provider. o Provided a digital ranking report for targeting company clients using strategic segmentation. o Conducted primary and secondary research inclusive of qualitative surveys within the organization, analyzed documents provided by the company and the external market environment. o Created future action plan with recommendations to be implemented.

Al Futtaim Engineering | Feb 2012 - Sep 2012

Presales Engineer

• Managed projects, worked on different value propositions for clients whilst initiating technical discussions, negotiations to meet their budget and group targets whilst complying to technical specifications. • Built and established a new relationship with a key client, leading to future enquiries.

JBK Controls International | Aug 2010 - Jul 2011

Estimation Engineer

• Managed in-house building automation design estimation proposals for Dubai startup. In addition, worked on different ELV systems and complied to their specifications to create proposals for the client. • Trained and supported interns, implemented guidelines and standard costing frameworks, data management procedures to ensure data quality and smooth communication within the organization. • Contributed positively to meet team’s yearly target and provided engineering support to operations team to successfully deliver the project.

Honeywell Building Solutions | Aug 2008 - Jul 2010

Project Engineer | BMS Estimation Engineer

• Promoted to lead project engineer for Meydan racecourse and managed all the different phases of project including implementation with a team of supervisors. Supported Project Managers on various other tasks for completion of the different projects. • Worked in collaboration with consultant, sub-contractors, and supervisors for smooth progression of the project. • Worked as an inhouse estimation engineer and collaborated with the sales team and clients to secure projects worth 2.5 million AED including Meydan Barns Complex project.

My Education

Take a look at my formal education

Master of Business Administration (MBA) University of Warwick - Warwick Business School | 2013
Bachelor of Engineering (BEng), Electronics and InstrumentationBITS Pilani Dubai | 2008
Mannheim Business School

About Me

Ekta Rajani

Currently seeking suitable opportunities to expand my growth as a data analyst in SQL, by exploring and querying complex data collected and supporting management to gather insights and reach target goals via suitable data visualization tools.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free