One platform: students, companies, universities
Walnutcraft
Career course · Working professionals Beginner

Data Analytics with Power BI

This course prepares you for the Microsoft PL-300, Google Data Analytics Certificate credentials. University partner: Partner University (sample).

Statistics, SQL and data modelling from university faculty; Power BI, Python and a client-style project from working analysts.

Part A · Theory · University · 40%Part B · Practical · Industry · 60%

Who this course is for

Graduates from any stream who want an analyst role, and working professionals in finance, operations, HR or sales who want to own their own reports.

What you will be able to do

Graduates are ready for junior data analyst, MIS analyst and reporting analyst roles, and for the PL-300 exam.

Careers this course serves

Data AnalystData Analyst in UAEData Analyst in GermanyData Analyst in CanadaData Analyst in UKData Analyst in AustraliaBusiness AnalystBusiness Analyst in Canada

Jobs this course leads to

Roles from partner employers that name this course's certification.

All jobs
IT services partner10 vacanciesJunior Data AnalystPune, India₹3 to 5 lakh a yearQualificationAny graduateKey certificationMicrosoft PL-300Suggested course12 weeksData Analytics with Power BIUniversity + company₹18,000Freshers, 0 to 1 yearView job Fintech partner6 vacanciesMIS and Reporting AnalystBengaluru, India₹3.5 to 6 lakh a yearQualificationGraduate in commerce, statistics or computer applicationsKey certificationMicrosoft PL-300, Google Data Analytics CertificateSuggested course12 weeksData Analytics with Power BIUniversity + company₹18,0000 to 2 yearsView job Retail group partner4 vacanciesData AnalystDubai, UAEAED 9,000 to 14,000 a monthQualificationGraduate with an attested degreeKey certificationMicrosoft PL-300Suggested course12 weeksData Analytics with Power BIUniversity + company₹18,0002 to 4 yearsView job E-commerce partner3 vacanciesData AnalystBerlin, Germany€48,000 to 60,000 a yearQualificationBachelor's degree recognised in GermanyKey certificationMicrosoft PL-300, Google Data Analytics CertificateSuggested course12 weeksData Analytics with Power BIUniversity + company₹18,0002 to 5 yearsView job

Syllabus, by who teaches it

Progress is tracked separately for theory and practical, and both are assessed.

Part A · Theory University faculty
  1. A1
    Statistics for analysts

    Descriptive statistics, distributions, sampling and confidence, with weekly quizzes.

  2. A2
    Relational data and SQL

    Tables, keys, joins, aggregation and window functions, with graded exercises.

  3. A3
    Data modelling

    Star schemas, grain, measures and dimensions, and data quality.

  4. A4
    Communicating with data

    Choosing the right chart, visual honesty and writing a one-page analysis.

Assessed by a proctored online theory exam set and marked by university faculty.
Part B · Practical Industry professionals
  1. B1
    Excel and SQL on company data

    Cleaning, lookups, pivots and queries on an anonymised industry dataset.

  2. B2
    Power BI Desktop

    Power Query, DAX measures, relationships and report design, demonstrated live by a working analyst.

  3. B3
    Python for analysts

    pandas and the automation of a weekly report, reviewed by your industry mentor.

  4. B4
    PL-300 exam practice

    Mock exams on the Microsoft Power BI Data Analyst syllabus.

  5. B5
    Industry project

    A dashboard built to a brief written by the partner company and presented to its analysts.

Assessed on progressive assignments, the industry project and a presentation to the partner team.
You earnWalnutcraft Certificate in Data AnalyticsIssued on passing both assessments, with theory and practical marks shown separately. Verifiable online by employers.
Industry projectA brief from a partner companyA dashboard built to a brief written by the partner company and presented to its analysts.
After the courseApply to partner rolesApply from Walnut LMS to the roles partner employers share for this career, and sit the certification exam with the course's preparation.

Certifications this course prepares you for

Microsoft PL-300MicrosoftThe certification for Power BI, the reporting tool most Indian companies use, and the one data analyst job descriptions name most often.Google Data Analytics CertificateGoogle, delivered on CourseraThe most popular entry credential for data analysts, covering the full analysis process with spreadsheets, SQL, R and Tableau.

Ready for Data Analytics with Power BI?

Ask about the next batch, fees and whether your employer can sponsor the seat.

Enrol or enquireRequest the syllabus