Training Programme
Data Analytics Course in Vashi
Thirty-two hours that take you from a messy spreadsheet to a published Power BI dashboard — cleaning, modelling, DAX and the reporting design that makes numbers land.
- 32 Hours
- 10 Modules
- Live Project
- Certificate
Ask about this programme
What the batches cost, when the next one starts and how the dashboard project works — answered by the trainer, not a call centre.
Data Analytics Training Institute in Vashi with Live Projects
This Data Analytics Course in Vashi is built around the sequence an analyst actually works in. You start in Excel, because that is where most real data still arrives, then move into Power BI to clean it with Power Query, model it properly, write the DAX that turns columns into business measures, and design a report someone will act on.
The emphasis throughout is on judgement rather than button-clicking: which chart answers the question being asked, why a measure gives the wrong number when the filter context changes, and how to build a model that still refreshes correctly next month. The programme closes with a full dashboard project you build, publish and present.
What each module covers.
Open a module to see the topics inside it. Thirty-two hours across ten modules, each ending in hands-on work.
M01 Introduction & Overview of Excel
- Why analysts still start in Excel, and where it stops being enough
- Workbook structure, ranges, Excel Tables and structured references
- Cleaning imported data — Text to Columns, TRIM, remove duplicates, find and replace
- Core formulas — IF, IFS, SUMIFS, COUNTIFS and XLOOKUP
- PivotTables, PivotCharts and slicers
- Conditional formatting for spotting outliers quickly
- Data validation and protecting a working sheet
- Practical — clean a messy sales export and summarise it in a PivotTable
M02 Introduction to Power BI
- The Power BI family — Desktop, Service and Mobile, and what each is for
- Installing Power BI Desktop and navigating Report, Table and Model views
- Connecting to data — Excel, CSV, web, folder and SQL sources
- Import versus DirectQuery, and the trade-off each one carries
- The working sequence — connect, transform, model, visualise, publish
- The canvas, the Fields pane and the Filters pane
- Publishing to the Power BI Service and how workspaces are organised
- Practical — build and publish your first one-page report
M03 Power Query Basics (Part 1)
- The Power Query Editor and why Applied Steps matter more than they look
- Data types, and how a wrong type quietly breaks everything downstream
- Removing and filtering rows, choosing and reordering columns
- Splitting, merging and extracting text; changing case and trimming
- Replacing values and dealing with nulls and errors
- Adding index columns and custom columns
- A first look at the M code sitting behind the steps
- Practical — turn a raw export into a clean, typed table
M04 Power Query Basics (Part 2)
- Append versus Merge, and choosing the right join — inner, left, full, anti
- Combining every file in a folder into one query
- Group By and aggregation inside Power Query
- Unpivot and pivot — reshaping cross-tab data into something usable
- Parameters and reusable queries
- Query dependencies, referencing and disabling load
- Query folding and why it decides refresh speed
- Building a proper date table
- The star schema — fact and dimension tables explained
- Practical — combine twelve monthly files into one refreshable model
M05 Working with Table & Card Visuals
- Table versus Matrix, and when each is the right answer
- Formatting that aids reading — conditional formatting, data bars, totals and subtotals
- Drill-down and drill-through for detail without clutter
- Card and multi-row card visuals
- The KPI visual — value, target and trend together
- Slicers — list, dropdown, between and relative date
- Filter levels — visual, page and report, and which to reach for
- Bookmarks, buttons and the Selection pane
- Number formatting and accessibility in a report people actually read
- Practical — build a summary page with cards and a supporting detail matrix
M06 Chart Visuals (Bar, Line, Pie)
- Choosing a chart from the question being asked, not from the ribbon
- Bar and column charts — clustered, stacked, and sorting that reveals the story
- Line charts for trend, and combo charts with a secondary axis
- Pie and donut charts — the narrow cases where they work, and when to avoid them
- Scatter, treemap, funnel, gauge and map visuals
- Small multiples for comparing across categories
- Colour, labels, axes and gridlines — removing everything that is not carrying meaning
- Tooltips, including report page tooltips
- Visual interactions and editing how visuals filter each other
- Practical — rebuild a cluttered report page into something readable
M07 Basic DAX — Measures & Columns
- What DAX is, and how it differs from an Excel formula
- Calculated columns versus measures — the distinction everything else depends on
- Row context and filter context, explained with worked examples
- Aggregations — SUM, AVERAGE, MIN, MAX, COUNT and DISTINCTCOUNT
- CALCULATE, the function that changes what a measure is looking at
- FILTER, ALL and ALLEXCEPT
- IF, SWITCH and DIVIDE — and why DIVIDE rather than a slash
- RELATED and RELATEDTABLE across a model
- Writing readable DAX with variables
- Practical — build a measure table holding your core business metrics
M08 DAX Use Cases & KPI Practice
- Time intelligence — year to date, quarter to date and month to date
- DATEADD, SAMEPERIODLASTYEAR, DATESYTD and TOTALYTD
- Year-on-year growth, running totals and moving averages
- Ranking with RANKX and building Top N views
- Percentage of total across changing filter context
- Target versus actual, variance and achievement percentage
- Dynamic titles and conditional formatting driven by measures
- Handling blanks and divide-by-zero so a report never shows an error
- Common causes of a slow report, and what to do about them
- Practical — build a KPI scorecard with year-on-year and target tracking
M09 Revision & Mini Project
- Consolidating the full chain — Power Query, model, DAX, visuals
- Reviewing the star schema and troubleshooting relationships that misbehave
- The errors that catch everyone, and how to diagnose them quickly
- Report design principles — layout, hierarchy, whitespace and reading order
- Using Performance Analyzer to find what is slowing a page down
- Mini project — an end-to-end report on a supplied dataset
- Peer review and feedback before the final project begins
M10 Final Dashboard Project
- Choose your domain — retail, finance, HR, healthcare or logistics
- Gathering requirements and agreeing the questions the dashboard must answer
- Cleaning and modelling the source data
- Building the measure layer that drives every visual
- A multi-page dashboard with working navigation
- Publishing to the Power BI Service, sharing and workspace roles
- Scheduled refresh and what a data gateway does
- Row-level security so people see only their own data
- Presenting your findings and answering questions on them
- Certificate awarded on submission and presentation of the project
The full syllabus in one PDF.
The brochure carries the complete module list, the practical work in each module, the tool set and the certification details, in one file you can share with a manager or a parent.
- 10 modules across 32 hours, Excel through to Power BI
- Power Query, data modelling, DAX and report design
- Mini project, final dashboard project and certification
Download the brochure
Tell us where to send it and the brochure lands in your inbox, with a download link here too.
Skills you can be tested on.
By the end of the programme you can
- Clean and reshape messy data in Power Query without altering the source file
- Build a star-schema model with relationships that behave predictably
- Write DAX measures, including time intelligence and KPI logic
- Choose and format visuals that answer a specific business question
- Publish to the Power BI Service and set up scheduled refresh
- Present a dashboard and defend the numbers inside it
Tools you will work in
- Microsoft Excel
- PivotTables
- Power BI Desktop
- Power Query
- M language
- DAX
- Power BI Service
- Power BI Mobile
- Performance Analyzer
- Bookmarks & Buttons
- Scheduled Refresh
- Row-Level Security
Built for people who have the data and need the answers.
No programming or statistics background is assumed. The first module starts in Excel.
-
Students and graduates
Final-year students and recent graduates who want an analytics skill that shows up directly in job descriptions, with a dashboard to demonstrate at interview.
-
MIS and reporting staff
Anyone who currently rebuilds the same Excel report every month and wants it to refresh itself instead.
-
Finance and operations professionals
People who already own the numbers and want to model and present them properly rather than fighting pivot tables.
-
Managers and business owners
Decision makers who want a dashboard they trust, and enough understanding to tell whether a report is telling the truth.
Data Analytics Course in Vashi
Do I need a programming or statistics background?
No. The course starts in Excel and introduces every concept from the ground up. DAX looks like a programming language but behaves much more like an Excel formula, and the two modules covering it move slowly through row context and filter context, which is where most self-taught learners get stuck.
How long is the course?
Thirty-two hours across ten modules, ending in a full dashboard project. Tell us whether a weekday or weekend batch suits you and we will place you in the next matching cohort.
How much Excel do I need to know already?
Enough to open a spreadsheet and enter data. Module 1 covers the parts of Excel an analyst actually uses — tables, lookups, SUMIFS and PivotTables — so you are not expected to arrive with those. If you already know them well, that module goes quickly and gives you a head start on Power Query.
Do I need to buy a Power BI licence?
Not for the course. Power BI Desktop is free, and that is where the great majority of the work happens. A free Power BI Service account covers publishing your own reports. A paid Pro licence is only needed to share reports with colleagues in a workspace, which is something employers provide.
Do I need my own laptop, and does it have to be Windows?
Yes to your own laptop — 8 GB of RAM and a few GB of free space is plenty. Windows matters here: Power BI Desktop is a Windows application, with no Mac version. If you use a Mac you will need Windows through Parallels, Boot Camp or a virtual machine. Tell us in advance and we will help you get it set up before the batch starts.
How many projects will I build?
Every module ends in a practical exercise, and there are two full projects: a mini project in module 9 on a supplied dataset, and the final dashboard project where you pick your own business domain, build it end to end, publish it and present it.
Will I learn SQL as well?
Not as a separate track. You will connect Power BI to a SQL source and understand what is happening, but the data preparation in this course is done in Power Query rather than by writing queries. If SQL is your goal, tell us and we will point you at the right next step after this programme.
Who will be the trainer?
A practitioner from our team who builds reporting for clients rather than a full-time lecturer. That matters most in the design modules, where the difference between a dashboard that gets used and one that gets ignored is judgement rather than feature knowledge.
Is the training available online?
Yes. Every session runs as a live online cohort as well as an offline batch at our Vashi centre. Online learners build the same reports on their own machines with the trainer on the call.
What do I get at the end?
A certificate issued by AI Technoverse Infotech Pvt. Ltd., plus a published, working dashboard with the model and measures behind it. That is the thing worth showing an interviewer — a report they can click through beats a certificate on its own.
What are the fees and how do I enrol?
Send an enquiry using the form on this page or call us. We will share the current fee, the next batch dates and the payment options, and answer anything else before you commit.
Want to talk it through first?Our IT counsellors are here to help.
Tell us what you work with today and what you need to report on. We will tell you honestly whether this programme gets you there, and what to start with if it does not.